#Ensemble

Hi Guys,

my understanding that Arrow can't be used in left or right joins as the example below, so is there an alternative ?

SELECT Sample.Employee.Name, Sample.Company.Name AS CompName
FROM Sample.Employee LEFT OUTER JOIN Sample.Company
ON Sample.Employee.Company->Name = Sample.Company.Name

Thanks

Once a week we are attempting to load an XML file from Workday into a MS SQL table using JDBC and Store Procedures. There is approx 102999 records in this XML file. We are struggling with processing the entire file within a reason amount of time. We feed the XML through a BPL to then populate values in a stored procedure then call the stored procedure through a Business Operation. I have tried splitting out the Business Operations to make two calls, but we still continue to see an issue loading the XML into MS SQL.

I need to remove content below, from PID-3/HL7 message, in IRIS. However, I need to keep the content in PID-3.1. For example, I’d need to keep only, “5050532”. Can this be done in Data Transformations? If yes, how?
Thank you!

MSH|^~\&|TEMPUS|TEMPUS LABS|EPICEMR|YRMC|20210930100824||ORU^R01|4823623379495310173|T|2.3|
PID|1||5050532^^^YRMC~09abefb8-872b-4147-8e4b-77463bb235cb^^^^TEMPUS||

Hello Everyone ,

From Serial Device , i am getting only <CR> as line terminator , but ensemble expects <cr><lf> as line terminator . I couldnt change Line Terminator values in parser . Need help please

Thanks

Shilpi

First of all thanks for your time reading this question, and thanks for your help

We have the following use case: we would need to send with MTOM a zip which contains a csv

We have read:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

Class abc.abcmh [ DdlAllowed ]
{ ClassMethod FetchMsgCount() As %Integer
{
set msgCount=-1

I tried out CSV Record Wizard with my dat file from Analytics contest:

https://raw.githubusercontent.com/oliverwilms/iris-analytics/master/data...

I'm working on a project were we are going to be receiving a non-HL7 formatted flat file that will contain a single result message per line and each result messages may contain repeating OBX fields that will need to be parsed out so that can be sent as an HL7 ORU messages that contains multiple OBX segments.

Hi

Upon creating namespace I selected same database for both Globals and Routines. How can I separate both the databases. Please note that I already have data and code saved in database.

Thanks

Hi Guys,

when using $ZD(mydate,4) sometimes it returns year as 4 digits and sometimes two, and the documentation is saying ([YY]YY is a two-digit year if hdate falls within the active window for two-digit years; otherwise it is a four-digit year), what active window for two means and how can I force the year to be always 4 digits ?

Thanks

Hi,

I'm processing POP3 emails using the standard EnsLib.EMail.InboundAdapter adapter and %Net.MailMessage. I'm basically processing documents that are attached to received emails. This works fine if the document is simply attached to the email itself. But some systems are sending documents that are attached to an attached email which has content-type = message/rfc822.

How do I get the attached file from the attached email?

Hi,

I am getting below error while starting production

ERROR <Ens>ErrException: <CLASS DOES NOT EXIST>zgetProductionItems+29^Ens.Director.1 *HS.FHIRServer.Interop.Service -- logged as '-' number - @''

Thanks

Hi Guys,

Would like to know how to hide an element or component in zen report?

I've a list of element (eg. table, images, items..etc) defined under

XData ReportDefinition [ XMLNamespace = http://www.intersystems.com/zen/report/definition ]

{

In the Data Transformation Builder, I have a source record with several values that is connected to a target record with several properties. In the Tools tab, clicking on Test, I have an xml format set up to test the data transformation but I'm getting this error:

ERROR <Ens>ErrNoObjFromString: Failed to find element Record / class BI.process.prodTest.Record in String

Do you know what might be causing this error to happen?