http://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+dataI put the header row in so when the xml gets generated I can see if I
got the right column in the field.
the data file reads from left to right.
if you only have say only three columns in a datafile, then only the
first three columns in the delimited file will be read.
the rest of the columns will be ignored.
Sam Hamilton sent the following on 2/2/2010 2:46 AM:
> Thanks BJ - couple of other questions
>
> Using the same example of posreport.csv, I understand that to use
> delimited file I need to use
> <data-file name="bacs-iscd" separator-style="delimited" type-code="text"
> delimiter="	">
>
> So does that mean that when using delimited files you can drop the
> length and position?
>
> <field name="prodCode" type="String" length="12" position="63"/>
> goes to
> <field name="prodCode" type="String"/>
>
> Also I am right to assume that all fields in the xml need to be
> specified in order so that the system knows what each of headings - so
> that using the same example of posreport.csv it should have 6x <field
> name="prodCode" type="String"/> rows?
>
> Cheers
> Sam
>
>
> But what I dont get is
>
> On 02/02/2010 18:00, BJ Freeman wrote:
>> the file is being defined as a fixed length file not as a delimited file.
>> <field name="name" type="String" length="32" position="17"/>
>>
>>
>>
>> Sam Hamilton sent the following on 2/2/2010 1:08 AM:
>>> Hey Guys,
>>>
>>> I am trying to work out the data file tools using the example on the
>>> wiki
>>>
http://cwiki.apache.org/confluence/display/OFBENDUSER/OFBiz%27s+Data+File+Tools>>> but in the first example posreport.csv has 6 fields but in the import
>>> xml (posschema.xml) there are only 5 fields defined?
>>>
>>> I am missing something?
>>>
>>> Cheers
>>> Sam
>>>
>
>
Locked
