This article is a follow-up to the previous one on how to migrate from popular databases (like PostgreSQL and MySQL) to IRIS.
We will use the same procedures utilized to migrate from PostgreSQL. However, you will see that it is even easier since the data types in MySQL are very similar to IRIS. That is why we will not need to create transformation rules in the columns.

Get the sample data to the migration process

In GitHub it is possible to download a docker-compose project to build and run 2 databases:

• Source Database: MySQL database Docker instance with a sample database.

In this article I will explain the usage of %SQL_Diag.Result and %SQL_Diag.Message table along with all-new LOAD DATA functionality.

It is recommended to go through LOAD DATA documentation first. 

After successful operation LOAD DATA insert one record in %SQL_Diag.Result table and details are inserted in %SQL_Diag.Message table

Below is the basic command when table is already created and source file does not contain header row. 

LOAD DATA FROM FILE 'C://TEMP/mydata.txt' 
INTO MyTable

The file name must include a .txt or .csv (comma-separated values) suffix and both source and target have the same sequence of data columns.

Loading from File Source: Header

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

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

Apache Zeppelin it's a Multi-purpose notebook that allow you:

•     Data Ingestion
•     Data Discovery
•     Data Analytics
•     Data Visualization and Collaboration.

Apache Zeppelin interpreter concept allows any language/data-processing-backend to be plugged into Zeppelin. Currently Apache Zeppelin supports many interpreters such as Apache Spark, Apache Flink, Python, R, JDBC, Markdown and Shell.

It provides you a safe environment to get insigth of your data. You can take avantage of Zeppelin's higligths using both , JDBC and Spark IRIS native connectors.

Hi Community, 

New video is already on InterSystems Developers YouTube! Learn about the easy process of migrating to InterSystems IRIS:

⏯ Join Us on a Journey from Caché/Ensemble to InterSystems IRIS

I have seen the Cache Python binding documentation and would like to know if it's also possible with IRIS so I can write data and also read/get it from the DB? The cachesys folder does not contain any python libraries.

* In-Platform Agent-Based Simulation of a Connected Factory Cluster

Author: Sergey Lukyanchikov, InterSystems

1. Purpose

In this paper we prototype and explore how multiple agent-based models of robotic factories connected to other robotic factories (represented by their respective models) can be orchestrated using an all-purpose data platform – thereby simulating descriptive and predictive properties of a group of factories (a factory cluster).

Dear experts,
Can you give tips to solve this issue?

When I try start cache is recording this error message in cconsole.log:

01/31/22-14:11:28:143 (4516) 3 Error: <DIRECTORY>SYSTEM+4^%ZSTART running %ZSTART - Logins are disabled

I try acess terminal and management portal, but are disable because that error.
I dont know how can I enable the logins.

Hi everyone,

Im trying configure the Caché Monitor Manager (^MONMGR) utility for send alert e-mails.
Following the steps I have doubs to configure the options in "Set Server" to send e-mails for hotmail or outlook (smtp-mail.outlook.com).
I dont know how can I configure Mail server SSLConfiguration for hotmail or outlook.
Could you give me help?
Thank you!

Mail server? mail.outlook.com (Enter '-' to reset) =>
Mail server port? 587 =>
Mail server SSLConfiguration?
Mail server UseSTARTTLS? 0 =>

Query result save to csv

How can I do to debug IRIS docker instance into VSCode?

See how you can deliver relevant and timely health information to clinicians and systems with HealthShare Unified Care Record®. This brand new learning path details key processes in configuring healthcare message delivery. Try it today!

