Subject: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?
Subject: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.