New post

#Ensemble

29

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

Hi Guys,

I'm using the below to export a query result to excel file and the only file type is .csv (100) but the resulting has two problems,

first the row header is including the field type and second the resulting file is a tab delimited so columns aren't properly separated (see attached below)

set st = ##class(%SQL.Statement).%New(2,"Sample")
set sql = "select ID, name from MyClass"
do st.%Prepare(.sql)
set type="csv"
set rs = st.%Execute()
do rs.%DisplayFormatted(type,"C:\Temp\report")

0 5
0 463
Question
· Jun 4, 2022
SSL/TLS connection error

Hi Guys,

I'm getting the below TLS error in SSL_connect(), SSL_ERROR_SYSCALL, I've treid mulitple SSL/TLS configuration and still get the same error, so should I be asking the client that I'm trying to connect if there a specific certificate or configuration!?

0 4
0 711



This formation, accessible on my GitHub, will cover, in half a hour, how to read and write in csv and txt files, insert and get inside the IRIS database and a distant database using Postgres or how to use a FLASK API, all of that using the Interoperability framework using ONLY Python following the PEP8 convention.

12 1
1 709

Hello,

I want to access the HL7 Router settings from within the HL7 rule. Goal is to create a New class by extending "EnsLib.HL7.MsgRouter.RoutingEngine".

Then create a PARAMETER ProcessMessage which can be set to an integer value for the HL7 Router.

Create a Rule class and based on the value of this setting ProcessMessage
process/not process the messages.

1 15
0 482

Hi ,

We have inbound HL7 message we want to transform. Is it possible to copy inbound NTE segments at ORC level to PID group level in the transformed messages? I see functions for insert / append / set etc but they appear to be related to specific properties / fields of segments as iodised to the entire segment.

thanks

0 6
1 893

We're looking forward to seeing everyone at the InterSystems Global Summit next week!

George James Software will be there offering demos of our Deltanji source control. It has been proven to improve efficiencies within for individual developers, larger organizations, and everyone in between by bringing clarity to the development of your system. It encourages configuration management, versioning, and process control to improve the quality of your code.

If you would like to find out more, look out for us in the Partner Pavilion or book in for our User Group session during lunch on Wednesday, June 22nd. Email laurelj@georgejames.com to let us know you'll be there.

3 0
0 238

While reviewing our documentation for our ^pButtons (in IRIS renamed as ^SystemPerformance) performance monitoring utility, a customer told me: "I understand all of this, but I wish it could be simpler… easier to define profiles, manage them etc.".

After this session I thought it would be a nice exercise to try and provide some easier human interface for this.

The first step in this was to wrap a class-based API to the existing pButtons routine.

I was also able to add some more "features" like showing what profiles are currently running, their time remaining to run, previously running processes and more.

The next step was to add on top of this API, a REST API class.

With this artifact (a pButtons REST API) in hand, one can go ahead and build a modern UI on top of that.

For example -

Open Exchange app
6 15
4 1.2K

Come and say hi to us in the Partner Pavilion at the Global Summit!

We’ll be showcasing our Serenji on-the-spot debugger which has undergone some big changes in the last year—users can now enjoy a seamless debugging experience with zero configuration, along with taking advantage of the latest features in VS Code itself, enabling users to smoothly identify and quickly fix errors in your code, contributing to the production of quality, maintainable code.

If you want to see Serenji in action look for us in the Partner Pavilion, we'll be on hand to show you a demo. Prospective users are also welcome to join our User Group Session during the lunchtime session on Wednesday, June 22nd. Email laurelj@georgejames.com to let us know you'll be there.

2 0
0 218
Question
· Jun 7, 2022
Connecting two ensemble instances

Hi Guys,

We currently running all our clients in Ensemble 2014, but now we are having a problem that 2014 can't resolve (TLS version is 1 where we need TLS 1.2 or higher).

0 1
0 193

I noticed today that when we are creating a message from one doc type to another doc type, that the message type categories are not necessarily set. This is causing some issues with routing rules when we try to reference the Message Type Categories. Is there a way to make sure the Message Type Categories are being set within a DTL to make sure this doesn't cause problems down the road?

Thanks

Scott

0 7
0 379

Good morning,

We would appreciate if you could read us and if you have the opportunity, please respond to us.

The current situation is as follows:

We have 2 environments PREproduction and INTegration :

Ensemble version in PREproduction:

Cache for UNIX (Red Hat Enterprise Linux for x86-64) 2018.1.6 (Build 717U) Thu Feb 24 2022 13:27:54 EST

Version of the tool to convert XML to ER7 and vice versa, the ITB, in PRE (we get it in the ITB.info.cls file):

0 1
0 195
Question
· Jun 1, 2022
Production Service connections

Hi Guys,

I have a service that picks up jobs and process them, is there a way that I can cap the number of attempts to pickup a certain job eg. 10 times if no response then just discard ?

Thanks

0 1
0 193
Question
· May 28, 2022
Write JSON file in HTTPREQUEST

Hi Guys,

how can I write a json file in httprequest, I'm using the below but when I check what's in mystring it's actually truncated and doen't include all my file?

0 10
0 489

I am using the EnsLib.File.PassthroughService class in the business service, this business service will accept a text file from a location and pass it through to the BPL as a stream. I have been trying to work with the BPL in the GUI and I have been reading the documentation and trying to get it to work but I can not I continue to get errors and I am not sure why.

I will attach the Photos of what I have been trying, I think there is a problem with my call action because when I try and trace the message the context of the file does not even make it to the business operation.

0 2
0 322