We have a data transformation where source is object collection (populated from a json file) and target is EnsLib.EDI.XML.Document.
If source file is large enough, transformation fails and we get <store> error and I quickly found this:
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=EBPLR_DTL_foreach which at the bottom in "Avoiding <STORE> Errors with Large Messages" section tells to:
Hello,
We need to convert this structure, where we observe empty component separators "^":
Hi,
Is there a way to hide a property in Data Transformation UI in Interoperability for IRIS?
I would like the property not to appear in the list of available properties to set.
Thanks,
Blaise
Ensemble beginner here. One of the downstream applications requires to send two A02 messages instead of one A17. We do it easily in Cloverleaf - either in translation or TCL. How do I create 2 target messages out of one source message in DTL?
This article will describe and include an example of how to embed an external PDF file into an HL7 segment, specifically ADT_A01:2.3.1 OBX(). This can be useful when attempting to insert pictures or other external data into an HL7 message. In this example, the name of the PDF file to be embedded is provided in the incoming HL7 message in OBX(1):ObservationValue field.
I'm not sure what the purpose of this is, but the Management Console causes the browser to refresh periodically. If you're in a form or an editor such as the DTL or Routing Rule editors, you may lose work unless you save frequently. This did not occur in Caché 2018 and earlier releases.
I've had a couple of incidents where I've created a number of rules in the DTL editor, answered the phone or stepped away for a few minutes, then come back to find any work since the last save erased.
I've noticed this in both 2019 and 2020 releases of IRIS.
Heads up!
Hi everyone,
I am very pleased to announce that the Readmission Demo has been released as open source. Many thanks to the Solution Factory team that worked hard on making this possible.
Here are the changes:
I have to write a DTL with the Data Transformation Builder to convert messages from HL7 ORU R01 v2.1 to HL7 ORU R01 v2.5. The incoming messages contain a text in OBX-5. This text contains LF characters (only LF - Segment separator is CR). Therefore it is not possible to parse the incoming message. While testing the transformation the OBX Segment ends at the first occurence of LF. Is there a way to replace the LF character before parsing?
example:
source:
OBX||FT|ltest1|| first line
second line
…
last line
||||||F|
target:
Hi All,
I am planning on doing some maintenance in 2020, I was wondering if it is possible to run a query to get a log on when a DTL and/or Business Rules was called in HEALTHSHARE, the idea behind this is to do some cleaning and remove some clutter.
Your help or ideas are highly appreciated.
LW21
Hi,
Is there a way to insert new Key/Value in an existing lookup Table via a DTL code? The only thing I found in the documentation is that we could use the following command SELECT KeyName,DataValue FROM Ens_Util.LookupTable WHERE TableName = 'myTab'. In the meantime I just created a table and used it in my DTL to insert new values and validate if the Key exist.
Regards
I need to add some extensions to the HS.FHIR.vSTU3,Model.Resource.Patient class and then use those extensions to convert incoming FHIR JSON to the FHIR Patient Resource and Likewise add functionality to create A FHIR Patient (target class) from my patient database into the FHIR Patient Resource Object (target class)
many months ago I found a tutorial that explained all of this but can no longer find that tutorial.
Yours
Nigel Salm
Hi,
I've heard from two different sources the SMP (or parts of it) and for sure the DTL front end (in studio? via SMP?) have been rewritten to be more modern. But on a latest IRIS Community download everything looks the same to me. Am I missing something or is this Marketting Spin?
Hopefully I won't get banned for this post aswell......
Hi,
I am trying to add an OR condition in the DTL but not able to. Sorry if this is a silly question, but can you advice?
I want to add a condition where if source.45 is "" or "..." then map "" to the target. But I am not able to add the OR condition
Currently I have as below
What will I need to do to add an "OR" condition to the DTL?
Would appreciate your guidance
Regards,
ED
Would you like to be sure your data transforms work as expected with a single command? And what about writing unit tests for your data transforms in a quick and simple way?
When talking about interoperability, there are usually a lot of data transforms involved. Those data transforms are used to convert data between different systems or applications in your code, so they are running a very important job.
I'm a beginner using HealthConnect. Trying to bring in a CCD and transform it to a HL7 messages. Is there any documentation on how to accomplish this? thanks!
Hi Community,
I am trying to remove a duplicate OBX from a result, but I am running into some issues. Let me explain.
First I had a OBX where the observation Value had the blood type in it and the following OBX had the result in it.
The clients wants the blood type and the result in one field. therefore I merged / concatenated the observation values of the two OBX's.
I tried removing the OBX:2 but just cant take the whole segment out.
please see examples below
This is the result.
I am currently evaluating Source Control systems that we can use for both MS SQL, MS Visual Studio, and InterSystems IRIS. For both MS SQL and MS Visual Studio we do have the option of either Azure or GitHub. I understand when we upgrade to IRIS 2019.1 we have options for Source Control, and in previous Global Summit's I have heard GitHub discussed. So why can't I user GitHub for both MS SQL/MS Visual Studio and IRIS?
A couple of questions come to mind starting to think about Source Control
How do I manipulate a string in Ensemble DTL (X12 document) to extract a string starting from the right, or end, of the string?
I need to have 10 digit phone numbers, however some of the source data records include the "1" for the long distance dialing and I need to exclude this.
I have tried using Right(), SubStr(), and even SubString(string,*,-10) but it will not compile.
I find it hard to believe that Ensemble does not have the ability to read a string from the right.
Thank you for any assistance.
hi
A newbie question. I am trying to use Data Transformation Editor to transform NTE segments into additional OBX segments. At the moment I am getting both segments OBX and NTE trying to populate a single OBX. Can this be easily fixed?
In a new rule I configured for a route, I have no constraint configured (so I assume it should pass everything), but I am getting an error that states "Constraints for rule failed".... ?
I am putting together a new interface to take in a CSV file and output an HL7 message.
I have used the record mapper to create the source class and I am putting together the transform, but when trying to test it I am not seeing the data populate the HL7 as intended.
Hello All.
In need of some help.
We are currently migrating Interfaces from JCAPS to HealthConnect 19.1 and have done a lot of work on our Dev server. I am looking to copy/export this work over to the Test server and have managed to export the production and Rules, HL7 custom Schemas etc. The only thing left now are the Data Transformations but so far I can only find ways of copying the transformations over individually. Is there some way to copy all of the transformations we have produced in our namespace to another server in one go?
Thanks
Way back when during our Siemens LCR days we had to limit the number of characters in OBX.5 to a length of 75. That was back when we had eGate.
Now I need to do the reversal of that and take loop through a string length and split the string up into multiple OBX or NTE based on a certain length. In reading documentation $EXTRACT can do this if you know the exact length, but in this case we don't.
So how would one loop through a string and say every 75 characters create a new OBX or NTE segment?
Thanks
Scott
Hello,
I have a DTL to transform X12 Document 278 Request to 278 Response HIPAA 5010 schema. The DTL is called from BPL. I defined a class method that receives source, target, and context objects. How can I create 2000F loops in the response when there were none in the source object?
Hello,
When creating an outbound X12 file (834, 835, 837, etc), what's the easiest way to keep a segment count to use in the SE01 element? Other mapping tools I've used either detect it's an X12 file and do this automatically, or there's an option to keep a count after each outputted segment. The Data Transformation tool within Health Connect doesn't seem to have similar functionality, but I could just be missing something. Any help would be greatly appreciated!
Thanks,
Jason
Hi community,
I need to create a DTL to get values from a JSon (%DynamicObject) to a class.
Thre first items is copied fine, however when it tries to get the values from an array it raises an error.
Our PAS system supplies date in a particular date format (ISO 8601 compliant) that includes seconds and milliseconds. Because many downstream systems cannot handle milliseconds (and some don't even want seconds) many transformations are required to truncate the data.
