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
Kim BartlSubject: Converting a csv file to xml using existing schema?
Author: Kim Bartl
Date: 17 Feb 2012 10:18 AM
Hello,
I am a beginner. Can anyone give me step by step instructions for converting a csv file into a xml file using an existing schema? I have attached the schema and csv file.

Thank you for your help.


UnknownData_Submission_Standard.xsd
Schema

UnknownQuarter32011datareadyforXMLformatting.csv
CSV file

Postnext
Ivan PedruzziSubject: Converting a csv file to xml using existing schema?
Author: Ivan Pedruzzi
Date: 17 Feb 2012 11:39 AM
Hi Kim,

Would you be able to produce a CSV file with the first row containing the column names?

I attached a screenshot that shows the a trivial mapping from CSV to XML, but without knowing the mapping semantic we could not complete the task

- File -> New -> XQuery File
- Switch to the Mapper tab
- Click Set Target and pick your schema
- Click Add Source and select your CSV file
- Click on "Opening using XML Converter"
- Pick Comma Separated Value (CSV)
- Draw links from left to right



Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
Kim BartlSubject: Converting a csv file to xml using existing schema?
Author: Kim Bartl
Date: 17 Feb 2012 12:58 PM
Hi Ivan,
Attached is the file with the column headings, I believe that is what you were looking for?
Thanks,
Kim


UnknownQuarter32011datareadyforXMLformatting2.csv

Postnext
Kim BartlSubject: Converting a csv file to xml using existing schema?
Author: Kim Bartl
Date: 17 Feb 2012 02:40 PM
Ivan, I believe I did get all of the mapping done. However, now how do I export this into a XML file like the one attached here?


UnknownMNVistingNurse247008Aug2011.xml

Posttop
Ivan PedruzziSubject: Converting a csv file to xml using existing schema?
Author: Ivan Pedruzzi
Date: 17 Feb 2012 03:13 PM

Click the button labeled "..." in the toolbar [Edit Scenario Properties].

When the Scenario dialog comes up, set the Output URL to the path where you want the file to be generated.

Now every time the query is executed, clicking the green triangle, the result is generated at the output URL.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
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.