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 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Dave MSubject: Create 1 xml file for each line of a CSV file
Author: Dave M
Date: 19 Aug 2008 06:28 PM
I have a CSV file that I need to convert to multiple XML files. Each line/row in the CSV needs to be it's own XML file. Is there a way to do this with Stylus?

Thanks in advance,
D

Postnext
Minollo I.Subject: Create 1 xml file for each line of a CSV file
Author: Minollo I.
Date: 19 Aug 2008 08:20 PM
Something like this:

for $book at $pos in doc("converter:CSV:first=yes?c:/books.csv")//row
return
ddtek:serialize-to-url($book, concat("file:///c:/book", $pos, ".xml"), "indent=yes")

...where books.csv is:
bookid,pubdate,title
1,03/01/2002,Java Web Services
2,01/01/2000,Java Message Service
3,03/01/2002,Professional ebXML Foundations
4,01/03/1997,Beginning Visual C++ 6 Database Programming
5,11/10/2000,"Beginner's Guide to Access 2.0"
6,11/12/1999,Beginning Java 2
7,02/07/1998,Beginning ATL COM Programming
8,10/01/1999,XML Applications
9,11/12/1999,Instant UNIX

Postnext
Dave MSubject: Create 1 xml file for each line of a CSV file
Author: Dave M
Date: 20 Aug 2008 01:42 PM
Thanks for the info. I guess that is the programatic way of doing it and no easy "Check Box" way to do it in Stylus.

Thanks again

Posttop
Minollo I.Subject: Create 1 xml file for each line of a CSV file
Author: Minollo I.
Date: 20 Aug 2008 01:48 PM
You can do it in Stylus Studio, creating a new XQuery and executing it. Not a check box, but easy enough...

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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.