Hi

I am a very experienced Ensemble and IRIS developer who has spent his entire career either working for InterSystems or with their products. I was a Senior Sales Engineer with InterSystems for 14 years with a further four years working for InterSystems TrakHealth. I started working for the InterSystems UK office and from there I spent several years travelling to InterSystems offices in Europe, Scandinavia, the Middle East, Israel and eventually ending up in the South African office. I moved back to South Africa in 2001.

Hi Community,

We are pleased to invite all the developers to the upcoming InterSystems Datasets Contest Kick-off Webinar! The topic of this webinar is dedicated to the Datasets contest.

In this webinar, we’ll do a quick tour of the new LOAD DATA feature, also chime in on packaging global data or file data with ZPM, and run a data-generation script as part of a method in the zpm install. 

As always, our experts will answer the questions on how to develop, build, and deploy datasets using InterSystems IRIS.

Date & Time: Tuesday, December 28 – 10:00 AM EDT

Speakers:  
🗣 @Benjamin De Boe, Product Manager, InterSystems  
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Where can I download the ODBC35 driver version 2018.1.4 64 bit?

Hi,

In a Business Operation i have the following code.

I need the identity of the latest row inserted in a table in MSSQL.

i Have the following code:

---------------------------------------------------------

set insertmaster= "INSERT INTO dbo.dataMasterArchive(deviceToPatientLogID) values (?)"

set tSC = ..Adapter.ExecuteUpdate(.nrows1,insertmaster,pRequest.deviceToPatientLogID)                                
$$$ThrowOnError(tSC)

set sql ="SELECT SCOPE_IDENTITY()"
set tSC = ..Adapter.ExecuteQuery(.tResult,sql)
$$$ThrowOnError(tSC)

set maxID =

Hello.

I want to store a mailbox in Caché, persistently.

Does anyone have some code for downloading all messages from mailbox into Caché? And maybe automatic syncing after download? I know, there is  %Net.POP3 but maybe someone has already done that.

Thank you.

Hi

I'm using a class which extends  %XML.Adaptor adaptor and I want to create an XML file with multiple namespaces, like the following:

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
</soap>

