|
Home > Archive > BizTalk Server General > June 2004 > Flat File - problems with format
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Flat File - problems with format
|
|
|
| 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
1StreetCustomer2CityCustomer1CityCustome
r2
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
| |
| David Downing [MSFT] 2004-06-26, 10:51 am |
| 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
|
|
|
|
|