Hi, I am passing an EDIFACT file from a service to an operation using the super class. I would like to prepopulate the 'Source' variable with some information, but I’m not sure how to access this variable.

Any pointers much appreciated.   

In this GitHub we fine tune a bert model from HuggingFace on review data like Yelp reviews.
The objective of this GitHub is to simulate a simple use case of Machine Learning in IRIS :
We have an IRIS Operation that, on command, can fetch data from the IRIS DataBase to train an existing model in local, then if the new model is better, the user can override the old one with the new one.
That way, every x days, if the DataBase has been extended by the users for example, you can train the model on the new data or on all the data and choose to keep or let go this new model.

I am starting to look at add-ons/enhancements that can be made to our environment as we move from 2018.1.3 to IRIS 2022.1. During one of our internal meetings it was mentioned that it would be helpful to gather and keep track of metrics as we move to IRIS 2022.1. I am looking to at trying to capture Message Count, Database size, global sizes, etc. Through Global Summit, and Open exchange, I know there is SAM, Grafana, and Promethus.

Hi Guys,

I've newly joined a new company and have been asked to get the number of classes in their system and was wondering if Ens, EnsLib and EnsPortal are normally a system or default packages that comes with default classes that developers can use or override? 

Hey Community,

Let me introduce to you our brand new "About Us" page!

📍 community.intersystems.com/about

On it, you will find general info about our Developer Community, interesting statistics, useful links, and much more!

Check it out, maybe you will learn something new even if you've been a member for quite a while.

Hi Guys,

is there an easy way to count all line of codes in all classes in a namespace ?

I've been asked to give the total lines of code in all our system and we have over 3000 classes, so opening each one of them to check total line would take a long time.

Thanks

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>

This is the fifth in a series of releases that are part of the developer preview program for 2022.2 Future preview releases are expected to be updated biweekly and we will add features as they are ready.  Many updates, fixes and enhancements  have been added in 2022.2, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas. Please share your feedback through the Developer Community so we can build a better product together.

The Early Access Program (EAP) is still active for the Columnar Storage.

Hi,

When i am using $$$LOGERROR("Message is Discarded") in the class  i am getting "Referenced Macro Not defined" error 

Can you help me how to use $$$LOGERROR in a class

Thanks,

Smythee

Hi all,

I am trying to test the IAM locally, but I came to a issue. When I turned on the the Basic Authentication, I get an 503 Service Unavailable.
error.

This is the scenario/setup:

• Because I am new to IRIS I need a test sample in IRIS where I can get data from. So I use this tutorial: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=AFL_rest#AFL_rest_exercise. It works, I can make direct calls to IRIS via Postman.
• Because the goal is to test IAM, I setup the IAM with: https://openedx.learning.intersystems.

Have a Zen report with a huge query that we are trying to break down and be more efficient.  

Looks like Zen only wants to take a result set class as the data (or XML, but writing to a file to generate these reports is probably even more overhead).

Is there a way I can move through a result set object, delete rows I don't want based on some objectscript commands and the pass that to the report?

Or can I pass a dynamic object?

Thanks.

Being interoperable is more and more important nowadays. InterSystems IRIS 2022.1 comes with a new messaging API to communicate with event streaming platforms like Kafka, AWS SQS/SNS, JMS and RabbitMQ.
This article shows how you can connect to Kafka and AWS SQS easily.
We start with a brief discussion of the basic concepts and terms of event streaming platforms. 

Event streaming platforms purpose and common terms

Event streaming platforms like Kafka or AWS SQS are capable to consume a unbound stream of events in a very high frequency and can react to events.

Hi Guys,

My application is running in Chrome but not in IE and I'm guessing it's a security issue, where when I open IE it tells me that ESC in on, but checking the configue in Server Manager tells otherwise? 

Thanks

Hello, Members of the Community!

We're so proud to announce that our InterSystems Developer Community has reached a couple of HUGE milestones:

📝 10,000 published posts

👥 11,000 registered members

