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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + How to achieve UTF-8 encoding ... (2)
-> + sorting Using JavaScript (6)
-> + Display values from .xml horiz... (5)
-> + query on xslt for-each (3)
-> + query on xslt for-each (2)
-> + issue for First occurance (2)
-> + XSL: Mapping 2 XSD to 1 XSD (2)
-> + xslt mapper looses linkage fro... (2)
-> - How to Modify only few nodes a... (1)
-> + XSLT autocomplete function (2)
-> + i need to display dynamic list... (2)
-> + How to group when source has m... (11)
-> - Using EXCEL to create XSLT for... (1)
-> - Mapper generating XSLT, popula... (2)
-> ->Mapper generating XSLT, p...
-> + multiple columns (2)
-> + First time to Stylus Studio 20... (3)
-> + xsl:if test statement result t... (4)
-> + XSLT for dynamic target fields (4)
-> + Remove duplicates (2)
-> + XML-XSL grouping issue while d... (2)
-- 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.