Home Page › Forums › BizTalk 2004 – BizTalk 2010 › FlatFile, Custom Pipeline: Missing Data
- This topic has 1 reply, 1 voice, and was last updated 6 years, 11 months ago by
community-content.
-
AuthorPosts
-
-
August 2, 2006 at 10:37 PM #15190
Hello and thanks for your assistance.
I have a sample flat file definition, (provided below), then i have a custom send port that outputs the file contents in \”|\” delimited fashion.
– When I output the flat-file schema just using PassThruTransmit, the expected 2 lines of data exist.
– When I output the flat-file schema using the custom send pipeline, only the first line of the expected two lines of data exist.Question, why would the custom send pipeline only output the first line of data?
This is my first FlatFile attempt, I tried looking for ‘delimited’ samples, but was only able to find ‘positional’ file samples, if you know a link to a sample (preferably with images) please let me know.
(When you see the output (provided below), it looks like the when transmited using ‘PassThruTransmit’, it appears as though thier exists in the document two root elements, i think that this may be the problem, if infact, question: how would i set up the flat file to work as i need?)
=============================================
[u:6796d5e4a2]Expected File OutPut[/u:6796d5e4a2]
firstName_1|lastName_1|city_1
firstName_2|lastName_2|city_2=============================================
[u:6796d5e4a2]FlatFileSchema.xsd[/u:6796d5e4a2]
<?xml version=\”1.0\” encoding=\”utf-16\”?>
<xs:schema xmlns:b=\”http://schemas.microsoft.com/BizTalk/2003\” xmlns=\”http://Schemas.TestSchema\” targetNamespace=\”http://Schemas.TestSchema\” 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=\”speed\” lookahead_depth=\”3\” 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=\”Root\” />
</xs:appinfo>
</xs:annotation>
<xs:element name=\”Root\”>
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure=\”delimited\” child_delimiter_type=\”char\” child_delimiter=\”|\” child_order=\”infix\” sequence_number=\”1\” preserve_delimiter_for_empty_data=\”true\” suppress_trailing_delimiters=\”false\” repeating_delimiter_type=\”char\” />
</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=\”firstName\” type=\”xs:string\”>
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”1\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name=\”lastName\” type=\”xs:string\”>
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”2\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name=\”city\” type=\”xs:string\”>
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification=\”left\” sequence_number=\”3\” />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>**CONTINUED IN NEXT POST
-
August 2, 2006 at 10:39 PM #15191
**CONTINUED FROM ABOVE
============================================
[u:2fc38b1367]Output when using PassThru Transmit[/u:2fc38b1367]
<ns0:Root xmlns:ns0=\”http://Schemas.TestSchema\”><firstName>firstName_1</firstName><lastName>lastName_1</lastName><city>City</city></ns0:Root><ns0:Root xmlns:ns0=\”http://Schemas.TestSchema\”><firstName>firstName_2</firstName><lastName>lastName_2</lastName><city>City</city></ns0:Root>
============================================
[u:2fc38b1367]Output when using Custom Send Pipeline[/u:2fc38b1367]
firstName_1|lastName_1|city_1
==============================================
Thanks Again.
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.