Hi Community!
Please welcome a new session recording from Global Summit 2017:
Hello,
Hi, folks. I have an HL7 SIU message inbound that is missing a few fields, such as patient ID and provider ID. I insert this HL7 message and a few of the fields into a SQL database. My SQL team then runs a stored procedure to retrieve the patient ID and provider ID and insert the found values into fields in the table. I would like to then do a select from the table, load the HL7 message and add the fields that were found by the SQL stored procedure into the HL7 message. I'm attempting to use a DTL to accomplish this. My sourceclass is CustomEDI.SQLSIUInRequest and targetClass is
We need to process 01B edifact files, INVOICE / CREDIT NOTE / DEBIT NOTE, ORDER, MESSAGE STATUS
Does anyone have SEF files or scheme to import , this EDIFACT version or other to use it at Ensemble?
Thanks in adavance!
"Telegram" is a well-known instant messenger, which provides an API for creating bots. 
The features of this API allow you to create bots with a wide range of functionality including receiving payments.
With the help of the telegram bot, I solved a simple task - sending Alerts from Ensemble to Telegram.
Advantages: Alerts come to the mobile phone, a notification appears, so there is no need to install any additional applications (in contrast to the solution https://community.intersystems.com/post/sending-alerts-mobile-phone-using-pushover- httpoutboundadapter).
The bot can be extended by adding new commands, for example, for managing the Production or for solving other tasks in Iris, Ensemble or Cache.
 |
 |
Hi,
The following sql statement is working through the SMP but couldn't make it work through the code.
The table is a linked table to oracle db.
Tried to change the date property in the linked table class from %Date to %String and also tried using %SQL.Statement and %Library.ResultSet
this work through SMP:
INSERT INTO PACKAGE.SOME_TABLE_NAME
(EFFECTIVE_START_DATE,MORE,DATA,HERE)
VALUES (to_date ('2018-04-01','yyyy-mm-dd'),123,456,789)
In the code i'm using '?' in the statement for the parameters.
So in the code it's go something like this (where the to_date is in the sql statement):
Hi,
Trying to work with REST protocol, using IIS 8, both client and server are Cache servers,
I have the following problem-
When I send a PUT command, I get the following error:
<HTML><HEAD><TITLE>Length Required</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Length Required</h2>
<hr><p>HTTP Error 411. The request must be chunked or have a content length.</p>
</BODY></HTML>
Hi
Made a request for API REST.
Using HTTP Request adapter.
Adapter As EnsLib.HTTP.OutboundAdapter
Outside the Ensemble an API response is JSON (CORRECT)
Answer in Ensemble: =?Á
Â0
?_eä,cÒ
'=
*^<YÙF¡í$í¼ÈÞÝt
oÉ÷ý$?|
¤1¡{Dâhà°Ý?Öù)2ós??R?¸¼?ºd?$,ñD+»??
?
ÔºQZéýNÕ V{C?óò?b¢?éÍ )$
²5Å?wEë? ??©tÖã1z×2FëÊnôeË æ??]Zßq ܺ?á
Help me.
Thank you
Hi,
I would like to add my favourite template at the template menu (Studio): Tools→Templates→Template 1
But I'm unable to find how to do it.
Thanks
Manel
Hi Guys,
We experiencing a strange problem with one of the clients on Cache 2008, for time to time they can't run any of their Crystal reports and each time we had re-compile the classes used in the affected report to get it running, then it happens again for the same reports.
I was wondering if there was a way to easily identify the node depth of a global.
Take the following global example. Is there way to determine the depth is 3?
s ^global("first","second","third")="some^info^here"For those who don't have a chance to vote elsewhere today, or for those who want to vote more than once 
, here's a poll for Ensemble users.
We are going to start using Git within Cache.
One question came up - if the branch that you checked out does not have the class or mac file, what is the correct thing to do?
Should we delete from Cache or should we just keep it?
I'm leaning more towards deleting it because Cache should reflect what is in your work folder in git. But other team members are saying to keep it.
Hello.
We have a request message with properties that has underscore. This is because we need to convert that request to JSON.
The problem is when we try to assign a value in a Business Process with the editor. It doesn't work, it doesn't compile.
How can we fix this?
This is the object used in the request:
Class test.msg.struct.TestXML Extends (%SerialObject,%XML.Adaptor)
{
Property "status_id" As %String(MAXLEN = "");
Property service As %String(MAXLEN = "");
}
{
Property "status_id" As %String(MAXLEN = "");
Property service As %String(MAXLEN = "");
}
And this is the error:
Does developing a RESTful API in Caché remove the requirement to use the InterSystems.Data.CacheClient.dll and generate proxy classes using the Caché Object Binding Wizard for .NET web development? If anyone has links to sample applications using .NET with Caché and REST Services, I would be grateful if you could share them.
Effective immediately InterSystems will no longer support Health Connect on Solaris. Previously released products starting with 2017.1 will also no longer offer this combination. This is in line with InterSystems HealthShare, which is not available on this platform.
Hi,
We have a PAS that accepts HL7v2 QBP^Q21 requests, and returns patient details in an RSP^K21.
We have a clinical system that wants to sent an http GET request of the form http://server/getpatientbyid?pid=M1234567
So I think I need to convert the query url into a QBP^Q21 (HL7) message, then take the response in HL7v2, convert to SDA, convert to FHIR, and put that in the response to the original GET.
Does anyone have any experience doing this? is there an approach you would recomend?
How to convert SQL persistent classes to JSON output - I have tried 1 option but appears to be very lengthy process.
I have many other SQL storage's defined and have to expose them as well to JSON. Can anyone please suggest a better approach.
My column names usually match with my Json properties.
My User.TestClass is the class with GetJsonList() as my method to return /output JSON formatted data.
The Code tried and SQL storage structure are as follows -
This is a sample Ensemble/Health Connect production which demonstrates how to receive an HL7 order (ORM) inbound from a file, extract fields (in this case, basic demographic information), and insert those into a table in an external SQL database via ODBC.
Included in the zip file:
- Exported code
- Sample ORM message
- 'How to configure' doc
Hi Everyone!
New session recording from Global Summit 2017 is already on InterSystems Developers YouTube:
Last time, we stopped on static stuff. Let’s continue...
A client wants information extracted from their MUMPS database and transferred to a cache database, where do I begin and what are some best practices I should keep in mind? (I am fairly new to MUMPS and have been put on this project)
Hi-
I have the following objects
Class A
Property P1 As B
Property P2 As %String
Property P3 As %String
Class B
Property P1 As %String
Can I create an index in Class A based on P1.P1. Basically I want an index of class A by property P1 in class B
I tried creating the following but got a compile error
Index I1 On P1.P1
Thanks
I am trying to created SOAP request body that I need to post as string. I created the SOAP client and tried with this to get SOAP envelope. Can you suggest a way for this.
Set proxy=##Class(Client.Class.Client.Methodname).%New("Methodname")
Set proxy.Para1="a"
Set proxy.Para2="b"
Set tClient=##Class(Client.Class.Client).%New()
Do tClient.WriteHTTPContent(proxy,proxy.%RequestName,0,0,"","",.stream)
I use macros everyday, but its the first time I want to create a macro like this
I want to create a new macro whereby I can pass a variable amount of parameters
the macro (much simplified version) would be
#define myMacro(%params) $listBuild(any Number Of %params I pass in)
so I want to be able to call $$$myMacro(user,ID,vehicle) ie 3 parameters would generate
$lb(user,ID,vehicle)
but equally I might want to call that same macro $$$myMacro(companyID) ie 1 paramter and would generate
$lb(companyID)
so the question is,
Is there a way to reduce the size of a CACHE.DAT file after a major reduction in global content has been performed?
Thx... Larry.
I am tasked with using CACHE to insert data retrieved from a CACHE data base and insert it into an sql database. The columns in the sql table that I am trying to insert data into have names that contain underscores such as "ACCESSION_DATE" I found a utility in CACHE to connect to the sql data base and perform inserts. I have the data I need to insert. I need to pass the data into the sql utility referencing the column names.
I tried using indirection to set the data into underscored variables, but that isn't allowed in cache object script.
Anyone have suggestions as to how to do that?
Will an upgrade from 2015.2 to 2017.1.2 or higher freeze the query plans from 2015.2? Is there some minimum source version where this will work?
I am rather new to ObjectScript and I have a query about assigning values to the context.
In BPL I have a context variable (A08Msg) which is set to type Enslib.HL7.Message, I want to put my inbound HL7 message into this variable so I tried:
- an Assign to set context.A08Msg to request
This seemed to load the message into the variable because I could read values, e.g. using context.A08Msg.{PD1:3(1).1} , but I was unable to write to context.A08Msg.
Hi Everyone!
Enjoy a new video on InterSystems Developers YouTube Channel:
