The below code is not working. its unable retrieve Record count and merge files

Class Util

{

ClassMethod zPyRecordCount(inputfile) As %Integer [ Language = python ]

{

import pandas as pd

import iris

import io

try:

df = pd.read_csv(inputfile, sep='|')

recordcount=len(df.index)

sys.stdout.write(len(df.index))

return recordcount

except Exception as e:

return 0

}

0 2
0 28
InterSystems Developer Community is a community of 23,521 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

I'm running the image "containers.intersystems.com/intersystems/irishealth-community:2025.1" as a container on my local Docker desktop.

Now I want to set up an ODBC SQL connection, but I don't know how to do it.

I have tried various ways without success. Like building my own image (see "Dockerfile" description below).

I have also added ODBCINI variable in my docker-compse (see "Docker-compose.yml" description below).

Anyone done this before?

I'd really appreciate some help.

Thanks.

0 1
1 28

When accessing management portal through IIS the page is not fully rendered and the buttons/links that are displayed don't work.

Management Portal works fine through private web-server.

Have just set up IIS/CSP Gateway to access Ensemble, and accessing the CSP Gateway configuration pages through IIS works fine (screenshot at end of post).

This is the view when accessing management portal through IIS (port 80) - missing images, links don't work, not all content displayed:

0 2
0 28

All,

At READY 2025 we will have a CCR User Group Breakfast for HealthShare and TrakCare customers on Wednesday at 7:30am (presentation starts at 7:45am). Topics will include:

  • Review of Self Service Best Practice Dashboard
  • Recent CCR New Features and Enhancements
  • Active CCR Feature Beta Programs
  • Summer and Fall Roadmap
  • Q&A

We will meet in the Jackson meeting room. Visit the Meeting Counter to have it added to your schedule or comment below to request an invite.

2 0
0 27

Hi everyone,

I’ve set up a scheduled task in InterSystems IRIS to run every night at 2:00 AM, but it doesn’t seem to trigger consistently. Some nights it works as expected, but other times it just skips without any error in the logs.

The task is marked as enabled, and there are no conflicts in the Task Manager. I’ve double-checked the system time and time zone settings all looks fine.

0 1
0 27

I was wondering if anyone had a way to automate creating the Query String for a FHIR Request?

Using HS.FHIRServer.Interop.Request in my development I have to specify the following...

I was wondering.... if my source had variable number of fields if there was a way to automate the build for the QueryString when doing a Patient Search?

1 0
0 25
Contestant

Hi Community,

Enjoy the new video from InterSystems Demo Games:

⏯ FHIR-Powered AI Healthcare Assistant

https://www.youtube.com/embed/P5JcdjLNvbc
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 0
0 23

Thank you community for translating an earlier article into Portuguese.
Am returning the favor with a new release of Pattern Match Workbench demo app.

Added support for Portuguese.

The labels, buttons, feedback messages and help-text for user interface are updated.

Pattern Descriptions can be requested for the new language.

Open Exchange app
2 0
0 23

I am attempting to follow the tutorial at Publishing Web Services Using Caché | Caché Web Services QuickStart Tutorial | Caché & Ensemble 2018.1.4 – 2018.1.11 to build a toy SOAP web-service using Cache but am running into what I suspect are permissions issues, or perhaps setting up the "plumbing" to get an incoming request to call the web-service methods.

0 1
0 22

Hey Community!

We're happy to share the next video in the "Code to Care" series on our InterSystems Developers YouTube:

⏯ Chaining LLMs for Better Results using Agentic AI

https://www.youtube.com/embed/hAtuAIihBVA
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
1 22
Contestant

Hi Community,

Enjoy the new video from InterSystems Demo Games:

⏯ Eliminating Waste in Healthcare Supply Chains

https://www.youtube.com/embed/NOgKJ09k5O8
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

12 1
0 21

Hi Community,

Watch this video to learn about Shift's new Data Platform architecture, combined with the InterSystems IRIS roadmap for data management:

⏯ Shift Data Platform: The IRIS Roadmap Applied @ Global Summit 2024

https://www.youtube.com/embed/-kDYPsLqrzA
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 0
0 19

Hi Community

I'm working on a complex piece of rules that needs to check each OBX and evaluate if 3 of the fields match certain criteria. I've tried to achieve this using a Foreach loop, which does work, however it is not as clean as I wanted it. I was hoping I could assign temp variables inside the foreach loop to make the rules more easier to read, for example @testCode @resultText. This is not support as you can only assign inside a when condition. Before I raise this as an idea, i wondered if there was an alternative way to achieve the same thing?

1 1
0 18

Hey Developers,

Enjoy the new video on InterSystems Developers YouTube from our Tech Video Challenge:

⏯ Message integration with Google Chat

https://www.youtube.com/embed/F3ZW7ojGcJM
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2 0
0 16
Hello and welcome to the June 2025 Developer Community YouTube Recap.
InterSystems Global Summit
By Rochael Ribeiro Filho, Fernando Ferreira
By Benjamin De Boe, Qi Li
By Alex MacLeod, Jason Sherwin
By Renan Lourenco
By Jim Breen, Jenny Ames, Art Dirik, Chi Nguyen-Rettig
0 0
0 15
Article
· Jul 11 7m read
Metabase IRIS Driver

Hi InterSystems Community! I'm Sidd one of the interns at the Singapore office and I recently had the chance to develop to develop a driver to connect IRIS to Metabase to help some of the Sales Engineers here. I was encouraged to share it here so that if any others have a similar issue they can use the driver and as well as get some feedback on potential improvements. The full GitHub repo with the quick start step, brief overview and the driver building process can be found here.

Open Exchange app
4 0
1 14