MQSeries.net :: View topic - Need help on XML to TDS conversion

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Need help on XML to TDS conversion

Need help on XML to TDS conversion

« View previous topic :: View next topic »

Author

Message

Muthukrishnan

Posted: Thu May 15, 2014 7:09 am Post subject: Need help on XML to TDS conversion

Apprentice

Joined: 16 Feb 2013
Posts: 48

We have a requirement to convert to XML to TDS in our project. I have converted the input to TDS format by setting the Properties.MessageFormat = 'TDS' in my esql and setting the Messaging Standard as HL7 and delimiter as '|'.

In addition to that we need to do the below steps to include ^ instead of '|'(delimiter) to one of the complex types residing inbetween the other complex types.

As of now I have set to ALL ELEMENTS DELIMITED in the message set as there as about 10 complex types. But the last complex type should not have '|' symbol.

** example of the field is the following:

Code:

UNEXPECTED OUTPUT
******************
|||N|N|N|||||||29800|||GA000780|Y

Code:

EXPECTED OUTPUT

^^^N^N^N^^^^^^^29800^^^GA000780^Y

The values present are mapped directly from input . The empty fields should not hold the length and will simply be denoted by ^^ instead of ||.

Please through some thoughts to achieve this.

kimbert

Posted: Fri May 16, 2014 4:21 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

I suspect that your message tree is the wrong shape, or else your message model is wrong. I cannot be sure, because this type of problem requires a huge amount of detail.
You can diagnose it yourself in the normal way
- add a Trace node before the output node
- take a debug-level user trace to see what the MRM TDS parser is doing

If you are on v8 or v9 then it will be simpler to use DFDL, not MRM.

IBM does provide a Healthcare Connectivity Pack which contains a full HL7 message set. Current versions based on IIB also include a DFDL model for HL7.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Need help on XML to TDS conversion

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP