Page 1 of 1

XML from flat file

Posted: Thu Apr 26, 2012 5:26 pm
by wnichols
I need to be able to transform a flat file (or csv file) into a XML file. I have XML schema from the Saas but do not understand how to move the individual elements from the flat file to the correct schema places in the XML Schema. Basically I'm reverse engineering to build the XML to load data back into the SaaS after cleansing it. Already have built the xslt to pull the data out. Any have any suggestions or can point me in the right direction?

Re: XML from flat file

Posted: Thu Apr 26, 2012 6:21 pm
by adrian
Hello,

I'm not sure if you're looking for a generic XML solution or an Oxygen specific one.

For Oxygen this kind of import can be done in two steps:
1. First import the text file into an XML file. For the text (CSV) file use File -> Import -> Text File. The "Import criteria" dialog allows you to choose the field delimiter (use Comma for CSV) and customize the form of the destination XML file("Change labels").

2. Process the imported XML file either manually or by transforming it with an XML stylesheet into the form required by the XML Schema.

Regards,
Adrian

Re: XML from flat file

Posted: Thu Apr 26, 2012 7:19 pm
by wnichols
using Oxygen..

Thanks for the directions. Appears to be working.