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 » XSLT Help and Discussion » Mapper generating XSLT, populates children records into teradata database, but not multiple children
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext 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
 
Topic Page 1 2 3 4 5 6 7 8 9 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.