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
Glenn HarmanSubject: Basics
Author: Glenn Harman
Date: 20 Aug 2010 01:28 PM
Originally Posted: 20 Aug 2010 01:24 PM
I have a csv file with a header, some detail lines, and some summary lines. I also have a desired schema. I simply need to convert one to the other.
I have created a .conv file. I also have viewed the schema I need.
What is the process for getting the data to the desired xml formatted file?

The .conv file had a certain number of detail lines. When I import another file with a different number, will the converter know these are detail lines? I looked in the regions to see if there was a flag that indicated whether they had max repeat values (as in EDI) but didn't find any.

One other question concerning attributes and data. Are attributes always passed or can they be set as constants?

Thanks,
Glenn


UnknownCircleKtest2.csv
Raw Data

UnknownCircleKtest2(1).conv


UnknownCircleKMWGL-NAMLRef.doc
Schema

Posttop
Rory FarrellSubject: Basics
Author: Rory Farrell
Date: 25 Aug 2010 05:18 PM
> What is the process for getting the data to the desired xml formatted file?

The process using XSLT would be:

1. Select File->New->XSLT Stylesheet.
2. Click on the ... for the Source XML URL.
3. Select All Files in File Open dialog and click on checkbox Open using XML Converter.
4. Select the CSV file.
5. Click on Custom XML Conversion in the Select XML Converter.
6. Click on the Value column and then the ... to select the .conv file.
7. Select the .conv file and click Open in the Select User Defined Conversion File.
8. Click on the Ok button in the Select XML Converter dialog.
9. Click on the Mapper tab and you should see a tree view of the converted CSV file.
10. Click on the Set Target Document and select the .xsd or sample xml file.

From then on you can map the transformation on the Mapper tab.

You should be able to do more or less the same steps with XQuery.

Regards,
Rory

 
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.