Problem

I'm working on exporting data from an Intersystems Cache database through the Cache ODBC Driver. There is a particular table that is giving me an error message. The ODBC Driver crashes and reports an error from the Cache system. I think I was able to trace down where the error is coming from, but I do not know how to debug or fix the error.

The table I am trying to extract is called SEDMIHP.

Here's the Error:

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

Background

In 2021, I participated as an InterSystems mentor in a hackathon, where a newcomer to FHIR asked me if there was a tool to transform generic JSON data containing basic patient information into FHIR format. I informed her that I didn't know anything like that, unfortunately.

But that idea stays in my mind...

Several months later, in 2022, I came up with an idea to experiment: to train a named entity recognition (NER) to identify FHIR elements into generic texts. The training involved synthetic FHIR data generated by Synthea and the spaCy Python library.

Open Exchange app
3 2
0 144

Hi Community!

There are two general ways to execute arbitrary SQL in serverside ObjectScript code: EmbeddedSQL and ObjectScript SQL a.k.a. Dynamic SQL.

E.g. if we want to get the value of the property of instance with a certain ID using SQL we can do:

&sql(SELECT Name INTO :name FROM Sample.Person WHERE ID=1)

write name

Same result with %SQL.Statement:

set rs=##class(%SQL.Statement).%ExecDirect(,"SELECT Name as name FROM Sample.Person where ID=1")
  do rs.%Next()
  write rs.name

1 2
0 917

We are investigating option of populating .pdf Custom Properties Name-Value pairs with episode/billing information from the TrakCare database, using Logi Reports. Resulting .pdf would be stored in a designated network folder. Would welcome suggestions on feasibility / technique to achieve / code to achieve (or alternative approach).

Intent is for further (watcher) process to detect new .pdf file in network folder and determine actions and/or process flow based on Name-Value pair information in pdf's Custom Properties.

0 2
0 99
Article
· Dec 21, 2021 8m read
IntegratedML hands-on lab

Have you tried the InterSystems learning platform lab for IRIS IntegratedML? In that lab you can train and test a model on a readmission dataset and be able to predict when a patient will be readmitted or not, or calculate its probability of being readmitted.

You can try it without any installation on your system, all you have to do is start a virtual lab environment (Zeppelin) and play it around!

9 2
2 489

Hey Community!

The latest webinar, recorded by InterSystems Sales Engineers @Sergey Lukyanchikov and @Eduard Lebedyuk, is already on InterSystems Developers YouTube! Please welcome:

"Machine Learning Toolkit (Python, ObjectScript, Interoperability, Analytics) for InterSystems IRIS"

https://www.youtube.com/embed/z9O0F1ovBUY
[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 2
1 407
Discussion
· Dec 28, 2021
On Datasets Licensing

Hi developers!

We launched the datasets contest.

And one of the important questions that need to be covered is dataset licensing.

There are two general cases:

a) a dataset you take from another place in public Internet or private network/person.

b) a dataset you create by yourself or own for any other reason.

We decided to follow the principles and considerations that data.world site introduces for datasets' licensing.

0 2
0 212

Hi! I am planning to move my Arbiter from a Unix server to a container(again on linux). To do this, I need the ISCAgent tar.gz file to configure Arbiter for our mirrored servers. I have tried searching for it on the Intersystems help forums but couldn't find it. Is it possible for someone to redirect me to the correct website to download it?

Thank you in advance!!

0 2
0 61

Hi all,

is it possible to omit the typical XML header line

<?xml version="1.0" encoding="ISO-8859-1" ?>

when writing an the contents of a EnsLib.EDI.XML.Document using the above mentioned operation. I´ve already digged into the config value Format. It only states that:

C(e) : output an XML header line declaring character encoding e. If e is empty use the encoding defined by the Adapter. If e begins with ! force the output stream's encoding. Note that this will be applied automatically for File Operations configured with a non-UTF-8 Charset

0 2
0 366

Let's say we have two serial classes, one as a property of another:

Class test.Serial Extends %SerialObject
{
Property Serial2 As test.Serial2;
}

Class test.Serial2 Extends %SerialObject
{
Property Property As %String;
}

And a persistent class, that has a property of test.Serial type:

Class test.Persistent Extends %Persistent
{

Property Datatype As %String;

Property Serial As test.Serial;

}

So it's a serial, inside a serial, inside a persistent object.

4 2
0 411

Hi Community,

We're pleased to invite all the developers to the upcoming InterSystems Grand Prix Contest 2022 kick-off webinar!

We'll share the details of our mega Grand Prix Contest 2022 and describe how you can win up to $22,000 in prizes! Unlike our other InterSystems Developer Community contests, this contest allows you to use any element of our data platform - IntegratedML, Native API, multi-model, Analytics and NLP, Open API and Interoperability, IKO, etc - in your project.

In this webinar, we'll talk about the topics to expect from participants and show you how to develop, build and deploy applications on InterSystems IRIS data platform.

Date & Time: Monday, May 9 – 11:00 AM EDT

Speakers:
🗣 ​​​@Alex Woodhead, InterSystems Technical Specialist
🗣 ​​​@Bob Kuszewski, InterSystems Product Manager
🗣 @Jeff Fried, InterSystems Director of Product Management
🗣 ​​​@Dean Andrews, InterSystems Head of Developer Relations
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

https://www.youtube.com/embed/5WZdxslBkMs
[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 2
0 267