Developer Community Digest, November 2016

Articles	Questions
.NET
Introduction to .Net Gateway - use external .net library from Cache Object Script
Can I use Microsoft Office automation components with Cache?

Admin
Importance and Collection of Exact Version Information ($zv / $zversion)	What are the Roles needed with HealthShare to get access to DeepSee functionality?
Fixing errors found when attempting to view a DeepSee listing	ODBC issue

Administration
Importance and Collection of Exact Version Information ($zv / $zversion)	Startup Tag^Routine property for UnknownUser
At last! - Ability to Create Namespaces that are not Enabled for Ensemble - Coming in 2017.1	Ensemble Business Operation QueueCountAlert
How the Ensemble Scheduler Works	ODBC issue
Ensemble Orphaned Messages	Looking for examples of Cache Password Pattern specifications
Some strategies on how to manage and decrease space taken by Ensemble system	InterSystems and containers

Analytics
Getting started with Text Categorization	iKnow - Text categorization "Category 1 covers the whole dataset"
Sample of IHE Performance monitoring dashboard	Sorting Numeric Dimensions
Accessing a new DeepSee Namespace for the first time

Analyzer
Fixing errors found when attempting to view a DeepSee listing	MDX QUERY
Building and using Plugins in DeepSee	Newbie Question for creating a this period/same period last year comparison
	Sorting Numeric Dimensions
	MDX Calculated measure help in DeepSee
	Accessing Deepsee plugin in MDX

Application Server
	Connect Cache client to GT.M database

Architect
Customizing DeepSee time level within date hierarchy	Accessing Deepsee plugin in MDX

Atelier
Interpreting icons in Atelier Explorer view	What does the () mean on the Add-Ins and Templates items on Atelier's Tools menu?
Tip to look Atelier more mac stylish only for Mac users	Atelier - equivalent of Studio GoTo function?
Working with javascript files in Atelier

Authentication
	Looking for examples of Cache Password Pattern specifications

Authorization
Mysterious errors when running common commands!

Beginner
Importance and Collection of Exact Version Information ($zv / $zversion)	Monospace output from Zen
Resolving Caché Printer Problems in Windows	How to set the Current Directory
	High level explanation of how you would "attach" nondiscrete documents to a patient record?
	audit login failures, how to trace?
	What the Cache class to find the NodeName
	Update several rows in SQL statement at Management Portal
	How do I log terminal output to file automatically?
	Cache up in emergency mode
	bitwise integer arithmetic
	Full migration Helthshare to another PC.

Business Operation
How to - Customize Ensemble Settings	SOAP Operation giving "Not Registered" error
	Duplicate Patients in FHIR Repository

Business Service
How to - Customize Ensemble Settings	SOAP Fault handling with ERROR #5659: Property '%ZHSLIB.Audit.LogParticipant::Log' required
Best Practices for Custom Business Services	Text File Fixed Format
Mastering the JDBC SQL Gateway

Caché
Extracting pButtons data to a CSV file on Windows	Ensemble - Namespace does not supported
Importance and Collection of Exact Version Information ($zv / $zversion)	Cache Studio - Find in Files
How to convert LDAP date time stamps into Cache $HOROLOG	Startup Tag^Routine property for UnknownUser
Reflection in Caché	File Creation
Bachelor thesis: Automated quality rating of emergency calls using NLP	Simple Arithmetics
Wireshark installer could affect Studio.exe and csystray.exe on Windows	cmd command not working on terminal
Mysterious errors when running common commands!	MakeDirectory
Resolving Caché Printer Problems in Windows	How to log out from a web application?
2016.2.1 Maintenance Release	CLS location from INT code
Caché and Ensemble 2017.1 field test now available	2 Skipping SET due to compare and swap failed on - in CConsole Log
SYSLOG - what it really is and what it means	Compile Date
Returning Disk Space to File Systems	Why my ZEN report displays ok in xml mode but not xlsx excel
Caché Localization Manager or i18N in InterSystems Caché	How to set the Current Directory
Tip to look Atelier more mac stylish only for Mac users	How to debug a CSP page
Introduction to .Net Gateway - use external .net library from Cache Object Script	audit login failures, how to trace?
Caché process failures on RHEL V7.2	File size limit for upload/download
InterSystems Data Platforms Capacity Planning and Performance Series Index	What the Cache class to find the NodeName
ECP and Process Management API	ODBC issue
Mastering the JDBC SQL Gateway	Cache Monitor (^MONMGR)/System Monitor and Email Alerts - No 'OK' messages are send!
November 22, 2016 – Alert: Database Integrity on UNIX® and Linux Platforms	timeout value
InterSystems Data Platforms and performance – Part 8 Hyper-Converged Infrastructure Capacity and Performance Planning	%file RemoveDirectory
Cache Tools	Server closed communication device?
MiniM InterConnect	How to declare TSQL variable over JDBC connection?
InterSystems Data Platforms and performance – Part 9 Caché VMware Best Practice Guide	How to set a beutiful name for settings field in BusinessOperation
	Decode Base64 into a file
	creating a UTF8 encoded files
	How do you iterate through SQL in Cache ObjectScript; and across namespaces?
	How do I log terminal output to file automatically?
	Copy namespace mappings programmatically
	How do you ensure synchronisation between two %ZEN.Component.tablePane objects?
	How to rename a Caché-Instance on Windows
	Cache up in emergency mode
	ODBC and PHP - Special characters - Ubuntu KO - Windows OK
	Looking for examples of Cache Password Pattern specifications
	bitwise integer arithmetic
	spatial data
	SQL and indexing on collection properties
	Persistent Classes and Transient SQL Calculated/Computed properties

Caché Objects
Installing InterSystems Python binding on MAC with El Capitan (10.11) or later	File size.
Exploring Code Generation with Caché Method Generators	MakeDirectory
	Convert %ArrayOfDataTypes to array, and back again
	Carriage Return in OBX5.5 that is a base64 PDF
	web service
	2 Skipping SET due to compare and swap failed on - in CConsole Log
	ERROR #5034: Invalid status code structure
	audit login failures, how to trace?
	To access object property value, performance wise whats fast method ?
	Unexpected ROLLFAIL error in an object %Save() call
	Soap Response performance
	Decode Base64 into a file
	How do you iterate through SQL in Cache ObjectScript; and across namespaces?
	Persistent Classes and Transient SQL Calculated/Computed properties

Caché ObjectScript (COS)
Importance and Collection of Exact Version Information ($zv / $zversion)	html beautifier
How to convert LDAP date time stamps into Cache $HOROLOG	iKnow - Text categorization "Category 1 covers the whole dataset"
Using Embedded SQL in Caché Object Script Part #1	Simple Arithmetics
	cmd command not working on terminal
	Round to next whole number
	Convert %ArrayOfDataTypes to array, and back again
	SOAP Fault handling with ERROR #5659: Property '%ZHSLIB.Audit.LogParticipant::Log' required
	Decode Base64 into a file
	URL Link Download of Document
	How do you iterate through SQL in Cache ObjectScript; and across namespaces?
	Create Namespace snippet
	Cache Syntax - Directory Exists
	Text File Fixed Format

Change management
Vote here - Should Portal's schema editors respect source control?	How to export class package in xml

Code snippet
	SOAP Fault handling with ERROR #5659: Property '%ZHSLIB.Audit.LogParticipant::Log' required

Compatibility
	macOS with 2017.1 and later
	When upgrading a Health Connect, do I have to recompile?
	Accessing selfmade sys namespace csp class through normal namespace

Continuous Integration
	InterSystems and containers

CSP
	LogoutAll
	&SQL in Cache Server Page
	How to bypass the log-in screen while navigating between 2 .CSP files in different namespaces
	DB access from CSP page without creating link table
	Client name in %CGIEVAR("HTTP_COOKIE")

Cubes
	MDX QUERY
	Sorting Numeric Dimensions

Dashboards
Sample of IHE Performance monitoring dashboard	Sorting Numeric Dimensions
Building and using Plugins in DeepSee	Creating text box widget
	DeepSee: Filtering a filter

Data Transformation (DTL)
	Carriage Return in OBX5.5 that is a base64 PDF
	Duplicate Patients in FHIR Repository
	Decode Base64 into a file
	URL Link Download of Document
	Text File Fixed Format

Databases
Returning Disk Space to File Systems	Connect Cache client to GT.M database
November 22, 2016 – Alert: Database Integrity on UNIX® and Linux Platforms	File size limit for upload/download
	DataBase Configuration
	Server closed communication device?

Debugging
Mysterious errors when running common commands!

DeepSee
Importance and Collection of Exact Version Information ($zv / $zversion)	What are the Roles needed with HealthShare to get access to DeepSee functionality?
Accessing a new DeepSee Namespace for the first time	Accessing Error Logs to See Build Problems and Update Problems with Cubes
Fixing errors found when attempting to view a DeepSee listing	MDX Calculated measure help in DeepSee
DeepSee – Less records built than rows in source table	DeepSee: Filtering a filter
	Accessing Deepsee plugin in MDX

Deployment
	Copy namespace mappings programmatically

