Hey Community,

We greatly appreciate all your feedback on the InterSystems Datasets programming contest! Please take a few questions to help us improve our contests.

👉 Quick survey: InterSystems Datasets Contest Survey

For some years I missed being able to offer, to everybody interested in ObjectScript, a tutorial more or less complete, to start with ObjectScript. Something that could help more and make things easier to those new developers that come to our technology... something intermediate, halfway between the common "Hello World!", that doesn't really get you further, and the "Advanced Training", that is unaffordable because of lack of time,etc.

If there were something truly helpful not only as an introduction to the ecosystem, but as a starting point, as a boost, to really start to walk into ObjectScript and move forward by yourself... wouldn't that be awesome?

Does anyone know of a relatively quick and straightforward way of converting code written in the old dot scoping syntax with argumentless do (see here for reference: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_cdo_legacy) to the modern parentheses scoping syntax? It's not too bad to do it by hand, but it's also easy to make a mistake and leave a "quit" in an if statement by accident for example.

E.g.

do:someCondition

.set value = do ##class(ExampleClass).ExampleFunctionThatReturnsValue()  quit:'value

.do ##class(ExampleClass).ExampleOtherFunction()

Should

Hi !

 I am new to the language and I am trying to read some json data from a government site (it is public data).

The address is: https://apisidra.ibge.gov.br/values/t/1736/n1/all/v/all/p/all/d/v44%202…

Here is some data sample:

[{"NC":"Nível Territorial (Código)","NN":"Nível Territorial","MC":"Unidade de Medida (Código)","MN":"Unidade de Medida","V":"Valor","D1C":"Brasil (Código)","D1N":"Brasil","D2C":"Variável (Código)","D2N":"Variável","D3C":"Mês

I am trying to emulate a behavior we used to have on an older Cache' system, namely the ability to call "csession cache" from inside of .bash_profile.

On the older system, passwordless users were allowed, now password is required.

The desired behavior is to have user log into linux and go directly into our cache application, which is character-based.

I have tried this technique, without success:

csession cache < myfile.txt.  where myfile.txt contains two lines, username on first line, password on second line.

(user is define to have a startup namespace and routine)

This technique appears to add

Application to import 12 Datasets along with 43 tables dynamically by using  LOAD DATA command which loads data from a source into an IRIS SQL table. 
List of Datasets

Hi contestants!

We've introduced a set of bonuses for the projects for the Datasets Contest!

Here are the projects that scored it:

Hi! For the Opendataset contest I've build a docker container app stack that use InterSystems IRIS & Openflights Dataset in a container and second container with Apache Zeppelin. You can found details here: https://github.com/andreas5588/openflights_demo

With that you can query the Opendflights Dataset from Apache Zepplin with zero configuration. The containers are on hub.docker so you can use it very easily.

If we look at the Docker Dashboard, we’ll see that there is a group named openflights_demo:

Apache Zeppelin is available via

http://localhost:8080

As you see on the screenshot the database

I participate in InterSystems Datasets Contest. I created dataset-finance and analyze-dataset-finance apps along with Online Demo.

The username is _SYSTEM and password is SYS. I created an online demo with a pretty dashboard here:

 https://finance.demo.community.intersystems.com/dsw/index.html#/login?from=%2FUSER%2FGenerated%2FSamples%20for%20finance.dashboard

 I wanted to create my own pivot table and went to regular management portal:

 https://finance.demo.community.intersystems.com/csp/sys/UtilHome.csp

 We can access Analyzer in USER namespace directly: 

https://finance.demo.community.intersystem

For the demonstration, a exchange-rate-cbrf-ui project was made and deployed an online demonstration in the cloud.

For authorization, you can use the account superuser with password SYS

For this project, I used the AdminLTE template, which I have already used in my projects more than once, for example info-chest or access-matrix.

On the main page, you can get a table of exchange rates...

... or download data from the official website of the Central Bank of the Russian Federation.

Two more pages have been created for demonstration purposes.

They show graphs of fluctuations in the exchange rate

Hello,

Does anyone have experience sending files using %Net.FtpSession?   I am not seeing any methods in the class for sending files and setting up an Ensemble production is not an option.   Any advice would be appreciated.  Thank you.

Hi everyone,

I want to talk about our project and use the dataset theme for this contest.

Our intention never was to be a data curator, especially because sometimes my precious data means a lot for me, but not for the rest of the world.

We want to go a step further and empower the user to find the perfect dataset for their needs.

Our project is a bridge between the data science community and the developer's community using InterSystems IRIS to achieve this mission.

Hey Developers,

Let the voting week begin! It's time to cast your votes for the best applications in the Datasets Contest!

🔥 You decide: VOTE HERE 🔥

How to vote? Details below.

Hi Developers!

Here're the technology bonuses for the InterSystems IRIS Datasets Contest 2021 that will give you extra points in the voting:

• Dataset Usage Demo Repository - 4
• LOAD DATA Usage - 3
• Questionnaire  - 2
• Unique Real Dataset - 4
• Docker container usage - 2 
• ZPM Package deployment - 3
• Online Demo - 2
• Code Quality pass - 1
• First Article on Developer Community - 2
• Second Article On DC - 1
• Video on YouTube - 3

See the details below.

Previously I had published The Article about the dataset from a real webserver, which can demonstrate how can activity and load of the Apache webserver depends on day of week, search engines indexing and some network noise.

Now I want to describe one useful function for most of webmasters and system administrators who are interested in obtaining of exactly information about visitors, hardware usage, and also about errors that gaing to their clients.

Here it is

My project also contains a graphical UI that allows you to upload logfiles from your own webserver, load data to the IRIS and watch whats

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 

According to the WHO, The top global causes of death, in order of total number of lives lost, are associated with three broad topics (source: https://www.who.int/news-room/fact-sheets/detail/the-top-10-causes-of-death):

1. Cardiovascular (ischaemic heart disease, stroke),
2. Respiratory (chronic obstructive pulmonary disease, lower respiratory infections) and
3. Neonatal conditions – which include birth asphyxia and birth trauma, neonatal sepsis and infections, and preterm birth complications.

I created an application that's provides real data (without personal data) for some of these top 10

I'd like to share an example on how the new Embedded Python feature in IRIS helped me in my daily routines.

While I’m participating in the iris-kaggle-socrata-generator project with Henrique Dias, I got to unzip datasets from Kaggle in order to import them.

Such a task was easily achieved by using the zipfile lib in Python (this code was copied from this stackoverflow):

Method UnZip(pZipFileName As %String, pExtractToDir As %String) As %DynamicArray [ Language = python ]
{
    import zipfile
    import iris
    with zipfile.ZipFile(pZipFileName, 'r') as zip_ref:

We have now released a new learning path to get you started with FHIR: Building Basic FHIR Integrations with InterSystems IRIS for Health. In this path, you'll learn the basics of FHIR, how to set up FHIR endpoints in InterSystems IRIS for Health, consume data into the FHIR repository and transform FHIR data, manage FHIR APIs with InterSystems API Manager, and query for FHIR resources using a client application. This path includes recommendations for starting such as using SDA-FHIR transformations to transform other formats of data to FHIR.

We're also looking at possibly creating additional

I am looking for experience of people running Veeam with Caché databases. 

Tips/Tricks/General questions like; what Veeam features are you using, what your backup cycle looks like, where does your data end up, what recovery/integrity checks you do, what sort of compression/dedupe you get. 

Also what questions _you_ have and what problems you might be trying to solve.

I'm happy to share with the community a web server log dataset from our longtime customer, an operating company.

Their webserver operates on Apache webserver and contains data which can be useful to analyse a load and search engines activity.

After installing the project, you will get the data for a few months that can show a typical load and activity of clients, robots and also you can see how it depends on day of week, holidays and time of a day.

The Cube is also included in package.

So you can use my previous project (Promjet-Stats) and see dataset in dashboards.

To make that you shoud install

I'm seeing trace messages being logged in a Router Business Process Routing Rule when the Business Process Log Trace Events setting is off.

In what circumstances is that setting ignored or not seen when logging trace messages?

A full cycle project, from initial data initialization, daily update products from the official website, a service for sending a course on request and receiving a schedule for any period.

After installing the project, we will get a table of ruble exchange rates against the main currencies of the world established by the Central Bank of the Russian Federation for 2016-2021. Launching the product service with default settings will allow you to receive daily new exchange rates for the current day. If necessary, you can load the missing data with the product service by changing the parameter CountD

II try to explore the new SQL LOAD DATA  feature in SQL comparing it to SQL INSERT

I'm stuck at this point:  INSERT INTO <table> (columns...) VALUES  (.....)
allows having not just simple column references but also ALL Standard SQL FUNCTIONS (at least)
example:  

INSERT INTO Test (ShortName,DOB)VALUES  (SUBSTRING(Name,1,4),TO_DATE(displayDate,'MM-DD_YYY')) 

This works perfectly. 
BUT the same VALUE clause applied to LOAD DATA  fails in various ways:

LOAD DATA FROM FILE '/irisrun/repo/LoadSQL.txt'
INTO Test (ShortName)  VALUES (SUBSTRING(Name,3,4))
USING {"from":{"file":{"header":"1"}}}

Refused

Hi community,

Prediction is a critical to the Maternal healthcare. The Health Dataset Application (https://openexchange.intersystems.com/package/Health-Dataset) has 10 real health datasets to predict the most important diseases and health problems, including Maternal Risk.

This article detail the steps to predict Maternal Risk using the InterSystems IRIS IntegratedML. This is a technology of InterSystems to do predictions using SQL Commnands! Great!

Follow these steps:

1. Clone/git pull the repo into any local directory

$ git clone https://github.com/yurimarx/predict-maternal-risk.git

2. Open

Hi Developers, 

It's time to announce the Winners for December 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in December 2021:

🥇 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabi

🥈 @Sergey Mikhailenko, Chief Specialist, AO Mosvodokanal, Russia

🥉  @YURI MARX GOMES,  Software Architect, YM Services, Brazil

Learn more about the competition and our awesome winners below.

Hello. I'm having problems migrating a java application that is running with cache 2018 to Iris
The application uses json generated by the cache to receive it as a string in java.

Basically an instance of the "%ZEN.proxyObject" class
On Iris I've been trying to convert this '%ZEN.proxyObject Object to an instance of the %GlobalBinaryStream class and I need to get it via reference.
But I haven't had success yet. I Just found example with primitive dataTypes via reference and I need a Streams.
Has anyone done something like that?
This is my cache class example:

ClassMethod Login(ByRef streamReturn As %

Hi All! For those of you who attended experience labs at the 2021 Virtual Summit, you may recall that one of the lab sessions was around Kubernetes. We've now converted that lab to be fully on-demand. You can launch a small cluster of VMs and follow the exercise to manage your Kubernetes cluster, deploy InterSystems IRIS containers to it, and watch its self-healing nature when destroying a pod.

It's a great introduction to Kubernetes if you are interested! See here: Achieving High Availability with InterSystems IRIS and Kubernetes

Hello everyone,

I want to see all properties from a %Net.HttpRequest, I tried to use:

zw objHttpRequest

It's show all the properties, but I want something more easy to analyse like a curl command, is it possible?

Thanks.