I want to address the nasty problems about reading a flat text in ASCII, UTF*
explicitly excluding HTML, EBCDIC, and other encoding.
According to Wikipedia there are at least 8 variations of control characters.

• CR+LF is typical for Windows
• LF is typical for the Linux/UNIX world
• CR is Mac's favorite

As you can deduct from the names the inspiration comes from mechanical typewriters.

There is an interesting new feature in the recently announced 2024.1 preview, JSON_TABLE. JSON_TABLE is one of a family of functions introduced by the 2016 version of the SQL Standard (ISO Standard, published in early 2017). It allows for JSON values to be mapped to columns and queried using SQL. JSON_TABLE is valid in the FROM clause of some SQL statements.

The syntax of JSON_TABLE is quite large, allowing for exceptional conditions where the provided JSON values don't match expectations, nested structures and so on.

In the previous article we saw how we could recover a resource stored in the database of our particular HIS, so today we will see how we can add new records in our HIS whose origin is an FHIR resource that we receive in our system.

IRIS Community Edition Installation Process.

Hello there developers,

Hello All

I'm not sure what the best practice is for this. I have a DTL for returning ORUs back to a hospital in a different time zone. They have requested that various timestamps have the time zone offset added to the HL7 format (%q%k, I think). First, I just wanted to be sure the system was aware it was DST. I was able to determine if DST is in effect like this:

Our 3M Computer Assisted Coding system goes down on a regular basis for updates, the Applications folks like us to Disable the Business Operations when this happens and start them back up when they page the on-call person. The Business Operations have to be started in a sequence to guarantee that all the ADT being sent it processed before we start sending everything else.

Hello everyone, could you please advise me on how to solve this error :
ERROR #6085: Unable to write to socket with SSL/TLS configuration 'HTTPSCert', error reported 'SSL/TLS error in SSL_connect(), SSL_ERROR_SSL: protocol error, error:1408F10B:SSL routines:ssl3_get_record:wrong version number' + ERROR #6034: SMTP server connection failed during init command: <READ>GetResponse+5^%Net.SMTP.1.
my SSL config :

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

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

🥇 @Luis Angel Pérez Ramos, Sales Engineer, InterSystems
🥈 @Pierre LaFay, CEO, Ellipse
🥉 @Sylvain Guilbaud, Sales Engineer, InterSystems

Learn more about the competition and our awesome winners below.

Does Intersystems have a simple (albeit large) HL7 Reference Guide ?

James M

I am very pleased with the added XML import/export feature in VS Code, this is something I found valuable in Studio. Similarly, I would find it very useful to allow import/export of .rtn files from VS Code. Is this currently possible (other than using SMP)? If not, are there plans for adding this? I frequently work with exported routines in .rtn format that I import into multiple instances.

Working on a custom view for LookupSettings.cls. I've added code to adda Change Log entry into the table when rows are added/updated. I'm trying to do the same for when rows are deleted. How can I pull the key & value for the row when it is selected for delete /un-delete? The variable rowData is used a pointer for the row index. I know I'm missing something simple...

Hi Team,

Can you please help with this error as below :

Hi gentlemen,

It may be very easy but I'm currently battling with a stupid business operation.

Here is what I must do and what is already in place:

A business service scan every 5 sec the apparition of files and send it to a business process.

The business process (a routeur) don't let pass everything and a few of them go to a specific operation.

The operation must :

1 ) create the file with the same name of the original one (in the service) then save it.

I recently realized it's been far too long since I talked about the latest features in the InterSystems ObjectScript Extension for Visual Studio Code.

I'm pleased to announce version 2.12.1 of the ObjectScript extension, containing a number of enhancements that make a developer's life easier. Some highlights are described below, including the #1 requested feature from Global Summit -- XML import!