Question Oliver Wilms · Nov 5, 2020 ECP Data Server - Allow Incoming Connections - Add ClientIP with code Hello, I am working with Elastic Container Service in AWS running IRIS for Health containers 2020.1. We have an ECP Data Server. I like to be able to add a new host IP on the data server when a new client starts up. What table are the Allowed ClientIPs stored in? Thanks, Oliver #ECP #InterSystems IRIS for Health 0 1 0 260
Question Oliver Wilms · Aug 19, 2020 Sample Code for Free Space Monitor Task Hello, I just watched the recording of Michael Brady's presentation on Ensemble Disk Free Space Monitoring. Is the sample code for the Task definition class still available? How can I obtain a copy? Thanks #Monitoring #Ensemble 0 2 0 244
Question Oliver Wilms · Aug 19, 2020 How can I add an application server to ECP client list in code? I was able to define ECP connection in Installer class that I run when I build docker image for my Docker IRIS application. Now I start to use Amazon ECS and Autoscaling. When a new instance is created and it runs the IRIS container, I want it to "register" as an Application server on the remote database server. What code can I execute to add an ip address as an Application Server? #Application Server #ECP #ObjectScript #InterSystems IRIS 1 2 0 372
Question Oliver Wilms · Jul 28, 2020 Enterprise Message Bank Hello, I work with IRIS for Health 2020.1 and I attempted to set up Enterprise Systems to populate Message Bank. I see entries in Message Bank Event Log from the defined Enterprise Systems. I can browse Messages going back before I set up Enterprise Systems using Enterprise Message Viewer. However, I find no messages in Message Bank Viewer. Do I need anything extra to archive messages? #Enterprise Message Bank #InterSystems IRIS for Health 0 5 0 294
Question Oliver Wilms · Jul 15, 2020 Mapping Legacy Global to Persistent class storage I want to map global ^myUnitTests(ID)={Start}_"^"_{JOB} where {Start} and {JOB} are two properties and ID is determined by $Increment(^myUnitTests). I defined this class but it will not compile: #Mapping #InterSystems IRIS 0 1 0 269
Question Oliver Wilms · Jun 25, 2020 Testing Interoperability Productions in Iris Hello, I am using a class based on %UnitTest.TestProduction to test Health Connect production. I read in Class Reference IRIS for UNIX 2020.1: Note: This class is not intended to be used in InterSystems IRIS instances. Why should this not be used in IRIS? I have not seen any difference using this with HealthConnect 2017 or IRIS 2020.1 #Interoperability #Testing #Health Connect #InterSystems IRIS #InterSystems IRIS for Health 0 1 0 256
Question Oliver Wilms · Jun 11, 2020 Inbound File Adapter - Check Complete - File Locks Hello, I want to deploy Iris Interoperability Production in multiple containers . The production has File Services that process files from EFS location. All the files being processed by multiple containers are in the same directory. The standard Adapter class does not have Check Complete option to lock a file so that other containers File Services looking in the same file path cannot process the same file. I updated the Inbound File Adapter class to offer another Check Complete option LOCK that will lock the file until it is processed and archived. #Business Service #Interoperability #Other 1 2 0 233
Question Oliver Wilms · Jun 5, 2020 Running multiple containers - File sharing Hello, How can I use ISC_DATA_DIRECTORY once IRIS runs inside a container? Some background... #Containerization #InterSystems IRIS #InterSystems IRIS for Health 0 5 0 317
Question Oliver Wilms · Jun 3, 2020 Dashboard - how to draw lines? Hello, I work on a dashboard. I understand basic html. I like to draw two boxes in different colors on the background. There will be multiple small boxes inside or over the boxes in the background. I defined the large boxes as <div> and the smaller boxes also as <div> inside the larger <div>. So far so good. How can I draw lines with arrows between the smaller boxes? #CSP #Dashboards #Frontend #Graph #HTML #Other 0 9 0 313
Question Oliver Wilms · Jun 3, 2020 ECP Connection to remote data server Hello, I work on deploying IRIS inside Docker container. I really like %Installer class can automate many steps. I want to establish an ECP connection to a mirror database and then define a remote database on the application server. I have already seen we can create local database and namespace in %Installer. What code is needed to establish ECP connection? #Coding Guidelines #Databases #Deployment #ECP #Mirroring #InterSystems IRIS 0 6 0 545
Question Oliver Wilms · May 27, 2020 Read data from Excel Hello, I work as a contractor for the Department of Veterans Affairs. I want to read data from an Excel workbook. I searched posts here and saw Apache POI suggested. I believe Apache POI is not approved for use within VA. I also believe we should be able to run SQL query against Excel. Has anybody done such a thing or are there other ways to read data from Excel workbooks? Thanks #ODBC #SQL #InterSystems IRIS 0 11 0 1.2K
Question Oliver Wilms · May 19, 2020 New database in Mirror If I set up a Mirror and add a new database to the mirror, do I need to create the new database on every single member of the mirror or will it automatically appear on Mirror members? How about HSCUSTOM database, which already got created when installing IRIS? #High Availability #InterSystems IRIS for Health 0 1 0 266
Question Oliver Wilms · Apr 24, 2020 Menu on Management Portal Has anybody tried to extend the Menu on Management Portal? I like to add a new page or a dashboard that will be created soon to the Management Portal and allow others to use it also. I understand there are risks that I could lose things during an upgrade. I am okay with that. Does InterSystems support such an effort? #Dashboards #Interoperability #Management Portal #Ensemble #InterSystems IRIS BI (DeepSee) 1 5 0 551
Question Oliver Wilms · Apr 9, 2020 Support for Standards built in? FHIR I know is supported, how about OAGIS, FERPA CEDS, PSD2/SWIFT, NIEM? Hello, I was wondering if InterSystems has support for the following standards built into IRIS or Health Connect / Ensemble: #Compatibility #Interoperability #Ensemble #InterSystems IRIS 1 3 0 363
Question Oliver Wilms · Mar 26, 2020 SMTP ERROR #6033: Error response to SMTP DATA: 500 #5.5.1 command not recognized. Hello, #Contest #Interoperability #Caché #Open Exchange 0 1 0 980
Question Oliver Wilms · Mar 21, 2020 Send Email from Iris Contest Application Hello, The application I am working on for Iris Contest needs to send an email. Is anybody aware of a configuration for SMTP server, port, credentials that I can use for the contest or any demo application? Thanks, Oliver #Testing #Open Exchange 0 1 0 213
Question Oliver Wilms · Feb 7, 2020 Ignore Control Characters (Carriage Return and Line Feed) in Complex Record Map I understand RecordMaps can be used to send delimited files through a production without custom coding. The data segments are delimited by tilde character followed by $Char(10) in Linux/Unix. When I test the same IO data in Windows, I have $Char(13) and $Char(10) instead of just $Char(10). I like to use just tilde character for record delimiter and ignore $Char(13) and $Char(10) between the tilde and the leading data of the next segment / record. Is this good idea or not if someone wants to generate classes will it override code? #Coding Guidelines #Ensemble 0 2 0 852
Question Oliver Wilms · Nov 28, 2019 InterSystems Cache DSN Hello, #Business Operation #ODBC #SQL #Ensemble 0 3 0 701
Question Oliver Wilms · Sep 18, 2019 Export Report to Excel Hello, I created a Zen Report and I want to export to Excel. I read I can use $MODE=xlsx but my output in Excel is not correct. All 3 elements are condensed into one cell. Class AETMON.Report Extends %ZEN.Report.reportPage { /// Class name of application this report belongs to. Parameter APPLICATION; /// Specifies the default display mode used for this report if /// the URL parameter, $MODE, is not present. #ZEN #Caché 0 1 0 362
Question Oliver Wilms · Aug 26, 2019 Line Chart - My first Zen Report - I see no line Hello,I started a post when I tried to display a line graph on a dashboard:https://community.intersystems.com/post/dashboard-line-graphThis did not work very well. I switched gears and now I have a Zen Page that includes a Zen Report in iFrame. However my line chart does not display a line.This is my Report class: #Graph #ZEN #Other 0 4 0 227