Hi Developers!

Sometimes we need to import CSV data programmatically to InterSystems IRIS either from CSV or from URL. And we expect the class with proper datatypes to be created and the data to be imported.

I published a module csvgen on Open Exchange which does exactly that.

If you just need the CSV file be imported into IRIS you can do the following:

USER>do ##class(community.csvgen).Generate("/usr/data/titanic.csv",,"Data.Titanic")

Class name: Data.Titanic
Header: PassengerId INTEGER,Survived INTEGER,Pclass INTEGER,Name VARCHAR(250),Sex VARCHAR(250),Age INTEGER,SibSp INTEGER,Parch INTEGER,Ticket VARCHAR(250),Fare MONEY,Cabin VARCHAR(250),Embarked VARCHAR(250)
Records imported: 891
USER>

Or if you have the CSV on the internet, e.g. COVID-19 Data on Github you can get the data in the following way:

USER>d ##class(community.csvgen).GenerateFromURL("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/05-29-2020.csv",",","Data.Covid19")

Class name: Data.Covid19
Header: FIPS INTEGER,Admin2 VARCHAR(250),Province_State VARCHAR(250),Country_Region VARCHAR(250),Last_Update DATE,Lat MONEY,Long_ DOUBLE,Confirmed INTEGER,Deaths INTEGER,Recovered INTEGER,Active INTEGER,Combined_Key VARCHAR(250),Incidence_Rate DOUBLE,Case-Fatality_Ratio DOUBLE
Records imported: 3522
USER>

7 16
1 1.4K

Hi ObjectScript developers!

How to Protect Your Belongings from Pests While Moving - Delicate ...

InterSystems ObjectScript is perhaps the best language on the planet to deal with globals - and it is an interpretable language.

Yes, it has a compiler. But even the compiler can compile some lines in ObjectScript which will then fire as bugs during the runtime.

There are some technics on how to avoid that such as unit testing, coding guidelines and your coding experience, of course ;)

Here I want to present to you the yet another approach to how you can reduce the number of errors in your ObjectScript runtime and enforce coding guidelines - it's an ObjectScript Quality tool developed by Lite Solutions, InterSystems solution partner.

See the details below.

4 0
0 470
Article
· May 7, 2020 4m read
Unit Testing with ZPM

Hi Developers!

I want to share with you the approach you can use working with Unit Testing which I personally find very convenient and robust.

Will not talk much here about Unit Testing, we have documentation, enough good articles on the topic not only on the Internet but here on Developers Community too, e.g. this one.

How can you manage the Unit Testing of your ZPM module?

This is pretty handy with ZPM. It has a special command "test" which runs all the tests you mentioned in the module. You can execute it as shown below:

zpm:USER>module-name test

And this command runs all the tests you mentioned in module.xml.

Let's see how it works.

6 5
3 721

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in April 2020!

19 New applications in April 2020

FHIR Server and API Manager for MIT COVID-19 Challenge by Steven LeBlanc

This demo shows how InterSystems API Manager (IAM) can be used to view and test FHIR resources with InterSystems IRIS for Health. It comes pre-configured with a FHIR server, pre-populated with synthetic patient data. The new InterSystems API Manager (IAM) includes OpenAPI Swagger specs to quickly generate REST client code to work with many common FHIR resources.

Production Manager by Nikolay Soloviev

REST API to manage IRIS Interoperability Productions.

rest-api-contest-template by Evgeny Shvarov

Template repository for InterSystems IIRS REST API Programming Contest

JSON-Filter by Lorenzo Scalese

ObjectScript server-side JSON filter.

objectscript-openapi-definition by Guillaume Rongier

The objectif of this library is to generate the ObjectScript Class from an OpenApi definition.

FHIR-HL7v2-SQL-Demo by Guillaume Rongier

Ready to use a demo of an FHIR Server and HL7v2 transformation to the FHIR Server on IRIS For Health Intersystems The FHIR repo can be a query in SQL.

CloudWatch-IRIS by Anton Umnikov

Configuring AWS CloudWatch with InterSystems IRIS

2 0
0 149

Hi Developers!

Today we launched the second programming contest on InterSystems IRIS, the landing.

The topic is the REST API.

And we introduced a few technology bonuses.

Here I want to provide details on what application eligible, what are the technology bonuses and how to collect all of them.

Here we go!

0 7
0 523

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in March 2020!

22 New applications in March 2020

isc-generate-db by Henrique Gonçalves Dias

Creating a new database, namespace, CSP/REST Application never been so easy.

cmPurgeBackup by @Alexey Maslov

cmPurgeBackup is an utility that can be used to erase old Online Backup files.

3 1
0 220

Hi Developers!

We are going to establish a series of InterSystems IRIS Online Programming contests this year.

In March we started with ObjectScript CLI and here is the schedule of topics for the next few months:

  • April - InterSystems IRIS with REST API
  • May - InterSystems IRIS Native API application: use Python, JS, .NET, Java native APIs in your application to use IRIS
  • June-July - InterSystems IRIS AI/ML solutions. IntegratedML as a bonus
  • August - InterSystems IRIS for Health FHIR application
  • September - InterSystems IRIS Full-stack application: IRIS as a server and UI on any framework and any form: and web, desktop, mobile UI
  • October - Interoperability solutions for InterSystems IRIS and InterSystems IRIS for Health
  • November - Analytics Solution using InterSystems IRIS
  • December - Multi-model solution using InterSystems IRIS

All applications should be runnable with InterSystems IRIS in a docker container.

8 11
1 931