|
|
 top
|
  Subject: Convert XML Feed to CSV/SQL/XLS
Author: Craig Worthing
Date: 31 Jan 2010 01:22 PM
Originally Posted: 31 Jan 2010 01:19 PM
|
I receive this type of XML data feed:
<Root xmlns:sql='urn:schemas-microsoft-com:xml-sql'><Truserv><Item item_nbr="103961" srp_cost="4.99" member_cost="2.24" ds_cost="2.29" short_description="QT Pet Feeding Dish" vendor_id="21717" dpt_code="L " class_code="70" subclass_code="24" vendor_name="BERGAN LLC" upc="879213008895" long_description="QT, Galvanized Pet Platter Pet Feeding Dish, Easy To Clean, Wide Low Profile Ideal For Multiple Cats Or Dogs, Especially Puppies & Kittens, Easy To Fill, Great For Outside Use." weight="0.50" length="9.00" width="9.00" height="1.25" pack_weight="3.60" pack_length="9.20" pack_width="9.20" pack_height="2.60" retail_pack_qty="1" member_pack_qty="8" member_pack_type="B" member_break_pack="Y" model="88889" country_code="CN" to_be_discontinued="N" retail_uom="EA " Edit_Divisor="1" Exclusive_Brand_Code=" "/></Truserv></Root>
I would like to convert to CSV if possible to open in EXCEL so I can filter out certain columns/rows using code within excel...
Basically what I'm doing is an online store which I get in the above XML format, which has around 78,000 items to sell.. I need the final file to be in CSV so I can import it in to my store...
or IF possible get the XML in a different XML format such as
<item>
<item_nbr>111111</item_nbr>
<srp_cost>2.00</srp_cost>
...
</item>
When I import the XML file in Excel For some reason around line 22,000 till 50,000 it skips all of those lines and resumes after ~50,000... that's why I need to convert to possibly CSV/XLS and import in to excel(hopefully in these formats it wont skip lines)...
|
|
|
|
