Flatfile Schema

amang
amang Member Posts: 14
edited 2005-08-22 in Navision e-Commerce
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

Comments

  • mark.cotton
    mark.cotton Member Posts: 1
    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
    amang Member Posts: 14
    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.

Categories