FlatFile, Custom Pipeline: Missing Data

Home Page Forums BizTalk 2004 – BizTalk 2010 FlatFile, Custom Pipeline: Missing Data

Viewing 1 reply thread
  • Author
    Posts
    • #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

    • #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.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.