Use case: small in-house hospital systems that query patient demographics via SQL.  The new PAS being implemented in the near future will only support query/response via HL7.  SQL access is available but intended for reporting so up to 24 hours behind.

Probably the easiest option is to set up a database in Ensemble and keep it up to date via standard ADT feed.  This is going to have quite a large footprint and has a risk of getting out of sync.

Another option would be to proxy the SQL queries in Ensemble and translate them to HL7 QRY messages.

I'm building a .Net Core Gateway container. Here's the issue.

As a final step I'm building a .Net Core 2.1 library. It has a runnable dependency - .Net Gateway, which I need to start first.

However dotnet publish generates .runtimeconfig.json and .deps.json only for my library and not for my dependency (.Net Gateway).

Is there a way to force dotnet to generate .runtimeconfig.json and .deps.json for a dependency?

With the latest improvements in support for Python in IRIS, and continued work on Python DB-API support by InterSystems. I've implemented IRIS support to the Django project where is Python DB-API is used to work with some other databases.

Let's try a simple application on Django, which stores its data in IRIS.

We are happy to share interesting information with you, as well as tell you why Python is good, where it is used.

Among the most used libraries are NumPy and Pandas. NumPy (Numerical Python) is used to sort large datasets. It simplifies mathematical operations and their vectorization on arrays. Pandas offers two data structures: Series (a list of elements) and Data Frames (a table with multiple columns). This library converts data into a Data Frame, allowing you to remove and add new columns, as well as perform various operations.

Coming up on Thursday March 3rd, VS Code Day 2022, the second official Visual Studio Code event from Microsoft.

Join the Visual Studio Code team and community at a live event just for VS Code users. Get a glimpse of things to come and meet the team who works on VS Code every day.

Starts 8am PST and runs for 90 minutes.

https://code.visualstudio.com/vscode-day/

Hi Community,

for our forms validation we use XData to describe fields on server side.

These XData are in JSON like this

XData FormValidator [ MimeType = application/json ]
{
 {
  "username": {
   "required": true 
  },
  "email": {
   "datatype": "email"
  }
 }
}

When I try to use %JSON.Adaptor in same classes, IRIS throw an error at compile time

 ERROR #6301: SAX XML Parser Error: invalid document structure while processing Anonymous Stream at line 1 offset 23
  > ERROR #5490: Error running generator for method '%JSONGenerate:helora.worklist.

Hi Developers, 

We invite you to share your feedback about our gamification program for developers - Global Masters. How did we do in 2021? What do you like about it? What you'd like to change?

➡️ Global Masters Survey 2021 (5 min, 11 questions)

We will build a roadmap for 2022 based on your answers. Please share your feedback and ideas! 

Voting time! 

Let's cast your votes for the best applications in the InterSystems Python Contest:

🔥 Vote for your favorites 🔥

How to vote? Details below.

Hey Developers,

We are pleased to invite you all to the next InterSystems online programming contest focused on Python! 

🏆 InterSystems Python Contest 🏆

Duration: February 7 - 27, 2022

In prizes: $10K - more prizes included!

Hello Community, 

Could anyone let me know the process to change segment/message terminators Eg: CR -> CRLF etc. inside the DTL ? 

Thanks 

In my article I described the work using iris.gref .
As the official documetation is rather slim on the subject it was necessary to dig into it.
Using the power of Python I was able to detect what I needed but was hidden.
I decided to share this with you. pydoc did the magic. 

Hey there,

I posted a reply to the recent video https://community.intersystems.com/post/new-video-building-data-driven-web-apps#comment-132511
with a slew of questions.  Wondering if someone can take a look a address my questions on that post or on this new thread.

I find many InterSystems learning to be challenging to follow, but I"m not sure if it's because my work computer is so locked down that I don't have all the right tools and permissions I need to do what the tutorial asks, or if I'm not understanding the basics of Cache/IRIS, or both!

Mike

We are planning to build a REST API with the Java Quarkus Framework.

• There'll be a connection pool;
• The DataSource instance will be automatically injected from the connection pool;
• We will use JDBI to do SQL instructions and this will give us automatic Connection and Statement management;

This Caché instance already have COS applications running and consuming connections and licenses.

After doing this, we will migrate to IRIS.

Is there any pitfalls that we must be aware before taking this approach?

