The flat file strikes back: BizTalk 2004 parsing positional records

re: The flat file strikes back: BizTalk 2004 parsing positional records

Norbert — Mon, 28 Jun 2004 08:12:00 GMT

Thanks for the big help. I'm really new with flat files. But I tried to run the schema with the dat using FFDAsm, but it still generates an error. It is in Dutch but this what it says:

Error
Source: System.Xml
Message: Data on root(?) level is invalid. Line 1 Position 1

HRESULT: 80131940

Thanx

re: The flat file strikes back: BizTalk 2004 parsing positional records

Norbert — Mon, 28 Jun 2004 08:34:00 GMT

Forget the previous comment
I got the \r\n error but solved this with:

allow_early_termination="true"

Getting another error:
Message: Unexpected end of stream looking for: P0sitional Data (Length is 30)
The current definition being parsed is ARecordB. The sream offset where the error occured is 1322.

Thanx

re: The flat file strikes back: BizTalk 2004 parsing positional records

Norbert — Mon, 28 Jun 2004 09:50:00 GMT

This is the schema I need to use on the flatfiles, but I think the Flat Files we get ( my company) can sometimes be a bit different, but they should be like the schema because it is used as a standard.

<?xml version="1.0" encoding="utf-16" ?>
- <xs:schema xmlns="http://Schemas.HA34_3"">http://Schemas.HA34_3" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" targetNamespace="http://Schemas.HA34_3"">http://Schemas.HA34_3" xmlns:xs="http://www.w3.org/2001/XMLSchema">
- <xs:annotation>
- <xs:appinfo>
<schemaEditorExtension:schemaInfo namespaceAlias="b" extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension" standardName="Flat File" xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions" />
<b:schemaInfo root_reference="DECL_HA34_3" count_positions_by_byte="false" standard="Flat File" allow_early_termination="true" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="DECL_HA34_3">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" child_delimiter_type="hex" child_delimiter="0x0D 0x0A" child_order="postfix" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element minOccurs="1" maxOccurs="unbounded" name="HA34_3">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo sequence_number="1" structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="BERICHTBEGIN_INFORMATIE">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo sequence_number="1" structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="COD001_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="1" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="TEC025_OO1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="2" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD002_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="3" justification="left" pos_length="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM001_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="4" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD061_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="5" justification="left" pos_length="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD377_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="6" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD085_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="7" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD181_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="8" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="DAT105_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="9" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="DAT106_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="10" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM029_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="11" justification="left" pos_length="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD363_ISO" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="12" justification="left" pos_length="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="DAT031_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="13" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM002_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="14" justification="left" pos_length="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="TEC007_085" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="15" justification="left" pos_length="85" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element name="VERZEKERDEN">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo sequence_number="2" structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element minOccurs="1" maxOccurs="unbounded" name="VERZEKERDE">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo sequence_number="1" structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="COD001_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="1" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM040_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="2" justification="left" pos_length="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD061_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="3" justification="left" pos_length="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM003_ZNET" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="4" justification="left" pos_length="15" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD038_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="5" justification="left" pos_length="11" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="NUM050_BELA" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="6" justification="left" pos_length="9" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="NUM087_ECP" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="7" justification="left" pos_length="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="DAT006_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="8" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD134_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="9" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD241_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="10" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="NAM067_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="11" justification="left" pos_length="25" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="NAM025_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="12" justification="left" pos_length="6" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="NAM068_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="13" justification="left" pos_length="10" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD083_KPN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="14" justification="left" pos_length="6" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM030_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="15" justification="left" pos_length="5" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="NUM079_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="16" justification="left" pos_length="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD032_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="17" justification="left" pos_length="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD151_VEK1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="18" justification="left" pos_length="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD180_VEK1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="19" justification="left" pos_length="5" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD316_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="20" justification="left" pos_length="11" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="TEC007_010" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="21" justification="left" pos_length="10" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COMMENTAREN">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="22" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element minOccurs="1" maxOccurs="unbounded" name="COMMENTAAR">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="COD001_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="1" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM040_VEK4" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="2" justification="left" pos_length="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM109_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="3" justification="left" pos_length="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="OMS016_143" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="4" justification="left" pos_length="143" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="PRESTATIES">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="23" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element minOccurs="1" maxOccurs="unbounded" name="PRESTATIE">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo sequence_number="1" structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="COD001_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="1" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM040_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="2" justification="left" pos_length="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM003_ZNET" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="3" justification="left" pos_length="15" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD038_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="4" justification="left" pos_length="11" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD383_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="5" justification="left" pos_length="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COD089_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="6" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="NUM032_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="7" justification="left" pos_length="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="DAT021_NEN" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="8" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD367_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="9" justification="left" pos_length="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD322_CTG" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="10" justification="left" pos_length="5" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="ANT054_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="11" justification="left" pos_length="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="NUM015_VEK1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="12" justification="left" pos_length="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD078_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="13" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="BED023_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="14" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="BED020_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="15" justification="left" pos_length="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD043_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="16" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="TEC007_039" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="17" justification="left" pos_length="39" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="COMMENTAREN">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="18" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element minOccurs="1" maxOccurs="unbounded" name="COMMENTAAR">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo sequence_number="1" structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="COD001_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="1" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM040_VEK4" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="2" justification="left" pos_length="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="NUM109_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="3" justification="left" pos_length="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="OMS016_143" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="4" justification="left" pos_length="143" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element name="BERICHTEINDE_INFORMATIE">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo sequence_number="3" structure="positional" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="COD001_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="1" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="ANT074_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="2" justification="left" pos_length="5" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="BED025_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="3" justification="left" pos_length="10" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD043_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="4" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="COD044_VEKT" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="5" justification="left" pos_length="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="1" name="TEC007_142" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo sequence_number="6" justification="left" pos_length="142" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

