#Ensemble

41

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 51

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
0 107

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 73

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 112

Hi Guys,

I'm running Ensemble 2014 and I'm using this to convert JSON to object:

class(%ZEN.Auxiliary.jsonProvider).%ConvertJSONToObject

 but how can I convert to %CharacterStream because I'm saving a %CharacterStream field

 

Thanks

 

0 1
0 85

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 231
Question
Rochdi Badis · May 17
Create aJSON file

Hi Guys,

 

How do I create a JSON with the below structure pls:

{
  "field 1": "123",
  "field 2": "1.1.1",
  "field 3": "4.428",
   "Lines": [
    [ 0.00523, 0.00952, 0.01626 ],
    [ -0.00303, -0.00286, 0.00387 ],
    [ 0.00110, 0.00814, 0.00800 ],
    [ -0.00991, 0.00952, 0.00800 ]
  ]
}

thanks

 

0 2
0 125

Hi Guys,

I currently have a service that uses an InboundAdapter to get a JSON file and process it given that the client is pushing data to us, but now we have another client where we need to request the JSON file by sending a HTTP request then get the file and process it, kind of a Get rather than push, how can I create a service that handle that?

 

 

0 1
0 85

Hi Guys,

How do I add another tablepane or gridview to make my tablepane look like expandable and collapses back as in the below pic?

so basically I would like to add a child tablepane or gridview for each row that populate the related details for it.

 

0 1
0 81
Question
Rochdi Badis · May 7
Cloning a class

Hi Guys,

we have a class with over 24 million records and despite indexes querying is still slow, so we are looking to create a copy or clone of our current class have an scheduled task that runs every night or month, copy old records this new clone (eg. from last month)   and remove old them from our current class.

0 6
0 219

Hi guys,

 

How do I create a make a http request using curl, I've found samples on how to do it from a command prompt but how to create and make a http post request and get a response with ensemble object and functions?

I guess somthing like :

0 2
0 155

Hello community!

I'm creating a script to remove an item (component) from the Ensemble production, I know there is a manual way to do it but as there are several components the idea is to use a script to be faster.

I tried using %Delete() and doing a select on Ens.Config.Item, but this ends up generating several errors in production. Does anyone have any idea how I can do this simply?

0 2
0 76
Question
Rochdi Badis · May 4
HTTP post request

Hi Guys,

 

How do I do a HTTP post request using a curl and get a response, the response should be a JSON file ? a sample code would be really appreciated.

 

Thanks

 

0 4
0 131