ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SWIFT XML conversion

Post new topic  Reply to topic
 SWIFT XML conversion « View previous topic :: View next topic » 
Author Message
gvpatil
PostPosted: Sat Jul 10, 2004 1:50 pm    Post subject: SWIFT XML conversion Reply with quote

Newbie

Joined: 18 Jan 2002
Posts: 9
Hi,
We are trying to do conversion from SWIFT to XML. The flow uses MQInput, RCD and Compute Node.
The RCD parameters given are as follows, all checkboxes selected.
Message Domain MRM
Message Set - IBM SWIFT Message Set
Message Type - MT536
Message Format- SWIFT(SWIFT)

Qs: How do we navigate through the input SWIFT message to do the mapping in ESQL?
The output message has all the XML tags but no DATA.
The trace file for the trace node after RCD or after the MQInput node shows the following data. How do we access the element :28E
(
(0x1000000)Properties = (
(0x3000000)MessageSet = 'ITSMS70098001'
(0x3000000)MessageType = 'MT536'
(0x3000000)MessageFormat = 'SWIFT'
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = FALSE
(0x3000000)CreationTime = GMTTIMESTAMP '2004-07-10 20:43:35.280'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'INPUTQ'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 273
(0x3000000)CodedCharSetId = 819
(0x3000000)Format = 'MQSTR '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 0
(0x3000000)MsgId = X'414d5120514d31202020202020202020b819f04020009e01'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'QM1 '
(0x3000000)UserIdentifier = 'MUSR_MQADMIN'
(0x3000000)AccountingToken = X'16010515000000dcf4dc3ba931434016c0ea32f303000000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 28
(0x3000000)PutApplName = 'Websphere MQ Client for Java'
(0x3000000)PutDate = DATE '2004-07-10'
(0x3000000)PutTime = GMTTIME '20:43:35.280'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x1000021)MRM = (
(0x1000013)FIN = (
(0x1000013)SWBH = (
(0x300000B)LT_Identifier = 'CHASGB2LACPT'
(0x300000B)Session_Number = 2222
(0x300000B)Sequence_Number = 1
)
(0x1000013)FIN_INPUT_SWAH = (
(0x300000B)Message_Type = '536'
(0x300000B)Receivers_Address = 'CEDELULLXXXX'
(0x300000B)Message_Priority = 'N'
)
(0x300000B)SW121 = '
:16R:GENL
:28E:1/ONLY
:20C::SEME//CDS-OUT-572-1
:23G:NEWM
:69A::STAT//20020809/20020910
:22F::SFRE//DAIL
:22F::CODE//COMP
:97A::SAFE//333333
:17B::ACTI//Y
:17B::CONS//N
:16S:GENL
:16R:SUBSAFE
:16R:FIN
:35B:ISIN 123451234501
ISIN DESC 1
ISIN DESC 2
ISIN DESC 3
ISIN DESC 4
:16R:TRAN
:16R:LINK
:20C::PREV//001
:16S:LINK
:16R:LINK
:20C::RELA//1234567890
:16S:LINK
:16R:TRANSDET
:36B::PSTA//FAMT/10000011,
:22F::TRAN//SETT
:22H::REDE//DELI
:22H::PAYM//APMT
:22F::SETR/CEDE/NETT
:98A::ESET//20020304
:16R:SETPRTY
:95P::REAG//MGTCBEBE
:16S:SETPRTY
:16S:TRANSDET
:16S:TRAN
:16R:TRAN
:16R:LINK
:20C::PREV//001
:16S:LINK
:16R:LINK
:20C::RELA//1234567890
:16S:LINK
:16R:TRANSDET
:36B::PSTA//FAMT/10000012,
:22F::TRAN//SETT
:22H::REDE//DELI
:22H::PAYM//APMT
:22F::SETR/CEDE/NETT
:98A::ESET//20020304
:16R:SETPRTY
:95P::REAG//MGTCBEBE
:16S:SETPRTY
:16S:TRANSDET
:16S:TRAN
:16R:TRAN
:16R:LINK
:20C::PREV//001
:16S:LINK
:16R:LINK
:20C::RELA//1234567890
:16S:LINK
:16R:TRANSDET
:36B::PSTA//FAMT/10000013,
:22F::TRAN//SETT
:22H::REDE//DELI
:22H::PAYM//APMT
:22F::SETR/CEDE/NETT
:98A::ESET//20020304
:16R:SETPRTY
:95P::REAG//MGTCBEBE
:16S:SETPRTY
:16S:TRANSDET
:16S:TRAN
:16S:FIN
:16R:FIN
:35B:ISIN 123451234502
ISIN DESC 1
ISIN DESC 2
ISIN DESC 3
ISIN DESC 4
:16R:TRAN
:16R:LINK
:20C::PREV//001
:16S:LINK
:16R:LINK
:20C::RELA//1234567890
:16S:LINK
:16R:TRANSDET
:36B::PSTA//FAMT/10000021,
:22F::TRAN//SETT
:22H::REDE//DELI
:22H::PAYM//APMT
:22F::SETR/CEDE/NETT
:98A::ESET//20020304
:16R:SETPRTY
:95P::REAG//MGTCBEBE
:16S:SETPRTY
:16S:TRANSDET
:16S:TRAN
:16R:TRAN
:16R:LINK
:20C::PREV//001
:16S:LINK
:16R:LINK
:20C::RELA//1234567890
:16S:LINK
:16R:TRANSDET
:36B::PSTA//FAMT/10000022,
:22F::TRAN//SETT
:22H::REDE//DELI
:22H::PAYM//APMT
:22F::SETR/CEDE/NETT
:98A::ESET//20020304
:16R:SETPRTY
:95P::REAG//MGTCBEBE
:16S:SETPRTY
:16S:TRANSDET
:16S:TRAN
:16R:TRAN
:16R:LINK
:20C::PREV//001
:16S:LINK
:16R:LINK
:20C::RELA//1234567890
:16S:LINK
:16R:TRANSDET
:36B::PSTA//FAMT/10000023,
:22F::TRAN//SETT
:22H::REDE//DELI
:22H::PAYM//APMT
:22F::SETR/CEDE/NETT
:98A::ESET//20020304
:16R:SETPRTY
:95P::REAG//MGTCBEBE
:16S:SETPRTY
:16S:TRANSDET
:16S:TRAN
:16S:FIN
:16S:SUBSAFE
'
)
)
)
Any help is greatly appreciated.
Back to top
View user's profile Send private message Yahoo Messenger
Lisa
PostPosted: Sat Jul 10, 2004 8:12 pm    Post subject: Swift Reply with quote

