[Dirk Engels]

Hi Jonathan,

I have now tried the access without encrypted smat dbs, but I always get an error:

{ “code”: “UnspecifiedError”, “message”: “java.lang.StringIndexOutOfBoundsException: String index out of range: -1”, “fieldErrors”: null }

Here is the body I post:

{
“files” :
[
“C:/HealthComm/cloverleaf/cis2022.09/integrator/hc_demosite/exec/processes/ADT/orbis_kus_adt_in.smatdb”
],
“criteria”:
[{
“type”: “plain”,
“itemName”: “MESSAGECONTENT”,
“operator”: “regular expression”,
“val1”: “A01”
}],
“sort”:
{
“ascending”: “true”
},
“pageNum”: 1,
“msgNumPage”: 10
}

[Dirk Engels]

Hi Jonathan,

with you post I was able to figure out how to do search. The documentation on this is still bad. Swagger doesn’t help much out.

But I still have a problem, because my smat databases are encrypted, so I have to provide a password. The only thing in swagger that fits this is:

“filePasswordMap”: {
“additionalProp1”: “string”,
“additionalProp2”: “string”,
“additionalProp3”: “string”
}

But how do I use it? Have you been able to figure this out?

Greetings from Germany,

Dirk

• This reply was modified 5 months ago by Dirk Engels.

[Dirk Engels]

Hi Jim,

I’ve done several HL7v2-FHIR xlates into our national German FHIR profiles, also a xlate for a ORU to DiagnosticReport  and this is quite common. I think that only means, that Cloverleaf stopped loading the whole schema (like loading only the first 2000 messages in a smat db) and will load the rest of the schema as it is required. A FHIR schema with all its subfields and extensions can be quite large.

Regards,

Dirk

[Dirk Engels]

Hi Jim,

 

I think that is possible. You only have to specify them if your message formats are different, so paths to fields are different. I have xlates, where I use include with the same ib and ob message formats and I don’t use prefixes.

[Dirk Engels]

We have several customers running CIS 2022.09.02 on Windows and Linux so far and that works well. Actually no one on AIX, but I will do an upgrade to 2022.09.02 on AIX at a customer in February as we have no problems since Rev2 patch with 2022.09 on the other platforms.

[Dirk Engels]

Hi Jim,

as you might know, we have over 500 Cloverleaf customers over here in Germany and some of them also have limited licenses. So, I created a little tcl script which gives me a list of all threads over all sites as a csv file so I can easily open that file in Excel and have a counted list of all threads sorted by site and process of a Cloverleaf box.

The script also tries to create a thread matrix to show what systems processes what messages (based on HL7 message types). That, of course only works if thread names follow a specific syntax. But that can be easily adapter in the script (see line 122-126).

Grretings from Germany.

Dirk

Attachments:

You must be logged in to view attached files.

[Dirk Engels]

I’ve attached my script which lists all port over all sites, so you can also see if there are double assigned ports over your site. You can also specify a sorting by thread, site or port number. The standard output is on screen, but with option -print it creates a csv file.

Just execute it with hcitcl getPortInfo.tcl within a Cloverleaf shell window.

Attachments:

You must be logged in to view attached files.

[Dirk Engels]

Hi Jason,

the points Jim wrote are right. he performance is highly depending on the database. Also you must be aware, that it can error out.

The difference between basic and advance dblookup is, that in advance you specify one table and one or more input and output fields from that table as where in the advanced lookup you can do with a sql statement whatever you like. Of course in a dblookup only select is allowed, but you can query over multiple tables, you can use inner selects and join and group results.

We have used both in xlates at our customer base. The overall performance is ok. Modern servers should be fast enough to handle this. Of course the performance is also based on the complexity of your sql statement.

[Dirk Engels]

Jim,

doing this in a tcl proc is a bad idea, because you would block your whole process. That’s why the javadriver proc was developed. The reason is how Cloverleaf actually call a java class. As the engine cannot call the java class directly, the engine calls the tcl interpreter which will call a tps proc. This tps proc calls a java runtime and that will run the java class. If you configure a java class in the gui, you can see, that there will a a tcl proc called. Look at $HCIROOT/tclprocs/tclIndex. You see some entries starting with clj… referring to $HCIROOT/tcl/lib/tfc/cloverleafJava.tcl. That’s how the engine executes a java class.

As long as your java proc is running, the thread and therefore the whole process is blocked.

But if you like to do it anyway, put that thread in a separate process. I would suggest to use two procs. First call the java class and do whatever you want. The proc should give a message back which you then may process in a tcl proc afterwards. You can mix up tcl and java in a tps.

[Dirk Engels]

Yes. with xpmmetaset instead of msgmetaset you can set the driverctl metadata field from within a xlate.

[Dirk Engels]

Tim,

have you execute the gvsave command after setting the new value? Otherwise you only update the variable in memory, but do not write it back into the file. I’m using the following

gvsetvar LASTSCANDATE $scandate; gvsave

and my global variable LASTSCANDATE will be updated in the file.

[Dirk Engels]

Hi Michael,

the attached zip archive has two tcl scripts for converting a Cloverleaf table into a csv file and a csv file into a cloverleaf table. The csv file should have/will be created with 2 columns.

Just start it with hcitcl and give it the file as an argument:

hcitcl create_tbl.tcl wardcodes.csv 

hcitcl create_CSV_from_tbl.tcl wardcodes.tbl

Both scripts create the resulting file in the same directory where the original file is.

Attachments:

You must be logged in to view attached files.

[Dirk Engels]

As Cloverleaf fires the alert, this is mostly a problem in the email server, which did not forward the message to the recipients. I would suggest to look at the email server logs.

[Dirk Engels]

Hi Rob,

is there also an equivalent in Java?

[Dirk Engels]

I’m wondering where I can find that mysterious check box? I cannot find it in my files/local protocol settings. Could you please assist? Maybe a screenshot?

[Author]

Replies