http://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data I 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 >>> > >
