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.4K
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 306
Article Oliver Wilms · Apr 24, 2020 2m read REST for Tasks on my Status Report I enjoy the challenge of being in a contest. Currently I participate in InterSystems IRIS with REST API Programming Contest. My idea for this contest was to create an app to help me keep track of tasks for my Status Reports. I started with the template provided by Evgeny Shvarov. I created a persistent class for Tasks and a REST Dispatch class. I defined my URL map and I even figured out how to test my REST app using Postman. #CSP #Frontend #JSON #REST API #InterSystems IRIS Open Exchange app 2 1 0 235
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 712
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 397
Article Oliver Wilms · Mar 26, 2020 1m read Iris Contest FileMailer Application Hello, #Contest #Interoperability #InterSystems IRIS Open Exchange app 1 3 0 177
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 1.1K
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 239
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 997
Question Oliver Wilms · Nov 28, 2019 InterSystems Cache DSN Hello, #Business Operation #ODBC #SQL #Ensemble 0 3 0 800
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 391
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 250
Question Oliver Wilms · Aug 13, 2019 Dashboard - Line Graph Hello,I want to create a dashboard with a line graph that shows system availability over time. I used this code to create a Dashboard: Set tItem = ##class(%DeepSee.UserLibrary.Link).%New() Set tItem.fullName = "Availability" Set tPage = "Availability.UI.CSVImport.zen" Set tItem.href = $system.CSP.GetPortalApp($namespace,tPage)_tPage Set tItem.title = "Availability" Set tSC = tItem.%Save() #Dashboards #Monitoring #InterSystems IRIS BI (DeepSee) #Ensemble 0 7 0 333
Question Oliver Wilms · Aug 12, 2019 Expand EnsPortal Hello, How should I go about it to add a page to the EnsPortal? I want to display a dashboard like page and I would like to be able to have it accessible from Management Portal. I hope there is a better way than typing the URL in address bar. Is the menu for Management Portal editable? Thanks, Oliver #Management Portal #Ensemble 0 1 0 228
Question Oliver Wilms · Jul 1, 2019 Open a text file in Windows - Append to existing log file Hello,I try to open an existing log file and append to it. In Windows I use Open file:(NRW):1. I would expect it to append to the file, but each time I execute the code I get only the new entries, the prior file content is lost.What is the proper syntax top open a file in "Append" mode?I will deploy this code in Linux. Is there a different syntax to open a file in Linux versus Windows?Thanks,Oliver Wilms #Platforms #Caché 0 1 0 778
Question Oliver Wilms · Jun 18, 2019 Create new loops in DTL X12 Document Hello, I have a DTL to transform X12 Document 278 Request to 278 Response HIPAA 5010 schema. The DTL is called from BPL. I defined a class method that receives source, target, and context objects. How can I create 2000F loops in the response when there were none in the source object? #DTL #Ensemble 0 2 0 380
Question Oliver Wilms · Jun 13, 2019 Array of Objects inside Response Message Hello,We have a BPL that returns in Response several %Strings, Dates. When we try to add Array of Objects property to the Response we verified just before the BPL terminates the response object has correct values in all properties including the array. We checked the Count(). It appears that even array of String works correctly but we prefer to pass objects rather than strings. #Business Process (BPL) #Ensemble 0 2 0 531
Question Oliver Wilms · Jun 6, 2019 Parsing JSON objects - Can Dynamic Objects be saved in persistent classes? Hello,I want to parse large JSON object and store data into persistent tables. Is there any other way besides pre-defining persistent classes including typing each property name? Maybe parse it and store properties into a global so that I know what properties need to be defined for each class...Thanks in advance for your thoughts #JSON #Caché 0 6 0 1K
Question Oliver Wilms · Apr 24, 2019 80 bytes wrapped X12 files Hello, our X12 File Service won't process files we encountered X12 files where they inserted CR LF after 80 bytes repeatedly in the middle of segments. X12 Parser does not seem to like it. I see there is a Whitespace property in Adapter. I am not sure if it ignores white space in the middle of a segment. I also heard about TolerateNewLine setting but I believe this also does not tolerate New Lines in the middle of a segment. We will probably have to read the file, strip out any CR and LF, write to a new file that the X12 file service can process. #Ensemble 0 1 0 221
Question Oliver Wilms · Jan 29, 2019 Production is not valid - Ens.Config.Production Hello,We are in process of moving our first Production from development to test. We exported our project from Studio. On test server, we cannot Open the Production because it is not a valid production because nothing exists in Ens. Config.Production class. What are we missing? How do we add our Production in Ens.Config.Production? #Deployment #Ensemble 0 3 0 695