Master

Joined: 07 Jun 2002
Posts: 287
Location: NJ
Hi,
Once you receive the MT536 message on the input queue, it should parse out into its proper SWIFT format. From there, you will reference the fields and assign them to the output format in your Compute node.

For example:
Set OutPut.Field1 to SWIFT.Tag.28E.Field1;
Set OutPut.Field2 to SWIFT.Tag.28E.Field2;

Hope this helps.

Lisa
Back to top
View user's profile Send private message Send e-mail
wooda
PostPosted: Mon Jul 12, 2004 1:38 am    Post subject: Reply with quote

Master

Joined: 21 Nov 2003
Posts: 265
Location: UK
Hi gvpatil -

looking at your trace extract I can see that your input message has not parsed correctly.

Your entire SWIFT message body has been parsed into one field SW121.

It should have been parsed into individual fields for each swift element.

Unfortunately I can' t tell anymore from the information available.

Maybe the inner message is not being correctly identified fro mthe key in the header ?
Back to top
View user's profile Send private message
brokendrum
PostPosted: Mon Jul 26, 2004 1:22 am    Post subject: Reply with quote

Apprentice

Joined: 14 Jan 2003
Posts: 34
Looks like the message is being parsed correctly right up until the first CRLF is encountered. I experienced this issue when trying to parse a Swift within an XML message, since all the CRLFs are replaced by LFs by the XML parser. I had to replace all the LFs with CRLFs to parse the Swift.

Regards,

BD
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SWIFT XML 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
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.