Flatfile Schema

amang

Hello,

again a problem with the Biztalk 2004 (but should be the same for 2002)

I must map the xml-files from Navision to a flatfile with a format like this:
100;220;4304457010138;4304457000009;
120;220;Companyaddress;4304457000009;
120;220;Customeraddress;4304457000009;
200;220;10000;Item 1;
200;220;20000;Item 2;
200;220;30000;Item 3;

The first number in the lines identifies the "line type" For example, lines with 200 are Sales Lines, 120 are address lines, 100 is the header. The problem: Some Lines are optional. For example the file could also look like this:
100;220;4304457010138;4304457000009;
200;220;10000;Item 1;
200;220;20000;Item 2;
200;220;30000;Item 3;
(no lines with identifier 120)

Is it possible to create a schema for this at all?

thanks

mark.cotton

try this:
http://www.winterdom.com/dev/bts/BTSFFSchemaTut1.html

It describes pulling in a flat file rather than describing creating one - but I think it'll help.

amang

thank you, the mapping from a xml- to a flatfile works now.

The remaining problem is, that the incoming flatfiles aren´t always send with the same linetypes to biztalk (like described in the first post). Some lines are optional.
But i will try some more options, i am testing at the moment.