|
next
|
Subject: CSV DOC to XML CONVERSION Author: (Deleted User) Date: 07 Jul 2009 04:59 AM
|
Hi George,
usually when converting from CSV to XML you use the XML Converter functionality of Stylus Studio, then design an XSLT stylesheet using Mapper to build the desired output structure.
For instance, create a new XSLT stylesheet, go to the Mapper tab, click on the "Add source document" button, select the CSV file in the Open File Dialog, check the "Open with XML Converter" check box and press OK; in the following dialog select the Comma Separated Values entry on the left and press OK.
In Mapper click on the "Set Target Document" button and select either the PubMed schema or an XML instance of such a schema.
Now you are ready to connect the element on the left schema to the ones on the right.
If the CSV data is stored inside a Word document, you will have to extract it to a separate file, e.g. by running another XSLT stylesheet against an XML version of the document
Hope this helps,
Alberto
|
|
|