InterSystems Ensemble is a complete and easy-to-use integration platform that enables users to connect people, processes, and applications in record
time.
Hi, I want to INSERT a customerID and customerName to a table if the customerID does not exist. Or UPDATE if they've changed their name.
I've reviewed the documentation (https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=RS...) and have confused myself with the INSERT OR UPDATE statement. Rather than using two individual statements , is there a way to get it in one?
What I have at the moment doesn't do anything. In fact it errors.
Hi, I'm still very much new at Ensemble DTL. I am trying to set up an algorithm that requires loading fields from an OBX into an Array. I don't think that I know how to iterate through the OBXs. I know that there is a "for loop", that I will try to play with, but in the mean time, could someone tell me what is wrong with the following?
For example the code below works when I hard code the number 1 in OBXgrp(1)
Hi,
I've added a REST service which worked fine on our test system but failed on the production environment because UnknownUser does not have %All set and I really don't want it set on production (in fact I've also switched it off on test).
Is there a way to allow a single REST service to have unauthorised access?
I was thinking adding a resource/role to UnknownUser specifically for that service but I've never touched on Users/Roles/Resources so I'm struggling to work out what needs adding where.
Thanks
I am having difficulties with using the ..Strip() function in my DTL to strip the slash ( / ) from the phone number portion of an x12 834. There are very few records that have the slash in the phone number, so I am trying to filter out any characters other than numbers so that all phone numbers are formatted 1112223333.
Here is the code portion of the strip:
Set HomePhone ..Strip(source.{loop2000(k1).loop2100A.PER:CommunicationNumber},"*AW","-()/").
I am then checking the length of HomePhone.
Hello,
I work with IRIS for Health 2020.1 and I attempted to set up Enterprise Systems to populate Message Bank. I see entries in Message Bank Event Log from the defined Enterprise Systems. I can browse Messages going back before I set up Enterprise Systems using Enterprise Message Viewer. However, I find no messages in Message Bank Viewer. Do I need anything extra to archive messages?
I'm trying to get a count of specific message type with a specific entry and thought I could build the query in Message Viewer but this does not provide counts (as far as I am aware). So when I take the SQL from 'Show Query' it omits the segment criteria as the code shows below.
I have attached the criteria that has been excluded. Is this possible?
Thank you
Hi,
Can anyone point me to an example of a DTL & Class method that can pull a base64 encoded PDF out of a MDMT02 message?
This is really asking for two things;
- how to make a DTL that extracts a specific subfield of an HL7 2.3 message into a message of its own,
and
- how to transform an base64 encoded document into its original binary form for writing to a file.
I'd also love to see an example of an HL7 2.n MDM^T02 ==> HL73.ITK2 non-coded CDA
Hi,
I am attempting to set up a security role for our support team so they can have read access to the production and messages.
I have given the role RW rights on the resource associated with the database. However, when I log into Management Portal and select "Ensemble", the "Available Ensemble namespaces" list is empty.
What permissions do i need to set to be able to navigate to the production?
Thanks in advance,
Carl
Edit:
Hello, guys!
I'm facing a problem when I compile my code in Atelier (version 1.3) when connected to an Iris Community instance in Docker container.
When compiling, the code is synchronized with the server correctly, however, in the IDE, the code is inserted into the class again.
Class after compile:
Been cleaning up our production 2017.1 instance of Health Connect in preparation to a move to Health Connect 2020.1 (on IRIS!)
One thing I have found I we have built up a number of old classes and other configuration files.
It would be nice to start on the new server with a clean slate.
Is there any way to identify classes that haven't been used for a long time so they can be reviewed and removed?
Kind regards,
Stephen
Hi, I am trying to read a field from the second obx segment but it keeps giving me an error.
Following is what I am trying:
If you're viewing a HL7 message in the front end, with a schema correctly applied, you can mouse over a segment or a field and see the schema path, e.g:
Mousing over PV1 in the above message shows the schema path is "PIDgrp(1).PV1".
I'm writing a utility function which you pass an EnsLib.HL7.Message into. I'd like to loop through each segment and take action dependant on that schema path. How can I reference or determine that schema path in code?
Hey everyone.
I have a use case where I need to write files to a handful of locations, and 2-3 subfolders in each location.
My plan was to extend EnsLib.File.PassthroughOperation and then pass that operation the file and the subfolder details, and then have an operation per destination.
Has anyone done anything similar and can highlight any pitfalls I may be about to make?
We have a bunch of CSV files of a few different types, which contain patient and medication data, among other things, which we need to load into Healthshare, so the information can be compiled together and then viewed from the Clinical Viewer/reports made on the data as well.
Hi,
I'm trying to ultimately create a function that I can use with HL7 messages that calls a stored procedure held on a SQL Server.
Initially I tried extending the function class to use the sql inbound adapter and/or EnsLib.SQL.Common, but this wouldn't work from the class method for the function.
I need to set and use some context variables in a transformation (written in DTL), but the code is manually written.
When writing the same as BPL I define context variables and they are visible in transformations called by that process.
In something like this my.DTLtransform sets HL7 message fields to values in context variables:
Hi,
I create a WebService in Machine One, with some process, i tested this webservice with SOAPUI, worked.
After that i create a simple Business Operation, SOAP Adapter, based on WebClient created with SOAP Wizzard, the problem with that is on response var, i have empty var on my operation, somebody have some Ideas ?
Hi, a client have a installed enviroment with mirror activated, but when you test SSL on webservices you can get an error, not SSL access correctly from browser because certificate problem apparently with TLS Version, someone have a suggestion to reinstall SSL Certificates on mirrors ?
Chrome : something wrong, no details or diagnostic
Firefox : SSL_ERROR_HANDSHAKE_FAILURE_ALERT
We try simple regenerate Authority an regenerate all certificates, but not worked. Same results.
Hi all,
We are working on getting a number of non-code based configurations and settings in fully automated deployments, and I was wondering if anyone had any ideas on how to "update" a task that already exists.
Hello Guys, can you help me with a issue? I think it is a beginning question, but here goes, how do I add a new business host to production programmatically? for example a new business service or business process.
I've been looking at the documentation for the classes Ens.Config.Production, Ens.Config.Item and Ens.Director and I haven't found any method to add, maybe the name is a little bit different.
The idea is to create a class that will "deploy" or "configurate" a new project components in a pre-existing production.
Best,
Fernando.
I've got a class that extends FTP.PassthroughService and utilizes the FTP.InboundAdapter. In Business Service, I have the FilePath set as /tmp and the subdirectory level = 1. How can I access the current file path (/tmp/subdir1) when there are files in /tmp/subdir1/test.txt for example? The ..Adapter.FilePath only returns the FilePath setting in the Business Service/Adapter but not the subdirectory level. Of note, it is a SFTP connection. I can access the
Hi, I have a timestamp of 201906192359 with a HL7 and I need to add a minute to it to get 201906200000. Is there an easy way within Healthshare to do this?
It seems easy enough within SQL but I cannot get the SQL to work within Healthshare, this is what I have for SQL which does the job in SQL Server.
SELECT REPLACE(REPLACE(REPLACE(CONVERT(CHAR(16),DATEADD(mi,1,STUFF(STUFF(@test,11,0,':'),9,0,' ')),120),'-',''),' ',''),':','');
Hi guys,
I'm trying to consume a REST Service that use Digest authentication, I'm trying to implement the authentication but I'm don't know where is my mistake.
Someone have already used this type of authentication.
Below the code I wrote to try to generate the response hash:
Hello
How to set up a schedule of service in Ensemble Production to run Business Process from Monday to Friday?
It is possible develop a new interoperability adapter? If yes, how can I do it?
Hi :
1591891200000
How do I convert the timestamp above to something like this format : 2020-06-12 00:00:00
Hi Community!
Do you know how to create workflow users and roles programmatically?
I use Docker for test deploy and I need to set up IRIS Interoperability using the install script.
Maybe do you know how to import/export already existing workflow users and roles?