From IRIS 2021.2 is possible write Class Methods using the Python Language. I used this new feature to detect persons and objects into images, using ImageAI (https://github.com/OlafenwaMoses/ImageAI). The ImageAI creator defines it as: "An open-source python library built to empower developers to build applications and systems with self-contained Deep Learning and Computer Vision capabilities using simple and few lines of code." In this article you will learn how to apply AI Computer Vision to detect object and persons inside images.

Hi,

What is the Python syntax I can use from a ClassMethod (developed in an IRIS using embedded Python), in order to invoke another class method,

- in the same class; and

- in another class.

I see 'self' is synonymous to use $this (..) in ObjectScript, but these are ClassMethods I am invoking, and self did not seem to work.

thanks - Steve

If you need create a upload REST API with IRIS is very simple. Do these procedures:

From Postman client you send a file

P.S.: It is a multipart form with a file type using "file" in the name. The request type is form/multipart. See the http request:

POST /image-analyzer/postFile HTTP/1.1
Host: localhost:52773
Content-Length: 213
Content-Type: multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW

----WebKitFormBoundary7MA4YWxkTrZu0gW
Content-Disposition: form-data; name="file"; filename="/C:/Users/yurim/OneDrive/Imagens/salesschema.

I have created a package that offers a utility to load a Global into JSON object and reverse     
to create a Global from this type of JSON object. Academic refers to the structure created.
Each logical node of the Global is presented separately with all its descendants.
Even if they don't contain any stored data.

Can we make any property immutable once it value is set? For example, I may have a property called RecordCreatedTime to track when the record is created in IRIS, and once it is set, I don't want anyone to modify the value. 

We recently encountered an Embedded SQL issue while upgrading to IRIS 2021.1, and thought the issue and workaround might be interesting to share.

Key takeaway:  Host variables in an ORDER BY clause of an embedded SQL query that is inside of a method don't work as expected. IRIS versions starting with 2020.1 are affected. As a workaround, add the host variable to the Method's PublicList list and "new" them so the embedded query has access to them.

It's come to our attention that the built-in license in the InterSystems IRIS and IRIS for Health 2021.1 Community Edition release is incorrectly set to expire on October 30, 2021.  

There is no impact to any production versions (the Community Edition is for development purposes), but developers will find that their instances stop running and should replace them with new ones.   For cases where replacing them is an issue, we have provided an override key.

I apologize for any inconvenience this may cause.

I would like to get current date and time in this format : YYYYMMDDHHMMSS  (eg: 20220126155704)

Simplest way to do that I found so far is this : 

$translate($zdatetime($horolog,8,1), " :", "")

It works, but it's not that great (I would like to avoid string manipulation) Is there a better, cleaner way ?

Hi....
I am trying to execute legacy routines from Cache 2018, into new environment with Iris 2021. I use new JDBC driver to make this connection, and change my java code to execute this legacy  routines. But I get this write error: <REMOTE EXECUTE INVALID WRITE> 
I changed the mnemonic routine to populate object and return this object to java. And the java class convert this object to json.
This is my simple classes used for this process, just to exemplification:
Java Class

package test;

import java.sql.SQLException;
import com.fasterxml.jackson.databind.JsonNode;
import com.

Currently running Ensemble on Red Hat Enterprise Linux Server release 7.7

One of our clients is requesting files sent to their SFTP site be encrypted with their PGP public key and digitally signed with our PGP private key

We have created a custom class that includes the following command to encrypt the files

if (pAction = "Encrypt") {
// Find the Key ID from the Keyname
set tKeyId = ..GPGKeyLookup(pKeyName, ..#PUBLICKEYLUT)
set tCmdLine = "gpg --homedir "_pGPGhomedir_" --always-trust -r """_tKeyId_""" -o "_pOutFileName_" -e "_pInFileName
}
// Execute the command to generate the output file
write

Hi Community

I have logged final generated json in the object script class using below statement

$$$LOGINFO("JSON = " _newMsg.Read())

where newMsg contains JSON stream, which contains nearly 1000000 + bytes.

In message viewer I am able to see Only some part of the json .

I want to capture all the json for my validation, how can i see total JSON in Management portal or any other source?

Thanks in Advance

I am working with a client database that is growing exceptionally fast ( about 15G/day).  As I understand it, the usage of the global ^STMONITS to gather statistics can consume a large amount of database space. This client in question is using this global. I would like to determine of the 1.7T size of the database, how much is being consumed with statistics data by the usage of the ^STMONITS global. Is there a method to get this value whether a size or percentage of the database overall size.

ERROR #6279: XML output string length is greater than the maximum string length.

This is Error I am getting while trying to get data from an obj and write into the test file.

Any Suggestions Please..

Hello,

I have been tinkering with FHIR recently and tried to update the FHIR servers Capability Statement after I made some changes. I updated an OAuth2.Issuer Service Registry entrys URL and needed to update the metadata which the FHIR server sends to the client so they can get the updated URL for the authorization server we use.

However, when I run the Console Setup tool with

do ##class(HS.FHIRServer.ConsoleSetup).Setup()

I get an error while the update is happening that %ZHS.HC.OAuth2.Utils class cannot be found. I wonder why this happens.

I'm trying to send an HTTP POST request with form-data from an Angular app to a Cache backend, but my request fails with a 406 Not Acceptable error.

httpRequestHeaders = new HttpHeaders({
  Authorization: 'Bearer ' + sessionStorage.getItem('access_token'),
  Accept: ''
}); 

uploadFile(file: File) {
  const formData: FormData = new FormData();
  formData.append("file", file);
  const req = new HttpRequest("POST", this.postURL, formData, {
    reportProgress: true,
    responseType: "json",
    headers: this.httpRequestHeaders,
  });
  return this.http.

I have a PDF ZEN report module that I'm using XslFoXslt to highlight the table cell.

What I need is for a particular value to add a background image to the <item> that is calling the XSLFoXslt

The code I have is the following but all that happens is the color. 

XData XslFoXslt
{
<xsl:template name="HighLight">
<xsl:param name="Value"/>

<xsl:if test="$Value = 400">
<xsl:attribute name='background-image'>url("images/trash-icon.png")</xsl:attribute>
<xsl:attribute name='background-repeat'>no-repeat</xsl:attribute>
<xsl:attribute name='color'>#ffffff</xsl:attribute></xsl:if>

</xsl:template>
}