Developer Community
How to convert LDAP date time stamps into Cache $HOROLOG	Comments do not allow attachements
Developer Community Articles and Questions Digest, October 2016	How do I decline an answer?
New InterSystems Developer Community Moderator	Chasing the footer - change to pagination
Home page summary doesn't display emoji	Copy text in editor
	Recently Read is incorrect
	Browse by Member
	[bug] subscription counts
	ODBC issue
	Timestamp and notification problems
	This text editor... I swear...
	New tag for the tools for developers

Developer Community FAQ
	featured/sticky posts on the homepage

Development Environment
Mysterious errors when running common commands!	audit login failures, how to trace?
Cache Tools	How can I send a test message into my Healthshare instance?
	How do I log terminal output to file automatically?
	InterSystems and containers

Distributed Data Management
ECP and Process Management API
MiniM InterConnect

Document
	How can I send a test message into my Healthshare instance?
	Attaching a document to an email from HL7

Documentation
Importance and Collection of Exact Version Information ($zv / $zversion)

ECP
ECP and Process Management API

Ensemble
Importance and Collection of Exact Version Information ($zv / $zversion)	Ensemble - Namespace does not supported
2016.2.1 Maintenance Release	Error when starting production
How to - Customize Ensemble Settings	Web server Setup, permission issue
Caché and Ensemble 2017.1 field test now available	Ensemble Business Operation QueueCountAlert
At last! - Ability to Create Namespaces that are not Enabled for Ensemble - Coming in 2017.1	Ensemble Business Process receive Stream , how to push through RecordMapper
Vote here - Should Portal's schema editors respect source control?	How to debug a CSP page
Ensemble Orphaned Messages	Looking for best practice to persist any kind of Email Message through Ensemble
Some strategies on how to manage and decrease space taken by Ensemble system	What are SubProductions?
November 22, 2016 – Alert: Database Integrity on UNIX® and Linux Platforms	How to set a beutiful name for settings field in BusinessOperation
	Decode Base64 into a file
	URL Link Download of Document

Global Summit 2017
Registering for Global Summit 2017 now?

Globals
Ensemble Orphaned Messages

Graph
Sample of IHE Performance monitoring dashboard

HealthShare
Importance and Collection of Exact Version Information ($zv / $zversion)	Healthshare FHIR Subscriptions
Sample of IHE Performance monitoring dashboard	Update the Health Insghts table (HSAA.Patient) based on a changed assigning authority code
How To Display Custom SDA Extensions in the Clinical Viewer (Sneeziness Example)	What are the Roles needed with HealthShare to get access to DeepSee functionality?
Changing the Registry Endpoint to the "/services" URL after Upgrading	When upgrading a Health Connect, do I have to recompile?
November 22, 2016 – Alert: Database Integrity on UNIX® and Linux Platforms	High level explanation of how you would "attach" nondiscrete documents to a patient record?
Featured InterSystems Online Video: Health Insight Overview Using DICOM Modality Worklists with HealthShare Health Connect	How can I send a test message into my Healthshare instance?
	Duplicate Patients in FHIR Repository
	[Answered] What are Healthshare AP and Healthshare Personal Community?

High Availability
	timeout value

HL7
	How can I send a test message into my Healthshare instance?
	SOAP Operation giving "Not Registered" error
	Create EnsLib.HL7.Message from %String or file?
	Decode Base64 into a file
	URL Link Download of Document
	Attaching a document to an email from HL7
	Text File Fixed Format

HTML
Working with javascript files in Atelier	html beautifier

iKnow
Bachelor thesis: Automated quality rating of emergency calls using NLP	iKnow - Text categorization "Category 1 covers the whole dataset"
Getting started with Text Categorization

Interoperability
Yes, you can use RMS file on OpenVMS	High level explanation of how you would "attach" nondiscrete documents to a patient record?
Can I use Microsoft Office automation components with Cache?

Java
Mastering the JDBC SQL Gateway	External monitoring of Ensemble and metrics

JavaScript
Working with javascript files in Atelier

JDBC
Mastering the JDBC SQL Gateway

JSON
Working with javascript files in Atelier	Binary Support in JSON?

Languages
Caché Localization Manager or i18N in InterSystems Caché

LDAP
How to convert LDAP date time stamps into Cache $HOROLOG

Localization
Caché Localization Manager or i18N in InterSystems Caché

Management Portal
Importance and Collection of Exact Version Information ($zv / $zversion)	Ensemble - Namespace does not supported
	Copy namespace mappings programmatically

MDX
Building and using Plugins in DeepSee	MDX QUERY
	Newbie Question for creating a this period/same period last year comparison
	MDX Calculated measure help in DeepSee
	Accessing Deepsee plugin in MDX

