Question Oliver Wilms · Nov 28, 2019 InterSystems Cache DSN Hello, #Business Operation #ODBC #SQL #Caché #Ensemble 0 3 0 575
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 321
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 191
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 244
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 #Other 0 1 0 175
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 521
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 278
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 355
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 2 0 706
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 175