Subject:Stylus Custom XML Conversion (mapping multiple fields under single element in a row) Author:Zahid Gauhar Date:30 Jul 2015 10:41 AM
Hi,
We are trying to convert a CSV file to an XML file, where multiple fields could be mapped to single XML element as shown in example below. We didn't see option to have nested elements in a single row, please advise if this is possible using Stylus?
Subject:Stylus Custom XML Conversion (mapping multiple fields under single element in a row) Author:Ivan Pedruzzi Date:30 Jul 2015 01:45 PM
Hi Zaid,
Use right click -> Duplicate Node to duplicate element custom in the target schema. When mapping, make sure to link the attribute before the element.See screenshot attached.
Subject:Stylus Custom XML Conversion (mapping multiple fields under single element in a row) Author:Zahid Gauhar Date:30 Jul 2015 02:12 PM
Thanks Ivan, if I am correct, it looks like you used two phase transformation, flat_file --conv--> intermediatory xml --xslt--> final xml. We want to achieve this directly in conv file. Is this possible?
We currently have licence for XML_Converters jar file, we use this jar to convert flat file to xml using .conv file. So we have to achieve the final xml with out xslt. Thanks for your help.
Subject:Stylus Custom XML Conversion (mapping multiple fields under single element in a row) Author:Ivan Pedruzzi Date:30 Jul 2015 02:45 PM
DataDirect XML Converters - Custom Converter is not designed for fine control on the XML shaping. You need either XSLT or XQuery to generate what you want.
Subject:Stylus Custom XML Conversion (mapping multiple fields under single element in a row) Author:Zahid Gauhar Date:31 Jul 2015 08:39 AM
Hi Ivan, I tried generating conv and xslt together, but I am having to do first generate xml, then store the output locally and then create a new xslt from the output. The screenshot you provided looks like its doing both in single screen. I would appreciate if you can describe steps to get to the screenshot you have attached. Thanks
Subject:Stylus Custom XML Conversion (mapping multiple fields under single element in a row) Author:Ivan Pedruzzi Date:31 Jul 2015 11:36 AM
Look at the demo program under the Stylus Studio folder, for how to wire XML Converters into XSLT
<Stylus Studio dir>Components
\XML Converters for Java
\examples\
Demo.java
When testing in Stylus Studio,
- open the scenario dialog,
- browse for the Source XML URL,
- click on "Open using XML Converter" at the bottom of the open file dialog.
- when the "Select XML Converter" dialog comes up, select "custom
converter" on the left and and browse for you .conv on the right