InterSystems Open Exchange Applications January 2022 Digest

docker handling improved, the tables are created and loaded into the docker image

v1.0.2

The %Java Server enconding arg is now configured via irisi.script, so now after docker-compose build the Openflights Dataset is ready to use

v1.0.3

• data cleansing
• more FKs added
• TUNE TABLE integrated

v1.0.4

• complete db model doc added
• improve some details

v1.0.5

• start the docker image right from hub.docker.com
• details about the demo project added

Clean up and better documented template

v1.2.0

Github Action to push the docker image GitHub registry added

• the new version of Embedded Python required some adjustment
• as WebSocket.org is closed down and dead an alternate echo server is required.
• with all firewalls and other limitations, a local docker server was added.
• It works on port 8080 inside Docker and port 10000 on localhost.

Updated dataset and license

Fix conventions required from contest and new datasets

v1.2.0

New dataset "pollution deaths", fix dataset licenses and zpm install

v1.2.1

fix zpm load data

v1.2.2

fixed zpm install references

Added example of data usage ApacheLog-Dataset

v1.1.0

Fix

v1.1.1

Connected to zpm package dataset-apachelog

11 more datasets added Web Application is added View and Export functionality is added

v1.0.3

Zpm Issue resolved

v1.0.4

Use of %SQL_Diag.Result and %SQL_Diag.Message tables with LOAD DATA Added

v1.0.5

ZPM version modified

v1.0.6

Fixed ZPM package

v1.0.7

Web App enhancements Online Demo Fixed ZPM

• Community Article
• Kaggle API
• Fixes for Socrata
• EAP for Graphic User Interface - Socrata
• Published in ZPM
• New links in VSCode Settings file
• README updated

v1.0.1

download/installation of big datasets fixed

v1.0.2

Search and install any dataset from Socrata using our Graphical User Interface!

v1.0.3

• GUI for Kaggle released!
  • Search
  • Download
  • Install
• Youtube video demo

• added ability to override default widgets with custom addons, using overrideBaseType parameter defined in AddonInfo static variable eg.:

// Ecample for overriding default "Bar Chart" widget with custom addon
static AddonInfo: IAddonInfo = {
    version: 1,     
    type: 'custom',
    overrideBaseType: 'barchart'
};

fixed ChartPanel

v1.1.16

fixed chart in LTE

Fix an issue with the method SignAllRequest (host filter does not work).

Redirect to FileCharacter : Fix an issue with existing files. A call MoveToEnd() has been added to avoid a content erase. commit cbc51a96ceea867b502ddf2a152afb3e089e1c3c

1. Thanks to PR from Dmitry Zasypkin two "SqlProc" methods to User.SQLvar added:

* GetFHIRPath() * GetFHIRPathOne(). 2. iris.script is modified to align with the current version of InterSystems IRIS for Health. 3. the image is modified to the latest

LOAD DATA support header and load data parameters introduced

v1.3.1

DATETIME support SQL reserved words support - if the reserved word is found in the header it adds "Field" string to it. e.g. if the col named DATE which is a reserved word, so it makes the field with the name DATEField

v1.4.0

removed ssl-client dependency. changed to one-liner from Guillaume Rongier

v1.4.1

SQLtoCSV method is implemented. allows export to CSV file as a result of an arbitrary SQL query. Credits goes to Eduard Lebedyuk

• Add Security.System class support .
• Fix a missing class parameterSYSCLASS in Security.Services
• upgrade the io-redirect dependency to version 1.0.2