Article Evgeny Shvarov · Jun 16, 2020 3m read

InterSystems Package Manager ZPM 0.2.3 release: test server, new commands, boilerplate generation and many more

Hi, folks!

We released a new version of ZPM, with one revolutionary feature, and a set of great enhancements, amongst of which, are:

  • module.xml boilerplate generator
  • test server
  • CLI commands order change,
  • and more!

See the details below

1. Official test server

To check if your package is published in the registry and then installed from it, use the test registry: https://test.pm.community.intersystems.com/registry/ login: test password: PassWord42

To switch to the test registry use the command

repo -r -n registry -url https://test.pm.community.intersystems.com/registry/ -user test -pass PassWord42

#Open Exchange #InterSystems Package Manager (IPM) #Release
Open Exchange
1
1 448
Question Vivek Nayak · Apr 20, 2020

How to create pdf file from html

<html>
    <head>
        <title>LabCorp</title>
        <link rel="apple-touch-icon" sizes="60x60" href="app-assets/img/ico/apple-icon-60.png">
        <link rel="apple-touch-icon" sizes="76x76" href="app-assets/img/ico/apple-icon-76.png">
        <link rel="apple-touch-icon" sizes="120x120" href="app-assets/img/ico/apple-icon-120.png">
        <link rel="apple-touch-icon" sizes="152x152" href="app-assets/img/ico/apple-icon-152.png">
        <link rel="shortcut icon" type="image/x-icon" href="app-assets/img/ico/favicon.

#InterSystems IRIS
8
1 2059
Question Dmitry Maslennikov · Jun 8, 2020

SQL Cached queries

Since IRIS 2020.1, changed the way how embedded SQL compiled. Now it compiles upon the first execution of such queries.

Is there any way, I could switch that feature back to the previous behavior, or get some more control over it?

We deliver our software as deployed, and we would like to have it well prepared. Another solution would suit us, if we could change the generated classname of the cached query to something which we would be possible to map. At the moment it generates classes %sqlcq.NAMESPACE, but our customers may use different namespaces.

#InterSystems IRIS #Deployment #SQL #System Administration
16
0 994
Question Cristiano Silva · Jun 9, 2020

Consuming a REST Sevice with Digest Authenctication

Hi guys,

I'm trying to consume a REST Service that use Digest authentication, I'm trying to implement the authentication but I'm don't know where is my mistake.

Someone have already used this type of authentication.

Below the code I wrote to try to generate the response hash:

 // Algorithm reference: https://en.wikipedia.org/wiki/Digest_access_authentication
 //
 // Test data:
 // Do TestDigest^HC.Debug("posstman", "password", "/digest-auth", "postman-echo.com", 80)
 // Do TestDigest^HC.Debug("usr", "pwd", "/digest-auth/auth/usuario/senha/MD5", "httpbin.
#Caché #Ensemble #InterSystems IRIS #Authentication #REST API
2
2 781
Question Henrique Dias · Jun 10, 2020

View Application Error Log

Hi Community, 

Is it possible to track Application Errors from a specific namespace? 

With the new API, I know we have the endpoint /alerts. 

But the endpoint /alerts, as described in the documentation: 

The /alerts endpoint fetches the most recent alerts from the alerts.log file and returns them in JSON format.

I want to create push notifications for Application errors in specifics Namespaces, and I don't know how to extract that information from there.

System  > System Logs  > View Application Error Log
Thanks,
Henrique

#Caché #InterSystems IRIS
3
0 574
Announcement Anastasia Dyubaylo · Jun 9, 2020

Online Meetup with the Winners of the 3rd IRIS Programming Contest

Hi Community!

We're pleased to invite you to the Online Meetup with the Winners of the InterSystems IRIS Native API Programming Contest!

Date & Time: Friday, June 12, 2020 – 11:00 EDT

What awaits you at this virtual Meetup? 

  • Our winners' bios.
  • Short demos on their applications.
  • A short interview with all the winners about the past contest. Plans for the next contests.

#InterSystems IRIS #Contest #Events #Meetup
2
0 810
Discussion Eduard Lebedyuk · Jun 7, 2018

Do you use Application Licensing API? How?

Application licensing enables InterSystems application partners to take advantage of Caché’s licensing capabilities for their own licensing purposes.

Caché manages customer application licenses just as it does Caché/Ensemble and InterSystems application licenses, maintaining usage counts and acquiring and returning user licenses as needed.

Application licenses consumed by a process or a CSP session are automatically released along with the Caché license consumed by the process or session when a process exits, halts or is deleted from the process table, or when a CSP session times out or is deleted.

More in docs.

Do you use this feature? If so, how?

I'm especially interested in license validation and general workflows?

#Caché #System Administration
4
0 503
Question Yone Moreno · Jun 15, 2020

