Hi all
    Is there anyway to decrypt the PBKDF2 encrypted data in a table?

Thanks,
Syed M

I want to try SAM in AWS. I followed these steps:

docker pull store/intersystems/sam:1.0.0.115

git clone intersystems-community/sam: System Alerting and Monitoring (SAM) (github.com)

git clone https://github.com/intersystems-community/sam

tar zpxvf sam-<version>.tar.gz

tar zpxvf sam-1.0.0.115-unix.tar.gz

$ cd sam-<version>

cd /home/ec2-user/git/sam/sam-1.0.0.115-unix/

$ ./start.sh

In your browser, visit:
http://<ip-address-of-host-where-SAM-runs>:8080/api/sam/app/index.csp
You'll be prompted to login.You can use standard InterSystems IRIS credentials like _SYSTEM/SYS.

Hi Developers, 

We've launched a friendly discussion on Global Masters called "Let’s meet developers' pets!" and invite all of you to join!

There are already so many cute photos from the community members. So, whether you have a dog 🐶, cat 🐈, hamster 🐹,  or gecko🦎, we want to see them!

Hey Developers, 

Are you ready for the new challenge? We're pleased to announce the first InterSystems technical article writing competition:

🏆 InterSystems Tech Article Contest 🏆

Write an article on any topic related to InterSystems technology from July 15 to August 15August 22 – extended!

Prizes for everyone: Everyone who publishes an article on DC during this period will receive a special prize pack!

Main Prize: Apple iPad

Join our new contest and your content will be seen by over 55K monthly readers! Details below. 

So I've got the IRIS AMI spun up in AWS EC2; it seems to be running fine.  
I've added an EBS volume to it for persistent storage, and now I'm pondering how to make it actually do something useful.  

What's the best way to do deploy code to this instance?  I can think of a few ways to do it, but what's the least painful way?  Push my code to an S3 bucket and figure out how to load it at system start?  Github project?  

I have attached a document that describes the product I have developed called NiPaRobotica Pharmacy.This is an interface I developed that accepts Pharmacy Dispense Requests and converts the line items on the order into dispense dialogues which it sends to pharmacy robots.I deployed the interface into 3 Hospital pharmacies two of which had 6 robots that were arranged in such a way that the dispense chutes channelled medications to desks by the pharmacists sitting in windows serving 1200 patients a day.The robots cut the average waiting time from 2 hours down to one hour.

I have described my efforts to optimize IRIS Mirror deployment in AWS ElasticContainer Service (ECS) in my prior article.

IRIS Mirror in the cloud (AWS) | InterSystems Developer Community | AWS
 

I have come to the opinion that IRIS Mirror is not as reliable as needed when deployed in ECS. The root of the problem is the fact that ECS randomly assigns one of the available IP addresses to each EC2 host or Fargate task it starts.

These get stored in iris.cpf file in MapMirrors section as shown here:

[MapMirrors.IRISMIRROR]

FAILOVER1=10.2ab.1cd.146,2188,,10.2ab.1cd.146,588E6700-DAB7-11EB-9111-0242AC11

Hey everyone as you may know I am a beginner and I am kindly asking for some assistance in a problem I have been solving. The problem is that I am calling a user defined function within a procedure called occupiedseatsAdj and the compiler comes up with this error. 

From what I understand I can call a user defined function from within a procedure (correct me if I am wrong) as shown below.Is this the correct way or should I create a .Mac file and include it somewhere within the above mentioned cls file ?

I have been working on redesigning a Health Connect production which runs on a mirrored instance of Healthshare 2019.We were told to take advantage of containers.We got to work on IRIS 2020.1 and split the database part from the Interoperability part.We had the IRIS mirror running on EC2 instances and used containers to run IRIS interoperability application.Eventually we decided to run the data tier in containers as well.Later we switched from using EC2 instances to Fargate “server-less” compute.

The first installment of this article series discussed how to read a big chunk of data from the raw body of an HTTP POST method and save it to a database as a stream property of a class. The second installment discussed how to send files and their names wrapped in a JSON format. 

Now let’s look closer at the idea of sending large files in parts to the server. There are several approaches we can use to do this. This article discusses using the Transfer-Encoding header to indicate chunked transfer. The HTTP/1.1 specification introduced the Transfer-Encoding header, and the RFC 7230 section 4.1 described it, but it’s absent from the HTTP/2 specification. 

Has anyone integrated IRIS with Azure AD? Any tips or guidelines you can provide are appreciated.

David

Hi - Looking at encoding a .rtf file to Base64 - I've seen the Base64Encode Method and I can pass text but how would you pass a file?  Or is there another method that can do this?

The end goal is to place the encoded output in a MDM^T02 (in OBX Segment) HL7 Message.

Appreciate any pointers - Thank You

Open up a random ObjectScript project (I think you need to be logged in first for this to work).

For example, the ZPM project

Then press "." (press full stop).

This will open the git repo inside an online instance of VS code.

Perhaps not that exciting for some, but I was impressed. Mainly because it's a good demo of editing ObjectScript in the cloud. As much as I like VS code locally, I still can't use it on many sites, and maybe not popular, but I still think IRIS + its own web IDE would be a killer combination. 

Looks like extensions in the marketplace are limited to core / common extensions at

It's possible to enable Ctrl+C / Ctrl+V in IRIS Terminal for Windows.

To do that, open Terminal and select Edit > User Settings and enable Windows edit accelerators. This settingspecifies whether the Terminal enables the common Windows edit shortcuts (Ctrl+C, Ctrl+V, Ctrl+Shift+V), in addition to the basic Terminal edit shortcuts (Ctrl+Insert and Shift+Insert).

