Announcement

Collapse
No announcement yet.

Inbound Translation of a Transmission

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Inbound Translation of a Transmission

    Hi,

    We have a need to change the location id being sent in the Order Release transmission to OTM. In the transmission the external application is building a location id. But we want to ignore that id and lookup OTM for an id and use the id that is being looked up.

    More info on the transaction: We are receiving the GlogXMLElement from the external system in GLOG schema format. We just want to replace the locationgid - /Transmission/TransmissionBody/GLogXMLElement/TransOrder/TransOrderLineDetail/TransOrderLine/ShipToLocationRef/LocationRef/Location/LocationGid/Gid/Xid with the one queried from OTM.


    Any ideas on how we can achieve that.

    Appreciate your time and suggestions.

    Regards
    SM
    Last edited by msk; July 24, 2008, 17:41. Reason: Added more info

  • #2
    Re: Inbound Translation of a Transmission

    It would be very easy to have a workflow agent (triggered on Order - Created or Updated) to do this lookup and replace.

    Gary
    Regards
    Gary Cunningham
    www.cbmc.co.uk
    www.mavenwire.com

    Comment


    • #3
      Re: Inbound Translation of a Transmission

      Hi,

      Thanks for the quick reply. Would it be possible to handle this in the transmission layer itself before transaction is persisted in the tables.

      Ideally we would not want to update system tables through our custom logic. If there is a way to replace the locationgid in the xml while processing the transmission, we would prefer that approach.

      Believe, IntSavedQuery will help in doing it. We are exploring that option. Any alternate ideas are appreciated.

      Thanks
      SM

      Comment


      • #4
        Re: Inbound Translation of a Transmission

        MSK,
        Which integration app are you using? We have done several "re-mappings" of data elements in the integration layer (i.e. before passed into OTM integration) for locations, items, organizations, and order release attributes.

        -Jeff

        Comment

        Working...
        X