Hi everyone

Anyone knows how can we add a column to an existing linked table in Cache to reflect the external SQL table?

I've tried different queries. It does not fail but does not add the column either...

Hello Developer Community!

I’m pleased to announce the 0.9 release of the ObjectScript extension for Visual Studio Code. Earlier this year I announced that InterSystems would be joining the community in evolving this already popular tool. Since then, we have been hard at work solidifying the code base and building a slew of new features.

Before I get into the details, I’d like to take a moment to thank @Dmitry Maslennikov, @John.

Common macro def as following

#def AnyNumber(%args) for i=1:1:$listlength(%args) { Write $listget(%args, i)}

Using this marcro in objectscript code:

ClassMethod Test() as %Status {

     $$$AnyNumber($lb(1,2,3))

}

if ths args is literal value , Iit worked great. But  When I want pass Objects, It's not working

$$$AnyNumber($lb(##class(someClass).%New()))

I know I can pass a %ListObjects , If I want more shorter Line. How can I do this.

Tks

Hello

We were wondering if there is a more concise and simple way to convert information from a string to an object.

Hi i have rules and i want to log them to analyse what rules executed , I want to add in the log Msg Controller Id, MRN, Value coming in the message, and my customize text telling whats wrong with this field... i have like 50 rules and at the end i can check the log table and found like 20 entries so it means 20 data issues are there for a given message control id. any advice how to to do it

Hi Community,

Enjoy watching the new Global Summit 2019 video on InterSystems Developers YouTube Channel:

⏯ Building Data-Driven Web Apps

Hi,

Does anyone have a simple code snippet to encode and upload a raw text to Azure Blob?

I'm looking for any  reference documents on migrating about 3 TB of data from DB2 to IS IRIS Healthshare..  I've looked through the IS  documentation  and SQL gateway, or TSQL are some of the methodologies mentioned , was wondering  if anyone had done this type of migration before, and can provide any pointers.

I put a html file into ensemble dir ,it's encoding is utf-8.

But when I access this file througn browser, It show incorrectly

I checked http response header, It content-type charset is GB18030 So that's reason

How to change the charset to UTF-8?

Tks.

Hi 

We have several rules in router to validate HL7 messages, each rule check a particular field in HL7 message and send back response.  We want to run all rules and combine the rules responses into some variable/object and at the end if variable/object is empty it means message is valid, else send the value from this variable/object. This way one message we dont run it again and again, and we can send one message and response will give us combine results from all rules. 

For example,

Rule 1 - Check MSH.12 field, Send response "MSH.12 value not valid", and RETURN

Rule 2 - Check PID.

Hi Team,

I am getting this error while i entered one field and hit search button. The screen spinning for few minutes and prompt this error.Error Condition CSP application closed the connection before sending a complete response. The job is still running in the backend. Is there anything wrong with this SQLQuery, S Select="SELECT * FROM Sample.

InterSystems has corrected a defect that can cause a build-up of orphaned processes consuming system resources. In extreme cases, this can cause a system to become unresponsive.

This defect affects the following versions:

• Caché and Ensemble 2018.1.4
• InterSystems IRIS and InterSystems IRIS for Health 2019.4, 2020.1, and 2020.2
• HealthShare Health Connect (HSAP) 15.032 built on Ensemble 2018.1.4
• HealthShare Health Connect 2020.1

No other InterSystems product versions are affected by this issue.  Specifically, earlier versions of Caché and Ensemble, Health Connect 2019.1 and 2019.1.

Hi Community!

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Use Case: Connecting Devices to IRIS for Health to Improve Patient Care

Dear,

I have a visual studio c# library (.net framework 4.7.2) where I want to use EF.  I cannot see my ODBC connection in datasource when I select a ADO.NET Entity Data Model for EF designer for database.

I followed the installation for CacheEF.zip file. (C:\Cache\Cache2010v2\dev\dotnet\bin\v4.0.30319)

Any Ideas,

Kurt

Hi all,

a HealthConnect customer of ours came across with a question to use an external service via REST and OpenID within one of his HealthConnect  (2020.1) productions. The overal idea is to send data to the external system after receiving a baerer token to use for the communication between HealthConnect and this system.

Since I´ve never done such thing before I have an idea to solve this task but looking for a best practise way to do so. Using the RESt-Api of the external system is not the question here.

Hello fellow comrades.

I have a little issue concerning the creation of an embedded PDF sent by hl7. When I Extract it, the pdf is not completed (Seen by opening it with notepad++) compared to the one I created with a Base 64 converter.

The one I got from the Base 64 converter contains 7XXX contains lines and mine after my program contains 5900. The 5900 lines are the same that 5900 firsts of the others so my converting code is ok. The problem must be in the recuperation of the data. I think it's too long and the GetFieldStreamRaw can't contain everything.

I'm testing with an application I'm writing in python. But I noticed that the pythonbind3 library will only work on the same machine where the cache is running. Is there really such a dependency?

I'm trying to run the examples that are in the / dev / python / samples3 folder, but they only work if I set "LD_LIBRARY_PATH" with the path to the cache installation folder.

But... I have this error when LD_LIBRARY_PATH is empty:

[root@cache2018 samples3]# python CPTest2.py -user _SYSTEM -password xxxxxx Traceback (most recent call last): File "CPTest2.

I am currently working with docker for the first time the last month. I created a project with these 2 images:

• https://hub.docker.com/_/intersystems-iris-data-platform (for backend)
• https://hub.docker.com/_/nginx (for frontend)

My docker-compose.yml looks like this:

    version: '2'
    services:
        frontend:
            container_name: frontend
            build: 
                context: ./container/frontend
                dockerfile: Dockerfile.

Getting routingrules compiling error message. same code works fine for IRIS For Health

/// 
Class Training.HL7Validation.RoutingRule Extends Ens.Rule.Definition
{
Parameter RuleAssistClass = "EnsLib.HL7.MsgRouter.RuleAssist";
XData RuleDefinition [ XMLNamespace = "http://www.intersystems.com/rule" ]
{
<ruleDefinition alias="" context="EnsLib.HL7.MsgRouter.RoutingEngine" production="Training.HL7Validation">
<ruleSet name="" effectiveBegin="" effectiveEnd="">
<rule name="Valid Sending Facility Code Required">
<when condition="Lookup(&quot;OnboardedFacilities&quot;,HL7.{MSH:SendingFacility.

Is Cache the preferred database source for extracting data elements for use in Health Share Patient Index or is there a significant benefit in sourcing data from a warehouse, data mart, or MV? I realize that could be a loaded question with 100 other questions that may follow, however, if there is a known advantage to extracting data from a particular data storage type, the answer may highlight that point. 

Our team is in the inception and elaboration phase of using the Health Share Patient Index solution.

The Great Outdoors campaign is running on Global Masters and we invite you to join!

The main goal of this campaign is to drive answers for unanswered questions on DC so all the members get the answers they need. Your knowledge is so important for the community. It's time to share your expertise!

Complete all 7 challenges of this campaign till September 15, 2020 to enter a raffle to win a $50 VISA Card*!

Also, you can participate even if you are not a Global Masters participant - read below how:
 

I have come across several cases where I need to set a Date filter to send only send any admit/scheduled date past a certain point. We have a couple different date comparison functions but none looking at the true date. Most of them are date + 15 or etc. Does anyone have a good date function they have written to say if x > 20170102 ?

Thanks

Scott

You might have encountered this and not known how to prevent it, or perhaps not even noticed it...

Hi Community!

We're pleased to invite you to the Online meetup with the winners of the InterSystems FHIR programming contest!

Date & Time: Friday, September 4, 2020 – 11:00 EDT

What awaits you at this virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• A short interview with all the winners about the past contest. Plans for the next contests.

I have a number of globals I want to loop through depending on a passed in string...

^A("SYSTEM")

^B("SYSTEM")

^C("SYSTEM")

^D("SYSTEM")

^E("SYSTEM")

I am passing in a string of "A:C:D"

Piecing that to pull out A,C,D, then want to use that to pull out A,C,D from above, but having problems setting the name of the global to be the name of the variable I have pulled out of the string

How do I set this?

I have tried ^varname("SYSTEM")

also tried setting a variable to have the value "^varname" and using that

Thanks

Edit:

May have found the issue but not the solution.

"SELECT * FROM wmhISTORYdETAIL" runs as a passthrough without asking for the DNS.

but

'SELECT Count([wmhISTORYdETAIL].[HistHMNumber] AS CountOfHistHMNumber FROM [wmhISTORYdETAIL] WHERE ((([wmhISTORYdETAIL].[HistMovType])='Receipt') AND (([wmhISTORYdETAIL].[HistMovDate])>=Date()-1) AND (([wmhISTORYdETAIL].[HistMovDate])<Date()));'

asks for the DNS but both are linked to a table that has the password saved.

Any Ideas please?

Rob

Hi

I have created an MS Access database with a passthrough query to our Intersystems Cache WMS system.

Good morning all,

A question to see if anyone out there is already doing this.

We have built a custom BS based off of the EnsLib.FTP.InboundAdapter.  We have our processes wake up (using the Scheduler), grab the files in the directory, stay awake for a while, and then go back to sleep.

Each file goes through on its own message.  So we can trace each individual file and we know if it made it successfully or not.

What we would like to add is a status report email that creates a list of all the files sent in a "batch".

Hi

can I have two business services listening on same port ?

so let’s say

service a port 51000

service b port 51000

this way we don’t need to open port every time we add new service 

Keywords:  IRIS, IntegratedML, Flask, FastAPI, Tensorflow Serving, HAProxy, Docker, Covid-19

Purpose:

We touched on some quick demos of  deep learning and machine learning over the past few months, including a simple Covid-19 X-Ray image classifier and a Covid-19  lab result classifier for possible ICU admissions.  We also touched on an IntegratedML demo implementation of the ICU classifier.

Hi 

Getting error message, when calling NACK function that I created. Its working fine on Iris For HeathShare but on HealShare its giving below error msg. Any help.

Error message

Compiling class Hospital.RoutingRules ERROR <Ens>ErrParsingExpression: Error parsing expression 'GenerateNACK("For NewBorn Msg, PID21 Mother Idendentifier should have MRN number",%ErrorStatus)': ERROR <Ens>ErrInvalidName: Invalid name at offset 83   > ERROR #5490: Error running generator for method 'evaluateRuleDefinition:Hospital.RoutingRules' ERROR: Ens.Rule.Definition.