[Keith McLeod]

It does seem a little slower. I still have a few things out there.  Still looking for help on tcl to be able to read the message structure from the variant and establish/determine the HL7 paths based on that structure and repetition information.  More for fun than a need. Great hearing from you.  Guessing you are still a world apart…

[Keith McLeod]

Don’t forget revisions directory will usually contain all of your prior saves.  Located $HCISITEDIR/revisions with filenames like NetConfig99202515526.  I am just guessing an extra newline was added to your file, restore and/or compare to known working copy should help.

[Keith McLeod]

I will probably keep the emails since we CC all interested parties when creating tickets, but the webservice should speed up ticket processing.

[Keith McLeod]

They generally do have API’s.  I am currently prototyping a JSON feed using oauth2 on Webservices to Halo(BMC).  I have email alerts that I am now going to drop using the existing variables into a VRL which get translated into JSON.  Functionally working just need to get more of the detail as to exactly what will create the ticket as desired.  Should be faster than email since I am currently seeing 48 minute and longer delays in the email.  I would bet that SNOW has the documentation for establishing a connection to receive ticket information and generate a ticket.

[Keith McLeod]

I usualy set up the Remote Shell Command in Client Preferences –> External Commands –> Remote Shell Command and put in the following for example: C:\Program Files\PuTTY\putty.exe @H

[Keith McLeod]

It might be helpful to have a visual of the data and what you are trying to accomplish.

[Keith McLeod]

Not sure the snippet copied. Hate when it obliterates your code…  See Attached

Attachments:

You must be logged in to view attached files.

[Keith McLeod]

You can override the URL or the Path in the userdata.  I do this using tables and a preproc in the Xlate.

I determine my key based on a value in my HL7 data to get which URL I am going to use.  I store it in @URL.

I send the path straight from the field, like PID:3.1

And if I require some Authorization for the Header, again I use the source and a table and store it in @SOME_AUTHORIZATION

I copy In my source:

@URL
1(0).0(0).0(0).PID(0).#3(0).[0]
@SOME_AUTHORIZATION

Use this preproc snippet

keylset userData httpRequestInfo.requestURL /[lindex $xlateInVals 1]] httpRequestHeaders.SOME-AUTHORIZATION ]
xpmmetaset $xlateId USERDATA $userData

and my destination is @null since I am purely formulating the msg metadata USERDATA to override any settings ws-rawclient.

Works pretty well.  Only have to update my table values for the most part with the URL and Authorization Header info.  You can update PATH only, but once you do the URL, PATH is no longer used.

Hope this helps….

[Keith McLeod]

Have you looked in Tables and used the Database Options?

• This reply was modified 1 year, 7 months ago by Keith McLeod.

[Keith McLeod]

Can you share the link to get the downloads?  I found the release notes I think, just not the actual software.

[Keith McLeod]

I ran into an issue with the dblookup on the 2022.09.02 version.  The recommendation on mine was to upgrade the SQL server DB.  2014 I believe is marginal on what the current JDBC drivers support.  I have one system for pathology that has put off upgrading their version of SQL from 2008 R2. Luckily, they are upgrading that over the next several weeks. The current versions of SQL for other apps seems to work fine…  Something you might want to check…

• This reply was modified 2 years, 5 months ago by Keith McLeod.

[Keith McLeod]

I believe the error log is a sqlite db exec/databases/elog.elogdb.

[hci@dc1vtclover01 data]$ sqlite3 elog.elogdb
SQLCipher version 3.15.2 2016-11-28 19:13:37
Enter “.help” for instructions
Enter SQL statements terminated with a “;”
sqlite> .schema
CREATE TABLE elog_info (“Version” INTEGER, “ECD” VARCHAR);
CREATE TABLE elog_msgs(
“MessageContent” BLOB,
“DataLen” INTEGER,
“DestConn” VARCHAR,
“OrigDestConn” VARCHAR,
“DataFmt” VARCHAR,
“SepChars” VARCHAR,
“DriverCtl” VARCHAR,
“UserData” VARCHAR,
“MidDomain” INTEGER,
“MidHub” INTEGER,
“MidNum” INTEGER,
“SrcMidDomain” INTEGER,
“SrcMidHub” INTEGER,
“SrcMidNum” INTEGER,
“Type” INTEGER,
“SourceConn” VARCHAR,
“OrigSourceConn” VARCHAR,
“Priority” INTEGER,
“Class” INTEGER,
“Flags” INTEGER,
“EdbState” INTEGER,
“GroupMidDomain” INTEGER,
“GroupMidHub” INTEGER,
“GroupMidNum” INTEGER,
“XltThread” VARCHAR,
“OwnerThread” VARCHAR,
“Retries” INTEGER,
“MidsAreNull” INTEGER,
“SkipXlt” INTEGER,
“GroupID” INTEGER,
“TimeIn” INTEGER,
“TimeXlt” INTEGER,
“TimeOut” INTEGER,
“TimeQCur” INTEGER,
“TimeQTot” INTEGER,
“TimeRec” INTEGER,
“ErrorString” VARCHAR,
“RdbState” INTEGER,
primary key (MidNum,MidHub,MidDomain));
sqlite>

Is this what you are looking for? My guess is that you can access in a similar way to SMATDB files and access the metadata.

[Keith McLeod]

Not sure… I tried a post twice yesterday and it appeared to cut out half of what I posted….Tried editting, but once I submitted lines were still missing or appeared to be missing….

[Keith McLeod]

hcitcl>set xlateInVals 20240402120000
20240402120000

hcitcl>regsub — {(\d{8})(\d{4,6})} [lindex $xlateInVals 0] {\1 \2} dt
1

hcitcl>echo $dt
20240402 120000

hcitcl>set xlateOutVals -format “%m/%d/%Y %H:%M:%S”]]
{04/02/2024 12:00:00}

• This reply was modified 2 years, 6 months ago by Keith McLeod.

[Keith McLeod]

Try this:

regsub — {(\d{8})(\d{4,6})} [lindex $xlateInVals 0] {\1 \2} dt

set xlateOutVals -format “%m/%d/%Y %H:%M:%S”]]

Example:

hcitcl>set xlateInVals 20240402120000
20240402120000
hcitcl>regsub — {(\d{8})(\d{4,6})} [lindex $xlateInVals 0] {\1 \2} dt
1
hcitcl>echo $dt
20240402 120000
set xlateOutVals -format “%m/%d/%Y %H:%M:%S”]]
{04/02/2024 12:00:00}

Hope this helps…

• This reply was modified 2 years, 6 months ago by Keith McLeod.
• This reply was modified 2 years, 6 months ago by Keith McLeod.

[Author]

Replies