webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Superscript character as field delimiter in EDI

webMethods Community Member

webMethods Community MemberWed July 02, 2003 04:19 PM

webMethods Community Member

webMethods Community MemberThu July 03, 2003 12:51 PM

  • 1.  Superscript character as field delimiter in EDI

    Posted Wed July 02, 2003 01:01 PM

    We have a trading partner using version X12 3020 docs with superscript character as the field delimiter.I will post a sample segment here:

    ISA³00³ ³00³ ³zz³1014663322 ³01³1122334455 ³040805³0432³U³00300³000000111³0³P³>

    So, we are not able to process the EDI Documents of this type.TN is able to recognise this document but the processing service fails

    Any help/ideas greatly appreciated.


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Superscript character as field delimiter in EDI

    Posted Wed July 02, 2003 01:14 PM

    Why does the service fail? What are the error messages?
    Remember the character is displayed differently depending on the system you’re on and the viewer you are using. All TN and EDI care about is the hex value of the Element Separator.
    Provide some more details.


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 3.  RE: Superscript character as field delimiter in EDI

    Posted Wed July 02, 2003 01:29 PM

    We are able to submit data to TN web console-WmTNforEDI.
    Submission of one single transaction set passes thru but when we try to submit multiple data the processing fails.

    When we do the same operation of submitting the data to the TN through a flow servce it fails again.

    Kindly let us know if there are any details relating to setting that needs to be taken care of.


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: Superscript character as field delimiter in EDI

    Posted Wed July 02, 2003 02:49 PM

    What content-type are you using?
    Try Application/EDIStream.


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: Superscript character as field delimiter in EDI

    Posted Wed July 02, 2003 03:17 PM

    I believe that submitting content with content-type of application/edistream is not supported by TN (see discussion [url=“wmusers.com”]wmusers.com).

    A project I’m working on has a partner that is using that same value for the sub-element delimiter. Try setting the content-encoding to ISO-8859-1, either on the submission side or if you have the bytes in your flow, set it in the bytesToString call.


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 6.  RE: Superscript character as field delimiter in EDI

    Posted Wed July 02, 2003 03:52 PM

    Hi Rob,

    application/EDIStream does work. I’ve been using it successfully since 4.6.

    Chris


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 7.  RE: Superscript character as field delimiter in EDI

    Posted Wed July 02, 2003 04:19 PM

    Cool. Thanks for the info Chris.


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 8.  RE: Superscript character as field delimiter in EDI

    Posted Thu July 03, 2003 11:36 AM

    Thanks Rob & Chris,

    Now we are able to submit multiple transactions through flow service by setting Content-type Application/EDIStream.But it fails whenever we tried to process document using wm.b2b.edi:envelopeProcess flow Service.

    Any suggetions.


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 9.  RE: Superscript character as field delimiter in EDI

    Posted Thu July 03, 2003 12:51 PM


  • 10.  RE: Superscript character as field delimiter in EDI

    Posted Thu July 03, 2003 01:18 PM

    Chris,

    wm.b2b.edi:envelopeProcess flow service generating “errorArray” output with the following messages.

    <?xml>
    <pathname>/ISA/ISA01/code</pathname>
    <errorcode>DT-STR001</errorcode>
    <errormessage>[B2BCORE.0082.9293] No matching choice value</errormessage>

    and generating “Values” output like this:

    <?xml>
    <isa>>>BasicData:record=0,field=Â,subfield=0,release= <<<">
    <isa01>
    <code>³</code>
    </isa01>
    <isa16>0</isa16>
    <undefdata>³ ³0³ ³zz³1014663322 ³01³1122334455 ³040805³0433³U³030³0322³0³T³>
    GS³IN³1014663322³1122334455³040805³0433³0322³X³03050</undefdata>

    Hope this information clarify my situation


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 11.  RE: Superscript character as field delimiter in EDI

    Posted Thu July 03, 2003 02:04 PM

    Vikram,

    You document seems to error on the ISA01 which is usually 00.
    However I see that your output is in XML format. The output from envelopeProcess Values, is a record (4.6) or document (6.0).
    What exactly are you mapping into edidata?
    You should be doing a bytesToString and map that output to edidata.
    Maybe you can share the sequence of steps you are following after you document gets to TN.


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 12.  RE: Superscript character as field delimiter in EDI

    Posted Thu July 03, 2003 02:24 PM

    Yes i am doing a bytesToString and map that output to edidata.Values, is a record(4.6), I am using recordTodocument to convert Values record into XML.This step i used for debugging purpose.

    Here is the sequence of steps that execute after document gets to TN:

    1.bytesToString
    2.envelopeProcess
    3.recordTodocument
    4.smtp

    steps 3 and 4 used for debugging purpose and here is the ISA segment of the EDI document that i submitted to TN.

    ISA³00³ ³00³ ³zz³1014663322 ³01³1122334455 ³040805³0432³U³00300³000000111³0³P³>

    regards
    Vikram


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 13.  RE: Superscript character as field delimiter in EDI

    Posted Thu July 03, 2003 03:00 PM

    I see “³” in the data of the error message. So your ISA looks to IS to be something like:

    ISA³00³ ³00³…

    Thus it thinks that  is your element delimiter and ³ is the value of ISA01, which is not a valid value. You need to set the encoding correctly in your bytesToString call. Set it to ISO-8859-1 and ³ won’t be turned into 2 characters during the conversion from bytes to string.


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 14.  RE: Superscript character as field delimiter in EDI

    Posted Thu July 03, 2003 04:44 PM

    Rob,

    Eventhough we set the encoding to ISO-8859-1, it is turning to 2 characters. Could you tell me what may be the reason for this.


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 15.  RE: Superscript character as field delimiter in EDI

    Posted Fri July 04, 2003 12:40 PM

    Hi

    It is working fine. We set the encoding to UTF-8. It is converting Properly and EDI processed successfully.

    Thanks Rob & Chris.

    regards
    Vikram


    #edi
    #webMethods
    #Integration-Server-and-ESB