http://ofbiz.116.s1.nabble.com/OFBiz-Users-XLS-to-XML-tp136405p136409.html
Thanks your instructions were very helpful. I have one more question about
1 entities to write to the datasource". I was importing products and when I
search for these products they are not in ofbiz. What other steps I have to
> 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>>
>
>
>
--------------------------------------------------------------------------------