Hi Community,

This post is a introduction of my openexchange iris-python-apps application. Build by using Embedded Python and Python Flask Web Framework. 
Application also demonstrates some of the Python functionalities like Data Science, Data Plotting, Data Visualization and QR Code generation.

image

 

 Features

  •  Responsive bootstrap IRIS Dashboard

  •  View dashboard details along with interoperability events log and messages.

  •  Use of Python plotting from IRIS

  •  Use of Jupyter Notebook

  •  Introduction to Data Science, Data Plotting and Data Visualization.

  •  QR Code generator from python.

Open Exchange app
4 1
0 223

With the release of InterSystems IRIS 2021.2 Preview and all-new LOAD DATA functionality dataset can by added with Objectscript Package Manager (ZPM) 

Medical Datasets contains following 12 datasets. For dataset tables and data details please visit ONLINE DEMO by using SuperUser | SYS 

ID Dataset Name Tables Licence
1 Synthetic Medical Data 11 Public Domain
2 Health Care Analytics - 1 8 Public Domain
3 Global Suicide Data 7 Public Domain
4 COVID-19 Polls1 7 CC-BY
5 Cancer Rates by U.S. State 2 Public Domain
6 Opioid Overdose Deaths 2 Public Domain
7 Heart Disease Prediction 1 Public Domain
8 Yellowpages medical services dataset 1 Public Domain
9 Hospital ratings 1 Public Domain
10 Heart Failure Prediction 1 (CC BY 4.0)
11 Diabetes Dataset 1 Public Domain
12 Chronic Kidney Disease 1 Public Domain

Open Exchange app
2 0
0 76

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

Open Exchange app
3 1
0 115

In this article I will explain how to Authenticate, Authorize and Audit by code by using CSP Web Application along with Enabling /Disabling and Authenticate/Unauthenticate any Web Application.

Application Layout
 

Open Exchange app
7 4
0 470