InterSystems FAQ rubric

When executing OS commands, use $ZF(-100).

do$ZF(-100,"",program,args) // Execute the Windows command [synchronously].

do$ZF(-100,"/ASYNC",program,args) // Executes a Windows command [asynchronously].

When executing OS shell commands such as mkdir and copy, also specify /SHELL.

do$zf(-100,"/shell /async","mkdir","c:\temp\x")

Please refer to the following documents for details:

About $ZF(-100) [IRIS]
About $ZF(-100)

Hi, Community!

This article is an overview of SQLAlchemy, so let's begin!

SQLAlchemy is the Python SQL toolkit that serves as a bridge between your Python code and the relational database system of your choice. Created by Michael Bayer, it is currently available as an open-source library under the MIT License. SQLAlchemy supports a wide range of database systems, including PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server, making it versatile and adaptable to different project requirements.

The SQLAlchemy SQL Toolkit and Object Relational Mapper from a comprehensive set of tools for working with databases and Python. It has several distinct areas of functionality which you can use individually or in various combinations. The major components are illustrated below, with component dependencies organized into layers:

I have a API that is returning on objext with four fields. Two are arrays that are empty.  How can I define the message class property to ignore/handle "Messages" and "SharedRelations"?

How can i modify file extention on output file leaving Busness Operation

Ex..changing "output.txt" to "output.hl7"

This question originally appeared in the comments of the post: Making use of Multiple Sub Transforms in a main map || HL7
 

I'm having a similar problem trying to get PRD(1) into PV1:ReferingDoctor and PRD(2) into PV1:ConsultingDoc
Running the subtransform will populate referring doctor for the first PRD, and then the second running will delete the PV1, make a new one with only the consulting doctor populated.

Was hoping I could use a subtransform to populate the information, but looks like it has to be done at the transform level.

I want to connect the app to Cloud SQL but when I registered and created the deployment (trial) I got the error:

Did anybody face such an error?
During the creation of an account, there was a message like 'username is taken' but the account have been created anyway. Maybe it could cause this problem.
 

Hi everyone!

The other day I was reflecting on the possibilities that FHIR brings us in the world of interoperability and electronic medical records and it gave me mixed feelings, let me explain, first a small introduction.

Introduction

As you well know, FHIR is based on parameterizing a series of concepts that it calls resources in JSON or XML format with the intention of covering the most common cases within the healthcare environment, relying on HTTP communications to cover CRUD and query functionalities.

Through this FHIR architecture, it is possible to develop a common base for the exchange

Hi.

I would like to exchange data with external system every one minute or even more frequent. So I need to trigger production process/operation every minute. How can I do it?

I'm trying to install the Inter System IRIS data platform in windows and I'm not able to download the installer file. Some one can help me with this.

Please look at the below image for the reference for the error I'm facing 

And also I'm looking for the docker version of the IRIS, but here also I'm not able to identify the IMAGE for the same. Please look into the below image.

Thanks.

How do i Install HS.FHIRServer.Installer in InterSystems IRIS?

Is there any way to perfom a cyclick redundancy of a "stream" instead of string?

I know exists the method $ZCRC but I think it's only for strings.

Thank you!

I getting the response back to my method fine,

but it is not returning to my BPL.

What am I missing to get the response back to the BPL?

// Execute REST Call
set tHttpResponse=##class(%Net.HttpResponse).%New()
set tSC = ..Adapter.SendFormDataArray(.tHttpResponse,"POST",tHttpRequest,"","",tURL)
set tStatusCode = tHttpResponse.StatusCode
$$$TRACE("Status Code: ["_tStatusCode_"]")
do ..logJSON(tHttpResponse.Data.Read(),"Post Relation Response")

