 |
Ubercart |
|
|
|
||
|
Fri, 11/09/2007 - 13:03
 Hey, I recieve all my product/price-lists in Excel sheets. They look rather similar: SKU, VendorProductNo, Description, Price1, Price2, (... PriceN) How should I convert them to the required XML format? Actually I did some research, so I have an XML schema description from other forum topics, but I'm just new to this XML stuff. Thank in advance, Zsigmond
update
actually the price-lists require some customization, so maybe I will import them to some kind of DB (OO + SQL backend or simply MySQL) Sorry, I'm a newbie Thanks
DTD
actually, as far as I know, Open Office is able to convert XLS to XML, there are various predefined XML filters available.   
Re: DTD
There isn't a DTD, but there is a Schema file at http://www.ubercart.org/files/store.xsd
OO + XML
for those who are interested: http://xml.openoffice.org/filter/
OO help
"To create an XML filter, you must have a good understanding of XML and XSLT concepts. These concepts are beyond the scope of this help"
XSLT
"1.Create an XSLT transformation stylesheet that maps the elements of the external XML format to the elements of the OpenDocument XML file format and back again."
XSLT
check this, and you are ready: http://www.w3.org/TR/xslt
    
Re: XSLT
You could just save the Excel file as a CSV file and run it through CpILL's csv_import and choose the option to "Show import XML only". Look here for more information: |
|
