Posted by
michal-2 on
Nov 11, 2005; 8:44pm
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-XLS-to-XML-tp136405p136412.html
I followed your steps and It wasn't working. When i click on run the reloads
quickly and nothing happens.
I checked console.log and this what i get:
178905154 (http-0.0.0.0-8443-Processor4) [
ContextFilter.java:192:INFO ] [Request]:
/webtools/control/viewdatafile
178905155 (http-0.0.0.0-8443-Processor4) [
ControlServlet.java:98 :INFO ] The character encoding
of the request is: [null]. The character encoding we
will use for the request and response is: [UTF-8]
178905156 (http-0.0.0.0-8443-Processor4) [
ControlServlet.java:134:DEBUG] [[[viewdatafile]
Servlet Starting, doing setup- total:0.0,since
last(Begin):0.0]]
178905157 (http-0.0.0.0-8443-Processor4) [
ControlServlet.java:183:DEBUG] [[[viewdatafile] Setup
done, doing Event(s) and View(s)- total:0.0,since
last([viewdatafile] Se...):0.0]]
178905158 (http-0.0.0.0-8443-Processor4) [
RequestHandler.java:210:INFO ] [Processing Request]:
viewdatafile178905160 (http-0.0.0.0-8443-Processor4) [
RequestManager.java:123:INFO ]
[RequestManager.getRequestAttribute] Value for
attribute "null" of uri "viewdatafile" not found
178905160 (http-0.0.0.0-8443-Processor4) [
RequestHandler.java:372:INFO ]
[RequestHandler.doRequest]: Response is a view.
178905161 (http-0.0.0.0-8443-Processor4) [
RequestHandler.java:524:INFO ] servletName=control,
view=viewdatafile
178905162 (http-0.0.0.0-8443-Processor4) [
Region.java:117:INFO ] real path for
[/templates/main_template.jsp] is:
/sequoia/framework/webtools/webapp/webtools/templates/main_template.jsp
178905274 (http-0.0.0.0-8443-Processor4) [
ControlServlet.java:258:DEBUG] [[[viewdatafile] Done
rendering page, Servlet Finished- total:0.116,since
last([viewdatafile] Se...):0.116]]
Also I have changed product_description.xml delimeter from # to , because
that is what I have in my csv data file.
Michal
----- Original Message -----
From: "Jacopo Cappellato" <
[hidden email]>
To: "OFBiz Users / Usage Discussion" <
[hidden email]>
Sent: Friday, November 11, 2005 12:03 PM
Subject: Re: [OFBiz] Users - XLS to XML
> 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>>
>
>
>
--------------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
>
[hidden email]
>
http://lists.ofbiz.org/mailman/listinfo/users
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users