Posted by
Jacopo Cappellato on
Nov 11, 2005; 5:03pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-XLS-to-XML-tp136405p136408.html
Hi michal,
yes the paths are absolute paths of the server.
These are the fields you should fill:
Data Filename or URL: --> the path to the csv file
Definition Filename or URL: --> the path to the def file
Data File Definition Name: --> the name of the definition in the def file
Save to entity xml file: --> the path to the xml file you want to create
For example see the attached definition file.
It can be used to parse a csv file in the format:
productId#internalName#productName#description#longDescription
Let's say the csv file is in: \tmp\data.csv
and the above def file on: \tmp\product_descriptions.xml
and that you want to create an entity xml file called: \tmp\dataxml.xml
You have to set:
Data Filename or URL: --> \tmp\data.csv
Definition Filename or URL: --> \tmp\product_descriptions.xml
Data File Definition Name: --> "descriptions"
Save to entity xml file: --> \tmp\dataxml.xml
The \tmp\dataxml.xml will be created, then you can easily import it into
OFBiz.
Hope this helps.
Jacopo
michal wrote:
> I found this option in webtools
>
> Data Filename or URL: Is URL?:
> Definition Filename or URL: Is URL?:
> Data File Definition Name:
> Save to file:
> Save to entity xml file:
>
> I entered path for the files and it didnt work. I guess my path was
> wrong. Should i enter absolute path on the server or ?? Could you give
> me some instructions ?
> Michal
>
>
> ----- Original Message ----- From: "Jacopo Cappellato" <
[hidden email]>
> To: "OFBiz Users / Usage Discussion" <
[hidden email]>
> Sent: Wednesday, November 09, 2005 11:48 AM
> Subject: Re: [OFBiz] Users - XLS to XML
>
>
>> Hi Michal,
>>
>> I'd suggest:
>>
>> From Excel: export a csv file
>> Using the OFBiz Data file tool: transform it into an entity XML file
>> Using the OFBiz XML entity import tool: import everything in OFBiz
>>
>> Jacopo
>>
>> michal wrote:
>>
>>> Do you guys know any free tools either for windows or linux to
>>> convert excel files to xml and then import them to Ofbiz??
>>> I was looking on google and couldn't find anything that would work.
>>> BTW, What is the best way to import list of products to ofbiz?
>>> Thanks
>>> Michal
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Users mailing list
>>>
[hidden email]
>>>
http://lists.ofbiz.org/mailman/listinfo/users>>
>>
>>
>> _______________________________________________
>> Users mailing list
>>
[hidden email]
>>
http://lists.ofbiz.org/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
>
[hidden email]
>
http://lists.ofbiz.org/mailman/listinfo/users>
<?xml version="1.0" encoding="UTF-8" ?>
<data-files xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="
http://www.ofbiz.org/dtds/datafiles.xsd">
<data-file name="descriptions" separator-style="delimited" delimiter="#" type-code="text">
<record name="Product" limit="many">
<field name="productId" type="String"/>
<field name="internalName" type="String"/>
<field name="productName" type="String"/>
<field name="description" type="String"/>
<field name="longDescription" type="String"/>
</record>
</data-file>
</data-files>
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users