// On HTTP 200 - OK
if tStatusCode = 200 {
     do tHttpResponse.Data.Rewind()
     do pResponse.%JSONImport(tHttpResponse.Data.Read())
     quit $$$OK
} else {
     q

I'm in a very early phase of an project where some of the methods should be written in python. Occasionally, projects also have byproducts, I call them utility methods, because some of the methods the project uses can also be used in other applications too. I tend to put such methods in percent classes, so they can be used everywhere, independent of the namespace, where an application runs. I try to do the same in my current project  too, merely with python it doesn't works! Why?

The question is, what is wrong with the (%Zpy.Utility) class below?
My testmethod (which doesn't contains any rocket

My newest app includes a java routine to read data from Excel 95, 97, 2000, XP, and 2003 workbooks and write the data into IRIS globals using Java Native API library.

If you have Git and Docker installed, clone/git pull the repo into any local directory

$ git clone https://github.com/oliverwilms/excel-java-iris.git

Open the terminal in this directory and run:

$ docker-compose up -d

Execute java class IRISNative

$ docker-compose exec -it iris java IRISNative

Press Enter to accept the default /opt/irisapp/excel/money.xls.

>>> Input File [/opt/irisapp/excel/money.xls]

The java code reads data from an

Hi Team,

I am not able to login to the Management Portal. I have used default password for _SYSTEM and Admin but still getting Access Denied.

Please help me.

Thanks,

Abhshek

Hi Developers!

Welcome to the 9th edition of the InterSystems Ideas news! In this issue you can learn about:

​​​​✓ New page on the Ideas Portal  - Idea-A-Thon Winners

✓ Implemented ideas for future announcements

✓ New ideas posted recently

In this month's Learning newsletter, see how mirroring helps keep your databases running smoothly, and learn about the newest cloud-based asset management software. Plus, explore a new option for getting recertified as an HL7 Interface Specialist! Subscribe to get the latest updates in your inbox.

I'm pretty new to ensemble.I'm working on a BPL process where I need to retrieve a result set from an SQL activity, loop over the results, and call a web service. I'm having trouble passing the request parameter(Labtype) into the SQL query for the WHERE condition .Can any one suggest how to loop over the result set as well.Any suggestions on how I can achieve it?

Hello,

First of all thanks for your help, time, and answers.

We would like to know what are we doing wrong and how could we improve it and fix it.

We need to convert the Api Monitor Metrics which are a String with this format:

iris_cache_efficiency 13449.122
iris_cpu_pct{id="CSPDMN"} 0
iris_cpu_pct{id="ECPWorker"} 0

[...]

iris_wdwij_time 11
iris_wd_write_time 8
iris_wij_writes_per_sec 0

To JSON.

We would expect them to look like a normal JSON as follows:

{
"iris_cache_efficiency": "13449.122",
"iris_cpu_pct{id='CSPDMN'}": "0",

[...]
"iris_wij_writes_per_sec": 0
}

We have currently developed a REST Operation

I have a case where the Active Directory Service Account passwords will be changed periodically every 3 months and the changes are shared via the LastPass application which requires logging into the app to retrieve the new password and manually entering it into the Interoperability Credentials configuratrion, or the Service Registry.

> Is there a way to retrieve the password automatically?

In this case the organization plans to use gMSA (Group Managed Service Account) and BeyondTrust for setting up new password in the future.

How have people delt with this?

K9s is a terminal-based UI (aka kubectl clown suit), to manage Kubernetes clusters that drastically simplifies navigating, observing, and managing your applications in K8s, including Custom Resources like the InterSystems Kubernetes Operator (IKO) and ArgoCD Applications. If you are about to take your CKD, CKA, or CKS, leave k9s well enough alone for awhile as the abstraction to kubectl will become the standard for navigating the cluster and you will undoubtedly become estranged to the extended flags of kubectl and bomb the exam.

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Performing Advanced FHIR Validation @ Global Summit 2023

I am creating a custom message class. How do I define @name and #text fields?

this?  Property name As %String (%JSONFIELDNAME = "@name");

                "AttributesXML": {
                        "Attributes": {
                            "Attribute": [
                                {
                                    "@name": "city",
                                    "#text": "Kyle"
                                },
                                {
                                    "@name": "gmbCode",
                                    "#text": "TXAUSKLY0020G"
                             

Maven Projects mixing ObjectScript and Java

What is Maven?

Maven is a tool, hosted by the Apache Software Foundation, for building and managing any Java-based project. Apache Maven is the best source of information.

Why Maven?

Managing a project, its dependencies, and life cycle can be a tedious task. Maven automates these tasks, making project management much simpler. Maven also defines a standard directory layout and provides tools for initializing projects. These tools employ project templates called maven archetypes. There is a rich library of archetypes available.

What's your approach to learning InterSystems technologies?

Elevate your learning journey with us: share your insights in a brief survey and help us shape your learning experience.

InterSystems Studio Client  2023.1.0 Build 229
 

I closed my watch and output panels.  and I am trying to reopen.  I tried using Alt-2, Alt-3 and it is higlighting /unhighlighting the appropiate icons yet panels are not displaying.

I would appreciate any help.

Thanks,

Orlando

I 

I'm converting a .NET gateway interface (call .NET code from IRIS) from the old "Caché style" that use imported proxy class to the new $system.external .NET gateway as documented in:

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

For simple case it works and I'm fine, unfortunately I don't understand how to implement/access .NET arrays from IRIS and unfortunately the documentation has no info whatsoever on how to work with arrays.

What I'm looking for is how to implement the same code as described in the old .NET gateway

I have a BPL that I set up a trace to check if the ProcRsltStatus Order is 1. Because the trace is set up in the BPL, I am having issues in searching traces that have the 1 in the message viewer. Any idea how I can limit my search to only the ones with ProcRsltStatus Order::1? Thanks in advance.  

Hi community!

In this article, I'm excited to introduce my latest application, Journal File Indexer. The development of this application is rooted in the portal idea  DPI-I-270.  

In short, this application lets you load and index a log file in a database.  

Why?

If you've ever used the log file search function in the management portal, you may have encountered a timeout error or even a blank page. This problem usually occurs when searching a large journal file. Journal File Indexer solves this problem by considerably increasing the speed of searches once the file has been loaded into the database.  

Another problem arises during the restoration process. When searching for global entries in a log file to restore old or new values, the management portal doesn't have this specific functionality. A routine must therefore be coded to achieve this. Journal File Indexer comes to the rescue, incorporating a restore function!

Overview

In our previous post, we discussed the motivation for developing a chatbot agent with access to FHIR resources. In this post, we will dive into the high-level design aspects of integrating a Streamlit-based chat interface with a Java SpringBoot backend, and enabling a LangChain agent with access to FHIR (Fast Healthcare Interoperability Resources) via APIs.