Hi Guys,
I've set DEFAULTMODE ="xlsx" in my report to be exported to Excel but it's exporting as .zip, is there something I need to add or set or maybe MS Excel to be installed in the server?
Thanks
Hi Guys,
I've set DEFAULTMODE ="xlsx" in my report to be exported to Excel but it's exporting as .zip, is there something I need to add or set or maybe MS Excel to be installed in the server?
Thanks
We are running HealthShare on Linux Redhat via Azure.
A couple of days ago, the Azure server rebooted. Which we were unaware of.
Resulting in the Instance being in a downed status.
In the short term I put together a quick script to check the status, if it is down to restart it.
However, before I go down that road, I thought it would be best to inquire if there is a much better and more streamlined solution?
In a nutshell I just want to check and see if the Instance is up or in a state such as down or hung then start it.
Hi Community,
Let's meet together at the online meetup with the winners of the InterSystems Datasets contest!
You'll have an opportunity to have a discussion with InterSystems Product Managers on new LOAD DATA functionality, Q&A on datasets, etc. Our winners' demo included!
Date & Time: Thursday, January 20, 2022 – 11:00 EDT
Hey Community,
We're pleased to welcome @Weidong Li as our new Moderator on the Developer Community in Chinese!

Let's greet Weidong Li with big applause and take a closer look at his bio!
Is there any recommended KPI's we should be using to monitor our IRIS configurations in Azure?
I started some development with the IRIS 2020.4 version and did not continue it for some months.
Now I just wanted to continue, but saw the license is not valid anymore.
Is there still a possibility to upgrade to 2021.2 community edition and to recover the globals from the old edition without having a valid license key?
How to execute it from the command line? I am able to use SQL in Management Portal, but I need to do it in Unix
select * from Ens_Util.Log where ConfigName='SFTPTo.HQ.SAFETRACE.DFT' AND Text LIKE '%Put Stream%' and TimeLogged LIKE '%2021-10-16%'
I have a user value set for an HL7 component that was removed from the source message. How can I pull that value for use in a Routing Rule suppression logic? Or do I have to create a custom class in order to do so?
Hi Developers,
I have created SOAP webservice , did not mentioned any security. Configured business service.
When I try to invoke from soaup UI, getting below error.
Hi,
We a currently looking at a way of securing any future REST API's using OAuth2, where the Authorisation Server (OAuth2) and Resource Server would be on the same server.
However, as we have mirrored environment the Resource Server, and therefore the Authorisation Server, need work with a Virtual IP Address and be able to failover to either of the mirror member servers.
Is that possible with OAuth2 and if so what are the best practices for this?
Any advise or guidance much appreciated.
Thank you.
Hey Developers,
Watch as the presenter uses IKO to deploy the WebGateway, SAM, and InterSystems API Manager with the latest version of the InterSystems Kubernetes Operator:
Hey Developers,
It's time to announce the winners of the InterSystems Datasets contest! Are you ready?
A storm of applause goes to these developers and their applications:
Hi Guys,
I was testing the Zen report from Samples namespace ( ZENReports.PageLayouts) by changing the DEFAULTMODE from PDF to xlsx and html and noticed that each time I get different output and fields! I thought that the output should be the same and the only difference would be the report format, or am I missing something? try yourself and you will see.
Thanks
HealthShare Unified Care Record Overview January 26-27, 2022 9:00am-5:00 US-Eastern Time (EST)
Hi all,
I am testing asynchronous Bulk Data retrieve with a large EHR vendor. When I retrieve the bulk data, they are returning ndjson (CONTENT-TYPE of "application/fhir+ndjson; charset=utf-8"). If I attempt to process that content using JSON functions - I get
ERROR #5035: General exception Name 'Parsing error' Code '3' Data ''
For example, the following generates the error
s objArray={}.%FromJSON(quickStreamOut)
The error makes sense in that ndjson is not a valid json format (I assume at least).
How can we strip a non-breaking space (hexadecimal code "C2A0")?
The other spaces like $c(9) and $c(20) should not be stripped along with that.
I would like to create a toolbar button in Cache Studio. After clicking on it, it would run a custom command (eg: to execute a routine that will clean a global).
I took a look at dialog that is shown after right clicking on a toolbar in Studio, then choosing "Customize" but AFAIK there is nothing there that allow such a thing.
I know it's possible to customize menu items by extending %Studio.SourceControl.Base class, is there something similar for toolbars ?
Here is some base code example (based on Danny Wijnschenk answer) :
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()
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:
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)
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
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:
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:
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.

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.