Hi Developers!

I'm pleased to present to you a new feature of Open Exchange - ZPM Package Manager support!

What's about it?

Hi Developers!

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

General stats:

279 applications published, 628 downloads in June, 621 developers joined.

18 New applications in June 2020

See the details below

Hi, folks!

Do you know the option/mode when I can feed multiline code into a terminal?

E.g.

for i=1:1:100 {

/// do one line

///do something else}

Hi developers!

We are starting InterSystems AI Programming Contest next week, and according to the rules, you can include some technology IRIS Features into your solutions, which will give you extra points in the voting.

Here are the technology bonuses for InterSystems AI Programming Contest!

1. IntegratedML usage - 2 expert vote points

IntegratedML is a new technology Introduced in InterSystems IRIS which you can use with InterSystems IRIS 2020.2 Advanced Analytics Preview release. IntegratedML:

• Gives users the ability to create, train, and deploy powerful models from simple SQL syntax without requiring data scientists.
• Wraps "best of breed" open source and proprietary "AutoML" frameworks including DataRobot.
• Focuses on easy deployment to IRIS, so you can easily add machine learning to your applications.

Learn more in IntegratedML Resource Guide.

You can use with IntegratedML template.

2. Python Gateway usage - 1 expert vote point

Python Gateway is an addon to InterSystems IRIS which gives you the way to use Python in InterSystems IRIS environment:

• Execute arbitrary Python code.
• Seamlessly transfer data from InterSystems IRIS into Python.
• Build intelligent Interoperability business processes with Python Interoperability Adapter.
• Save, examine, modify and restore Python context from InterSystems IRIS.

Learn more about Python Gateway.

You can use the Python Gateway template, which includes IntegratedML too.

3. Docker container - 1 expert vote point

The application gets a 'Docker container' bonus if it uses InterSystems IRIS running in a docker container.

Both templates, IntegratedML template and Python Gateway template use docker so you can collect this bonus if you build your solution using these templates.

Or you can use any other Docker-based templates, published on Open Exchange.

Feel free to ask any questions about using the listed technologies.

Good luck in the competition!

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.

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

Hi Developers!
Want to share with you what we did in May 2020 to improve InterSystems Developers Community. Here are the new features:

• New, better design for DC notification letters.
• Editor in markdown: images import with hosting, decoration, etc.
• Unanswered questions management improvements.

Here we go!

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>

I have the variable with literal.

Can I understand with ObjectScript that the literal is:

%String,

or %Integer,

or %Date,

or %Double,

or %Numeric?

What I'm looking for could be:

set variable="To be or not to be"

USER>w ##class(utils).GetType(variable) 

%String

set variable=42

USER>w ##class(utils).GetType(variable) 

%Integer

Hi!

Is there a method in a persistent class that can return the current number of records/persistent objects in it?