Hi Developers!
Welcome to the 9th edition of the InterSystems Ideas news! In this issue you can learn about:
✓ New page on the Ideas Portal - Idea-A-Thon Winners
✓ Implemented ideas for future announcements
✓ New ideas posted recently
In this month's Learning newsletter, see how mirroring helps keep your databases running smoothly, and learn about the newest cloud-based asset management software. Plus, explore a new option for getting recertified as an HL7 Interface Specialist! Subscribe to get the latest updates in your inbox.
I'm pretty new to ensemble.I'm working on a BPL process where I need to retrieve a result set from an SQL activity, loop over the results, and call a web service. I'm having trouble passing the request parameter(Labtype) into the SQL query for the WHERE condition .Can any one suggest how to loop over the result set as well.Any suggestions on how I can achieve it?
Hello,
First of all thanks for your help, time, and answers.
We would like to know what are we doing wrong and how could we improve it and fix it.
We need to convert the Api Monitor Metrics which are a String with this format:
iris_cache_efficiency 13449.122
iris_cpu_pct{id="CSPDMN"} 0
iris_cpu_pct{id="ECPWorker"} 0
[...]
iris_wdwij_time 11
iris_wd_write_time 8
iris_wij_writes_per_sec 0
To JSON.
We would expect them to look like a normal JSON as follows:
{
"iris_cache_efficiency": "13449.122",
"iris_cpu_pct{id='CSPDMN'}": "0",
[...]
"iris_wij_writes_per_sec": 0
}
I have a case where the Active Directory Service Account passwords will be changed periodically every 3 months and the changes are shared via the LastPass application which requires logging into the app to retrieve the new password and manually entering it into the Interoperability Credentials configuratrion, or the Service Registry.
> Is there a way to retrieve the password automatically?
In this case the organization plans to use gMSA (Group Managed Service Account) and BeyondTrust for setting up new password in the future.
How have people delt with this?
K9s is a terminal-based UI (aka kubectl clown suit), to manage Kubernetes clusters that drastically simplifies navigating, observing, and managing your applications in K8s, including Custom Resources like the InterSystems Kubernetes Operator (IKO) and ArgoCD Applications. If you are about to take your CKD, CKA, or CKS, leave k9s well enough alone for awhile as the abstraction to kubectl will become the standard for navigating the cluster and you will undoubtedly become estranged to the extended flags of kubectl and bomb the exam.
Hi Community,
Enjoy watching the new video on InterSystems Developers YouTube:
I am creating a custom message class. How do I define @name and #text fields?
this? Property name As %String (%JSONFIELDNAME = "@name");
Maven Projects mixing ObjectScript and Java
What is Maven?
Maven is a tool, hosted by the Apache Software Foundation, for building and managing any Java-based project. Apache Maven is the best source of information.
Why Maven?
What's your approach to learning InterSystems technologies?
Elevate your learning journey with us: share your insights in a brief survey and help us shape your learning experience.
InterSystems Studio Client 2023.1.0 Build 229
I closed my watch and output panels. and I am trying to reopen. I tried using Alt-2, Alt-3 and it is higlighting /unhighlighting the appropiate icons yet panels are not displaying.
I would appreciate any help.
Thanks,
Orlando
I
I'm converting a .NET gateway interface (call .NET code from IRIS) from the old "Caché style" that use imported proxy class to the new $system.external .NET gateway as documented in:
https://docs.intersystems.com/iris20221/csp/docbook/DocBook.UI.Page.cls…
For simple case it works and I'm fine, unfortunately I don't understand how to implement/access .NET arrays from IRIS and unfortunately the documentation has no info whatsoever on how to work with arrays.
I have a BPL that I set up a trace to check if the ProcRsltStatus Order is 1. Because the trace is set up in the BPL, I am having issues in searching traces that have the 1 in the message viewer. Any idea how I can limit my search to only the ones with ProcRsltStatus Order::1? Thanks in advance.
Hi community!
In this article, I'm excited to introduce my latest application, Journal File Indexer. The development of this application is rooted in the portal idea DPI-I-270.
In short, this application lets you load and index a log file in a database.
Why?
If you've ever used the log file search function in the management portal, you may have encountered a timeout error or even a blank page. This problem usually occurs when searching a large journal file. Journal File Indexer solves this problem by considerably increasing the speed of searches once the file has been loaded into the database.
Another problem arises during the restoration process. When searching for global entries in a log file to restore old or new values, the management portal doesn't have this specific functionality. A routine must therefore be coded to achieve this. Journal File Indexer comes to the rescue, incorporating a restore function!
Overview
In our previous post, we discussed the motivation for developing a chatbot agent with access to FHIR resources. In this post, we will dive into the high-level design aspects of integrating a Streamlit-based chat interface with a Java SpringBoot backend, and enabling a LangChain agent with access to FHIR (Fast Healthcare Interoperability Resources) via APIs.
Hello!
I am trying access each "name" tag in the xml-file down below and want to display them through the trace in the production:
<?xml version="1.0"?>
<staff>
<doc type="consultant">
<name first="David" last="Marston">Mr. Marston</name>
<name first="David" last="Bertoni">Mr. Bertoni</name>
<name first="Donald" last="Leslie">Mr. Leslie</name>
<name first="Emily" last="Farmer">Ms. Farmer</name>
</doc>
</staff>
Hi,
DBA has asked me to configure a working Business Operation using a SQL.OutboundAdapter (connecting to external MSSQL server) to run as TRANSACTION ISOLATION LEVEL READ UNCOMMITTED.
I would like help with an example of how this is done.
Thanks
According to Databricks Apache Parquet is an open source, column-oriented data file format designed for efficient data storage and retrieval. It provides efficient data compression and encoding schemes with enhanced performance to handle complex data in bulk. Apache Parquet is designed to be a common interchange format for both batch and interactive workloads. It is similar to other columnar-storage file formats available in Hadoop, namely RCFile and ORC. (source: https://www.databricks.com/glossary/what-is-parquet). Below are the characteristics and benefits of Parquet according to
Currently, many digital artists use generative AI technology as a support to accelerate the delivery of their work. Nowadays it is possible to generate a corresponding image from a text sentence. There are several market solutions for this, including some available to be used through APIs. See some at this link: https://www.analyticsvidhya.com/blog/2023/08/ai-image-generators/.
Hello all,
Hi,
I'm receiving in one of our interface a XML file as a %Stream.GlobalBinary, and in the source Application that produces this XML file, the user sometimes add a special character that force the XML file to have the header encoding to UTF-8, instead of ISO-8859-1 :
<?xml version="1.0" encoding="UTF8"?>
When my current interface tries to convert the %Stream.GlobalBinary into %XML.XPATH.Document to this exceptional UTF8 header encoding of the XML file :
Set tSC=##class(%XML.XPATH.Document).CreateFromStream(stream,.tDoc) --> contains exceptionally UTF8 encoding
Hi folks!
I need to change a status database to RW with the class
I used scripts for this, for example, I can create a database like this
setup_database() {
csession -B -U "%SYS" <<-EOF
zw ##class(SYS.Database).CreateDatabase("/InterSystems/cachedb/mydatabase")
set Properties("Directory")="/InterSystems/cachedb/mydatabase"
zw ##Class(Config.Databases).Create("MYDATABASE",.Properties)
halt
EOF
How can I modify this status R/W?
Does Iris 4 Health support the OpenTelemetry initiative for logs/tracing etc? https://opentelemetry.io/
If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
Reviews by other members of the community are marked by * in the last column.
I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix.
Some were accepted and merged, and some were just ignored.
So if you did a major change and expect a changed review just let me know.
Hello,
I have a database drive which is getting full and almost getting out of space. My retention policy is for keeping 3 days worth of data. Seems like I have to modify my code for daily purge as it seems like not doing the complete job. In the meantime, I was looking to move the current CACHE.DAT files for a couple of my databases with maximum size and create a new .DAT file to replace. Can anyone kindly guide on the process?
Thank you,
Cal Hacks 2023 was a phenomenal event! This annual hackathon, organized by the University of California, Berkeley, brought together a diverse and talented group of innovators.
Kudos to the outstanding winners of the InterSystems IntegratedML challenge:
🥇1st Place - MultiMed Vision+ DevPost
This healthcare app designed for generational wellness, harnessing the power of multi-modal LLMs to offer personalized AI-driven health management.
While starting the development with IRIS we have a distribution kit or in case of Docker we are pulling the docker image and then often we need to initialize it and setup the development environment. We might need to create databases, namespaces, turn on/off some services, create resources. We often need to import code and data into IRIS instance and run some custom code to init the solution.
And there plenty of templates on Open Exchange where we suggest how to init REST, Interoperability, Analytics, Fullstack and many other templates with ObjectScript. What if we want to use only Python to setup the development environment for Embedded Python project with IRIS?
So, the recent release of Embedded Python template is the pure python boilerplate that could be a starting point for developers that build python projects with no need to use and learn ObjectScript. This article expresses how this template could be used to initialize IRIS. Here we go!
How can IRIS productions be deployed more quickly and with greater peace of mind?
The aim of interoperability productions is to enable you to connect systems in order to transform and route messages between them. To connect systems, you develop, configure, deploy and manage productions that integrate several software systems.
That’s what the InterSystems documentation on its reference website tells us, but what do you actually have to do to deploy a production ?
GmOwl is a solution that offers an organized and engaging learning platform. It was developed to cater to the increasing need, for learning tools providing a versatile quiz environment that meets users requirements.
The main objective of GmOwl is to deliver an user experience for individuals participating in quizzes while giving administrators comprehensive control, over content and user engagement.
GmOwl uses Java EE with MVC template, and the InterSystems IRIS database is used to store data. The InterSystems JDBC Driver is used to connect to the database.
Hello,
First of all thanks for your time, thoughts, teaching and help:
We wonder how could we get the metrics from http://[Ip]:[Port]/api/monitor/metrics and use them in Kibana to chart statistics.
We would like to ask you how do you use the api monitor metrics, and as a second question, how would you suggest to utilize them in a third party software as Kibana to chart them.
We have thought to do the following:
