none
How to convert CSV file to EDI 850 file? RRS feed

  • Question

  • Hi,

    We are getting csv file with one purchase order. we have to convert this csv file to EDI 850 file. Please let me know the procedure. Thanks


    ravindra

    Thursday, May 24, 2012 7:32 PM

All replies

  • you can put the data of CSV file into database....

    then poll the data and map it to the 850...

    Thursday, May 24, 2012 7:50 PM
  • Use a FlatfileDisassembler Pipeline Component and a Flatfile Schema to convert the csv file to XML (Receive it through a File Adapter). Then map, either to a canonical format and then to the EDI 850 Schema or directly to a EDI 850 Schema.

    Morten la Cour

    • Proposed as answer by sriaug Thursday, May 24, 2012 10:27 PM
    Thursday, May 24, 2012 8:22 PM
  • Hi,

    You can create a flat file schema for the csv file, receive this file in biztalk and then map this to the EDI 850. HTH


    Regards,
    Bali
    MCTS: BizTalk Server 2010,BizTalk Server 2006 and WCF
    My Blog:dpsbali-biztalkweblog
    -----------------------------------------------------
    Mark As Answer or Vote As Helpful if this helps.

    Friday, May 25, 2012 5:41 AM
  • Hi,

    How to generate ISA column after mapping flat file schema and EDI 850 schema?


    ravindra

    Tuesday, May 29, 2012 2:23 PM
  • The Values in the ISA column can be defined in the agreement between the two Parties defined in the BizTalk administration Console.
    • Edited by mitchke Tuesday, July 10, 2012 7:53 AM
    Tuesday, July 10, 2012 7:52 AM
  • You can import (or paste) your csv data onto Excel, then create a VB macro script with the edidev component to generate the 850 EDI file.  There is an example program "ExcelEdI850_As2.zip" posted at edidev website.
    Thursday, March 14, 2019 4:27 PM
  • You can import (or paste) your csv data onto Excel, then create a VB macro script with the edidev component to generate the 850 EDI file.  There is an example program "ExcelEdI850_As2.zip" posted at edidev website.
    They are asking this in the BizTalk forum, so asking how to do this in BizTalk, for which La Cour's answer is correct one.
    Thursday, March 14, 2019 9:12 PM