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

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

🥇 @Danny Wijnschenk, Application Developer/Owner, Winfo, Belgium

🥈 @Lorenzo Scalese, Solution Architect, Zorgi, Belgium

🥉 @YURI MARX GOMES, Software Architect, YM Services, Brazil

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

Learn more about the competition and our awesome winners below.

Hi Guys,

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in June 2022:

Hi Guy,

is there like a utility or a function that convert from UTC to Locale time?

Thanks

Question:

What version of Caché supports TLS v1.2?

Answer:

Caché 2015.2 announced support for TLS v1.1 and v1.2. In this version, the SSL/TLS configuration page provides checkboxes for TLS v1.1 and v1.2, which allows the versions to be configured individually. This allows sites to, for example, require TLS v1.2 only.

Additionally, some earlier versions of Caché provide undocumented support for TLS v1.1 and v1.2, specifically Caché 2014.1.3 and above and 2015.1, on Windows, Linux and Unix.

InterSystems Native SDK for Python is a lightweight interface to InterSystems IRIS APIs that were once available only through ObjectScript.

I'm especially interested in the ability to call ObjectScript methods, class methods, to be precise. It works, and it works great, but by default, calls only support scalar arguments: strings, booleans, integers, and floats.

But if you want to:
- Pass or return structures, such as dicts or lists
- Pass or return streams

You'll need to write some glue code or take this project (installs with pip install edpy). edpy package gives you one simple signature:

call(iris, class_name, method_name, args)

which allows you to call any ObjectScript method and get results back.

Hi,

I am in a situation where my container is on UTC time (as is the host). But I need to send a datetime to a machine in a specific time zone. Various languages have constructs for doing that, sometimes you need a library

python has the pytz library.

Hi Guys,

I'm using the below to export a query result to excel file and the only file type is .csv (100) but the resulting has two problems,

first the row header is including the field type and second the resulting file is a tab delimited so columns aren't properly separated (see attached below)

set st = ##class(%SQL.Statement).%New(2,"Sample")
set sql = "select ID, name from MyClass"
do st.%Prepare(.sql)
set type="csv"
set rs = st.%Execute()
do rs.%DisplayFormatted(type,"C:\Temp\report")

UPD: check out the Greetings video here

Hi Community!

As you know, this year Global Summit is back in-person. We really want to see everyone there!

Not all of the Community members can attend (me either!), so we decided to produce a cool VIDEO with Greetings from Our Community Members 🎥
Let's join virtually this great event from all around the World!🌏

⬆️ Upload in this challenge a short (2-3 sec) VIDEO of you saying "Hi from your country🙌" to our Community Members. So, we could combine it with the other videos from our members and present it on Global Summit 2022. You can also just send me a link to a shared file in DM.

Deadline: June 18, Friday, till the end of the day!

See you there!

Hi,

I am using IRIS for Windows (x86-64) 2019.1.1

I have.

1. Created a BS with SQL Inbound Adapter which successfully connects and gets rows from DB .

2. Created a request message is populated with results of SQL query.

3 Created a BP with HL7 Router + Routing Rule + Transformation + Send to Target (BO).

4 . Created BO sending HL7 to file.

i am getting the following error.

After a short (or too long) pause from the previous part here is a short recap of the next few days of the Global Summit 2022 in Seattle!

As before, each day started with the keynotes (which you should be able to watch tomorrow ). But unlike the keynotes on June, 21 the following day they were dedicated to Data Platform IRIS. As before, you can find the topics and the presenters in this announcement. Some of the notable speeches were delivered by Geoffrey Moore, Bestselling Author, Consultant, and Disruptive Technology Specialist

If you do your IRIS development in Visual Studio Code and wish you had a convenient way to get a terminal session on your server, take a look here:

Hello everyone! Don't miss the Developer Community Post Digest for June 2022.