Hi !

I have to map a posional flat file which contains customer data. This
includes the name, street, city and so on. The file has the following
format:

 NameCustomer1NameCustomer2StreetCustomer
1StreetCustomer2CityCustomer1CityCus
tomer2

Note that in this example I have only to customers, which is currently
the maximum. But in the future the numbers of customers could be
higher.
I have created tow schemes which I can use to validate the input data
and create XML files. The first outputs:

<CustomerData>
<NameCustomer1>Name1</NameCustomer1>
<NameCustomer2>Name2</NameCustomer2>
<StreetCustomer1>Street1</StreetCustomer1>
<StreetCustomer2>Street2</StreetCustomer2>
..
</CustomerData>

and the second scheme:

<CustomerData>
<NameCustomer>Name1</NameCustomer>
<NameCustomer>Name2</NameCustomer>
<StreetCustomer>Street1</StreetCustomer>
<StreetCustomer>Street2</StreetCustomer>
..
</CustomerData>

For better data handling I want to map it to a XML file which contains
a record element for each customer.

<Cutomer>
<Name>Name1</Name>
<Street>Street1</Street>
<City>City1</City>
</Customer>
<Cutomer>
<Name>Name2</Name>
<Street>Street2</Street>
<City>City2</City>
</Customer>

How do I have to map the schemes to get such a output and which scheme
is the better one? (I think scheme two because of the growing number
of customers)

Thank you !
Alex

PS: BizTalk 2004

[ Post a follow-up to this message ]

Alex,

Do you have an actual flat file instance that you can cut/past into a post
for us to take a look at?  If possible also attach your schemas and map.

Thank you,
Dave

--------------------[vbcol=seagreen] 
13:32:07 GMT)[vbcol=seagreen] 
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!postn
ews2.google.com!not-for-mail[vbcol=seagreen] 
ustomer2[vbcol=seagreen] 

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team

[ Post a follow-up to this message ]