none
How to create Custom EDI Schema in BTS 2006 R2 RRS feed

  • Question

  • Hello all,

    I need to create schema from customized EDI file.

    UNB+UNOA:1+sss+zzz+080925:0704+6932'UNH+1+LOGMES:1:0:BM'BGM+997'DTM+243:0809241748:201'NAD+MS+FWRAPPLICATION'NAD+MR+BM*DRIVE'SEQ++000001'LOC+8+PTAZACD'GIN+CN+W0L0XCF2594039564'DLM++Y:DC:Z06:ZGM'DTM+Z05:0809241628:201'GIR+1+0083LPKR:VV'LOC+Z0+PT0999:Z07:ZGM'LOC+Z04+PTAZACD'LOC+Z05+PT0035:Z07:ZGM'SEQ++000002'LOC+8+PTAZACD'GIN+CN+W0L0AHM758G178466'DLM++N:DC:Z06:ZGM'DTM+Z05:0809241638:201'GIR+1+0034LD9T:VV'LOC+Z0+PT0999:Z07:ZGM'LOC+Z04+PTAZACD'LOC+Z05+PT0053:Z07:ZGM'UNT+24+1'UNZ+1+6932'

    I tried to treat it as a flatfile and created FF schema out it. but ended up with "Unrecognized data in remaining stream."

    can anyone guide to create customised EDI schema

    Many thanks,
    Vidhya



    Wednesday, November 25, 2009 7:00 AM

Answers

  • Hi Vidhya,

    When you custumize EDI schemas you are a bit limited. If you want to define a segment group. The name of that record in your schema needs to look like "NADLoop". Especially the word Loop is important. That will get rid of the error.
    You also can't change the namespace of the schema.
    It is best to just stick to adding and/or removing segments or segment groups.
    If you wan't I can assist you a bit in the customisation.

    Kind Regards
    Tim
    Thursday, November 26, 2009 9:44 AM

All replies

  • Hi Vidya,

    You need to identify the closest match for your EDI message and add or delete the elements as per your custom schema. That is the better way to create a custom schema. Can I know which EDI message you are looking for ??

    Regards
    Vishnu


    Vishnu
    Wednesday, November 25, 2009 11:07 AM

  • Hi Vishnu,

    "LOGMES" is my customized EDI message type. I tried to find out the existing schema that matches with my reqired one. But it is not allowing me to add few nodes into it. It throwed me this error "node has invalid depth".

    Is it good to treat the same EDI file as Flat file and validate the instance in VS.net.

    If possible can you pls share the customized schema u created.

    Regards,
    Vidhya
    Thursday, November 26, 2009 5:33 AM
  • Hi Vidhya,

    When you custumize EDI schemas you are a bit limited. If you want to define a segment group. The name of that record in your schema needs to look like "NADLoop". Especially the word Loop is important. That will get rid of the error.
    You also can't change the namespace of the schema.
    It is best to just stick to adding and/or removing segments or segment groups.
    If you wan't I can assist you a bit in the customisation.

    Kind Regards
    Tim
    Thursday, November 26, 2009 9:44 AM
  • Hi Tim.

    It will be of great use to me, if u can assist in customization.

    Pls guide me to move forward.

    Regards,
    Vidhya
    Tuesday, December 1, 2009 3:40 AM
  • Hi Vidhya,

    Could you then explain the requirements in detail?

    Kind Regards
    Tim
    Tuesday, December 1, 2009 7:59 AM
  • Hi Tim,

    Pls find the details below.

    We are in the process of Migrating BTS 2002 to BizTalk 2006 R2.
    From the existing 2002 Input file, It has been clearly visible that they are maintaining customized EDI schema i.e "LOGMES" message type.
    In BTS 2002, they managed to create a customized EDI message of transaction type "LOGMES".
     
    Attaching sample input and 2002 Schema files.
     
    We tried to migrate that EDI Schema in 2006 R2 in the following ways.
     
    # Methods followed Errors
         
    1
    Changing extension from .xml to .xsd
    error BEC2004: Invalid root node reference found.
    2
    Using BTS06EdiSchemaMigrator.exe
    error BEC2004: Invalid root node reference found.
    3
    Creating EDI schema from scratch
    error BEC2004: Root element missing.
    4
    Adding/Modifying tags to already shipped schemas in 2006 R2 
    error BEC2004: Root element missing.
    5 Treating EDI Input as Flatfile and created FF schema out of it error BEC2004: Unrecognized data in remaining stream.
     
    Finding it very difficult to create customized schema in 2006 R2. Any help would be of great use.

    My sample Input file (ignore line break's. '  alone is the segment terminator )

    UNB+UNOA:1+0935HRB2001101+OPELPORPTAZAPT+091030:1247+00000000066602'UNH+1+LOGMES:1:0:GM'BGM+996:Z01:ZGM'
    DTM+243:0910301247:201'NAD+MS+GM*DRIVE'NAD+MR+0OPELPORPTAZAPT'
    SEQ++XXXXXX'LOC+8+PTAZACD'GIN+CN+W0L0AHL35A2023689'TDT+30+++++0OPELPOR'
    DLM++1:CO:Z06:ZGM'DTM+Z05:0910301228:201'GIR+1+0087MKX7:VV'
    LOC+Z0+PT0037:Z07:ZGM'LOC+Z05+PT0066:Z07:ZGM'LOC+Z04+PTLISDZ'
    LOC+Z06+PT0066:Z07:ZGM'GIN+CN+W0LGT8EM8A1029739'DLM++1:RH:Z06:ZGM'
    DTM+Z05:0910301241:201'GIR+1+0050MKM6:VV'LOC+Z0+PT0999:Z07:ZGM'
    GIN+CN+W0LGT8EM8A1029739'TDT+30+++++00000000'DLM++1:CO:Z06:ZGM'
    DTM+Z05:0910301241:201'GIR+1+0050MKM6:VV'LOC+Z0+PT0098:Z07:ZGM'
    LOC+Z05+PT0098:Z07:ZGM'LOC+Z04+PTOPPCC'LOC+Z06+PT0098:Z07:ZGM'
    GIN+CN+W0LGT8EM8A1029739'DLM++1:HO:Z06:ZGM'DTM+Z05:0910301241:201'
    GIR+1+0050MKM6:VV'LOC+Z0+PT0098:Z07:ZGM'GIN+CN+W0L0AHL35A2027029'
    DLM++1:RH:Z06:ZGM'DTM+Z05:0910301241:201'GIR+1+0046NFV5:VV'LOC+Z0+PT0999:Z07:ZGM'
    GIN+CN+W0L0AHL35A2027029'TDT+30+++++00000000'DLM++1:CO:Z06:ZGM'
    DTM+Z05:0910301241:201'GIR+1+0046NFV5:VV'LOC+Z0+PT0098:Z07:ZGM'
    LOC+Z05+PT0098:Z07:ZGM'LOC+Z04+PTOPPCC'LOC+Z06+PT0098:Z07:ZGM'
    GIN+CN+W0L0AHL35A2027029'DLM++1:HO:Z06:ZGM'DTM+Z05:0910301241:201'
    GIR+1+0046NFV5:VV'
    LOC+Z0+PT0098:Z07:ZGM'
    CNT+9:1:NMB'
    UNT+56+1'
    UNZ+1+00000000066602'

    Thanks,
    Vidhya
    Wednesday, December 2, 2009 9:04 AM