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 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
chris miszturSubject: Mapping multiple files within a single mapping
Author: chris misztur
Date: 09 May 2013 10:54 AM
I'm using the XQuery mapper and I'd like to map 4 files to output 1 xml. Each input file is a customer master file from a different division without our company. Is it possible to use a single map or do I have to create 4 individual maps?

Postnext
Ivan PedruzziSubject: Mapping multiple files within a single mapping
Author: Ivan Pedruzzi
Date: 09 May 2013 11:28 AM

Hi Chris,

The XQuery mapping tool can handle many to one mapping.Here few question to better understand your requirements

- A) Do you need to merge the data from these input into one file?
In this case simply add all files to one mapping

- B) Does each file need to generate its own output?
--- B.1) Do they have the same XML structure?
--- Create one mapping with a single file which is representative of all your inputs then run the same mapping on each file.

Does it help?


Ivan Pedruzzi
Stylus Studio Team

Postnext
chris miszturSubject: Mapping multiple files within a single mapping
Author: chris misztur
Date: 09 May 2013 11:41 AM
Sorry if I'm being vague. Note the element name differences between the inputs. So I guess I'm looking to concatenate them.

Input

<file1>
<entry>
<Address1>123 main</Address1>
</entry>
</file1>

<file2>
<entry>
<Addr1>456 main</Addr1>
</entry>
</file2>

output

<target>
<AddressEntry>
<AddressLine1>123 main</AddressLine1>
</AddressEntry>
<AddressEntry>
<AddressLine1>456 main</AddressLine1>
</AddressEntry>
</target>

Postnext
Ivan PedruzziSubject: Mapping multiple files within a single mapping
Author: Ivan Pedruzzi
Date: 09 May 2013 12:27 PM


Your inputs have different structure, I suggest building a separate map for each input.


Ivan Pedruzzi
Stylus Studio Team

Postnext
chris miszturSubject: Mapping multiple files within a single mapping
Author: chris misztur
Date: 09 May 2013 12:10 PM
man... i don't know what's up with these multiple posts. I was using Chrome, thinking that might have been it, but then I switched to FF and it continues to happen.

Postnext
chris miszturSubject: Mapping multiple files within a single mapping
Author: chris misztur
Date: 09 May 2013 01:03 PM
That makes sense, Ivan. Then once I have all 4 xml files in the same structure, what strategy could I use to concatenate them?

Posttop
chris miszturSubject: Mapping multiple files within a single mapping
Author: chris misztur
Date: 09 May 2013 03:43 PM
found a solution...

http://users.atw.hu/xsltcookbook2/xsltckbk2-chp-8-sect-4.html

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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.