Hi All,
Finally i got the solution for importing csv data's into ofbiz
datasource
having your csv file in ur local disk, and write a xml file as a template
for the table along with field names
like
<data-files xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/datafiles.xsd";>
<data-file name="posreport" separator-style="fixed-length"
type-code="text">
<record name="tillentry" limit="many">
<field name="tillCode" type="String" length="16" position="0"/>
<field name="name" type="String" length="32" position="17"/>
<field name="prodCode" type="String" length="12" position="63"/>
<field name="quantity" type="String" length="8" position="76"/>
<field name="totalPrice" type="String" length="8"
position="85"/>
</record>
</data-file>
</data-files>
then mention the path of these file in working with data file in ofbiz, it
will give you a xml file like
<entity-engine-xml>
<tillentry tillCode="021196033702" name="5031BB GLITTER GLUE PENS BRIGH"
prodCode="5031BB" quantity="1" totalPrice="299" />
<tillentry tillCode="021196043121" name="BB4312 WONDERFOAM ASSORTED"
prodCode="BB4312" quantity="1" totalPrice="280" />
<tillentry tillCode="021196055025" name="9905BB PLUMAGE MULTICOLOURED"
prodCode="9905BB" quantity="4" totalPrice="396" />
</entity-engine-xml>
then import this as usuall in the xml data import tab
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/Data-files-in-ofbiz-tp4171814p4172399.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.
