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 |
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 > |
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 >> > |
In reply to this post by BJ Freeman
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 >>> > > |
This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system. ______________________________________________________________________ |
Free forum by Nabble | Edit this page |