Hi Community, 

We are glad to announce that Developer Community in French is now connected to Global Masters, which means members of DC FR will automatically get points & badges for their contributions.

Hey Community,

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

Hey Community, 

Learn how you can develop a Node.js application and connect to InterSystems IRIS data platform through the Native API:

⏯ Using Node js to connect to InterSystems IRIS

Hi Guy,

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

Thanks

Newbie stuck again, hoping this won't be as bad as I'm thinking. In my DTL Editor I've got 

Source.Appointments.(k1).Date = 07/05/2022

Source.Appointments.(k1).StartTime = 14:30

Source.Appointments.(k1).

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.

Here’s why:  Caché uses the openssl library for SSL/TLS.  TLS v1.1 and v1.

Hello, today we had another freeze in the system. It was close to 09:55. Logs follow for analysis. Following are MSM/MUMPS logs with about 1050 active connections at the time of the freeze. Does anyone see something different?

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 developer folks!

Thanks to all of you who start the development with InterSystems IRIS from the basic development template!

Recently, thanks to @Dmitry Maslennikov's contributions I've updated the Dockerfile to make the development simpler, images lighter and the building process faster. And it looks more beautiful too ;)

Here is what changed:

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.

We prefer a solution which is ObjectScript only.

Hi I've got a service setup to query a sql server via ODBC.

I've got all the parameters etc setup and everything is ok

My Query is

SELECT TOP 1
CI.ClientID, 
Gender, 
DateOfBirth, 
MaritalStatus AS MartialStatusCode,
(SELECT CodeDescription FROM GenMaritalStatus WHERE Code =  MaritalStatus) AS Martial,
Ethnicity AS EnthnicityCode,
(SELECT CodeDescription FROM GenEthnicity WHERE Code = Ethnicity) AS Ethnicity,
Nationality AS NationalityCode,
(SELECT CodeDescription FROM GenNationality WHERE Code = Nationality) AS Nationality,
DateOfDeath,
CN.Surname AS Surname,
 ISNULL (CN.GivenName1, '')
 + ISNULL( CN.

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")
 

Thanks

Is it a good practice to set the MAXLEN value of %Library.String property type?  Will it lead to wasted storage if its not really using it?

For example, I have to store a 5 characters long string into the below str field. Which of the statement is recommended? 

Property str As %String;

vs

Property str As %String(MAXLEN="5");

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!

Hello guys!

The Global Summit 2022 in Seattle ended just over a week ago but keynotes are already available for those who missed them while being on the premises or who couldn't attend this in-person event at all for some reason or another (or just for those who wish to refresh their memory and listen to them again).

Without further ado, the beginning of the Global Summit AKA the Greetings from the Community:

Enjoy watching all the keynotes from all three days of Global Summit 2022 via this YouTube playlist: 

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.

ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>zOnRequest+1^EnsLib.MsgRouter.VDocRoutingEngine.1 *DocType,Test.SQLtoHL7Req -- logged as '-' number - @''

What am i missing

Thanks.

I just met a personal challenge translating my article to French.
Tough I had to learn it at school and could read and understand
famous literature (Sartre, Molière, Mauriac, Proust, Saint-Exupéry, Anouilh, ...) 
I missed the specific terms used with ISC technology.
Thanks to @Lorenzo Scalese my errors were corrected.
But no dictionary was able to answer. 
Especially as English is gender-neutral the individual gender in other languages is just undefined.
QUESTION:
- Is there anywhere a Dictionary in ISC to cover this

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

How would you like to be able to access the Web Terminal directly from your VSCode?

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:

A new VS Code extension leverages the popular and well-established WebTerminal package to bring you this experience.

If you like it, please vote for webterminal-vscode in the current contest. Voting closes at midnight on Sunday 5th.

Hey Developers, 

See how you can develop a .NET application and connect to InterSystems IRIS® data platform using one or more APIs:

⏯ Using  NET to Connect to InterSystems IRIS

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

Hey Developers! Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in June 2022.

The InterSystems IRIS has excellent support for encryption, decryption and hashing operations. Inside the class %SYSTEM.Encryption (https://docs.intersystems.com/iris20212/csp/documatic/%25CSP.Documatic…) there are class methods for the main algorithms on the market.

IRIS Algorithms and Encrypt/Decrypt types

As you can see, the operations are based on keys and include 3 options:

• Symmetric Keys: the parts running encrypt and decrypt operations share the same secret key.

In the June 2022 newsletter, see the new releases unveiled at the Global Summit—including cloud-based offerings! Plus, get the latest on performing analytics queries, check out the latest certification exam, and try the new documentation search features.

Hi Everyone,

              I am a very new to IRIS Object Script Development. There is a  usecase where I have to execute a .sh file from the object script. I am looking for examples for that, but what I find is the ways to execute the shell commands. Can you please point me to some examples executing a .sh file. Thanks in Advance

Hi developers. I often miss the ZPM program on a clean system. Nothing complicated? Take and install. And in one line? Especially in a docker container. There is a solution. I'm very happy with it;) Maybe the line can be shortened?

set $namespace="%SYS", name="DefaultSSL" do:'##class(Security.SSLConfigs).Exists(name) ##class(Security.SSLConfigs).Create(name) set url="https://pm.community.intersystems.com/packages/zpm/latest/installer" Do ##class(%Net.URLParser).Parse(url,.comp) set ht = ##class(%Net.HttpRequest).%New(), ht.Server = comp("host"), ht.Port = 443, ht.Https=1, ht.

If one of your packages on OEX receives a review you get notified by OEX only own YOUR package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on Github when I found a problem I could fix.    
Some were accepted and merged, and some were just ignored.     
So if you did a major change and expect a changed review just let me know.

Developer Preview releases are now available for the 2022.2 version of InterSystems IRIS, IRIS for Health, and HealthShare Health Connect.

 This is the first in a series of releases that are part of the developer preview program. Future preview releases are expected to be updated biweekly and we will add features as they are ready.  This program allows us to get feedback on capabilities and enhancements as they're available.  You'll see below a list of enhancements that are targeted for 2022.2.  Some these are not included in the first developer preview.  Look for those over the coming weeks.

We recently migrated to IRIS. Before, the CACHE.EXE executable could be invoked from a batch file directly : 

C:\InterSystems\Cache\bin\cache.exe -s C:\InterSystems\Cache\mgr -U %SYS

This will display the following in console : 

Node: DESKTOP-8H4B321, Instance: CACHE

USER>

Additionally, the pipe instruction can be used to redirect some commands directly

echo write 50 | C:\InterSystems\Cache\bin\cache.exe -s C:\InterSystems\Cache\mgr -U %SYS

I am looking for the same thing in IRIS.