InterSystems Ensemble is a complete and easy-to-use integration platform that enables users to connect people, processes, and applications in record
time.
Hello,
I am reading in an X12 document into my production that needs to be processed and returned as a CSV file. I have created a record map to support the fields I want to extract with a batch class to store headers. I have a DTL mapping the data to the appropriate fields in the record map and am sending the record map to a EnsLib.RecordMap.Operation.BatchFileOperation.
I have a case where I have an external table that lives out in MS SQL. Using Ensemble Security functions has anyone created a csp or cls page that acts like a portal to allow users to Update a multidimensional table without knowing SQL? I could clone the EnsPortal.LookupSettings but that was made for LUT which are only 2 columns.
I know its a long shot but trying to see if there was anything off the shelf that I can use to help meet the requirements of this project.
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 All,
I am getting server application error in salesforce outbound message after upgrading the HealthShare (from version 2015.1.0 to 2015.1.4). Please guide me to resolve this error.
The message in Ensemble has been retained for only 20 days, but the amount of data is still more than 300G. What should be done to reduce the storage capacity?
Hello,
I would like to catch an Adapter error in a try/catch. I have a problem with SMTP and SFTP adapter when the connection failed after 15 seconds.
Here is an example of my code for the SFTP adapter:
Hello team,
I am trying to do a basic read file of HL7 messages. Need to count how many FT1 segments are there in each file and how many messages are in each file.
Any help will be appreciated. I have the stream object.
Just need to loop through the stream and get the info in some way.
Any help will be appreciated.
Thanks,
Jimmy Christian.
Hi everyone,
I've encountered this annoying issue so many times before, if any one also encounter this issue, please share here if you have any solution.
So, I've been working on a web service project using HealthShare 2015. Sometimes I have to set a debug target to a csp file to debug it. If I pause the debug process about 3 minutes above or so (to examine an object, variable, etc..) the studio will hang.
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
Off the back of the Interface Monitoring post I had created a class that queries the Ens.AlertRequest global and returns the entries between 6pm the night before and 6am in the morning.
I tested this build in our T&D environments and the build worked very well.
However in our production environment the query is being truncated, by what I believe to be a timeout and I get a partial query output.
In the System>SQL pages my 12 hour query times out.
the file being created on the FTP server will have a format that includes the current date I would like to pull this file off the FTP while ignoring other files on the same location.
Inbound Service Class
.png)
I would like to find the file on the FTP that is being created using Todays date. But it appears that the wildcard are not recognizing the file format:
Hi Folks,
I am trying to add SQL action in DTL in order to populate previous location in target PV1.PriorPatientLocation.room
from external table based on episode ID. I can query table fine through the System\SQL but seems that I can't set new value even when pre-setting value in embedded SQL statement panel:
Select 'test' into :target.PriorPatientLocation.room
DTL test displays * next to PV1 but no value is set.
Maybe I am going about it wrong way and should use different approach. Any suggestions are welcome.
Thank you in advance.
I am under the impression that inside HealthShare you can Services, Processes, and Operations. The service takes incoming data, the processes can process that data, and then the operations can send that data out.
I am curious if anyone has any experience, guides, or advice on how I can send data to a service using a Java application. I intend for the data to be in XML format. I am also curious if I succeed at picking up the data in the service, how I send the data back to the Java application using an Operation.
Im usually pretty good at ComplexMaps and implemented a couple, but I have one that is stumping me on how I can implement it. My problem is I have no real "leading data" to key off of and need something else...
It goes a little bit like this:
D123456 THING1 THING2 THING3 THING4
D789101 THING1 THING2 THING3 THING4
Hi everyone,
I am currently sending an HTTP POST request to an
Olá pessoal,
Compartilho material de um curso desenvolvido por mim, espero que possa ajudar a comunidade.
English:
Hi folks,
I share material from a course developed by me, I hope it can help the community. The material is in Portuguese.
Link: https://www.linkedin.com/posts/cristianojs_material-te%C3%B3rico-activity-6608421528906285056-sr8E
For simplicity sake let's say that we talk about active production.
I need to know if the business host is added to the production or not.
Currently I have:
do ##class(Ens.Director).IsItemEnabled("HostName", .sc)
set defined = $$$ISOK(sc)Which looks like a workaround.
Hello,
I've got a table with many attributes and data. There is 10 000 000 registrations approximatly.
I need to make a research on this table with filters, paging, and order.
You can see an example of my SQL request :
SELECT * FROM ( SELECT TOP ALL * FROM ANCV_Data.Titre WHERE etatTitre = 'Emis' ORDER BY numRemise desc) v WHERE %vid BETWEEN 1 AND 25
Cause there are many data on my table, my SQL req is too long if I don't have index on my attributes BUT there are many associations possible...
BridgeWorks is pleased to announce a VDM, v9.1.0.1. This release includes the following updates:
Updates
Bug Fixes
I am sending a HL7 message from a Service called Servicios.Interconsulta PeticionInterconsultav01r00 to a Bussiness Process Process called
EnrutadorVisa doMedicamento using SoapUI
Currently, many of you has some knowledge about CachéQuality (which is being renamed to objectscriptQuality) for analyzing objectscript code using the rules we have predefined. Probably you have tested it and have found too many warnings in your projects. I'm sure there are issues which are really important for you and some others which you would like to dismiss.
In time for InterSystems Global Summit 2019 we at George James Software are pleased to offer a cloud-hosted evaluation environment where you can work with Serenji in Visual Studio Code, editing and debugging ObjectScript in a sandbox running InterSystems IRIS 2019.3 Community edition.
You can do it all from your web browser. Nothing will be installed on your workstation, nor will any settings have to be changed on it.
To take Serenji for a test drive please visit https://georgejames.com/dc-gitpod
Some time ago I developed an application that tackled a familarial problem faced by many developers when required to update multiple UAT or PRODUCTION sites with the latest Software patches that have been developed and tested on your DEV server and now need to be deployed to multiple sites running that software.
In principle the solution works as follows:
1) Prepare an XML export of affected classes/routines/csp pages/hl7 definitions et al
2) Optionally create a global export of any new globals or changes to existing globals
Customized Command ZZJSON for CACHÉ
IRIS brought us an excellent %JSON.Formatter class.
I did a backport to Caché to have it also availaible there
It consists of %ZZ.JSON.Formatter.cls and %ZZPVA.inc
But for debugging it is stil not handy enough. So ZZJSON.inc was also included.
