XML File Reads

wjfitzgerald · Post by **wjfitzgerald** » Mon Dec 08, 2008 10:03 am

Hi,

I am looking to read an XML file and convert it to a sequential flat file.
I presume this is possible using the XML input/output/tranform stages.
And am currently working to achieve this.

Just to save me the time, if it is not possible, could some one let me know please?

Any tips or hints would be gratefully recieved.

Thanks,

John Fitz

chulett · Post by **chulett** » Mon Dec 08, 2008 10:08 am

For Server it is typically:

Folder -> XML Input -> Transformer -> Sequential

Check Kim Duke's website under his Tips&Tricks page you'll find an XML Best Practices document that he is hosting for us. Invaluable reading.

wjfitzgerald · Post by **wjfitzgerald** » Mon Dec 08, 2008 10:12 am

thank you, it's great to know that you are not chasing the impossible.

regards,

john fitz

chulett · Post by **chulett** » Mon Dec 08, 2008 10:14 am

Also helps a great deal if you have an xsd for the xml file and have imported the metadata from it, rather than from the xml directly or typing the XPath Expressions by hand. FYI.