Hi Community!

This is the update on what are the new applications submitted on OpenExchange in March 2019

New Applications

isc-tar published by @Dmitry Maslennikov

Compact files as TAR or Extract files from TAR files

Light weight EXCEL download v.1.0 published by @Robert.Cemper

This is the working example of a light weight export to EXCEL based on data in SAMPLES namespace. Good old CSP is well equipped to produce HTML tables accepted from EXCEL as input. With modern Browsers you don't even need and tags. So the required code around your SQL result set is really slim. And you are free to add any formatting you need either by HTML or in SQL.

PythonGateway v.0.7 published by @Eduard Lebedyuk

Python Gateway for InterSystems Data Platforms.

Adopted Bitmaps v.1.0 published by @Robert.Cemper

This is a running example of the Bitmap Adoption

WebSockets Tutorial v.1.0 published by @Lily Taub

A short tutorial on WebSockets in InterSystems IRIS 2018.1+ and Caché 2016.2+

Sync Data with DSTIME v.1.0.0 published by @Robert.Cemper

Other Sync-Tools just work from Caché/IRIS to Caché/IRIS. Synchronizing your data to some external DB you requires some other solution. DSTIME can do it.

HL7 and SMS Interoperability Demo v.1.3 published by @Amir Samary

This demo shows how easy it is to integrate an Electronic Medical Record system that is sending HL7 messages with AWS.

InterSystems is pleased to announce that Caché and Ensemble 2015.1.4 are now available as maintenance releases.
For a complete list of the corrections in 2015.1.4, please review the release notes.

Caché and Ensemble 2015.1.4 are available today for the same platforms as 2015.1.3.
The complete set of supported platforms, including specific point releases and/or patches, is detailed in the Supported Platforms document.

Hello All,

I'm new to InterSystems, just wanted to check if we can configure the Visual Studio code to use it as Studio for Intersystems development. I tried following the instructions in few posts but nothing worked. Please guide me to setup this

Hey Members!

We know there are times when some of you are looking for new team members. So here is a short tutorial on how you can place your job opportunities on the Community to attract the best employees ever!

First of all, you need to add a tag Job Opportunity.

InterSystems has corrected a defect that can cause corruption of databases and journal files on AIX systems with IBM POWER8 or later POWER processors. This defect can be triggered only when database or journal encryption is in use.

22:07:52.821:Ens.Director: ERROR <Ens>ErrException: <CLASS DOES NOT EXIST>zgetProductionItems+45^Ens.Director.1 *EnsLib.HL7.Adapter.TCPOutboundAdapter -- logged as '-' number - @' Set tRunAsJob=pDefinition(tConfigName,"RunAsJob"), pDefinition(tConfigName,"RunAsJob")=$S('
22:07:52.823:Ens.Director: ERROR <Ens>ErrException: <CLASS DOES NOT EXIST>zgetProductionItems+45^Ens.Director.1 *EnsLib.HL7.Adapter.TCPOutboundAdapter -- logged as '-' number - @' Set tRunAsJob=pDefinition(tConfigName,"RunAsJob"), pDefinition(tConfigName,"RunAsJob")=$S('

Consider a Natural Key with an Identity (Serial) field.

I cannot seem to acquire the generated value after persisting my entity. That is, the returned entity by Spring Data's "save" does not have the generated value.

The value is generated by the database, and I can query it after repository.save(entity).

I have done some testing and created a Github repo with it...

I'm wondering if anybody has done an implementation of the https://www.shibboleth.net/products/service-provider/ interface in Caché / IRIS to have a application running in Caché / IRIS be acception the shibboleth tokens and data as usage credentials.

Hello Community !

We are delighted to invite all our customers, partners and community members to participate in the InterSystems Benelux & France Summit 2025! The registration for the Summit 2025 is already open.

This event promises to be an interactive experience highlighting inspiring case studies, technological innovations and roadmaps for the coming year in the fields of healthcare and data platforms. Hands-on demonstrations will also allow you to explore the latest developments in a tangible way.

➡️ InterSystems Benelux & France Summit

🗓 Dates : February 11 - 12, 2025

📍 Place : Hilton Rotterdam | Weena 10 | 3012 CM Rotterdam | Netherlands

On 4 December 2024, System Alerting and Monitoring (SAM) will be removed from the InterSystems download sites, the container registry, and documentation site.

I try to get a vector from calling GetEmbedding, but i failed to convert it into a vector

Here is a simplyfied sample class:

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:

Hi All,
I want to write testcase in objectscript but stuck at this point where I am getting a DynamicObject from the class method and how can I assert this and check it is okay.
Also if in any case error It will throw error custom exception class that I created. How to handle assertion for exception in this case also.

So, I know that I can return a SQL Error message from my SQL Procedure written in ObjectScript, with code like this

$ cat <<EOF | irissqlcli iris://_SYSTEM:SYS@localhost:1972/USER
CREATE or REPLACE PROCEDURE test()
LANGUAGE OBJECTSCRIPT
{
 SET %sqlcontext.%SQLCODE = 400
 SET %sqlcontext.%ROWCOUNT = -1
 SET %sqlcontext.%Message = "test error message"
};

CALL test();

EOF
[SQLCODE: <-400>:<Fatal error occurred>]
[Location: <SPFunction>]
[%msg: <test error message>]

But I did not find how to do it with Python. I can't find %sqlcontext variable available there