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 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
M KlineSubject: XML to XML via XSL Mapper
Author: M Kline
Date: 02 Dec 2006 01:28 PM
Hello,
I'm trying to map an XML to another XML (which is a Customer XML) and can't get the nesting quite right.

Can anyone give me some suggestions?
Thanks much,

Mary


Unknown2_BENDIXASN_DBtoXML.xml
Source file

UnknownASNImportExample.xml
Target file

Unknown12_1_06_BENDIXASN.xsl
XSL

UnknownBendixOutput.xml
Final output, but needs to repeat

Postnext
Minollo I.Subject: XML to XML via XSL Mapper
Author: Minollo I.
Date: 02 Dec 2006 03:44 PM
Your mapping is indeed looping on all Suppliers and on all ASNs; the sample output you have attached is not what I get with using the XSLT and XML you attached; I'm attaching what I see.

It's not clear to me though what the desired output is; the input contains multiple BENDIXASN elements, that contain SUPPID information and more; are you assuming each input XML references a single SUPPID? In that case you shouldn't probably loop on each SUPPID in your mapping; you should loop only when you create ASN elements?


Documentoutput(6).xml
The output I see

Posttop
M KlineSubject: Fw: XSLT Help and Discussion Digest for Sunday, December 03, 2006
Author: M Kline
Date: 04 Dec 2006 01:58 PM

Hello,

