[James Cobane]

We only keep 7 days’ worth of SMAT DBs on our engine (in a separate file system, with folders for each day Sun-Sat).  Our stance is that it is an “interface engine” for receiving/queueing/sending data, not a data repository.  While it seems a bit constraining, it is in a “good way”.  It saves us from being the archival and reporting system.

Jim Cobane – Henry Ford Health

[James Cobane]

FYI – The APIKEY argument on the proc in the thread has an actual numeric value and not xxxxxxxx like I thought.  Please don’t use that value, replace it with yours.  I can’t delete and re-upload the BOX for some reason.  It is not letting me edit my post 🙁

[James Cobane]

Attached is the BOX containing one of our configured threads and the associated procs.  You would replace the xxxxxxxx on in the {APIKEY xxxxxxxx} argument on the outbound tps_cbord_SOAP_env proc with your api key that NetMenu supplied.

Hope this helps.

Jim Cobane – Henry Ford Health

• This reply was modified 2 weeks, 5 days ago by James Cobane.
• This reply was modified 2 weeks, 5 days ago by James Cobane.

Attachments:

You must be logged in to view attached files.

[James Cobane]

We converted from on-prem CBORD to NetMenu a few years back.  It was a bit of a struggle to get it working and the NetMenu side had some issues with volume, so we had to split up into multiple connections to them.  We have the threads configured with the Netmenu endpoint info and we have an outbound tps proc which base-64 encodes the HL7 message and applies the xml wrapper around the base-64 encoded HL7 message with the APIKEY that they specified.  We also have a reply handling proc that receives/checks the http response and decodes the base-64 encoded HL7 ACK to determine if they ACK’d or NAK’d us.  I’ll box one of the connections and the respective procs for reference.  Stay tuned….

Jim Cobane – Henry Ford Health

[James Cobane]

If you aren’t handling the replies via a proc or actually routing them, then they will hit the error database.  Also, do you have ‘Outbound Only’ checked on ‘Inbound’ tab of the thread?  If you don’t, if a reply message comes in when the connection is not expecting a reply, then it will hit the error database as well.

Hope that helps.

Jim Cobane – Henry Ford Health

[James Cobane]

It would be great if Infor would do a webinar for this functionality.  I have a bunch of scripts that utilize ncitlib to pull data from NetConfig(s), but supposedly using these API’s is the future direction for getting this kind of data.

Jim Cobane – Henry Ford Health

• This reply was modified 4 months, 2 weeks ago by James Cobane.
• This reply was modified 4 months, 2 weeks ago by James Cobane.

[James Cobane]

I have a script that I created that reads a CSV file and utilizes an SQLite database to remove duplicates and generates a Cloverleaf lookup table.  Let me know if you would like a copy of it.

Regards,

Jim Cobane, Henry Ford Health

[James Cobane]

Darrell,

You could add a statement in your ITER that sets a temp variable if a PDF exists (i.e. @pdfExists, set it to ‘1’), then just after your ITER you can add an IF statement to check if @pdfExists is not equal to ‘1’, and SUPPRESS.

Hope that makes sense.

Jim Cobane – Henry Ford Health

[James Cobane]

Mischa,

The Recovery DB is going to process the messages in a first in, first out (FIFO) basis unless you have code in place to change the message priority.  So, messages should queue in the order they are received.

Depending on volume, just allowing the Recovery DB to handle the data is the path of least resistance (i.e. let it queue).  We have a couple of MDM interfaces that have very large messages, so for those we have some thread forwarding configurations in place to write messages to file then when the system comes back up, we read from those files at given pace to not overwhelm the receiving system.

Jim Cobane – Henry Ford Health

[James Cobane]

In Tcl you can simply use the clock scan command:

set myDate [clock scan “5 days ago”]

That will return the clock value from 5 days ago that you can then format:

clock format $myDate

 

Jim Cobane – Henry Ford Health

[James Cobane]

David,

From the Epic documentation, in this scenario where we need to create DCS records for the documents (rather than update existing ones), you can either:

1. Use a fully HL7 option, where the messages contain the base64 encoded PDF in OBX-5

2. Use a Kuiper utility to migrate the binary data to the blob server, and use HL7 to file the metadata to create/update the DCS records

To use option 1, the HL7 would contain the PDFs already encoded in OBX-5.  But, it sounds like you may want to consider option 2.  You should contact your Epic TS.

Both of these options are described in a bit more detail here: Move Files to the Web BLOB

Jim Cobane – Henry Ford Health

• This reply was modified 1 year, 3 months ago by James Cobane.
• This reply was modified 1 year, 3 months ago by James Cobane.

[James Cobane]

Remember that you should treat xlateOutVals as a list

• This reply was modified 1 year, 4 months ago by James Cobane.

[James Cobane]

You could use the clock commands to reformat the date:

set dateIn [lindex $xlateInVals 0]

set dateOut [clock format [clock scan $dateIn -format “%Y%m%d”] -format “%m%d%Y”]

set xlateOutVals

(for some reason, it isn’t displaying the last portion of my “set xlateOutVals

” command above)

 

Hope that helps.

Jim Cobane – Henry Ford Health

• This reply was modified 1 year, 4 months ago by James Cobane.
• This reply was modified 1 year, 4 months ago by James Cobane.
• This reply was modified 1 year, 4 months ago by James Cobane.
• This reply was modified 1 year, 4 months ago by James Cobane.
• This reply was modified 1 year, 4 months ago by James Cobane.

[James Cobane]

I don’t know that I would recommend attempting to change the NetConfig programmatically from a script; I think you could unknowingly corrupt your NetConfig.  When I have had to do a mass change on the AutoStart settings in NetConfig in the past, I have done it via a text editor and simply done a search/replace of AUTOSTART 0 to AUTOSTART 1 (or visa versa) depending on the need.  I simply ensure that I back up the NetConfig before making this change, then load it in the GUI after the change to make sure it didn’t break.

Hope that helps.

Jim Cobane – Henry Ford Health

[James Cobane]

Jason,

Yes, this information is available within the DRIVER CONTROL portion of the metadata of the message.  Here is a snippet of Tcl code that you could put into a proc in the inbound context that would give you that information from the message:

set myklst [msgmetaget $mh DRIVERCTL]
keylget myklst FILENAME myFileName

Hope that helps.

Jim Cobane – Henry Ford Health

[Author]

Replies