XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Basics
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + predefined macros ${ (4)
-> - TRADACOMS - EDI (1)
-> + SUM not working (3)
-> - Large xml file handling gives ... (1)
-> + 2011 Enterprise code folding f... (9)
-> + custom xml converter (3)
-> - Start Excel feter the mapping ... (1)
-> + Uninstall (2)
-> + xpath to compare two values fr... (2)
-> - xpath to compare two values fr... (1)
-> + SS2011 cannot save XML files u... (3)
-> + SS 2011 Enterprise saying 2010... (2)
-> + How to change the way whitespa... (7)
-> + Updating Relational Data Using... (4)
-> - Contract Stylus Studio help. ... (1)
-> + UTF_8 characters not displayed (6)
-> + Problem XSL to PDF ( dont reco... (2)
-> + HIPAA EDI - Looping question (4)
-> - HIPAA EDI - Looping question (1)
-> + Does XML Report support column... (2)
-- Previous [481-500] [501-520] [521-540] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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
   
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.