New post

#Ensemble

37

InterSystems Ensemble is a complete and easy-to-use integration platform that enables users to connect people, processes, and applications in record

time.

Learn more

Documentation

Question
· Sep 19, 2019
Credentials - Domain Account

Hi,

I've a Service utilising the Adapter EnsLib.SQL.InboundAdapter, which uses a Credentials item set with the details of a local SQL account. This currently works, however, we're looking to use the credentials of an AD domain account.

The domain account is a member of an AD security group, which has the required permissions on the source SQL database. I've checked that access is possible with this account via SQL studio.

1 2
0 270

Hey all,

I am currently working on a website (with Angular) for displaying the results of UnitTests.

Everything is working fine, except that I can not run a test inside a ClassMethod.

I have 2 classes: One for handling which test class should be invoked and then a test class that is extending %UnitTest.TestCase

The test class:

0 1
0 210

I am getting the date 20201121090000 in the HL7 message, How do I convert it to 2020-11-21 09:00:00 in a easy way?

I am currently doing it by extracting the first 7 values and splitting as date and time and then adding a hyphen using substring.

Is there an easier way by using $ZDATE? or something like that?

0 20
0 1.7K

Dear Community,

I need to collect a file from an FTP server over FTPS.

I have the :

  • credentials saved correctly
  • correct host and port informatoin
  • correct filepath I am trying to collect from
  • I have setup the SSL configuration in System > Security Management > SSL/TLS Configurations and this tests sucessfully

When I run the business service to connect it connects, but soon after connecting it fails to open the directory:

0 3
0 353

I have a project to only filter certain pathology results into a downstream system.

Within a HL7 router and business I was planning on using a lookup table and either the exists() or Lookup(), but am having issues when using it with repeating fields or segments.

For example if I perform teh analysis per stated segment usign {} brackets this will work, as each stated repeat is assessed:

0 2
0 724

Hi,

I need to develop a HL7 Q22/K22 query/response mechanism for a NHS Trust I am working for, but I do not know how to handle the message continuation.

Can any one give me any advise on this and/or point me in the direction of any documentation on the subject?

Thanks

Neil Thaiss

0 2
0 552

I have multiple files with different columns, first 9 values are fixed, so i want to ignore the first value, and next 8 values i want to combine into one value using ^ sign

Current Format

|||||||||||^^||||||^^|||||||||||||||||
|||||||||||^^||||^^|||||||||||||||||||||||
|||||||||||^^|||^^||||||||

Desired Format

^^^^^^|||^^||||||^^|||||||||||||||||
^^^^^^|||^^||||^^|||||||||||||||||||||||
^^^^^^|||^^|||^^||||||||

Reading each line from the file use below code.

0 11
0 746

We use ExecureProcedure() to execute a stored procedure which returns a result set. But we see lot of "Invalid cursor state" errors when the result set is empty. The connection to SQL server database is made through ODBC.

ERROR #6022: Gateway failed: Fetch. + ERROR <Ens>ErrGeneral: SQLState: (24000) NativeError: [0] Message: [Microsoft][ODBC Driver 11 for SQL Server]Invalid cursor state

Here is the code snippet from the business operation class which uses EnsLib.SQL.OutboundAdapter

0 2
0 8.9K

I am looking to create a routing rule that will do the following:

When transaction is not an A03, and discharge date is valued, do not transform.

What I am having trouble with is with the conditional for the discharge date {PV1:45}. Not sure if I can use length here or if I can use HL7.{PV1:45}>0. I did try that, but its not working. Not sure what I am doing wrong.

Thanks,

Nicole

0 2
0 214
Question
· Nov 11, 2020
leading zeros

Hallo, I need a Ensemble transformation to fill up a 6 or 7 digit Number to a 10 digit string with leading zeros.

123456 --> 0000123456

1234567 --> 0001234567

Thank you!

0 4
0 575

I am trying to match on config items that have the same Vendor name in them for custom alerting.

Example:

FromVendornameSiteADT

ToVendornameORM

Where Vendorname could be several systems that have multiple interfaces.

How can I find all config items (interface names) with the same Vendor name, without explicitly naming them?

0 9
0 313

Hi

My Ensemble platform worked well before.

Since yesterday , I found out lot of slow request ,I opened trace for one message.

as above shown.

It take about 8s from HisEmrRouter to ADTRoutingRule.

In my opinion, HisEmrRouter And ADTRoutingRule is Simple Rule, should't do IO operation. should be pure compute.

Why does it take so long to process the routing?

0 10
1 354

I currently have an Ensemble production which accepts and handles SOAP requests. I now need to support the exact same data, but instead of coming in as a SOAP request, comes in as a multipart/form-data request. The body of the message would look something like:

0 4
1 741
Question
· Nov 2, 2020
HL7 - FHIR

Hi All,

I know hundreds of people have done this but I'm looking for some DTL's as a start to do HL7 to FHIR, I appreciate everyone's HL7 is slightly different, but just some starter DTL's would be much appreciated? Can anyone help?

Regards

0 2
0 462

Hello,

I am trying to create a HL7 message (REF_I12 message) using variables extracted from a Dynamic Object and need some advice about segment creation issues that I am having. Some background info: I receive a JSON response from an API call and used %FromJSON to convert the response to an Dynamic Object. Some of the items in the response are repeated such as NOKName, NOKrelationship.

0 3
0 611

I noticed when creating Record Map's within Ensemble that it is creating a Persistent cache table as it translates the file and puts it into the Record Map data structure.

I was wondering if there was a way to add a column to the cache table that is Hidden from the record map, but is a calculated date value on when that record was inserted?

0 4
0 196