XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Zahid GauharSubject: 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?

CSV file:
id1,cust1,cust1val,cust2,cust2val,name

Expected XML:
<payments>
<payment>
<id>id1</id>
<custom name="cust1">cust1val</custom>
<custom name="cust2">cust2val</custom>
<name>name</name>
</payment>
</payments>

Version: Stylus Studio 2010 Enterprise Version

Postnext
Ivan PedruzziSubject: 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.

Does it help?

Ivan Pedruzzi
Stylus Studio Team

Postnext
Zahid GauharSubject: 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.

Regards,
Zahid

Postnext
Ivan PedruzziSubject: 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.

Ivan Pedruzzi
Stylus Studio Team

Postnext
Zahid GauharSubject: Stylus Custom XML Conversion (mapping multiple fields under single element in a row)
Author: Zahid Gauhar
Date: 30 Jul 2015 02:57 PM
Thanks Ivan for quick response, we will introduce xslt to transform intermediary xml.

Postnext
Zahid GauharSubject: 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

Postnext
Ivan PedruzziSubject: 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



Does it help?

Ivan Pedruzzi
Stylus Studio Team

Posttop
Zahid GauharSubject: Stylus Custom XML Conversion (mapping multiple fields under single element in a row)
Author: Zahid Gauhar
Date: 31 Jul 2015 12:09 PM
Great, Thanks Ivan. it worked.

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.