If you want to see some code the PoC can be found here.

Thanks.

Hi contestants!

Here are the results of the bonus collections the applications of the Python Contest accomplished.

Here are the projects that scored it:

I have performed the suggested steps given in the below link for IAM installation but got an error "docker. errors.NullResource: Resource ID was not provided
[21528] Failed to execute script docker-compose"

https://docs.intersystems.com/components/csp/docbook/Doc.View.cls?KEY=C…

I have the " FHIR Production" which converts HL to FHIR, CDA to FHIR and accepts FHIR rest API to insert data into the FHIR repository.

When data is added by the above production, The Repository Stores that data as new data.

Is there any way to check resource duplication before inserting them into the repository?

Thanks,

Vivek Nayak

Is there any chance to make available a arm64/aarch64 binary version for Caché ODBC Driver?

Just like IRIS ftp://ftp.intersystems.com/pub/iris/odbc//2021/ODBC-2021.1.0.215.0-lnxr…

As I am using docker, currently is not possible to build locally a new image using existing Caché ODBC Drivers on Mac M1.

When designing a hierarchy in DeepSee, a child member must have only one parent member. In the case where a child corresponds to two parents, the results can become unreliable. In the case where two similar members exist, their keys must be changed so that they are unique. We will take a look at two examples to see when this happens and how to prevent it.

Example 1

There are a handful of states with a city named Boston. In my sample data, I have records from both Boston, MA and Boston, NY. My dimension is defined as:

City and State are simply strings in my case.

Hi!

Trying to create a string with $LB using Embedded Python.

Don't see the way to do it. If Embedded Python supports list builds?

It appears the link to download IRIS is down:
https://download.intersystems.com/download/login.csp

Hello All,

I am looking for some ideas from people who have automated alerting in place for their Ensemble or IRIS productions.  

I want to start with basic things like, simply checking if a Production is up and running. Once this has been achived, I am looking to go deeper and implement monitoring on each interface level for things like, Queue Size, Errors and Inactivity.

Would appreciate if you can share some ideas. I have been exploring http://localhost:52773/api/monitor/metrics but don't see anything in there that tells me whether my Production(s) are running ok or not.

Thank you.

Hi anyone hs any experience sharing with migrating from Oracle to IRIS? Thx!

Found one interesting behaviour in one system with Ensemble. Some Request class has a property with type %XML.CharacterStream by design, this class is the heaviest request in the system, and with profiling journal files, it got about 40% of the file. When I counted all the sizes of such streams per one day and found that the real stored data is three times less. After deep inspecting the journal file, I found the first save of stream data, then removing previously stored data, and saving again and there were no reasons to change the content of the stream, it should be stored only once.

How to Configure and implement X509 users to allow login into cache without password.

Is there a way to apply Transformation on any Dynamic column in Clinical Viewer.

As there is no transformation field available here. 

Hi,

In Visual trace there is EDI Response legend. What is the EDI Response and what is its use in production?

Thanks

I'm thinking to try ChunkedWriter based on the documentation I'm reading to solve an issue but could use some clarification. Anyone that could provide a usage example of this down below?

To send a chunked request, do the following:

1. Create a subclass of %Net.ChunkedWriterOpens in a new window, which is an abstract stream class that defines an interface for writing data in chunks. In this subclass, implement the OutputStream() method.
2. In your instance of %Net.HttpRequestOpens in a new window, create an instance of your %Net.

Hi All,

We wanted to implement SSO(Single Sign On) flow from VSCode plugin to web application. In order to do this we need to launch new browser from VSCode (typescript code) and open application URL in this new browser. When trying to achieve this by using WebView  we are getting - X-frame-options issue and mentioning it is set as same origin. We have tried setting 'Content-Security-Policy' as well but not able to launch application in browser.

How to add a default healthdhare login page on a js application hosted on healthshare 

Hi,

I'm using a DTL to convert a custom request class to various R4 FHIR resources using the HS.FHIR.DTL.vR4.Model.Resource classes. All is well with the exception of "meta.profile": when I attempt to hardcode this to a string value, the output is missing the value. This happens for several resources, specifically .HealthcareService, .Location, and .OrganizationAffiliation. I am able to get around this by doing an Insert() in a subsequent code block in a BPL, but was curious if someone knows why this would fail in a DTL.