| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| get messages in email input node |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqjeff |
 Posted: Wed Aug 24, 2011 1:21 am Post subject: |
 |
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| RITCHEA wrote: |
| IF Root.MIME.Parts.Content-Type= '*.txt' |
The esql "=" does not do any wildcarding. Why do you think it does? |
|
| Back to top |
|
 |
| RITCHEA |
| Posted: Wed Aug 24, 2011 3:28 am Post subject: |
|
|
Apprentice
Joined: 25 Jul 2011
Posts: 27
|
the following is the message i am getting as output of emailinput node, but what i require is just the attachment part (999,MUR1234567890124,2,RTG,20030811,1125,2,0,XXXXXXXXX,CANBH03127000003,21
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,) How should i do it...
FILE:-
Content-Type: multipart/mixed; boundary="----=_Part_164_3340072.1314181237260"
------=_Part_164_3340072.1314181237260
Content-Type: text/plain; charset=us-ascii
--
Best Regards
Kumari Chand
Entry Level Trainee Programmer
Extn : 911
www.omnitechglobal.com
------=_Part_164_3340072.1314181237260
Content-Type: application/octet-stream; name="BODY1.CSV"
999,MUR1234567890124,2,RTG,20030811,1125,2,0,XXXXXXXXX,CANBH03127000003,21
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
,,,,,,,,,,
------=_Part_164_3340072.1314181237260-- |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Aug 24, 2011 4:17 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
By understanding what the ESQL = sign means and does.
By understanding what other ESQL operators or functions may allow you to access the .csv part of a given string.
By understanding that, just because an email attachment is marked as being a .csv, that it might in fact contain a jpeg file of terrible aspect. |
|
| Back to top |
|
|
| RITCHEA |
| Posted: Tue Sep 06, 2011 3:05 am Post subject: |
|
|
Apprentice
Joined: 25 Jul 2011
Posts: 27
|
able to solve this problem...
just need to write following ESQL in compute node to get first attachment
CREATE LASTCHILD OF OutputRoot DOMAIN 'BLOB' PARSE (InputRoot.MIME.Parts.Part[2].Data.BLOB.BLOB ENCODING MQENC_NATIVE CCSID 1208); |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Sep 06, 2011 5:33 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| RITCHEA wrote: |
able to solve this problem...
just need to write following ESQL in compute node to get first attachment
CREATE LASTCHILD OF OutputRoot DOMAIN 'BLOB' PARSE (InputRoot.MIME.Parts.Part[2].Data.BLOB.BLOB ENCODING MQENC_NATIVE CCSID 1208); |
Except that that statement doesn't do very much at all, and is significantly more complicated than it needs to be.
it's the functional equivalent to
| Code: |
| Set OutputRoot.BLOB.BLOB=InputRoot.MIME.Parts.Part[2].Data.BLOB.BLOB; |
But it is much harder to read and understand. Fortunately for you, I'm sure that using PARSE for the BLOB domain is a no-op, so it won't actually cause additional CPU load to write it incorrectly like you have. |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
