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 >> >
