none
How to convert edifact document into xml using biztalk server 2006 r2? RRS feed

  • Question

  •  

    I didn't get any tutorial to convert the edifact (D97 A) document into Xml file.Can anyone plz help me to solve this problem?I m new in BTS 2006 R2.I don't have exact idea about this.Plz tell me the steps to solve it.

    Here is my source D97A document.

    UNA:+.? '
    UNB+UNOC:3+3013558310009:14+8713432000006:14+060914:0721+00000000000001++ORDERS++++1'
    UNH+00000000000001+ORDERSBig Smile:97A:UN'
    BGM+220+4500149097+9'
    DTM+137:20070726:102'
    DTM+2:20070727:102'
    RFF+ON:4500149097'
    NAD+BY+3013558310009::9'
    NAD+DP+8713432000006::9'
    NAD+IV+3013558310009::9'
    NAD+SU+8901124000018::9'
    CUX+2:EUR:4'
    LIN+1++4901780697809:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+2++4901780791255:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+3++4901780883264:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+4++4901780728619:EN'
    QTY+21:10002Stick out tongueCE'
    LIN+5++4901780627363:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+6++4901780697809:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+7++4901780791255:EN'
    QTY+21:10000Stick out tongueCE'
    UNS+S'
    UNT+33+00000000000001'
    UNZ+1+00000000000001'

    Saturday, February 2, 2008 12:13 PM

