Page 1 of 1

tool to remove complex types to xs:string?

Posted: Fri Apr 03, 2015 9:34 pm
by kleach
I have large XML that I need to load into a database table..
I was never supplied and XSD.. when I generated it with oxygen it added complex types for attributes values..
I would rather just have a flat structure that I can load in to the database.. and any attrib value can be loaded as a string..
I assume I would have to create an XSLT to get into that format? is there a option to build this?

What is the best way to get the xml data in to a flat table?
-Ken

Re: tool to remove complex types to xs:string?

Posted: Mon Apr 06, 2015 12:43 pm
by sorin_ristache
I think the best way to convert the large XML file to another XML file with a flat structure (only a simple sequence of XML elements instead of a more complex tree-like structure) is with an XSLT stylesheet.

Are you asking if the Oxygen application offers an option that can automatically or visually do this convertion? Sorry, the answer is no, which means you will have to develop the XSLT transformation manually by means of the extensive XSLT support offered by the Oxygen application. You should look at the videos and recorded webinars about the XSLT support.