XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Stylus Custom XML Conversion (mapping multiple fields under single element in a row)
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + SXXP0003: Error reported by XM... (2)
-> + Validation error (5)
-> + Windows 10, latest Java, new t... (2)
-> + using help crashes stylus stud... (3)
-> + Web Service Call error (5)
-> + javax.xml.xquery.XQException: ... (2)
-> + Trang translator is not availa... (2)
-> + Replacement for flat2xml (2)
-> + CONV CSV Display Problem (3)
-> + StylusValidator.exe Command Li... (3)
-> + Cannot run Java built in valid... (2)
-> + Windows 10??? (3)
-> - Stylus Custom XML Conversion (... (8)
-> ->Stylus Custom XML Convers...
-> ->Stylus Custom XML Convers...
-> ->Stylus Custom XML Convers...
-> ->Stylus Custom XML Convers...
-> ->Stylus Custom XML Convers...
-> ->Stylus Custom XML Convers...
-> ->Stylus Custom XML Convers...
-> + X14 enterprise and saxon 9.4.0... (3)
-> + Open an XML document in the XM... (3)
-> + How to generate mapping report... (4)
-> + Unresponsive - Custom XML Conv... (2)
-> - Need Help defining Flat File w... (1)
-> + XML to Database (6)
-> + XSD path when associating to a... (3)
-> - Auto EDI File Translation (1)
-> + Need help parsing EDI and crea... (2)
-> + Bug in generating Xml from Dtd (7)
-> + Stylus Studio 15, install erro... (4)
-> + How to create UML from XSD (2)
-> + Java configuration (4)
-> + embedding/starting X15 dircet ... (2)
-> + Stylus X15 R2 environment crip... (5)
-> + Output Method TEXT does not wo... (6)
-> + CONV loses its format on re-op... (5)
-> - Trouble Converting 846 EDI Fil... (1)
-> + XML Catalog support - DITA (2)
-> + non-persistent VDI, App-V Lice... (2)
-> + Can we READ XLS file and Conve... (8)
-> + Mapping XML to XML (3)
-> + SS X15 - Getting Error with 45... (2)
-> + Optimal for DB to XML? (2)
-> + Issues exporting SQL Server ->... (2)
-> + need additinal field in XML (2)
-> + blinking (3)
-> + HELP ANYONE PLEASE (3)
-> + xi:include including include s... (2)
-> + Validating an XML file against... (2)
-> + XML to EDI Telco D.0 field len... (2)
-> + Converting EDIFACT to XML in c... (3)
-> + XSLT Transformation fails with... (4)
-> + StylusStudio X15 R2 java Auto ... (6)
-> + StylusStudio X15 Review - firs... (2)
-> + Stylus Studio X15 stuck on pro... (11)
-> + Error handling in Coverter fil... (2)
-> + RESTful Web Services in Stylus... (3)
-> + How to produce a human-readabl... (3)
-> + EDI 945 to AX (2)
-> + Help x15 failing install (5)
-> + XSD 1.0/1.1 schema validation ... (3)
-> + Java Runtime Environment 8.0 (3)
-> + Web Service Call to Oracle OSM... (2)
-> + Telco EDI to XML output on opt... (12)
-> + Authentication failed (2)
-> + no declaration found for eleme... (2)
-> + Component installation failed (5)
-> - Component installation failed (1)
-> - AUP to expire (1)
-> + Disable Automatic Updates in S... (2)
-> + Windows 7 64 bit compatibility (2)
-> + EDI 8.1 to 10.6 (2)
-> - Conerting EDI 8.1 to EDI 10.6 ... (1)
-> + Debugging with Java built-in p... (3)
-> + Moving Stylus Studio (2)
-> + When using an xsl:import file,... (3)
-> + Generate XSD file from XML fil... (2)
-> + Custom XML Conversion (2)
-> + Create XML from XSD schema fil... (4)
-> + Slimed by Microsoft Word 2010 (6)
-> + XML to EDI (Telco D.0) convers... (3)
-> + XML Pipeline Troubleshooting (10)
-> + Allow negative values in Telco... (7)
-> + Unable to add new arguments to... (2)
-> + Validating XML Document (4)
-> + Debugging with X15 and MSXML p... (2)
-> + Parameter values (5)
-> + Limit on size of schema/instan... (4)
-> + Enterprise 12r1-The decompress... (5)
-> + Lost my copy - how do I renew? (2)
-> + Add Arguments to JVM does not ... (10)
-> + Page-position='last' not inple... (3)
-> + Decode the base 64 encrypted f... (2)
-> + XALAN Processor (4)
-> + How to create an XSD for flat ... (4)
-> + xslt saxon processor failure (3)
-> + Variables window Context path ... (4)
-> + XLS Formatting Objects Preview... (7)
-> + German DTA File (2)
-> + EDI to XML and LX segment (2)
-> - The element with name "F0101Z2... (1)
-> + How to insert the current date... (3)
-> + XSD - XML Sample (4)
-> + XSD to XML (3)
-> + Java extension functions, Xala... (2)
-> + XML with XSD to PDF (7)
-- Previous [61-80] [81-100] [101-120] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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.
   
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.