Find

Article
· Jul 31 5m read

From Mud to Masterpiece: Meet dc-artisan and Craft Better Prompts

artisan cover

If you’ve ever watched a true artisan—whether a potter turning mud into a masterpiece or a luthier bringing raw wood to life as a marvelous guitar—you know that magic isn’t in the materials, but in care, craft, and process. I know this firsthand: my handmade electric guitar is a daily inspiration, but I’ll admit—creating something like that is a talent I don’t have.

2 Comments
Discussion (2)1
Log in or sign up to continue
Announcement
· Jul 31

Technology Bonuses Results for the InterSystems Developer Tools Contest 2025

We are happy to present the bonuses page for the applications submitted to the InterSystems Developer Tools Contest 2025!

See the results below.

Project

Vector Search

Embedded Python

Interoperability

IRIS BI

VSCode Plugin

FHIR Tools

Docker

IPM

Community Idea Implementation

Find Embedded Python bug

First Article on DC

Second Article on DC

Video on YouTube

First Time Contribution

Total Bonus

Nominal 3 3 3 3 3 3 2 2 4 2 2 1 3 3 37
Interoperability REST API Template     3                     3 6
iristest-html                           3 3
Global-Inspector             2 2     2   3   9
InterSystems Testing Manager for VS Code         3       4   2 1 3   13
IPM Explorer for VSCode         3           2   3 3 11
typeorm-iris             2   4   2   3   11
addsearchtable     3                       3
iris-message-search     3       2 2             7
iris4word   3 3 3     2 2 4   2 1 3   23
PyObjectscript Gen                             0
IrisTest             2             3 5
dc-artisan 3 3 3   3   2 2     2 1 3   22
templated_email   3 3       2 2     2       12
wsgi-to-zpm   3         2               5
toolqa   3 3       2       2 1     11
dataset-sample-split   3         2             3 8
snipforge         3                 3 6

Please apply with your comments for new implementations and corrections to be made here in the comments or in Discord.

28 Comments
Discussion (28)3
Log in or sign up to continue
Question
· Jul 31

Issue Sending Data to SQL Server from a Business Operation in IRIS Ensemble

Hi everyone,

I'm developing an Ensemble process that sends user data from a Business Process to a Business Operation using EnsLib.SQL.OutboundAdapter. The operation is supposed to call a stored procedure on a SQL Server.

The stored procedure expects 3 parameters:
@FirstName, @LastName, and @Email.

The procedure works fine when executed directly from SQL Server Management Studio.

However, when I trigger it via Ensemble, I get the following error:

[SQL Server] Incorrect syntax near 'email@domain.com'

hat is the proper way to use ExecuteProcedure or ExecuteUpdateParmArray to safely pass parameters to a SQL Server stored procedure using EnsLib.SQL.OutboundAdapter?

If anyone has a working example of a Business Operation calling a SP with parameters – that would be a huge help 🙏

Thanks in advance!

5 Comments
Discussion (5)4
Log in or sign up to continue
Announcement
· Jul 31

[Demo Video] AI Clinical Trial Platform

#InterSystems Demo Games entry


⏯️  AI Clinical Trial Platform

The Trial AI platform leverages InterSystems cloud services including the FHIR Transformation Service and IRIS Cloud SQL to assist with clinical trial recruitment, an expensive and prevalent problem. It does this by ingesting structured and unstructured healthcare data, then uses AI to help identify eligible patients.

Presenters:
🗣 @Vic Sun, Sales Engineer, InterSystems
🗣 @Mohamed Oukani, Senior Sales Engineer, InterSystems
🗣 @Bhavya Kandimalla, Sales Engineer, InterSystems

👉 Like this demo? Support the team by voting for it in the Demo Games!

Discussion (0)0
Log in or sign up to continue
Article
· Jul 31 1m read

Import CSV into CACHÉ

Here's a practical example of how to import data from a CSV file into InterSystems CACHÉ using ObjectScript
Assuming your CSV file is simple (e.g., comma-separated, with headers), you can use %Stream.FileCharacter to read it line by line and parse the data.

 

ClassMethod ImportCSV(filePath As %String) As %Status {
    Set stream = ##class(%Stream.FileCharacter).%New()
    Set sc = stream.LinkToFile(filePath)
    If 'sc Quit sc

    While 'stream.AtEnd {
        Set line = stream.ReadLine()
        Set fields = $ListFromString(line, ",")
        // Example: Save to a persistent class
        Set obj = ##class(MyApp.Data).%New()
        Set obj.Name = $List(fields,1)
        Set obj.Age = $List(fields,2)
        Set obj.Email = $List(fields,3)
        Do obj.%Save()
    }
    Quit $$$OK
}

Discussion (0)1
Log in or sign up to continue