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