| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Does anyone have advice for creating an inbound email flow? |
« View previous topic :: View next topic » |
| Author |
Message
|
| jrsetters |
 Posted: Mon Dec 10, 2012 8:21 am Post subject: Does anyone have advice for creating an inbound email flow? |
 |
|
Acolyte
Joined: 24 Aug 2011
Posts: 72
Location: Cincinnati, OH
|
This is completely new to me and I am trying to work through the IBM sample.
My organization wants to take a simple email message that is generated by our transport tracking system and convert it into an outbound HL7 message to our EMR system.
What I will get is a very simple message that contains about 2 lines in the message body, always formatted in the same way:
JOB #12345, SMITH, JOHN 823456, FROM CCU RM 200 BED 01 TO LOBBY by Transport, BY Wheelchair
Basically, I would need to extract the following fields, store them in the environment then use a mapping node or eSQL compute node to build an HL7 message and plug them into the appropriate fields.
JOBNO - '12345'
LASTNAME - 'SMITH'
FIRSTNAME - 'JOHN'
ACCOUNTNUM - '823456'
FROMUNIT - 'CCU'
FROMROOM - '200'
FROMBED - '01'
TOLOCATION - 'LOBBY'
BYSERVICE - 'Trasnport'
BYMECHANISM - 'Wheelchair'
I don't think it will be a problem to extract the data because the deliminations used above are always the same. That is, the job number will be preceeded by the text "JOB #", the Last Name will always be after the first comma and so forth.
What I am having trouble understanding is how best to get the emails into the email input node in the first place. From the sample it sounds like my main options are to set up a POP or IMAP connection to an email server address and use configurable services to create a security token (mqsisetdbparms). Or it looks like I can use configurable services to create a local email service and create an inbound email port there.
We do not currently have any flows that are originated by inbound email, so this will be the first one configured in our organization.
I am wondering if anyone has configured an email input using a simple Exchange configuration. It seems like it would be pretty easy just to have an additional address added to our Exchange server where these messages are forwarded.
What is the best option here? |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Mon Dec 10, 2012 8:28 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Dec 10, 2012 8:30 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Where I've done it, I've done it by creating a POP connection to the existing email server and leaving the mail administrators to worry about space, storage, spam and all the other fun stuff.
It also allows for greater flexibility in the email address exposed and the mailbox used; there are all sorts of forwarding rules, tricks and tips than might be of benefit.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| goffinf |
| Posted: Mon Dec 10, 2012 11:10 am Post subject: Re: Does anyone have advice for creating an inbound email fl |
|
|
Chevalier
Joined: 05 Nov 2005
Posts: 401
|
| jrsetters wrote: |
I am wondering if anyone has configured an email input using a simple Exchange configuration. It seems like it would be pretty easy just to have an additional address added to our Exchange server where these messages are forwarded.
What is the best option here? |
Did this recently in v6.1. Just started the flow with a timer so the in-basket is polled at regular intervals (configured via UDP), then just wrote a JavaCompute with calls to the Java mail API. I used IMAP because I need to deal with emails with fairly large attachments (using POP would have used too much memory). I also employed some of the large message processing techniques to move the emails from Exchange to MQ. After that it's just straight-forward broker stuff. Works pretty well, Java is relatively simple (it's definitely not my strength but got thru ok).
Fraser. |
|
| Back to top |
|
|
| kimbert |
| Posted: Mon Dec 10, 2012 4:35 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Which version of WMB? If on v8 then DFDL is the obvious choice for parsing the incoming delimited data. |
|
| 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
|
|
|
|
