Q:
Hi
I have generated schema by flatfile schema wizard, and its working fine if i have all the records.. and if have no records in optional records..its not generating proper schema
this is the flatfile
18195-014
LAHPE
E5ASx14/1P-SC-S
----
E5ASx14/1P-SC-S
----
E5ASx14/1P-SC-S
E5AS
EA
751
E5AS
EA
751
0
0
161
161
E
E_E Type
5AS_Size 5AS
SC_SS+CU
H_High Theta
1P_1 Pass
S_Pressure Class S
14
FP_Both sides
3_*E*
151_*5AS*
3_*E*
151_*5AS*
3_E unit stud b allowed
1
BMSTART ------------- Constant Value
2;;34571;1;
2;;34572;1;
2;;33111;1;
2;;33106;6;
2;;33110;5;
BMEND ------------- Constant Value
DWGSTART ------------- Constant Value
CD000080
DWGEND ------------- Constant Value
MQS ------------- Constant Value
CQ00021S
CONSTART ------------- Constant Value
F4;-;
F3;-;
F1;-;
F2;-;
CONEND ------------- Constant Value
BMSTART ------------- Constant Value
2;;34571;1;
2;;34572;1;
2;;33111;1;
2;;33106;6;
2;;33110;5;
BMEND ------------- Constant Value
DWGSTART ------------- Constant Value
CD000080
DWGEND ------------- Constant Value
MQS ------------- Constant Value
CQ00021S
CONSTART ------------- Constant Value
F4;-;
F3;-;
F1;-;
F2;-;
CONEND ------------- Constant Value
this is the schema...
<?xml version="1.0" encoding="utf-16" ?>
- <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns="http://www.sdr.net/BizTalk/Internal/Av_Flatfile_BOM" targetNamespace="http://www.sdr.net/BizTalk/Internal/Av_Flatfile_BOM" 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 standard="Flat File" codepage="65001" default_pad_char="" pad_char_type="char" count_positions_by_byte="false" parser_optimization="complexity" lookahead_depth="0" suppress_empty_nodes="false" generate_empty_nodes="true" allow_early_termination="false" early_terminate_optional_fields="false" allow_message_breakup_of_infix_root="false" compile_parse_tables="false" root_reference="Av_Flatfile_BOM" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="Av_Flatfile_BOM">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" child_order="postfix" sequence_number="1" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="ItemNumber" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="RevisionNo" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="RevisionComments1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="RevisionComments2" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="CreatedBy" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="5" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdrDescr1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="6" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdrDescr2" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="7" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdrDescr3" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_int_descr" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="9" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_sort_key" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="10" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_Unitofmeasure" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="11" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_pcc" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_former_nbr" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="13" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_superceeded" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="14" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_grp_tech" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="15" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_substitute_item" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="16" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_phantom" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="17" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_war_mtrl" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="18" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_confg_code" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="19" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_manuf_loc" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="20" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="21" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim2" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="22" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim3" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="23" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim4" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="24" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim5" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="25" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim6" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="26" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_item_type" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="27" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_type" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="28" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_size" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="29" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_material" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="30" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_subtype" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="31" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_execution" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="32" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_pressure" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="33" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_no_of_pl" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="34" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_cfg_denom" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="35" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_cfg_active" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="36" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_type_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="37" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_size_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="38" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_material_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="39" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_subtype_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="40" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_execution_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="41" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_pressure_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="42" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_low_pl_no" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="43" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_high_pl_no" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="44" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_cdof" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="45" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_plm" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="46" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_con_ass_code" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="47" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_special_confg" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="48" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_drawing_status" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="49" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element default="BMSTART" name="BMSTART" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="50" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="BM_INFO">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="char" child_delimiter=";" child_order="postfix" sequence_number="51" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="Constant" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Conn_Position" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="ArticleNo" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Quantity" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element default="BMEND" name="BMEND" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="52" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element default="DWGSTART" name="DWGSTART" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="53" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="DWG_INFO">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" child_order="infix" sequence_number="54" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="DrawingNo">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
<xs:complexType />
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element default="DWGEND" name="DWGEND" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="55" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element default="MQS" name="MQS" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="56" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="MQS_INFO">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" child_order="infix" sequence_number="57" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="MQSId">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
<xs:complexType />
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element default="CONSTART" name="CONSTART" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="58" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="CON_INFO">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="char" child_delimiter=";" child_order="postfix" sequence_number="59" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="Conn1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Conn2" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element default="CONEND" name="CONEND" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="60" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns="http://www.sdr.net/BizTalk/Internal/Av_Flatfile_BOM" targetNamespace="http://www.sdr.net/BizTalk/Internal/Av_Flatfile_BOM" 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 standard="Flat File" codepage="65001" default_pad_char="" pad_char_type="char" count_positions_by_byte="false" parser_optimization="complexity" lookahead_depth="0" suppress_empty_nodes="false" generate_empty_nodes="true" allow_early_termination="false" early_terminate_optional_fields="false" allow_message_breakup_of_infix_root="false" compile_parse_tables="false" root_reference="Av_Flatfile_BOM" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="Av_Flatfile_BOM">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" child_order="postfix" sequence_number="1" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="ItemNumber" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="RevisionNo" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="RevisionComments1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="RevisionComments2" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="CreatedBy" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="5" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdrDescr1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="6" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdrDescr2" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="7" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdrDescr3" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="8" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_int_descr" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="9" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_sort_key" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="10" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_Unitofmeasure" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="11" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_pcc" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="12" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_former_nbr" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="13" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_superceeded" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="14" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_grp_tech" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="15" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_substitute_item" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="16" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_phantom" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="17" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_war_mtrl" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="18" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_confg_code" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="19" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_manuf_loc" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="20" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="21" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim2" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="22" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim3" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="23" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim4" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="24" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim5" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="25" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_dim6" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="26" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_item_type" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="27" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_type" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="28" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_size" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="29" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_material" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="30" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_subtype" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="31" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_execution" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="32" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_pressure" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="33" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_no_of_pl" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="34" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_cfg_denom" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="35" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_cfg_active" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="36" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_type_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="37" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_size_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="38" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_material_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="39" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_subtype_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="40" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_execution_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="41" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_pressure_group" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="42" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_low_pl_no" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="43" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_high_pl_no" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="44" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_cdof" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="45" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_plm" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="46" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_con_ass_code" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="47" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_special_confg" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="48" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="sdr_drawing_status" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="49" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element default="BMSTART" name="BMSTART" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="50" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="BM_INFO">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="char" child_delimiter=";" child_order="postfix" sequence_number="51" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="Constant" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Conn_Position" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="ArticleNo" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Quantity" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element default="BMEND" name="BMEND" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="52" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element default="DWGSTART" name="DWGSTART" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="53" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="DWG_INFO">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" child_order="infix" sequence_number="54" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="DrawingNo">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
<xs:complexType />
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element default="DWGEND" name="DWGEND" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="55" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element default="MQS" name="MQS" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="56" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="MQS_INFO">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" child_order="infix" sequence_number="57" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="MQSId">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
<xs:complexType />
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element default="CONSTART" name="CONSTART" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="58" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element minOccurs="0" maxOccurs="unbounded" name="CON_INFO">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited" child_delimiter_type="char" child_delimiter=";" child_order="postfix" sequence_number="59" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="Conn1" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Conn2" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element default="CONEND" name="CONEND" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="60" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
I am facing problem when i have a file like this
18195-014
LAHPE
E5ASx14/1P-SC-S
----
E5ASx14/1P-SC-S
----
E5ASx14/1P-SC-S
E5AS
EA
751
E5AS
EA
751
0
0
161
161
E
E_E Type
5AS_Size 5AS
SC_SS+CU
H_High Theta
1P_1 Pass
S_Pressure Class S
14
FP_Both sides
3_*E*
151_*5AS*
3_*E*
151_*5AS*
3_E unit stud b allowed
1
BMSTART --------------- no record
BMEND
DWGSTART
CD000080
DWGEND
MQS ----------------------- no record
CONSTART------------------- no record
CONEND
BMSTART --------------- no record
BMEND
DWGSTART
CD000080
DWGEND
MQS ----------------------- no record
CONSTART------------------- no record
CONEND
if i validate instance...i am getting like this..
- <Av_Flatfile_BOM xmlns="http://www.sdr.net/BizTalk/Internal/Av_Flatfile_BM">
<ItemNumber xmlns="">45066</ItemNumber>
<RevisionNo xmlns="" />
<RevisionComments1 xmlns="" />
<RevisionComments2 xmlns="" />
<CreatedBy xmlns="" />
<sdrDescr1 xmlns="">NPT 1/2" - 14</sdrDescr1>
<sdrDescr2 xmlns="" />
<sdrDescr3 xmlns="" />
<sdr_int_descr xmlns="">NPT 1/2" - 14</sdr_int_descr>
<sdr_sort_key xmlns="">THREAD NPT</sdr_sort_key>
<sdr_Unitofmeasure xmlns="">EA</sdr_Unitofmeasure>
<sdr_pcc xmlns="">330</sdr_pcc>
<sdr_former_nbr xmlns="" />
<sdr_superceeded xmlns="" />
<sdr_grp_tech xmlns="" />
<sdr_substitute_item xmlns="" />
<sdr_phantom xmlns="">0</sdr_phantom>
<sdr_war_mtrl xmlns="" />
<sdr_confg_code xmlns="">0</sdr_confg_code>
<sdr_manuf_loc xmlns="">111*161</sdr_manuf_loc>
<sdr_dim1 xmlns="">20</sdr_dim1>
<sdr_dim2 xmlns="">18</sdr_dim2>
<sdr_dim3 xmlns="">2</sdr_dim3>
<sdr_dim4 xmlns="">22</sdr_dim4>
<sdr_dim5 xmlns="">14.5</sdr_dim5>
<sdr_dim6 xmlns="" />
<sdr_item_type xmlns="">C</sdr_item_type>
<sdr_type xmlns="">CO_Connection</sdr_type>
<sdr_size xmlns="" />
<sdr_material xmlns="">SS_Stainless Steel</sdr_material>
<sdr_subtype xmlns="">N_NPT Thread</sdr_subtype>
<sdr_execution xmlns="">TH_Thread</sdr_execution>
<sdr_pressure xmlns="" />
<sdr_no_of_pl xmlns="" />
<sdr_cfg_denom xmlns="">1/2"NPT</sdr_cfg_denom>
<sdr_cfg_active xmlns="">FP_Both sides</sdr_cfg_active>
<sdr_type_group xmlns="" />
<sdr_size_group xmlns="" />
<sdr_material_group xmlns="" />
<sdr_subtype_group xmlns="" />
<sdr_execution_group xmlns="" />
<sdr_pressure_group xmlns="" />
<sdr_low_pl_no xmlns="">0</sdr_low_pl_no>
<sdr_high_pl_no xmlns="">500</sdr_high_pl_no>
<sdr_cdof xmlns="">2_*STD**CUST*</sdr_cdof>
<sdr_plm xmlns="" />
<sdr_con_ass_code xmlns="">1_Connection not ____</sdr_con_ass_code>
<sdr_special_confg xmlns="" />
<sdr_drawing_status xmlns="">1</sdr_drawing_status>
<BMSTART xmlns="">BMSTART</BMSTART>
- <BM_INFO xmlns="">
<Constant>2</Constant>
<Conn_Position />
<ArticleNo>46646</ArticleNo>
<Quantity>0.078</Quantity>
</BM_INFO>
<BMEND xmlns="">BMEND</BMEND>
<DWGSTART xmlns="">DWGSTART</DWGSTART>
<DWGEND xmlns="">CD000009-1</DWGEND> ---------------------------------------
<MQS xmlns="">DWGEND</MQS> -----------------------------------
<CONSTART xmlns="">MQS</CONSTART> ---------------------
<CONEND xmlns="">CQ00021S</CONEND> ------------------------
</Av_Flatfile_BM>
Sol:
Fix1: try
setting the property "ParserOptimization" to Complexity in order to handle optional records.
If the issue resides in the last optional fields of some records, you need to set the "Allow Early Termination" AND "Early Terminate Optional Fields" properties to yes.
Fix2: Try
In the Root Properties Change it to the following..
Child Delimiter: 0xD0xA
Type: HexaDecimal
order : postfix
No comments:
Post a Comment
Post Your Comment...