IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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

Extracting the delimiters from the edi

  • 1.  Extracting the delimiters from the edi

    Posted Thu June 16, 2005 10:11 PM

    Hi,

    I’m getting a bizdoc variable from the TN and mapping some data from the bizdoc to an internal format document.can anyone tell me how to get the delimiters from the original EDI doc?

    Thanks in advance…

    ramesh


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


  • 2.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 03:09 AM

    could anyone help me on this issue?

    ramesh


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


  • 3.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 03:30 AM

    ramesh,

    Is the edidata string available? Can you describe the process flow or provide an example?

    Dave


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


  • 4.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 04:01 AM

    Dave,

    The Edi doc is sent to the TN and the processing rule executes a service.i specified the input specification as wm.tn.rec:ProcessingService which has the bizdoc variable,sender summary and the receiver summary.now i want to pass the EDI doc delimiters to the internal format document.

    ramesh


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


  • 5.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 04:19 AM

    I’m doing this from memory so I may be off a bit.
    The specification should be wm.tn.rec.bizDoc.
    See this thread [url=“wmusers.com”]wmusers.com
    You will then find a number of idata objects in the pipeline.
    One will be ICValues which will have the structure of your EDI document ISA to IEA. In there will be structure call @delimiters which will hold the delimiter values.

    HTH


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


  • 6.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 04:36 AM

    Chris,

    There is no ICValues object in the pipeline when EDI doc is passed to the TN, and there is no variable in the bizdoc envelope where in i can get the delimiters.

    ramesh.


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


  • 7.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 04:53 AM

    Did you change the specification?


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


  • 8.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 05:02 AM

    chris,

    i’m still using the wm.tn.rec:ProcessingService specification.
    Can you tell me which field holds the delimiters?
    ramesh.


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


  • 9.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 08:08 AM

    The delimiters are not identified in the bizdoc. After calling bizdocToRecord boundNode/ST/@delimiters holds the delimiters.


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


  • 10.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 04:12 PM

    Rob,

    when i call the bizdocToRecord service,i pass in the bizdoc variable as input and i am getting an empty boundNode document.there is nothing underneath it.can u tell me how to do it?

    Thanks
    ramesh


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


  • 11.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 08:18 PM

    Use the Wm EDI documentation to double check that all the setup for establishing EDI document types within IS have been successfully completed.


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


  • 12.  RE: Extracting the delimiters from the edi

    Posted Fri June 17, 2005 08:44 PM

    Rob,

    I have got the delimiters by parsing the EDI string using the substring function, but now i have to get the Transaction type,version and standard of the EDI doc.can you tell me how to get them without using the bizdocToRecord service?

    ramesh


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


  • 13.  RE: Extracting the delimiters from the edi

    Posted Sat June 18, 2005 01:20 AM

    You shouldn’t parse the EDI string yourself. You should focus on getting bizdocToRecord working, which does the parsing. Make sure you’re using the bizdocToRecord service that is in the WmEDIforTN package, not the standard TN bizdocToRecord.


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


  • 14.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 02:53 PM

    Rob

    I am using the bizdocToRecord service from the WmEDIforTN package,even then it is throwing the following exception:

    com.wm.ff.parse.StorageException: [FFP.0015.0005] Specified an invalid schema EDIFFSchema.X12.V4010:T%transactionName%, is not a Flat File Schema.

    and when i see the EDIFFSchema folder, the schema exists.
    and when we call the bizdocToRecord service, we never specify the schema.if i am not wrong, it actually matches the schema when it comes from the TN
    I know that we should’nt parse the EDI string to get the delimiters but there is no other solution i could find.and one more problem is i want to get the transactionName,version and standard.

    Can you tell me how to do this or any other solution to get this done.

    Thanks
    ramesh


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


  • 15.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 03:07 PM

    Ramesh,

    When you do the envelopeProcess on edidata string you will see the delimiters record in the pipeline,so extract the required delimiters from the pipeline.

    HTH,
    RMG


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


  • 16.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 03:37 PM

    wm.b2b.editn:bizdocToRecord will give you all of those details.

    The wm.b2b.editn:bizdocToRecord service is a flow service, so you can look at exactly what it is doing.

    The error you’re seeing:
    com.wm.ff.parse.StorageException: [FFP.0015.0005] Specified an invalid schema EDIFFSchema.X12.V4010:T%transactionName%, is not a Flat File Schema.

    indicates that “transactionName” doesn’t exist in the pipeline. The second step of the service determines the “standard”, “version” and “transactionName” of the document using the TN document type name. bizdoc/DocType/TypeName holds the TN doc type name. As an example, a doc type of “X12 4010 810” will return standard=X12, version=4010 and transactionName=810.

    The pub.flatFile:convertToValues step uses these variables to define the ffSchema input using “EDIFFSchema.%standard%.V%version%:T%transactionName%” and variable substitution.

    What’s odd is that standard and version are clearly substituted, but transaction name is not. I’m not sure what would cause that behavior. Best bet is to set things up so you can step through this service to see the value of bizdoc/DocType/TypeName, what getDetailFromTypeName returns, and so on.

    HTH


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


  • 17.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 03:40 PM

    RMG: since Ramesh is using TN and EDI for TN, there is no need to use the envelopeProcess. Deenveloping occurs under the covers. bizdocToRecord is the service Ramesh needs and once things are set up to get that working, all the data desired will be available in the pipeline.


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


  • 18.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 03:45 PM

    In my experience, the parsing error occurs when invoking bizdocToRecord at the group level, rather than at the transaction level. If you invoke it in a processing rule for, say the X12 4010 850, rather than the X12 Group or Envelope, then, as Rob says, all the needed data should be available in the pipeline.


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


  • 19.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 03:47 PM

    ramesh,
    Let me back you up a second so I can get a handle on some of the basics of your setup. The key I saw in your post is the error you just identified indicating that bizdocToRecord could not identify the transaction name.

    Is the X12 doctype that you are translating setup completely in TN. In other words go to the doctypes and see if this document is listed there and in an active/enabled status an example would be X12 4010 850. Make sure it is enabled.

    Next save and restore your pipeline and check the bizdoc and let me know what is in the element bizdoc/DocType/TypeName. TypeName is used in the service wm.b2b.editn:getDetailFromTypeName where the transactionName is determined.

    The last thing I am looking for is EDIFFSchema.X12.V4010:T850 do you see a schema similar to this example for the document you are translating in the WmEDIforTN package?
    Thanks,
    Dawn


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


  • 20.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 03:54 PM

    Rob,

    I totally understand that he is routing the edi via TN,but since he is not able to pass thru the bizdocToRecord service,i told alternative method for extracting delimiters etc…may be he is missing something as users mentioned above.Ramesh pls make sure as Dawn mentioned above incase debugging the pipeline info helps.

    HTH,
    RMG


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


  • 21.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 03:56 PM

    Rob,

    I got them using the editn_grp Document type which is there in the pipeline.
    Thx for your suggestions

    Have a good day

    ramesh


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


  • 22.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 04:02 PM

    ramesh,
    So you are processing at the group envelope level (GS)? You probably need to process at the actual transaction level if you want your bizdoc to recognize the transaction level information. What is in the TypeName? If it is not the actual transaction 850, 810, etc… then this service will now know what Schema to use.
    Thanks,
    Dawn


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


  • 23.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 04:09 PM

    Hi Guys,

    Actually i’m processing at the Group level.may be that is the reason i was getting this error.our specification says to process at Group level.
    As RMG says,i’m routing the document through the TN.
    i got the solution using the EDITNGROUP Document type.

    Thanks for your valuable suggestions…

    ramesh


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


  • 24.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 04:16 PM

    Ramesh,

    Yes editn_grp,editn_env,editn_txn variables will be in the pipeline depends on the processing level (Group or Enveloper or transactionset)…once they are routed to a service.

    Glad you made resolved.

    HTH,


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


  • 25.  RE: Extracting the delimiters from the edi

    Posted Mon June 20, 2005 05:53 PM

    I wonder why the specification says to process at the group level? What is driving that desire? I assume that you’re doing some additional work to pull out each transaction set from the group and then translating each–additional code to write when EDI for TN will already do all that deenveloping for you.


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