Is it possible to use integer with a higher precision so that something like this works:

ClassMethodSet9223372036854775807

9223372036854775807
9223372036854775810   // should be 9223372036854775808
0                     // should be 1

The docs say "... However, with extremely large numbers (larger than 9223372036854775807E127) it is not always possible to convert a numeric string to a Decimal value. ..."[0], but operations on numbers bigger than 9223372036854775807 are not working correctly.

[0] https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GCOS_types#GCOS_types_nonnumasnum_big

Upgraded IRIS/Connect to 2022.1 and /api/atelier no longer works through a Web/CSPGateway.  Also upgraded the Web/CSPGateway to version WebGateway-2022.1.0.152.0 on Ubuntu and HTTPD Server version: Apache/2.4.29 (Ubuntu) with no luck as well.

It doesnt seem to matter if I add /api/atelier or /api/monitor to the enabled applications list, these routes do not make it back to the instance, however /csp, /csp/sys still does.

Am I missing a step in this upgrade process to serve these apps through Web/CSPGateway in the new kit version?

Hey Developers, 

New video is already on InterSystems Developers YouTube channel:

⏯ Using the Business Process Designer in InterSystems IRIS

Hi Guys

I have a table data in one namespace that I want to access from another Namespace  - is that possible?

Cheers

We're excited to announce the launch of the Community Roundtable series!

Roundtable sessions are for you to learn new things and connect with other Community members. Each month we'll select a new topic, provide an overview and select a specific date and time for this event.

We drafted a couple of topics for the first roundtable to choose from, but most of all we want to hear what you'd love to discuss! 

Navigate >> to this challenge << on Global Masters to choose the topic and suggest yours.

UPD: Challenge is closed. Thank you for voting and ideas! We will be announcing the topic for the first session shortly.

Is anyone aware of how to find out if a UNICODE database has been installed on an 8-bit version of IRIS i.e. is there a way of checking and actual database rather than the IRIS instance version?

Hi Team,

                I am new to InterSystems. I am trying to setup DHTML editor with ActiveX control for Trakcare 2021.7 version. I am receiving Ensemble locally not installed error. Could you please guide me for using Ensemble in local windows machine

Hello guys,

Does anyone know what is a process status IPQW ?

We get it in jobs that do some SQL..

Thanks in advance.

Yaron Munz 

I am using $Query to loop through a global. 

When I use $GET to get the data all we get back is the global name. 

How do you get the value of the global after you have looped. 

Below is my example in terminal. 

Thank you in advance 

Set node = $Query(^FromExtraMed("")) 

w node
^FromExtraMed("A02",9220)

If i try w $GET(node) it returns 

^FromExtraMed("A02",9220)

If i had this hardcoded it would have got the value

w $GET(^FromExtraMed("A02",9220))
0,66340,2120

I have already read the documentation and it is not clear. Can someone advise? 

In the August Learning Services newsletter, see how you can get hands-on with healthcare analytics tools, Embedded Python, and InterSystems Package Manager. If you're new to InterSystems ObjectScript, try out a learning path to get started!

Hey Community! 

We've always had this idea on the back burner about improving the process of collecting, analyzing, and responding to product enhancement requests from our members. We knew we needed a good user experience and even better internal processes to make sure the best ideas were gathered, heard, and responded to. And finally, this thought has come to fruition!

So in case you missed it, let me introduce to you the Official InterSystems feedback portal:

💡 >> InterSystems Ideas << 💡

Can someone help me on how the alter a table in Management table, I have tried the SQL and MYSQL way but it does not alter the table.

Thank you.

Is it possible to access (read, write) to an external Oracle database via Cache SQL Gateway using JDBC in Cache Object Script?  I am currently using ODBC successfully but wanted to see if JDBC was an option too.  If it is possible, does anyone have a basic Object Script example(s) that I can review?

Thanks!

Hi,