How could we iterate over an ORU, to get all OBXs?

Hello,

We would need to iterate all over the OBXs list and get their OBX3 CE1 to determine if it is the lab result we need to send to the output system.

We wonder how could we achieve this in a foreach component inside a Bussiness Process.

We think we would need to use a foreach because of it is needed to generate a message, for each one of the OBX which have the OBX3 CE1 that the output systems uses for the lab results.

#Caché #Ensemble #Code Snippet
1
0 712
Question Arun Kumar · Oct 15, 2018

How to validate the CSP sessionId in another zen pages/restful api's

Hi All,

Actually, I'm developing few restful API's. I want to create a authentication tokens and display it on my login restful API. If I'm using CSP sessionId, how can I validate the session Id's in another or continues restful API's. else, is there any other approach to handle this task. 

My Primary goal is, I have to integrate 2 different front end applications. One is Zen framework another one is web pages from Python. 

If any lead, it would be appreciated. 

Thanks,

Arun Kumar Durairaj. 

#Caché #API #Authentication #Access control #Frontend #REST API #Security #ZEN
1
0 610
Question Gunwant Kapade · Apr 9, 2019

LDAP lookup via product group value

Hi, I am facing issue during LDAP lookup like whenever I used product group parameter in AD explorer to search data from application I am getting empty result. If I set product group parameter as null then based on distinguished name result is generated in application. So if anyone knows about how LDAP works and how parameters are set in AD explorer then please let me know.

Thanks in advance.

#Caché #Ensemble #HealthShare #LDAP
1
0 366
Article Yuri Marx · Jun 13, 2020 1m read

How to configure non repository maven files (like intersystems-jdbc-3.1.0.jar)

Some InterSystems Java libraries are not available in public maven repositories, like intersystems-jdbc-3.1.0.jar. In this case, to configure your Java Maven dependency, copy the external file to your project (for a folder visible to the classpath, like resources) and use <systemPath>. Follow the sample:

<dependency>
            <groupId>com.intersystems</groupId>
            <artifactId>intersystems-jdbc</artifactId>
            <version>3.1.0</version>
            <scope>system</scope>
            <systemPath>${project.basedir}/src/main/resources/intersystems-jdbc-3.1.0.jar</systemPath>
#InterSystems IRIS #Java
0
4 802
Question Ting Wang · Jun 12, 2020

Mass Export DTL

Hi Everyone,

We are trying to migrate old server to new infrastructure and need to sync all the DTL cls from old one to new one. There are hundreds of DTL in system and we tried to export from production but cannot select all at once which might cause some missing classes. Not able to connect to studio or atelier with that server neither. Is there any way that we are able to do mass export from system which will save some effort? Please let me know your thoughts. Thanks.

#HealthShare #DTL #ObjectScript
3
0 296
Article Zhong Li · Jun 12, 2020 8m read

Python ODBC connection into IRIS database - 2nd quick note

Keywords:  PyODBC, unixODBC, IRIS, IntegratedML, Jupyter Notebook, Python 3

Purpose

A few months ago I touched on a brief note on "Python JDBC connection into IRIS", and since then I referred to it more frequently than my own scratchpad hidden deep in my PC. Hence, here comes up another 5-minute note on how to make "Python ODBC connection into IRIS".

ODBC and PyODBC seem pretty easy to set up in a Windows client, yet every time I stumbled a bit somewhere on setting up an unixODBC and PyODBC client in a Linux/Unix-style server.

#InterSystems IRIS #Artificial Intelligence (AI) #Analytics #Machine Learning (ML)
0
1 2237
Question Token Ibragimov · Jun 11, 2020

SFTP connect

Hello,

I'm trying to upload file to SFTP server.  

I have access to SFTP server . 
My code is bellow 

Try {
Set sftp = ##class(%Net.SSH.Session).%New()

Set sc = sftp.AuthenticateWithUsername(username,password)
if 'sftp.Connect(host){
            Set status = $$$ERROR($$$GeneralError,"Cannot connect to sftp  ")
            Quit       
}
Set sc = sftp.OpenSFTP(.t)

If 'sftp.Disconnect() Write "Failed to logout",!

} Catch ex {
Set status=$$$ERROR($$$GeneralError,$ZE)
Quit
}

