Hi,

We have a PAS that accepts HL7v2 QBP^Q21 requests, and returns patient details in an RSP^K21.

We have a clinical system that wants to sent an http GET request of the form http://server/getpatientbyid?pid=M1234567

So I think I need to convert the query url into a QBP^Q21 (HL7) message, then take the response in HL7v2, convert to SDA, convert to FHIR, and put that in the response to the original GET.

Does anyone have any experience doing this? is there an approach you would recomend?

This is a sample Ensemble/Health Connect production which demonstrates how to receive an HL7 order (ORM) inbound from a file, extract fields (in this case, basic demographic information), and insert those into a table in an external SQL database via ODBC.

Included in the zip file:

• Exported code
• Sample ORM message
• 'How to configure' doc

Apache Spark has rapidly become one of the most exciting technologies for big data analytics and machine learning. Spark is a general data processing engine created for use in clustered computing environments. Its heart is the Resilient Distributed Dataset (RDD) which represents a distributed, fault tolerant, collection of data that can be operated on in parallel across the nodes of a cluster. Spark is implemented using a combination of Java and Scala and so comes as a library that can run on any JVM.

A client wants information extracted from their MUMPS database and transferred to a cache database, where do I begin and what are some best practices I should keep in mind? (I am fairly new to MUMPS and have been put on this project)

One aspect of source code management is how to deal with the almost inevitable need to upgrade your Caché or Ensemble platform to a newer InterSystems release.

It's long been my experience that InterSystems does a very good job of maintaining backward compatibility. Code that works correctly on, say, 2012.1 is very likely to work correctly on, say, 2015.2 without any modification.

I use macros everyday, but its the first time I want to create a macro like this

I want to create a new macro whereby I can pass a variable amount of parameters

the macro (much simplified version) would be

#define myMacro(%params) $listBuild(any Number Of %params I pass in)

so I want to be able to call $$$myMacro(user,ID,vehicle) ie 3 parameters would generate

$lb(user,ID,vehicle)

but equally I might want to call that same macro $$$myMacro(companyID) ie 1 paramter and would generate

$lb(companyID)

I am tasked with using CACHE to insert data retrieved from a CACHE data base and insert it into an sql database. The columns in the sql table that I am trying to insert data into have names that contain underscores such as "ACCESSION_DATE" I found a utility in CACHE to connect to the sql data base and perform inserts. I have the data I need to insert. I need to pass the data into the sql utility referencing the column names.

I tried using indirection to set the data into underscored variables, but that isn't allowed in cache object script.

I am rather new to ObjectScript and I have a query about assigning values to the context.

In BPL I have a context variable (A08Msg) which is set to type Enslib.HL7.Message, I want to put my inbound HL7 message into this variable so I tried:

• an Assign to set context.A08Msg to request

This seemed to load the message into the variable because I could read values, e.g. using context.A08Msg.{PD1:3(1).1} , but I was unable to write to context.A08Msg.

Hi All,

I have a line of mumps code that creates a folder on a network shared drive.

Example:

d ##class($Library.File).CreateDirectory("\\share\folder\newfolder")

If I run this line of code from a cache terminal window it works fine and creates the folder without problems.

However If I create a very simple business operation in a production in the same namespace that simply runs this one line of code then the code fails.

We are planning to integrate drawing software like AutoCad with an in-house facility management software and plan on using Ensemble. Has this been done before? And if so we would like to get the necessary assistance or guidance.

Thanks.

Izak.

Is there a way to make the system users like _SYSTEM and ensadm bypass the Delegated sign-on and not cause it to fill up the Audit trail with "Programmer mode login failure"?? I figured I still had to leave password login enabled for the background users to run. How would I script if username = "_SYSTEM" then don't do the Delegated sign on?

Here is my ZAUTHENTICATE

Hi All,

I have a query:

Is it possible to send HL7 messages and Non HL7 Message such like Record Maps in a single TCP operation in ensemble?

Many Thanks,

Archunan K

Has anyone use any other setting then -1 on the Stay Connected setting on a SQL.OutboundAdapter? I am having issues with a particular database and wonder if it would be beneficial since I only connect once a day to read the data from the Adapter to create an HL7 message.

Thanks

Scott Roth

In CACHE did there any way to extract text from PDF and Doc files?