re: The flat file strikes back: BizTalk 2004 parsing positional records

Gilles — Tue, 29 Jun 2004 16:46:00 GMT

Norbert: Wjat do you mean by "can sometimes be a a bit different"? As you already know, you flat file is currently parsed with a sequence of 2 record A and two records of type B. If that strcuture changes,then you will fail on thsoe messages.

As far as your error is concerned (error looking for positional data lenght = 30) it usually means that the parser ran out of data while parsing the line. Either way, you specified a record with a larger with that it is or you did not get your line separator fine.

I understand that once parsed, the XML should validate against the above schema. As I am sure you understand, there are two ways to deal with this: 1) you parse the file and produce the right XML using the flat file disassembler. 2) you parse the file to some XML that is close to the schema you need but not exactly it and you then use a map to adjust the XML to validate against your schema.

re: The flat file strikes back: BizTalk 2004 parsing positional records

Martins — Fri, 23 Jul 2004 19:06:00 GMT

Hi Gilles,

where can I find these tricks and not published annotation's like allow_early_termination="true" ?

Is there any help not shipped with bts2004 ?

thanks,
Martins

re: The flat file strikes back: BizTalk 2004 parsing positional records

Gilles — Fri, 23 Jul 2004 20:39:00 GMT

Martins: You might not have updated your documentation to the latest refresh. Downloads are available on http://www.microsoft.com/biztalk.

More specifically, the attribute you mention (and others) is documented here:

http://msdn.microsoft.com/library/en-us/sdk/htm/ebiz_prog_edit_ytch.asp?frame=true

Thanks.

Assembling A Delimited File with Positional Elements

Zen and the Art of Development — Wed, 04 Aug 2004 00:21:00 GMT

re: The flat file strikes back: BizTalk 2004 parsing positional records

John — Wed, 04 Aug 2004 11:29:00 GMT

Hi Gilles,

How do you handle file that has has spaces. Simple example:

-----------------------------------------------
Definition -

Header 10 characters
Detail 10 characters
Footer 10 characters

CRLF as the end of line.

Data -

Header XXXXXXX**
Detail XXXXX****
Detail XXXXXX***
Detail XX***XX**
Footer XXXX***XX

* = space
X = data
-----------------------------------------------
I can read the data in but all spaces are striped & when we send the data out via a send pipeline assembler this is reflected. Is there a way to get the XML to preserve the spaces? Thats the trick I am trying to work out - spaces both between data and at the end of the data line. I am also trying to avoid defining all fields, just want to specify the record as one field with CRLF the delimiter between records.

Thanks in advance.

John.

re: The flat file strikes back: BizTalk 2004 parsing positional records

Gilles — Wed, 04 Aug 2004 17:14:00 GMT

John: By default, as I explained, padding is set to "whitespace" and "ignore padding".

If you do not wish this to happen, set "pad character type" to "none". Everything will be considered as valuable data. This setting is per field, so you will have to do this on every single field you want to keep spaces.

re: The flat file strikes back: BizTalk 2004 parsing positional records

John — Thu, 05 Aug 2004 03:07:00 GMT

Thank Gilles,

I was able to read in any flat file with CRLF at the end of each row and maintain the spaces by specifying: {pad_char_type="hex" pad_char="0x0A"}

Note all rows are read into 1 field called "Field" - Schema below.

Thanks for pointing me in the right direction!!

Cheers.

-------------------------------------------------------------------------------

<?xml version="1.0" encoding="utf-16"?>
<xs:schema xmlns="http://BizTalk_Server_Project1.Schema1"">http://BizTalk_Server_Project1.Schema1" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" targetNamespace="http://BizTalk_Server_Project1.Schema1"">http://BizTalk_Server_Project1.Schema1" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:annotation>
<xs:appinfo>
<b:schemaInfo count_positions_by_byte="false" standard="Flat File" root_reference="Root" />
<schemaEditorExtension:schemaInfo namespaceAlias="b" extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension" standardName="Flat File" xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions" />
</xs:appinfo>
</xs:annotation>
<xs:element name="Root">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" child_delimiter_type="hex" child_delimiter="0x0D 0x0A" child_order="postfix" />
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
<xs:element maxOccurs="unbounded" name="Record">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" child_delimiter_type="hex" child_delimiter="0x0D 0x0A" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
<xs:element maxOccurs="unbounded" name="Field" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" pad_char_type="hex" pad_char="0x0A" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

re: The flat file strikes back: BizTalk 2004 parsing positional records

Mark — Thu, 05 Aug 2004 19:39:00 GMT

Please explain the use of <Sequence> nodes in your schema. I've never had to use them, but maybe I should be??

Mark

replies to mark_at_markscott_dot_net would be great.

Assembling A Delimited File with Positional Elements

Zen and the Art of Development — Tue, 10 Aug 2004 05:52:00 GMT

re: Managing Flat Files in BizTalk 2004

synBoogaloo — Fri, 28 Apr 2006 23:27:17 GMT