XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Posttop
Craig WorthingSubject: 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 &amp; 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)...

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.