Monitoring
SYSLOG - what it really is and what it means	Ensemble Business Operation QueueCountAlert
Ensemble Orphaned Messages	Cache Monitor (^MONMGR)/System Monitor and Email Alerts - No 'OK' messages are send!
Email alerts for cconsole.log messages using ^MONMGR	External monitoring of Ensemble and metrics

Namespaces
	Ensemble - Namespace does not supported
	Create Namespace snippet
	Copy namespace mappings programmatically

Objects
	How to work out the cause of a STORE error

ODBC
	How to declare TSQL variable over JDBC connection?
	ODBC and PHP - Special characters - Ubuntu KO - Windows OK

ODBC/JDBC
Sample of IHE Performance monitoring dashboard	Server closed communication device?
Mastering the JDBC SQL Gateway	How to declare TSQL variable over JDBC connection?

Online Learning
Featured InterSystems Online Video: Health Insight Overview Using DICOM Modality Worklists with HealthShare Health Connect

Performance
Extracting pButtons data to a CSV file on Windows

Resources
Mysterious errors when running common commands!

REST Services
	How to force HTTP status response using EnsLib.REST.Service
	Binary Support in JSON?
	How to use REST Service with https

Roles
Mysterious errors when running common commands!

Security
How to convert LDAP date time stamps into Cache $HOROLOG	LogoutAll
Mysterious errors when running common commands!	Looking for examples of Cache Password Pattern specifications

SQL
Introduction to Outlier Selectivity	What is Block Count in TuneTable results?
Sample of IHE Performance monitoring dashboard	How do i retrieve values for specific production settings from Ens_Config.Item using SQL Query in Management Portal
Using Embedded SQL in Caché Object Script Part #1	Unexpected ROLLFAIL error in an object %Save() call
Mastering the JDBC SQL Gateway	Update several rows in SQL statement at Management Portal
The Art of Mapping Globals to Classes (3 of 3)	DrawTableError in Management Portal SQL Utility
	Server closed communication device?
	How to declare TSQL variable over JDBC connection?
	How do you iterate through SQL in Cache ObjectScript; and across namespaces?
	Is there a tool to get the slowests queries ?
	Persistent Classes and Transient SQL Calculated/Computed properties

SSL and Certificates

Studio
Wireshark installer could affect Studio.exe and csystray.exe on Windows	Connect Cache client to GT.M database
	File size limit for upload/download
	Studio View > Inspector in Atelier?

System Admin
Extracting pButtons data to a CSV file on Windows	How can I send a test message into my Healthshare instance?
Importance and Collection of Exact Version Information ($zv / $zversion)	Looking for examples of Cache Password Pattern specifications
Feature Tracker in 2017.1	InterSystems and containers
Returning Disk Space to File Systems
InterSystems Data Platforms Capacity Planning and Performance Series Index
InterSystems Data Platforms and performance – Part 8 Hyper-Converged Infrastructure Capacity and Performance Planning
InterSystems Data Platforms and performance – Part 9 Caché VMware Best Practice Guide

Tips & Tricks
Extracting pButtons data to a CSV file on Windows	Copy namespace mappings programmatically
Importance and Collection of Exact Version Information ($zv / $zversion)
How to convert LDAP date time stamps into Cache $HOROLOG
Mysterious errors when running common commands!
New WRC User Interface Video
Resolving Caché Printer Problems in Windows
How to - Customize Ensemble Settings
What is a core file, and when are they useful?
SYSLOG - what it really is and what it means
Tip to look Atelier more mac stylish only for Mac users
InterSystems Data Platforms Capacity Planning and Performance Series Index
Ensemble Orphaned Messages

Unstructured Data
Bachelor thesis: Automated quality rating of emergency calls using NLP
Getting started with Text Categorization

Users
	Startup Tag^Routine property for UnknownUser
	Looking for examples of Cache Password Pattern specifications

Web Development
Caché Localization Manager or i18N in InterSystems Caché	LogoutAll
Working with javascript files in Atelier	Best way to redirect to home page when logging into 'middle' of application?
	%CSP.Websocket and Timeouts
	How do you ensure synchronisation between two %ZEN.Component.tablePane objects?
	ODBC and PHP - Special characters - Ubuntu KO - Windows OK
	socket listen port IP

Web Services
	WebSocket proxy to telnet
	How to log out from a web application?
	web service
	SOAP Fault handling with ERROR #5659: Property '%ZHSLIB.Audit.LogParticipant::Log' required
	How can I send a test message into my Healthshare instance?

ZEN
	Why my ZEN report displays ok in xml mode but not xlsx excel
	Adding parameter to ZEN dataCombo at runtime from server
	Error while generating HTML report in zen pages
	How do you ensure synchronisation between two %ZEN.Component.tablePane objects?
	Zen client methods and inheritance
October 2016 Digest September 2016 Digest