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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Dump Payload into String (4)
-> + Converting Global EDIFACT into... (2)
-> + Auto mapping of XSLT? (3)
-> + Numbering a list broken into m... (3)
-> + help in xsl:analyze-string (2)
-> + Use XSLT with SOAP (2)
-> + Order of Processing Child Elem... (2)
-> + XSL finding a node based on va... (2)
-> + grouping a group? (11)
-> + Query on Looping (5)
-> + java.lang.Assertionerror_: Slo... (7)
-> + CONVERT SQL Server data to XML... (11)
-> + Error using "xsltproc" command... (3)
-> + XML refresh via web broswer (3)
-> + XSL-mapping usage for csv file... (4)
-> + form controls with xslt (2)
-> + Stylus Studio 2011 XML Enterpr... (2)
-> + Looping through Itema and gett... (2)
-> + Image src through System Varia... (3)
-> + XSL-mapping usage for csv file... (3)
-- Previous [61-80] [81-100] [101-120] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Ryan SappSubject: Mapper generating XSLT, populates children records into teradata database, but not multiple children
Author: Ryan Sapp
Date: 17 Aug 2011 08:53 AM
Originally Posted: 17 Aug 2011 08:48 AM
I am using the mapper in stylus studio to produce an xslt that will be used to shred input xml into our staging teradata database. It mostly works great, we successfully shredded a few records into the database. However, when we try and add two child records, the shredder only recognized the first child and therefore only enters 1 child(flight leg) into the database instead of the desired 2(or more). Attached is the XSLT file and the input xml file. Is there a setting in the XSLT that should let the shredder know to look for multiple children? Help is appreciated.
Thanks
Ryan


DocumentFlightMapping_Working.xslt
XSLT file

DocumentalisAviatorPostFlightRecord.xml
Input xml file

Posttop
Ivan PedruzziSubject: Mapper generating XSLT, populates children records into teradata database, but not multiple children
Author: Ivan Pedruzzi
Date: 17 Aug 2011 10:33 AM

Hi Ryan,

I did small changes to take into account the repeatable elements.

You can accomplish this drawing a links using the right mouse button then picking "Create repeatable link"

I also had to change the namespace in order to match the sample input document.

See attached XSLT, let us know if can help you further


Ivan







DocumentFlightMapping_Working_Ivan.xslt

   
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.