Answers

  • Yes, you can create a custom source schema for another EDIFACT document that isn't delivered out-of-the-box with the BizTalk 2006 base EDI Adapter. You can read some general guidance here or in this more specific KB article (see Authorizing schemas that did not ship out-of-the-box).

    You could also take an existing schema such as D97B ORDERS and modify that to conform to D96A ORDERS or if you prefer, use the D96A ORDERS that comes with R2 and modify it accordingly to work with BizTalk 2006 (some namespace changes as far as I can tell, but haven't tried).

    Hope that helps. Good luck and let us know how it goes.
    Monday, February 4, 2008 8:00 AM

All replies

  • Please, see the
    BizTalk 2006 R2 has a new EDI system with all standard schemas (EDIFACT schemas too), it has mechanism to convert EDI to Xml and backward automaticaly.
    Just use the EDIReceive pipeline in your receive port. Then use parties to set up the EDI processing.
    Use the SDK Samples to get idea. Use the BizTalk Help to get full information.
    Sunday, February 3, 2008 6:14 AM
  • Hi All!

    I want to know that if i m using biztalk server 2006 not R2 and i want to convert D96A Edifact document into Xml using BTS 2006.But problem is that the schema for D96A document is not available in BTS 2006 but it is available in BTS 2006 R2.But i want to use only BTS 2006 for this task.So Can i make custom (Source) schema for D96A document(Purchase Order) in BTS 2006?

     

    Thnx.....

     

    Monday, February 4, 2008 6:31 AM
  • Yes, you can create a custom source schema for another EDIFACT document that isn't delivered out-of-the-box with the BizTalk 2006 base EDI Adapter. You can read some general guidance here or in this more specific KB article (see Authorizing schemas that did not ship out-of-the-box).

    You could also take an existing schema such as D97B ORDERS and modify that to conform to D96A ORDERS or if you prefer, use the D96A ORDERS that comes with R2 and modify it accordingly to work with BizTalk 2006 (some namespace changes as far as I can tell, but haven't tried).

    Hope that helps. Good luck and let us know how it goes.
    Monday, February 4, 2008 8:00 AM
  • Thnx karloff..i vl try to do it...and will get back to u with update

     

    THNX

     

    Monday, February 4, 2008 9:35 AM
  • Hi Karloff...
    I m again here for my quiries.I m still facing problems to convert the edifact data into XML using BTS 2006 R2.
    I read the document on MSDN for this task but i cudn't solve this issue.
    See what i did so that u can easily identify the problem in my approach.I configured the properties of global setting for EDIFACT according to the document given in MSDN.But there were properties only for UNH,UNB etc but there are no properties to configure the other segments like NAD,QTY,BGM,LIN etc.These are the contents of EDIFACT file.For reference u can read the Edifact file given below:

    UNA:+.?'
    UNB+UNOC:3+3013558310009:14+8713432000006:14+060914:0721+00000000000001++ORDERS++++1'
    UNH+00000000000001+ORDERSBig Smile:97A:UN'
    BGM+220+4500149097+9'
    DTM+137:20070726:102'
    DTM+2:20070727:102'
    RFF+ON:4500149097'
    NAD+BY+3013558310009::9'
    NAD+DP+8713432000006::9'
    NAD+IV+3013558310009::9'
    NAD+SU+8901124000018::9'
    CUX+2:EUR:4'
    LIN+1++4901780697809:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+2++4901780791255:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+3++4901780883264:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+4++4901780728619:EN'
    QTY+21:10002Stick out tongueCE'
    LIN+5++4901780627363:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+6++4901780697809:EN'
    QTY+21:10000Stick out tongueCE'
    LIN+7++4901780791255:EN'
    QTY+21:10000Stick out tongueCE'
    UNS+S'
    UNT+33+00000000000001'
    UNZ+20+00000000000001'

    And generated XML is:

    - <ns0:Efact_Contrl_Root IsGeneratedAck="true" IsContrlReceipt="true" xmlns:ns0="http://schemas.microsoft.com/Edi/Edifact">
    - <ns1:UNH xmlns:ns1="http://schemas.microsoft.com/Edi/EdifactServiceSchema">
      <UNH1>4</UNH1>
    - <UNH2>
      <UNH2.1>CONTRL</UNH2.1>
      <UNH2.2>4</UNH2.2>
      <UNH2.3>1</UNH2.3>
      <UNH2.4>UN</UNH2.4>
      </UNH2>
      </ns1:UNH>
    - <UCI>
      <UCI1>00000000000001</UCI1>
    - <UCI2>
      <UCI2.1>8713432000006</UCI2.1>
      <UCI2.2>14</UCI2.2>
      </UCI2>
    - <UCI3>
      <UCI3.1>3013558310009</UCI3.1>
      <UCI3.2>14</UCI3.2>
      </UCI3>
      <UCI4>4</UCI4>
      <UCI5>26</UCI5>
      <UCI6>UNB</UCI6>
      </UCI>
    - <ns2:UNT xmlns:ns2="http://schemas.microsoft.com/Edi/EdifactServiceSchema">
      <UNT1>3</UNT1>
      <UNT2>4</UNT2>
      </ns2:UNT>
      </ns0:Efact_Contrl_Root>

    I m felling like in HELL bcoz i m not getting the right direction to solve this problem.Plz tell me is there any help on MSDN or some books or some links to Convert EDIFACT file into XML file so that i can try.
    Plz give me guidance.
    I m waiting for your reply.Thnx in advance.

    Tuesday, June 17, 2008 1:22 PM
  • See the Mohsin Kalam’s Blog http://mohsinkalam.wordpress.com/ He has tons of usefull articles about EDI.
     
    Do you use the 2006 R2 or just extract the EDI schema to use it in 2006?
    As I understand you've found the service schema. It is the "Envelope" schema. The "real" schemas with all segments are placed in huge archive file (thousand and thousand schemas). You have to extract schema you need.
     
    If you use 2006, not R2 you have to manualy compound two schemas, one you also got and the "real" schema.
     
    Here is the entry point for EDI documentation: http://msdn.microsoft.com/en-us/library/bb226324.aspx
     
    Wednesday, June 18, 2008 9:24 PM
  •  

    Hi Leonid,

    i am using the schema that are in the archieve file and i have already picked up the schema for d96a orders document and implemented the same schema but where i stuck is :
    i am not able to get the data in the NAD,QTY,BGM etc segments.
    i have already tried configuring the pipeline and i tried to change the settings to the schema as well but that too do not materialize.
    i am really kind of stuck to that place only and i need your help desperately.
    i visited the mohsin blogs as well but do not find the way to get the data that is in the edifact document.

    i really appreciate your favour if you provide me with the link or any kind of resource to get the data in the sub segments of the d96a document.

    as far as the errors are concerned there is no error for the transmission of the edifact document to xml, and i do realise that the xml generated is just a kind of acknowledgement ony as it do not contain any valid data.

     

    i apprecaite your favour if you go through the case and give me the appropriate answers

    i am ready to start from the scratch,and waiting for your reply

    plz forward me the specific steps to generate the xml from the edifact document.
    my work requires that,waiting for your reply.....
    Thanks in advance




    ramjeet
    Thursday, June 19, 2008 5:29 AM
  •  

    Hello

     

    You may consider also an alternative solution for BizTalk EDIFACT adapter:

     

    http://www.bsh.bg/whatwedo/bts.htm

     

    Regards,

    Raicho

    Friday, July 4, 2008 9:47 AM
  • Ramjeet,
    Did you go through the SDK samples for your case? If not it should be strictly recommended.
    First you have to go through all steps of the process and with SDK samples it much simpler then with custom code. When you are fell comfortable with the procedures start with your code.
     
    " am not able to get the data in the NAD,QTY,BGM etc segments." - what exactly wrong with it?
     
     
    Saturday, July 5, 2008 9:31 PM
  • Hi,
    Thaks for all of your help.
    the issue is being resolved....
    Thanks
    Ramjeet
    Monday, July 7, 2008 4:58 AM
  • Hello  Leonid Ganeline ,

    I need help in Biztalk 2006 R2 HIPAA.I am new to the HIPAA transaction implementation in Biztalk. I have a HIPAA276 transaction message at some stage in my orchestration. I need to convert this message in ANSI format before submitting to a IBM MQ. How to convert X12 message in to ANSI format in orchetsration?The down stream system only accepts the message in ANSI format only.
     
    I think  in BTS 2002 version it was done using HIPAA accelerator. I want implement this functionality in BTS 2006 R2.


    Can you body help me how can i do this from orchestration.

    Thanks in advance!!
    Yeggu_K

    Tuesday, September 9, 2008 11:13 AM