The output : $lb(5001,"Cannot connect to sftp "

What i'm doing wrong ?

#Caché #FTP
10
1 2056
Question Oliver Wilms · Jun 11, 2020

Inbound File Adapter - Check Complete - File Locks

Hello,

I want to deploy Iris Interoperability Production in multiple containers . The production has File Services that process files from EFS location. All the files being processed by multiple containers are in the same directory. The standard Adapter class does not have Check Complete option to lock a file so that other containers File Services looking in the same file path cannot process the same file.

I updated the Inbound File Adapter class to offer another Check Complete option LOCK that will lock the file until it is processed and archived.

#Other #Business Service #Interoperability
2
0 348
Article Evgeny Shvarov · Jun 12, 2020 3m read

Game Of Throne Analytics or How long is Arya's Stark List

Hi Devs!

Last weekend I had been testing the newborn csvgen module and was looking for a CSV file to test - thus I came across an interesting datafile on Data.World  with Game of Throne episodes statistics. Death statistics. These folks documented all the murders through all the 8 seasons and noted where, who, from what clan with what weapon had killed another one.

So I imported it and made an IRIS Analytics dashboard.

You Know Nothing, Jon Snow | You Know Nothing, Jon Snow | Know ...

Don't worry, Jon,  with this dashboard we can figure out something ). See the details below.

#InterSystems IRIS #InterSystems IRIS BI (DeepSee) #CSV #Docker #Google Cloud Platform (GCP) #ObjectScript #InterSystems Package Manager (IPM) #VSCode
Open Exchange
0
2 836
Question Viroj (Pat) Padyandorn · Jun 11, 2020

How to set HL7 value inside "code" in the DTL

Hello,

In the DTL, is there a way to set a value for the HL7 data element in the code section?

For example,
set target.SetValueAt("PID:3(k1).1)") = mrn (mrn is the value returned from the SQL query)

When I ran the test utility, I got this error message.

ERROR ErrException:
zTransform+27^testclass.TEST.1 *SetValueAt,EnsLib.HL7.Message -- logged as '-' number - @' set target.SetValueAt("PID:3(k1).1)") = mrn'

I tried both target.SetValueAt("PID:3(k1).1)") and target.GetValueAt("PID:3(k1).1)"). That didn’t make a difference. The code still error out.

#Caché #Ensemble #DTL #SQL
3
0 1274
Announcement Rob Tweed · Jun 11, 2020

Visualising your Global Storage using QEWD Monitor

The latest WebComponent-based, SB Admin 2-themed QEWD Monitor application now includes a cool D3-based viewer for visualising your IRIS or Cache Globals - see example below

This qewd-monitor-adminui application is automatically installed when you install QEWD on a Windows machine

See here for details on installing QEWD on Windows:

https://github.com/robtweed/qewd-microservices-examples/blob/master/WINDOWS-IRIS-2.md#initial-steps
 

#Caché #InterSystems IRIS
1
0 331
Question Jeff Burdette · Nov 20, 2017

Cache ODBC - Access Denied

Hello,

I'm working on integrating a Cache database into an existing .NET project of mine.  I'm trying to execute certain queries utilizing the Cache ODBC driver.  The first error I ran into was "[S1000] [Cache ODBC][State : S1000][Native Code 417] Access Denied".  The part that's throwing me for a loop though is that the application ran ~200 successful queries before I started getting that.  After some of those Access Denied errors, they turned into "[Cache ODBC][State : S1T00][Native Code 450] Request timed out due to user timeout".  This was all with the regular (2.5?) driver.

#Caché #ODBC #System Administration
8
0 10830
Announcement Rob Tweed · Jun 11, 2020

Building an Interactive WebSocket-based CRUD Application, using Node.js and IRIS Natively on Windows

If you're interested in building a browser-based CRUD application for maintaining data on IRIS, check out the detailed, step-by-step tutorial at:

https://github.com/robtweed/qewd-microservices-examples/blob/master/WIN…

To get a preview of the application you'll build in the tutorial, along with background on its technology stack, watch this video:

https://www.youtube.com/watch?

#Caché #InterSystems IRIS #JSON #Microsoft Windows #Node.js
0
0 1309
Announcement Anastasia Dyubaylo · Jun 2, 2020

InterSystems Developer Survey: Your Opinion Matters!

Hey Everyone! 

At InterSystems, the developer community is an integral part of our ecosystem and this role is pivotal in the development of our products and services. As a result, we wanted to undertake market research in recognition of this to discover how best businesses can support developers. We have already asked 300 developers their thoughts, but we wanted to extend this survey to reach more people and also get your views on the current climate as we have all had to adapt our working environments.

➡️ Please click this link to take part in our survey!  

Note: The survey will take less than 5 minutes to complete.

#Developer Community Official
3
0 256
Question Olivier Champion · May 20, 2018

https config error xml.reader

Hi

on this code

set reader=##class(%XML.Reader).%New()
    set statuscode=reader.OpenFile(file)
    if $$$ISERR(statuscode) {do $System.Status.DisplayError(statuscode) quit $$$NULLOREF}

I got this error "unable to open file 'https://www.musicxml.org/dtds/partwise.dtd'"

or using the xml schema wisard i got the error  https is active but no configuration found.

where do I have configure it?

#Caché #ObjectScript
5
0 514