👁 5,000,000 reads (it's five million!)

Looking for a new position working on InterSystems and Interface/Ensemble development/implementation, engine migration/upgrade, custom interfaces, message format conversions, or ETL.

Ideally looking for part-time and corp-to-corp. 

Profile:

• More than 15 years in healthcare industry, concentrated in HL7 integration with extensive experience in interface development with InterSystems IRIS for Health, Cerner OpenEngine, Openlink and Mirth.
• Strong emphasis in Microsoft technologies such as Visual Basic .

In this article you will have access to the curated base of articles from the InterSystems Developer Community of the most relevant topics to learning InterSystems IRIS. Find top published articles ranked by Machine Learning, Embedded Python, JSON, API and REST Applications, Manage and Configure InterSystems Environments, Docker and Cloud, VSCode, SQL, Analytics/BI, Globals, Security, DevOps, Interoperability, Native API. Learn and Enjoy!

Machine Learning

Machine Learning is a mandatory technology to build advanced data analysis and automate manual activities with excellent efficiency.

Hi all, 
I have a requirement to periodically poll a URL to fetch some XML data based on a list of query data, lets say every hour, and map what's returned to HL7 then send downstream, I mostly have everything contained within a business process and DTL but I'm lacking a way of invoking the process every X minutes, 
The client has a prefence for as much as possible to be done via out of the box components in the standard HL7 model of  "Service --> Process/Rule/DTL --> Operation" within the Web UI, 
I'm looking for something to act as the Service part that will trigger the  "Process/Rule/DTL -->

One of the most important tasks of dashboards is, on the one hand, to help you perceive data in an aggregated form, and, on the other hand, not to lose the depth of immersion in the data if you need this. One of the tools that help us achieve this result is drill down. It enables us to display several hierarchical levels of data, from aggregated to detailed.
Our task is to make an analytical dashboard that will be able to drill down by time periods:  from months to weeks and days in each chart.

Is it possible to create a scheduled task programmatically without using the management portal "Task Scheduler Wizard"?

Once created the scheduled task  would then be editable in the Wizard as normal for other users.

Thanks,

Conor

Hi Community

I have created a simple package that allows the use of Cache with the Laravel Framework.

From my initial testing everything seems to be operating smoothly but I would like to appeal to the PHP users in the community to help me improve this package.

For those of you out there who have time and would be interested in this, please visit the repo at https://github.com/jeandormehl/laracache

Thanks in advance

Is there a way to compare the value in a source field against all of the values in a repeating field?  For example, we have multiple DG1 target segments populated.  Is there an easy way to check a source DG1 segments against all of the target DG1 segments?  I didn't know if there is a wild card I can use for the comparison.

Hi!

I have a question regarding SQL insert/update from the mananger portal's SQL window.

I am trying to do an insert with a value that contains multiple spaces ($32) between two words. This is needed for a comparative reason. But the spaces are automatically trimmed away all the time. How should I write to keep these?

Example:

Insert into TableA
(MyColumn) Values('xxxx    yyyy')

then the spaces are trimmed away and it becomes: 'xxxx yyyy'

But I want to keep the spaces. How do I get around the problem?

Regards,
Michael

Does anyone have experience with CircleCI or really any automation tool using %UnitTest?

I have built my app and ran my unit test in a Docker container automated by CircleCI.  However, after many of the tests failed I see:

How do you halt out of the IRIS session and return an exit code to the shell?

I have a script in my repo that I pass into IRIS after CircleCI does the code checkout

iris session IRIS < inFile

Am I trying to approach this the wrong way?  Should I be writing test output to a file or something?

How do I detect that sync mirror backup is caught up to primary? Or at least close to caught up.

I'm executing the code on a backup.

A Minute Of Laughter on the Developer Community with #InterSystemsMemes

Meme author: @Mathieu Delagnes 

Have your own idea for a meme? Submit in this challenge on Global Masters.

Hi ,

     When I use jdbc driver to query the column info ,the "REMARKS" field always show the same as the "COLUMN_NAME" field.

When I use the sql "select * from INFORMATION_SCHEMA.columns a where a.table_name='some table name ' " to query columns info,there has a "DESCRIPTION" field ,the value is some comment for the current field.

So is there anyway to return the description to the jdbc  remarks field? And is there anyway to update the desciption or remarks field? Or is there some other way that I don't know to manage column comment info?

Many password requirements can be enforced using a password validation routine which is available to implement in System Management Portal. But how about this one:

Check that at least 50% of the characters changed from old password to new password.

We need to have access to the old password to check this, currently password validation routine only gets the new password.

We can create a new form to update the password where user must enter the old password and new password. I think I can block users from changing the password the usual way by having a password routine reject all passwords.

Hi all,

Does anyone backing up with CommVault version 11 (but lets forget the version for now) and had problems using vss to backup Cache/Iris ?

Can you tell me what you did to overcome that problem/problems?

Thanks,

Yossi.k

Hi Community, 

In April 2022 InterSystems participated as a Gold Sponsor in MIT Hacking Medicine GrandHack – MIT's annual flagship hackathon introducing healthcare challenges to be solved by engineers, clinicians, designers, developers, and business people. This year we introduced the "Best Use of InterSystems FHIR Services" challenge (read more here) and awarded prizes to the three winning teams.  

⏯ Sharing this recap video from MIT Hacking Medicine GrandHack so you could also catch the vibe of the event!