next
|
Subject: convert text to xml from more than one source? Author: Phillip Ankerson Date: 21 Aug 2008 12:12 PM
|
I have watched the video tutorial on how to create a customer xml converter for a text file, and have done that with a relatively simple text file. I need to read from more than one source (perhaps two text files - one for customers and one for addresses) or a database file, and create and xml file according to a spec I was given. Is this something that must be done with XQuery, or can it be done at all? We are creating an interface with Websphere...is there a pre-defined connector for this?
Example:
source 1 - customer
name1,status,logonID1,companyName
name2,status,logonID2,companyName
name3,status,logonID3,companyName
source 2 - address
addresstype,zipcode,phone1,email1,firstName,LastName,address1,city,state
addresstype,zipcode,phone1,email1,firstName,LastName,address1,city,state
addresstype,zipcode,phone1,email2,firstName,LastName,address1,city,state
addresstype,zipcode,phone1,email3,firstName,LastName,address1,city,state
logonId = email; notice there could be more than one address per user
|
|