locked
Re-structuring/formating message in orchestration RRS feed

  • Question

  • My messages, I receive are in plain string format (ActiveXMessageFormatter). Its non xml formal.

    e.g: SDFS8005934U05ProductDetails

    in detail, it is like:

    1) OriginID: SDFS

    2) PRODID: 8005934

    3) UNITID:U05

    4) INFORMATION: ProductDetails

    I need to have a c# program (I am assuming that it is of type BizTalk Orchestration) which gives me the output structuring as:

    "OriginID:SDFS;PRODID:8005934;UNITID:U05;INFORMATION:ProductDetails"

    How can I achieve that. Is it possible. Can you please give me direction which way to proceed.

    Thank you.

    Thursday, March 15, 2018 3:31 PM

Answers

  • What you have is a delimited Flat File so you should use the Flat File Disassembler in the Receive Location to convert that format to Xml.

    You can then process it normally in a Map, Orchestration or Send Port.

    • Marked as answer by Aryaa Monday, June 4, 2018 8:21 PM
    Thursday, March 15, 2018 5:50 PM
    Moderator
  • As suggested use the Flat File Disassembler

    Output can likewise easily be converted from the internal XML format to a flat file structure according to your requirements

    More on the Flat File Disassmbler
    https://developersource.wordpress.com/2016/05/02/convert-flat-files-to-xml-in-biztalk-using-flat-file-disassembler/

    /Peter

    • Marked as answer by Aryaa Monday, June 4, 2018 8:22 PM
    Thursday, March 15, 2018 6:00 PM
  • You can use any combination of line prefix, fixed length and/or delimiter

    Splitting your text: "SDFS8005934U05ProductDetails" in needed elements is easy as it goes using the flatfile disassembler wizard

    Please give it  try and let us know if you meet any obstacles

    Thanks /Peter

    • Marked as answer by Aryaa Monday, June 4, 2018 8:22 PM
    Tuesday, March 27, 2018 9:23 PM

All replies

  • What you have is a delimited Flat File so you should use the Flat File Disassembler in the Receive Location to convert that format to Xml.

    You can then process it normally in a Map, Orchestration or Send Port.

    • Marked as answer by Aryaa Monday, June 4, 2018 8:21 PM
    Thursday, March 15, 2018 5:50 PM
    Moderator
  • As suggested use the Flat File Disassembler

    Output can likewise easily be converted from the internal XML format to a flat file structure according to your requirements

    More on the Flat File Disassmbler
    https://developersource.wordpress.com/2016/05/02/convert-flat-files-to-xml-in-biztalk-using-flat-file-disassembler/

    /Peter

    • Marked as answer by Aryaa Monday, June 4, 2018 8:22 PM
    Thursday, March 15, 2018 6:00 PM
  • I do not have any delimiter between the fields. So will the flat file disassembler still work for me.

    I just know that a filed is so and so number of length to substring it out.

    Tuesday, March 27, 2018 7:32 PM
  • You sample appears to be delimited by the semi-colon [;] and colon [:] characters.
    Tuesday, March 27, 2018 7:41 PM
    Moderator
  • You can use any combination of line prefix, fixed length and/or delimiter

    Splitting your text: "SDFS8005934U05ProductDetails" in needed elements is easy as it goes using the flatfile disassembler wizard

    Please give it  try and let us know if you meet any obstacles

    Thanks /Peter

    • Marked as answer by Aryaa Monday, June 4, 2018 8:22 PM
    Tuesday, March 27, 2018 9:23 PM