Hi, Community! Here is the digest of Articles and Questions published on InterSystems Developer Community in November 2016. **Most viewed** [Caché and Ensemble 2017.1 field test now available](https://community.intersystems.com/node/420726)  212 [Simple Arithmetics](https://community.intersystems.com/node/420426)  179 [Reflection in Caché](https://community.intersystems.com/node/419981)  177 [Importance and Collection of Exact Version Information ($zv / $zversion)](https://community.intersystems.com/node/419882)  162 [How do you iterate through SQL in Cache ObjectScript; and across namespaces?](https://community.intersystems.com/node/421891)  129 [Connect Cache client to GT.M database](https://community.intersystems.com/node/420286)  128 [Round to next whole number](https://community.intersystems.com/node/420596)  128 [How to work out the cause of a STORE error](https://community.intersystems.com/node/421081)  121 [Caché Localization Manager or i18N in InterSystems Caché](https://community.intersystems.com/node/421166)  118 [InterSystems Data Platforms Capacity Planning and Performance Series Index](https://community.intersystems.com/node/421441)  117   **Most voted** [SYSLOG - what it really is and what it means](https://community.intersystems.com/node/421016)  12 [Importance and Collection of Exact Version Information ($zv / $zversion)](https://community.intersystems.com/node/419882)  10 [Wireshark installer could affect Studio.exe and csystray.exe on Windows](https://community.intersystems.com/node/420206)  8 [Bachelor thesis: Automated quality rating of emergency calls using NLP](https://community.intersystems.com/node/420156)  7 [Mysterious  <command></command>errors when running common commands!](https://community.intersystems.com/node/420211)  7 [New InterSystems Developer Community Moderator ](https://community.intersystems.com/node/420376)  6 [Caché and Ensemble 2017.1 field test now available](https://community.intersystems.com/node/420726)  6 [Vote here - Should Portal's schema editors respect source control?](https://community.intersystems.com/node/420896)  6 [Returning Disk Space to File Systems](https://community.intersystems.com/node/421021)  6 [Exploring Code Generation with Caché Method Generators](https://community.intersystems.com/node/421841)  6   **Most commented** [Update several rows in SQL statement at Management Portal](https://community.intersystems.com/node/421626)  11 [DB access from CSP page without creating link table](https://community.intersystems.com/node/421046)  9 [How to export class package in xml](https://community.intersystems.com/node/421861)  9 [creating a UTF8 encoded files](https://community.intersystems.com/node/421871)  9 [Connect Cache client to GT.M database](https://community.intersystems.com/node/420286)  8 [How to log out from a web application?](https://community.intersystems.com/node/420676)  8 [How to work out the cause of a STORE error](https://community.intersystems.com/node/421081)  8 [Round to next whole number](https://community.intersystems.com/node/420596)  7 [What the Cache class to find the NodeName](https://community.intersystems.com/node/421206)  7 [Customizing DeepSee time level within date hierarchy](https://community.intersystems.com/node/421726)  7   **By Tags**
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 DigestSeptember 2016 Digest