| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| CSV message Not properly tramform into xml. Please help |
« View previous topic :: View next topic » |
| Author |
Message
|
| ashfaque.ansari |
 Posted: Mon Nov 14, 2011 10:25 pm Post subject: CSV message Not properly tramform into xml. Please help |
 |
|
Novice
Joined: 05 Sep 2011
Posts: 12
|
Hello ,
I m trying to convert r41 msg taking input into .csv and tramnsform it to .xml but below is my output.
<?xml version="1.0" ?>
- <CSV_1>
- <blockA>
<AppId>CAN</AppId>
<MsgId>F01</MsgId>
<IOId>O</IOId>
<MsgType>298</MsgType>
<SubMsgType>R41</SubMsgType>
<SenderAddress>CANB0239777</SenderAddress>
<ReceiverAddress>HDFC0123098</ReceiverAddress>
<DeliveryMonFlag>2</DeliveryMonFlag>
<OpenNotificationFlag>2</OpenNotificationFlag>
<NonDeliveryFlag>2</NonDeliveryFlag>
<ObsolescencePeriod>999</ObsolescencePeriod>
<MUR>MUR1234567890124</MUR>
<PossibleDupFlag>2</PossibleDupFlag>
<ServiceId>RTG</ServiceId>
<OrigDate>20030811</OrigDate>
<OriginTime>1125</OriginTime>
<TestTrainingFlag>2</TestTrainingFlag>
<SequenceNumber>101010101</SequenceNumber>
<Filler>XXXXXXXXX</Filler>
<UniqueTxRef>CANBH03127000003</UniqueTxRef>
<RTGSPriority>21</RTGSPriority>
</blockA>
- <block4>
<Trans_REF_Num>:2020:TRN/00000000001</Trans_REF_Num>
<Send_Receive_Info>,,,,,,,,,,,, :2006:RRN0000000000001,,,,,,,,,,,,,,,,,,,, :4488:20040130INR5000000,,,,,,,,,,,,,,,,,,,, :5517:BNKA0123ABC,,,,,,,,,,,,,,,,,,,, :6717:/C/SENDERCORRESPONDENTACC,,,,,,,,,,,,,,,,,,,, :5526:/CLINE 1 OF RECEIVERCORRESPONDENT,,,,,,,,,,,,,,,,,,,, :6521:BNKB0000001,,,,,,,,,,,,,,,,,,,, :7495:/FAST/RECEIPT1001,,,,,,,,,,,,,,,,,,,,</Send_Receive_Info>
</block4>
</CSV_1>
SO U CAN SEE THAT BLOCKa IS TRANSFORMINT INTO XML PROPERLY BUT BLOCK4 IS NOT. I HAVE USED <CR><LF> AS LINE TERMINATOR.
SO PLZ HELP ME TO FIND OUT THE ERROR |
|
| Back to top |
|
 |
| kimbert |
| Posted: Tue Nov 15, 2011 1:26 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
No help until you give the following information:
- what steps have you already taken to diagnose this problem? No point in asking you to repeat stuff that you have already tried.
- have you looked at the CSV samples in the Samples Gallery?
...and please don't SHOUT. It's bad manners. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Nov 15, 2011 5:32 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Using [c o d e ] blocks might help clarify the question. And taking a training class (or getting help from her onsite mentor if the OP doesn't have enough money to attend training).
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