However, I don't see how to do this with the code I have. So far, I have

 Class GMMHTIE.Docman.Messages.Request.RequestWrapper Extends (%Persistent, %XML.Adaptor)
{
 Parameter XMLNAME = "soap:Envelope";
 Parameter NAMESPACE = "http://www.w3.

Hey everyone,

Lots of new content to read! Thanks to our wonderful participants of the 2nd InterSystems Tech Article Contest!

🌟 25 AMAZING ARTICLES 🌟

So it's time to announce the best of them!

For those that, at some point, need to test what means that of ECP for horizontal escalability (computing power and/or users and processes concurrency), but they're lazy o have no much time to build the environment, configure the server nodes, etc..., I've just published in Open Exchange the app/sample OPNEx-ECP Deployment .

UnitedHealth Group is looking for an IRIS expert to help guide our development team, providing subject matter expertise and sound software design skills.

This is a permanent, full-time, 100% telecommuting position.  The job will be a mixture of software design, consulting and hands-on development.  The ideal candidate will have excellent communication skills, a solid understanding of computer science and be an energetic team player.

I need iterate multiple times the same ResultSet. How can I do a rewind on it?

Does someone knows if any Studio version or, if in its new versions, it will be able to recognize new Javascript statements like arrow function, let, const etc ?

let there be less <UNDEFINED> or <SUBSCRIPT> Errors in my life.

Hey Developers,

Learn about the latest updates to InterSystems HealthShare Health Insight and what is coming next:

⏯ InterSystems HealthShare Health Insight: New & Next

We have a couple of systems that send us a URL link to a PDF instead of base 64 encoding it in the HL7 message. Has anyone ever tired to take that URL, and retrieve the file off of the server to save it off somewhere?

Hi Developers, 

It's time to announce the Winners for November 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in November 2021:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈@Oliver Wilms, Integration Engineer, Take2 Consulting, USA  

🥉 @Mary George, Team Lead, Barts Health NHS Trust UK 

Learn more about the competition and our awesome winners below.

Hey Developers,

Thanks to everyone for participating in the Advent of Code 2021and coding in InterSystems ObjectScript! We're pleased to introduce the winners and distribute all the prizes! 

Big applause goes to these developers: 

   @Kevin An (w/ repo)

   @Yuval Golan (w/ repo)

   @Oliver Wilms (w/ repo)

We'd also like to reward another developer who conquered Embedded Python and made all 25 challenges on it. Please welcome:

   @Robert Cemper (w/ repo)

Hey DC members,

How could we make the Tech Article contest better? We want to hear from you all: both from our participants and from those who were unable to participate.

Please answer some questions to help us improve our writing contest!

👉 1-min survey: InterSystems Tech Article Contest #2 Survey

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.

Hi all

We are looking into automating worklist report SQL queries that we run manually on InterSystems IRIS platform but we would like to have them run on a Java application.

This means we must have a way to get our java application to talk to IRIS in order for those queries to run. Please advise on how to go about this?

Regards,

Ephraim Malane

We have an interface that need to be disabled then re-enabled when it starts to queue up. I wrote the following code to do this functionality in a process. This works in our development domain, but in production it says it fails to disable the job - it only shuts down the interface without updating the production/starting the interface back up. Error message: "Failed to stop job '36831290' within 60 seconds. Status '<unknown>" 

Is there something wrong with how I'm trying to do this? 

set tSC = ##class(Ens.Director).EnableConfigItem(itemname,0,0) 

set tSC = ##class(Ens.Director).

I need to send the data from a view that returned NULL, but is going as empty. The fields are of type String.

I'm using: 

 SET tSC  = ##Class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.tSteamJson,pObj,,,,"e")

{
    "altura": "",
    "atendimento_id": "3060382",
    "data_atualizacao": "2021-12-16 10:39:12.0",
    "data_coleta": "2021-12-16 10:37:00.0",
    "data_liberacao": "2021-12-16 10:39:12.

Hi Developers, 

New video is already on InterSystems Developers YouTube: 

⏯ Embedded Python for ObjectScript Developers: Working with Python and ObjectScript Side-By-Side

If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.
​​​So @Evgeny Shvarov  suggested publishing my monthly summary of my reviews here in DC.
It reflects my experience with the status I found at the time of my review.

to dismount/mount a database, use Dismount() and Mount() methods in SYS.Database class available in %SYS namespace.
NB: the database ID is its Directory

You'll find  some examples of how to dismount/mount and check if a database is mounted (Mounted=1) or not (Mounted=0), and quickly see all the attributes of a database (via zwrite)

%SYS>set db="/opt/irisapp/data" 

%SYS>w ##class(SYS.Database).%OpenId(db).Mounted                     
1
%SYS>w ##class(SYS.Database).%OpenId(db).Dismount()
1
%SYS>w ##class(SYS.Database).%OpenId(db).Mounted   
0
%SYS>w ##class(SYS.Database).%OpenId(db).

Hey Community, 

Day by day, our team makes the DC site a better place for InterSystems developers. This release will show how we've improved the Developer Community recently.

The key features:

• User profile editing
• Contest page for Tech Article Contests
• Word & character counter

Learn more about our new features below.

Hello!

I send request: 

set hr=##class(%Net.HttpRequest).%New()
set hr.Server = "server.com"
set hr.Location = "method?param=value"
do hr.EntityBody.Write("{ "name": "value" }")
set tSC=hr.Send("POST")
But when request incoming to server.com URI = "method%3Fparam%3Dvalue".
How I can disable urlencode params in URI, so that the URI remains "method?param=value"?

One of my colleagues had developed an interface in Health Connect (HealthShare 2019.1) to add large amounts of data to an external SQL Server database. The data comes from many text files with delimited rows and data for one table per file. There is a business process to read a file line by line and send an Insert Request to an operation. The request contains an Insert statement like ‘Insert into TABLE columns (col1, col2, … colZ) values (val1, val2, … valZ).’ The Health Connect operation utilizes Outbound SQL Adapter to insert one row into a table per request.

Hello,

I am in the process of trying to create a GIT repository and I am struggling to export all the relevant classes from Studio, as I only have access to Studio and not able to export via the Management Portal. Does anyone have any suggestions as to how I can export from Studio as one project to include all the relevant folders and its associated classes?

Are there also any recommended documentations/links you would suggest to help me get a better understanding of  GIT and how it works etc?

Thanks!

Pavi

Hi Community, 

New video is already on InterSystems Developers YouTube:

⏯ Updates on Security: OpenSSL and a New "Security" Database