My desired output is like this:
(I'm pretty new to this so I was just excited I got it to loop at all!)

<SUPPLIER>8840</SUPPLIER>
<SHIPFROM>8840</SHIPFROM>
<FACILITY>ACUNA 141</FACILITY>
<SHIPTO>141</SHIPTO>
<CREATEDATE>2006-12-01</CREATEDATE>
<ASN>
<ASNNUMBER>I200034</ASNNUMBER>
<ASNDATE>2006-11-29</ASNDATE>
<CONTAINERTYPE>CTN90</CONTAINERTYPE>
<NUMCONTAINERS>1</NUMCONTAINERS>
<GROSSWEIGHT>1</GROSSWEIGHT>
<PACKINGSLIP>3807579 00</PACKINGSLIP>
<GROSSWEIGHT_UOM>LB</GROSSWEIGHT_UOM>
<NUMSHIPMENTS>1</NUMSHIPMENTS>
<SHIPMENT>
<PONUMBER>600777</PONUMBER>
<POLINE>106</POLINE>
<ITEM>5010930</ITEM>
<REVISION>0</REVISION>
<UOM>EA</UOM>
<RELEASEDATE>2006-11-28</RELEASEDATE>
<SHIPDATE>2006-11-29</SHIPDATE>
<SHIPQUANTITY>1</SHIPQUANTITY>
</SHIPMENT>
</ASN>
<SUPPLIER>8840</SUPPLIER>
<SHIPFROM>8840</SHIPFROM>
<FACILITY>ACUNA 141</FACILITY>
<SHIPTO>141</SHIPTO>
<CREATEDATE>2006-12-01</CREATEDATE>
<ASN>
<ASNNUMBER>I200035</ASNNUMBER>
<ASNDATE>2006-11-29</ASNDATE>
<CONTAINERTYPE>CTN90</CONTAINERTYPE>
<NUMCONTAINERS>20</NUMCONTAINERS>
<GROSSWEIGHT>21</GROSSWEIGHT>
<PACKINGSLIP>3800369 00</PACKINGSLIP>
<GROSSWEIGHT_UOM>LB</GROSSWEIGHT_UOM>
<NUMSHIPMENTS>1</NUMSHIPMENTS>
<SHIPMENT>
<PONUMBER>600777</PONUMBER>
<POLINE>106</POLINE>
<ITEM>5010930</ITEM>
<REVISION>0</REVISION>
<UOM>EA</UOM>
<RELEASEDATE>2006-11-21</RELEASEDATE>
<SHIPDATE>2006-11-29</SHIPDATE>
<SHIPQUANTITY>20</SHIPQUANTITY>
</SHIPMENT>
</ASN>
<SUPPLIER>8840</SUPPLIER>
<SHIPFROM>8840</SHIPFROM>
<FACILITY>ACUNA 141</FACILITY>
<SHIPTO>141</SHIPTO>
<CREATEDATE>2006-12-01</CREATEDATE>
<ASN>
<ASNNUMBER>I200434</ASNNUMBER>
<ASNDATE>2006-11-30</ASNDATE>
<CONTAINERTYPE>CTN90</CONTAINERTYPE>
<NUMCONTAINERS>1</NUMCONTAINERS>
<GROSSWEIGHT>34</GROSSWEIGHT>
<PACKINGSLIP>3747039 00</PACKINGSLIP>
<GROSSWEIGHT_UOM>LB</GROSSWEIGHT_UOM>
<NUMSHIPMENTS>1</NUMSHIPMENTS>
<SHIPMENT>
<PONUMBER>600777</PONUMBER>
<POLINE>61</POLINE>
<ITEM>5003428</ITEM>
<REVISION>2</REVISION>
<UOM>EA</UOM>
<RELEASEDATE>2006-11-21</RELEASEDATE>
<SHIPDATE>2006-11-30</SHIPDATE>
<SHIPQUANTITY>1500</SHIPQUANTITY>
</SHIPMENT>
</ASN>
......then start with the next SUPPID and flow through to the end......


Mary Kline
EDI Coordinator
General Fasteners
MKline@genfast.com
Ph: 734-452-4430
Fax: 734-452-2208


|---------+------------------------------------------------->
| | "stylus-studio-xslt Listmanager" |
| | <stylus-studio-xslt.listmanager@stylus|
| | studio.com> |
| | |
| | 12/03/2006 01:00 PM |
| | Please respond to "stylus-studio-xslt |
| | Listmanager" |
|---------+------------------------------------------------->
>---------------------------------------------------------------------------------------------------------------------------------------------|
| |
| To: (Recipients of 'stylus-studio-xslt' suppressed) |
| cc: |
| Subject: XSLT Help and Discussion Digest for Sunday, December 03, 2006 |
>---------------------------------------------------------------------------------------------------------------------------------------------|




XSLT Help and Discussion Digest for Sunday, December 03, 2006

Topics in this issue include:

17849: XML to XML via XSL Mapper
by "Mary Kline"
17850: XML to XML via XSL Mapper
by "Minollo I."


To post a new topic to this forum:
mailto:stylus-studio-xslt@stylusstudio.com

To subscribe/unsubscribe or get help, send a blank message to:
mailto:stylus-studio-xslt.list-request@stylusstudio.com


[ 17849 ] ----------------------------------------------------------------
Date: Saturday, December 02, 2006 13:28 -0500
From: "Mary Kline"
Subject: XML to XML via XSL Mapper
Reply To: mailto:stylus-studio-xslt.17849@stylusstudio.com
Message URL: http://www.stylusstudio.com/SSDN/read?17849,48
Reply URL: http://www.stylusstudio.com/SSDN/post?48,17849
Reply/Quote URL: http://www.stylusstudio.com/SSDN/post?48,17849r


Hello,

I'm trying to map an XML to another XML (which is a Customer XML) and can't
get

the nesting quite right.



Can anyone give me some suggestions?

Thanks much,



Mary

--
Attachment:
http://www.stylusstudio.com/SSDN/upload/2%5FBENDIXASN%5FDBtoXML.xml (6KB)
Source file

http://www.stylusstudio.com/SSDN/upload/ASNImportExample.xml (2KB)
Target file

http://www.stylusstudio.com/SSDN/upload/12%5F1%5F06%5FBENDIXASN.xsl (10KB)
XSL

http://www.stylusstudio.com/SSDN/upload/BendixOutput.xml (1KB)
Final output, but needs to repeat


[ 17850 ] ----------------------------------------------------------------
Date: Saturday, December 02, 2006 15:44 -0500
From: "Minollo I."
Subject: XML to XML via XSL Mapper
Reply To: mailto:stylus-studio-xslt.17850@stylusstudio.com
Message URL: http://www.stylusstudio.com/SSDN/read?17850,48
Reply URL: http://www.stylusstudio.com/SSDN/post?48,17850
Reply/Quote URL: http://www.stylusstudio.com/SSDN/post?48,17850r


Your mapping is indeed looping on all Suppliers and on all ASNs; the sample
output

you have attached is not what I get with using the XSLT and XML you
attached; I'm

attaching what I see.



It's not clear to me though what the desired output is; the input contains
multiple

BENDIXASN elements, that contain SUPPID information and more; are you
assuming

each input XML references a single SUPPID? In that case you shouldn't
probably

loop on each SUPPID in your mapping; you should loop only when you create
ASN elements?

--
Attachment:
http://www.stylusstudio.com/SSDN/upload/output%286%29.xml (5KB)
The output I see








 
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.