After that Ctrl+C / Ctrl+V would work.

Also <SYNTAX> errors after incorrect copy/paste go away.

Docs.

Hi.

Does anyone have experience with JDBC connection from Android to IRIS?

Regards,

Matjaž

I'm trying to debug a CSP page but I'm not able to set up a breakpoint into <script> tag.

Is it possible to setup on CSP files? Am I forgeting something?

PS:

this is the tag

<script language="Cache" method="OnPreHTTP" arguments="" returntype="%Boolean">

Good morning everybody,

In Html sometimes we need to use entities code for don't have problems with browsers all over the world. Ex. 'á' is converted to code: '&aacute;' / 'é'  is converted to '&eacute;'. 

I have a question, how can i convert a string like my name to this type of code? Ex. "Flávio" will be "Fl&aacute;vio". I tried this way:

USER>write $zconvert("Flávio","I","HTML")
Flávio

but don't worked :(
 

Best Regards.

I'm wanting to write a query in SQL that will return a row with a count for each day for a given month or year for a specific operation or configname.  The following is a start but I'm not finding what I want in the documentation to parse out the TimeLogged field of the table.  Nay help is appreciated.

SELECT count(TimeLogged), ConfigName
FROM Ens_Util.Log
where TimeLogged like '2021-07%'
and ConfigName = 'operation_Name'
group by TimeLogged

Hello,

We need to upgrade our cache instance from 2016.2 to the latest version.

I find the documentation about the "Upgrade Path" but I cant  find where I can get the files to upgrade in the documentation.

Also I cant find how to make this upgrade, they talk about strategies but dont talk how to perform the task to upgrade.

Is there any documentation of how to make and upgrade and where I can get the files?

We have the instance installed on RedHat unix. 

Thanks!! 

Hi developers, 

We have just published an update to the Deltanji version control extension for Visual Studio Code.

When used in certain Deltanji workflows, triggering an automatic checkout on first keystroke could result in the developer working on an outdated copy of the code and only being notified of this later when saving their changes. In order to prevent this from happening checkout now reloads the document immediately. 

Error messaging has been improved in two areas - when attempting to cancel code that is not checked out, and when trying to register new code onto a withdraw system. 

We have also improved interoperability between the Deltanji extension and the InterSystems ObjectScript one, as well as its handling of multi-component objects.

If you're already a user of Deltanji then your extension with automatically update. You can find out more information on Deltanji and the latest release here. 

Hi, Is there a way to connect to a MYSQL ODBC? I tried using the SQL Connect class but getting an error.

Set conn=##class(%SQLGatewayConnection).%New()
Set sc=conn.Connect("databasename","username","password")

&sql(insert into ORDERS (column1, column2, column3, column4, column5) values(:value1,:value2,:value3,:value4,:value5))
s sc=res.Close()
Set sc=conn.Disconnect()

But I am getting an error :

Please can you advice how I can do this?

Alerts are automatic notifications triggered by specified events or thresholds being exceeded.

InterSystems Documentation

I have a Business Service connected to a machine with ~100 sensors. BS receives sensor values once a second.

Several conditions determine if a Business Service should raise an alert (it's a list of: sensor id > threshold).

I have three questions:

1.  Should I write these conditions as a business rule and call this rule from the Business Service, and if the rule returns 1 call SendAlert? Or is there some other way to do that?
2. Business Rule returns a reason for the rule

Introduction

This is a csvgen UI frontend in Angular 8. The aim of this project is to easily import csv file to Iris from a web ui.

Demo

Install with ZPM

It will automatically install the dependency of csvgen and sslclient

zpm "install csvgen-ui"

This will create two new endpoints :

• One for the Rest API for uploading files

• /api/{namespace}/csvgen/

• One for the UI

• /csp/{namespace}/csvgen/index.html

Stand alone demo on docker

Run the server

docker-compose up -d

UI

The UI is per-namespcae, this mean it will be available only for the namespace where csvgen-ui is install. For example :

http://localho

Hi everyone, 

Learn how to build FHIR applications in the cloud using S3, Azure AD, and a FHIR service:

⏯ Build FHIR Provider & Patient-Facing Applications in the Cloud

Hi Developers!

InterSystems IRIS online documentation is temporarily available here.

UPD: https://docs.intersystems.com/ is available.

Hi Guys,

Would like to know how to hide an element or component in zen report?

I've a list of element (eg. table, images, items..etc) defined under 

XData ReportDefinition [ XMLNamespace = http://www.intersystems.com/zen/report/definition ]

{

}

and all of them don't have hidden attribute available, so how can I hide any component under ReportDefinition?

Thanks

I have a handful of EnsLib.HL7.MessageRouter sending an HL7 message to a single Business Process (Ens.BusinessProcess).

In the OnRequest method, I am declaring pRequest as EnsLib.HL7.Message

What I need to do is determine which HL7 Router sent any given request to my BusinessProcess. 

To do this, I know that I need to fetch the SourceConfigName property from the Ens.MessageHeader of the Request, but I am not sure how (or if) I can fetch this data from within the OnRequest Method.

Does anyone have any pointers?

Bill Casey

Hey Developers, 

Learn how to search for FHIR resources with a variety of query options:

⏯ FHIR Search @ Virtual Summit 2020

Hi!

I am looking for examples of implementations of a more robust forgot username and forgot password implementation.  Does anyone have one to share, even just a link to the page so I can see how it works, or screenshots?  We would like to implement a secure system for requesting username and resetting password.

Hi developers!

Do you know a CRM that is built with InterSystems IRIS or Caché or Ensemble on a backend?