Is there a way to include a prefix for the instance name in the server connection? I have 1 server with multiple iris instances, using 1 webserver. Each instance can be reached using a prefix in the url: (for example https://localhost/instance1/...).

I want to use VS code remote, but can't add the prefix to the hostname (or ip), and also not to the port, as this is numeric. Any idea how to solve this?

This GitHub is the simplest way to scrap using IRIS and Python, all of that already incorporated in an IRIS PRODUCTION.
From here you can build any IRIS production in full Python or in ObjectScript as this module is interoperable.
See for more information

1. IRIS-WEB-SCRAPING

• 1. IRIS-WEB-SCRAPING
• 2. What is Web Scraping:
  • 2.1. The popular libraries/tools used for web scraping are:
  • 2.2. The BS4 tool
• 3. Using full Python to web scrap on IRIS
  • 3.1. The Production
    • 3.1.1. Starting the Production
    • 3.1.2. Access the Production
    • 3.1.3. Closing the Production
  • 3.2. Step 1 : Find the URL of the webpage that you want to scrape.

I am receiving batched results in an EDIFACT file. I need to debatch and send individual HL7 out. I have built a DTL to read the first instance of a result from EDIFACT and that generates an ORU^R01 as desired, but I have no idea how to make the DTL loop and send multiple HL7 messages outbound.

I did go down the path of stripping the first instance of a result from the EDIFACT, then sending the now truncated EDIFACT data back to itself. This works well in theory but I then need a while loop in the Rule Editor, and I cannot seem to access the source.

Hello,

  We have an IRIS installation on one drive "D"; the drive is a partition that is limited to 2TB in size; we want to move the entire D: contents to a larger partition-type not limited to 2TB.

The IRIS install is on D: as are all of the Databases the instance uses.

Are there any concerns or issues that should be considered or are not so obvious with doing this?

i.e. IRIS and all processes doing disk access to D: need be shutdown first (and a full-backup taken, all journals up to date for mirrors etc).

A new partition of E: created as say 3TB.

We are looking for a 3rd party application that can scan our IRIS based Cache Object Script code for vulnerabilities or coding weaknesses.  There are many, many applications/vendors out there that do code scanning but none seem to support Cache Object Script or scanning the IRIS environment.   If anyone is aware of a company/product that can scan our code / IRIS environment, I would love to hear about it.

Thanks in advance for the help.

Mike

I am trying to import a large base64 string into objects but I can't seem to get it to work:

ClassMethod Test() As %Status
{
Set readerForItkRequestData = ##class(%XML.Reader).%New()
 
Set file="c:\Source\test_full.xml"
 
Set status = readerForItkRequestData.OpenFile(file)
Do readerForItkRequestData.Correlate("Envelope","Phu.Epro.Schema.Itk.Envelope")
set temp = readerForItkRequestData.Next(.pOutput,.tStatus)
Do pOutput.%Save()

}

The class I'm trying to project to: 

Class Phu.Epro.Schema.Itk.Payload Extends (%Persistent, %XML.

Do we have messages.log/cconsole.log projection in SQL?

I was sure we do, but unable to find it.

Now that I have SAM up and running, out of the box I would like to add some Application Metrics. Does anyone have templates, or have suggested classes that someone could use to add custom metrics to SAM? Maybe we should start a repository somewhere? Or would someone be willing to share custom metrics on the Open Exchange? 

What I am looking to do is capture the overall HL7 message and header count per day.

• SELECT Count(ID) FROM Ens.MessageHeader WHERE TimeCreated > <date> and TimeCreated < <date>
• SELECT Count(ID) FROM EnsLib.HL7.

Hello community,

First of all thanks for reading this post:

Because of you are more experienced, pragmatic, and have a lot of knowledge and good know-how; please consider to read and answer some question, if you would like:

Why did you choose to become a software engineer / developer?

How and when did you start to generate a "flow state of mind" during your career?

What are recommend habits inside and outside, during you own time and during your work time, to be focused during you coding session and daily tasks?

📍🙏📌Thanks for reading and answering

Hi, 

I am trying to input an entire xml into a sql server table. I am doing this via an operation in Ensemble.

I keep getting the following error

[SQL Server]XML parsing: line 0, character 0, unrecognized input signature

I have setup the table with a column parameter XML.

Here is the request object that is being sent to the store procedure

{ call dbo.PopulateDataTable(?,?,?,?,?,?,?

In this GitHub we gather information from a csv, use a DataTransformation to make it into a FHIR object and then, save that information to a FHIR server all that using only Python.

The objective is to show how easy it is to manipulate data into the output we want, here a FHIR Bundle, in the IRIS full Python framework.

1. Fhir-orga-dt

• 1. Fhir-orga-dt
• 2. Prerequisites
• 3. Installation
  • 3.1. Installation for development
  • 3.2. Management Portal and VSCode
  • 3.3. Having the folder open inside the container
• 4. FHIR server
• 5. Walkthrough
  • 5.1. Messages and objects
  • 5.2. Business Service
  • 5.3. Business Process

In MS SQL Server i can do this:

SELECT 
Category, CrewNumber, MedicalCertificationDate, Seat, SeatbeltUsed, Sex, ShoulderHarnessUsed, ToxicologyTestPerformed, childsub
INTO #tempfemale
FROM Aviation.Crew
WHERE Sex = 'F'

The code would create  a new temporary table with the fields defined from Aviation.Crew.   I cannot find how to do this in Cache SQL in the documentation.  Can someone show me the correct syntax or other solution?

Hey Community, 

In this video, you will learn how to use the Data Transformation Wizard in the Management Portal of InterSystems IRIS® data platform to convert messages to other formats: 

⏯ Transforming Healthcare Messages in InterSystems Integrations

Hi Guys,

I'm a newbie in Ensemble productions and I've been asked to create an Inbound adapter and specify a port of which clients can send through JSON files and I did as attached, but now I've been asked to provide the URL to give to our clients so they send their JSON files to and I don't know what URL is should look like!? 

Thanks 

I was able to get SAM running with podman, but I am still unable to access the web page, and need a bit of help in troubleshooting as I am just trying this for the first time.

I verified the images were running by running podman ps

[xxxxxx@xxxxxx sam-1.1.0.107-unix]$ sudo podman ps
CONTAINER ID  IMAGE                                    COMMAND               CREATED         STATUS             PORTS                   NAMES
065776e769e8  localhost/podman-pause:4.0.2-1650363392                        13 minutes ago  Up 13 minutes ago  0.0.0.0:8080->8080/tcp  d91a3f748861-infra
f78b9bc67c28  docker.

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.