Question
· Nov 9, 2022
SQL gateway connections

Hi Guys,

My understanding is that SQL gateway connection is a way where you can have two ensemble instances where in instance A you can have a class and then you create a connection from instance B and you can run queries for that table from instance A into B?

But as I checked the doc, it says that SQL gateways is a way to just import data from an instance to another?

Thanks

0 1
0 310

Hello,

Need some technique to solve an issue about zen page table.

- "xyz" table exists in all my namespaces.

I have a simple Zen page in "USER 1" namespace. It has a tablepane which pulls data from "xyz" table.

OnLoad of the page i want the zenpage to pull the data from "USER 2" namespace with same "xyz" table name.

Zenpage has to be in "USER 1" namespace

1 10
2 310

Hi all

I require an operation that will get a list of hosts every X minutes and call them, using values from my database.

The only issue is that I can't find any sort of scheduling/ timed event functionality in Ensemble. The documentation isn't particularly helpful so I thought I'd give the community a shot.

Is there any existing functionality in Ensemble that allows for scheduled operation calls?

Thanks

0 2
0 310
Question
· May 10, 2018
2015.2.2 .json format

Is it possible to produce a .json format using Ensemble 2015.2.2? Not sure what the trigger will be as of yet, but we have our local Department of Health trying to develop a reporting piece using .json.

Not sure how this will work with our Ensemble instance not being in the DMZ to send outside our network, but I thought I would ask anyway to see if it is possible.

Thanks

Scott Roth

0 2
0 310

Has anyone tried to extract a Microsoft SQL Image Column into a JPG file using Ensemble? We currently have a Microsoft SQL Integration Services job that exports a SQL Image column into a JPG and then resizes it. I would like to get this job off of Microsoft so the rest of our team can support it and wondered if we could do it in Cache Object Script using Ensemble.

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

0 1
0 308

Hello,

I am trying to send a HL7 Billing Batch 2.3:FHS file out to an FTP site:

The file needs to be in Variable Length / Carriage return carriage control format--

When I send the file, the format is Fixed Length 512 Byte Record-- Not Working

The data is ok within the file-- It is just the way I am sending it out of Ensemble that is not correct.

I am thinking that it is a setting within the Operation that I am missing or not choosing correctly.

Charset-AsciiCR

Separators -|^~\&\r

0 2
0 308
Article
· May 27, 2016 1m read
2016.3 Field Test Kit 2016.3.0.628.0

Steve Glassman is on vacation today so in his place I wanted to announce the availability of a new kit for the 2016.3 Field Test. The kit details are: 2016.3.0.628.0

Most of the changes are related to DeepSee, DocDB data models and dynamic objects. You can find a complete listing here:

https://wrc.intersystems.com/wrc/WRC.StreamServer.cls?FILE=/wrc/FieldTes...

Bill McCormick

Director of Product Management

0 0
0 306

Hi,

Is it at all possible to protect certain properties / message fields that is sent via Ensemble from within Ensemble.

Alternatively to mask it when displaying in the message view Body /Contents tabs.

We could send in the fields encrypted but I was hoping that we could just hide or mask the fields.

Any ideas on this.

0 4
0 306

The class %Compiler.UDL.TextServices arrived in 2015.1, bringing us methods for exporting a class in UDL format (i.e. looking just like we're used to seeing it in Studio), and importing a UDL format definition back into a namespace. Some source control tools including our Deltanji are now able to use UDL format, resulting in diffs that are easier to understand.

1 1
0 306

Introduction

Application integration at its simplest is often just one application sending a message to another to notify it of some change. Perhaps when a patient arrives at a hospital, the registration system will send a message to clinical systems so they have all demographic data ready to use. Of perhaps it is just a nightly file transfer from the sales system to the accounting system.

But modern application integration platforms or suites can do a lot more than this to help applications work together and add real value to the enterprise.

0 0
0 306
Question
· Mar 9, 2019
%SYS.TasK Related query

Hi Community,

I have to make a daily task (Job) which will run (7 am to 7 pm) in a day at an interval of 3 hours. Timings are as (7:00 am, 10:00 am,13:00 pm,16:00 pm,19:00 pm). But at each time when task will run i have to set a variables as per below condition

Sample:

1) If task run at 2019-03-19 07:00 am in morning

I have to set two variables (start and end) whose value will become like this

(set starttime= 2019-03-09 07:00:00.00 and set endtime=2019-03-09 10:00:00.00)

0 3
0 306
Question
· Jan 18, 2021
ERROR #5012:

Hello!

I have created a record map that I am going to use to parse a flat file coming into Ensemble. From there I am trying to send the parsed out data as emails to patients. I am getting this error when the Service tries to locate the file and send it through...it finds the file (as it states in the error message). So why does it say it does not exist?

0 2
0 305

Hello,

We would need to know the Ens.Response SourceConfigName to identify which Operation has raised an exception.

We have tried:

$$$LOGINFO("..%Process.%PrimaryResponseHeader.SourceConfigName..: "_..%Process.%PrimaryResponseHeader.SourceConfigName) //It outputs an empty string
 
$$$LOGINFO("response.SourceConfigName: "_response.SourceConfigName) //It generates an exception

We would need to get from an Ens.Response which body is null, its SourceConfigName:

0 2
0 305