Subject:flat file conversion Author:Tony Lavinio Date:27 Mar 2008 10:24 PM
File|Open, choose the .csv file, check the 'convert using XML converters' box, select the CSV converter, make sure the property that says to get the field names from the first row is set to 'yes', and press OK.
Subject:flat file conversion Author:Tony Lavinio Date:27 Mar 2008 10:27 PM
[Sorry, hit (Post) too quickly]
That will get the file into XML to make sure it looks okay.
Now, to do the actual mapping.
Choose File|New|XSLT (or XQuery)
When the scenario dialog opens, choose the [...] button next to the
input source field, and choose the input exactly the way the previous
instructions gave.
Next, switch to the 'mapper' tab, and click on the button at the top of the right column and load your sample XML file.
Then just draw some lines; the XSLT (or XQuery) will be created for you.