#InterSystems IRIS

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.

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'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:
        zip_ref.

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.

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.

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

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.

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?

Hi Everyone,

Has anyone tried to write down a function in a routine that list all of possible function inside the routine? I can only think of iterating through the routine line one by one and differentiate between function and function definition. Is there any existing function that can be utilised? I think it should work similar to how

do function^routineName 

works. I could not find the source for how "do" works, but I believe do will look at the list of function in the routine, and if it finds it, it will call the function, but if it does not find it, it will give an error?

If you develop in IRIS you are confronted with two major phenomena:

• an incredibly fast and excellent designed data storage engine
• a scripting language to work on this storage engine, actually named ObjectScript 

Hello community,

I'm trying to validate a HS.FHIRServer.Interop.Request received from an HS.FHIRServer.Interop.Service, which looks more or less like this example

It is quite intuitive to gain access to basic properties like

$$$TRACE("Request Method: " _ pRequest.Request.RequestMethod)

But when I try to get access to the AdditionalInfoItems (especially the 'ClientAddr' element) simplicity is over.

As $$$TRACE("Request contains " _ pRequest.Request.AdditionalInfo.Count() _ " Info items.") results in printout of a correct number of elements, a for loop

for tCount=1:1:pRequest.Request.

Hi, everyone!

I want to share a personal project that started with a simple request at work: 

Is it's possible to know how many Caché licenses we are using? 

Reading other articles here in the community, I found this excellent article by  David Loveluck 

APM - Using the Caché History Monitor
https://community.intersystems.com/post/apm-using-cach%C3%A9-history-monitor

So, using David's article, I started using Caché History Monitor and to show all that information. 

When facing the question: Which cool tech should I use?

I have csv date file with date values like this "4/10/2021" for April 10, 2021. I defined a table with this property: Property TranDate As %Library.Date.

I capture error

[SQLCODE: <-104>:<Field validation failed in INSERT, or value failed to convert in DisplayToLogical or OdbcToLogical>] [Location: <ServerLoop>] [%msg: <Field 'dc_data_finance.transact.TranDate' (value '4/10/2021') failed validation Field ...

I do not really want to change TranDate to %String. How can I import "4/10/2021" into %Date property?

Hi folks!

Sometimes we need the docker image of the InterSystems IRIS solution we build to be published on some docker registry. The cases could be:

1. Deploy it then in Kubernetes cluster
2. Let your pal run the image of your public repo without building it locally.

You can push the image to Docker Hub Registry or Github Registry.

In this very short article, I provide a way how to do it automatically on every push to your GitHub repository.

Hi Community,

In a hard work of data curation and data quality, the Health Dataset application deploy to you the above datasets.

These datasets can be used in your ML applications/models, AutoML and analytics projects. See more details here:

Installation

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

$ git clone https://github.com/yurimarx/automl-heart.

Hello developers, I'm a newbie to Intersystems technologies and I started to work with Caché and Ensemble, and to be more specific I'm working with systems integration. In a scenario where I need to develop new software from scratch, would it be better to develop this new software using REST APIs? Does anyone have any recommendations about courses?

I read under Topics and Rules of InterSystems Datasets Contest:

• Class naming convention. Start the class names with: dc.data.your_name.class. E.g. if there is a dataset on trading data the class names could be: dc.data.finance.transaction, dc.data.finance.instrument.

I created a class “dc.data.finance.transaction”. I expected that it would not compile, because I remembered “Date” was a reserved word in SQL, and one of its properties was named “Date.”  To my surprise, the class compiled successfully. When I tried to execute query “select * from dc_data_finance.

I have a csv file with 13 columns.

The header row is:

"Date","Check","Merchant","Category","SubCategory","Memo","Credit","Debit","Bill Pay","Debit Card","Account","Balance","Status"

The first data row is:

"","","","","","","","","","","Cash","56",""

I have created a SQL table to LOAD DATA into. When I ran

LOAD DATA FROM FILE '/irisrun/repo/data/finance-transactions-08-Jan-2022_08-25.csv' into dc_data_finance.transact

I got Cash into “Account” property (correct) and I saw 56 in “Status” property. I want to skip the “Balance” column.

Hey Developers,

With the release of InterSystems IRIS 2021.2 Preview and all-new LOAD DATA functionality, we'd like to put it to the test with the new DATASETS contest! 

🏆 InterSystems Datasets Contest 🏆

Duration: December 27 - January 16, 2022

In prizes: $9,450

I use Microsoft Query via Excel to query an Intersystems database. 

Since upgrading from CACHE to Intersystems, lots of reports fail to refresh twice - by which I mean I can open the report (which may have several separate queries) and query the database once, and then it will refuse to reconnect.

I get:
[IRIS ODBC][State : S1000][Native Code 417] .... Access denied

If I then close and reopen excel, I can run the query again.

If I test the odbc connection between refresh attempts, the connection is

Is there some generic way to output a %SQL.StatementResult to CSV?

Preview releases are now available for the 2021.2 version of InterSystems IRIS, IRIS for Health, and HealthShare Health Connect.

As this is a preview release, we are eager to learn from your experiences with this new release ahead of its General Availability release next month. Please share your feedback through the Developer Community so we can build a better product together.

InterSystems IRIS Data Platform 2021.2 makes it even easier to develop, deploy and manage augmented applications and business processes that bridge data and application silos.

Hello Everyone,

In October 2021 we asked for input from the IRIS community regarding exam topics for our InterSystems IRIS System Administration exam. We will close the window for providing feedback on the exam topics on Wednesday, January 12, 2022. Thus, if you would like to have your say in what topics are covered on the exam, this is your last chance!

Extra perk for US-based, non-InterSystems employees: To show our appreciation for helping us validate our exam design, we will offer the first 20 volunteers that complete the survey a $50 gift card.

Hi Developers

As you know it's very easy to publish a package to the Developers Community registry. 

But how to test it before publishing?  How to be sure that everything you introduced into module.xml is installed properly?

See the step-by-step instruction below!

For those of you who might be new to IRIS, and even those who have used Cache or IRIS for some time but want to explore beyond its usually-assumed boundaries and practices, you might want to dive into this detailed exploration of the database engine that is at its heart, and discover just what you can really do with it, going way beyond what InterSystems have done with it for you. 

You'll discover that it's actually a hugely powerful yet incredibly simple storage engine that allows you to model any kind of database you wish, once you understand and master its simple, basic principles.