Developer Community Articles and Questions Digest, October 2016 |

Articles	Questions
.NET
	Ensemble + .Net dll with MS Word

Administration
Why KeepIntegrity Is Important When Purging HealthShare/Ensemble Data	Hourly Scheduled Task
Handling Date and Time Operations in Caché	Slave Write Daemons

Analyzer
	How to do a TOP 15 Payers and Percent of Total Paid

APIs
	Invalidate DeepSee Result Cache for a Specific Cube

Atelier
Deltanji 6.1 - new release of the integrated native source code management tool for Caché, Ensemble, HealthShare	Unable to create a new Atelier Server connection
Ensemble XML VDoc Schema Editing	Classes removing and renaming best practice with Atelier
	"auto insert" template in Atelier?

Auditing
	"Disclosure Report" (access audit) for multiple patients?

Authorization
	Authorization (OAuth 2.0) failure due to mismatch server name (SSL Cert)

Backup
October 11, 2016 – Alert: Caché Online Backup and Journal Restore	Shadowing between Caché 5.0.21 and 2016.2.0?
How to cope with "October 11, 2016 – Alert: Caché Online Backup and Journal Restore" in non-patched (yet) Caché 2015.x

Beginner
RESTful way of data transfer	Can't get access to the Management Portal
How to dismount/mount a database programmatically	%XML.TextReader - Looping Through Elements?
RESTful Exception Handling	execute .exe
How to execute terminal commands from a webpage	Cache deleting users
RESTful API	parsing xml to list of object issue
Lines of Code	Cache security
How to write COS code inside a unix script	HTTP Post through Cache
Macros in the InterSystems Caché	Export CSV
Creating an Ensemble MicroService using RESTful Web Services	Are we using callin API?
Applying MicroServices Architecture to Ensemble	LDAP Adapter - Credentials?
NewBie's Corner Session 22 Parameters Part III	Upgrade to Ensemble 2016
NewBie's Corner Session 21 Parameters Part II	Call Java package from Caché
Ensemble XML VDoc Schema Editing	Is it possible to use non /csp/ for SMP
Ensemble's Workflow Inbox portal	Operators
	Community Feedback about saving a post but not yet releasing it
	Zen Excel Report
	Importing XML to a Caché Object

Business Operation
	SOAP Client Web Service Exception Handling
	RabbitMQ Integration

Business Process (BPL)
Ensemble: How to embed a PDF file into an HL7 message	SOAP Client Web Service Exception Handling
	ProvideAndRegisterRequest to HS.Message.XMLMessage Transformation

Business Rules
	Rule Editor - Property Does Not Exist - PID:PatientIDInternalID()
	Multiple Rulesets

Business Service
	RabbitMQ Integration

Caché
Data Platforms and Performance - Part 7 ECP for performance, scalability and availability	Cache 2008 ODBC issue with PHP 5.6
Internal Structure of Caché Database Blocks, Part 1	Any changes in support of Spooler in newest versions
Tips & Tricks - SQL to Excel	How to connect to JDBC database using SQL Gateway?
How to Parse a URL in Caché	Calling $ZF(-1) and $ZF(-2) from within Cache Studio on Windows
How to add a parameter to a class programmatically	Setting properties on GlobalBinary stream
How to dismount/mount a database programmatically	[Solved]Reset the cursor of a Query (resultset)
Tips & Tricks - Automatic removal of system methods from codebase	Restarting Cache from inside
Caché and Ensemble 2016.2.0 Release	PDFs from COS
Internal Structure of Caché Database Blocks, Part 2	Has anyone succeeded to expose some metrics for prometheus ?
October 11, 2016 – Alert: Caché Online Backup and Journal Restore	Cache deleting users
How to execute terminal commands from a webpage	Duplicates for EVERY HS.Message.PatientSearchRequest?
How to cope with "October 11, 2016 – Alert: Caché Online Backup and Journal Restore" in non-patched (yet) Caché 2015.x	HTTP Post through Cache
Lines of Code	Export CSV
2015.2.5 Maintenance Release	How do you add a Total Phones column populated by SQL COUNT(*) expression in the Zen Quickstart Tutorial?
How to write COS code inside a unix script	LDAP Adapter - Credentials?
Internal Structure of Caché Database Blocks, Part 3	Upgrade to Ensemble 2016
Macros in the InterSystems Caché	%UnitTest Code Coverage
How to replace the CACHE.DAT of a mirrored database (i.e: when you need to upgrade a software version)	Fault reason in SOAP client
Zen Mojo 1.1.2 released	Sql Error Message
NewBie's Corner Session 22 Parameters Part III	Operators
NewBie's Corner Session 21 Parameters Part II	Shadowing between Caché 5.0.21 and 2016.2.0?
Deltanji 6.1 - new release of the integrated native source code management tool for Caché, Ensemble, HealthShare	Source Control dialog box in Cache Studio - pre-Atelier! Cache 2016.1 version and below. Authenticate developer before commit...
New WRC Customer Interface	Is there a way to search a string in all cls codes?
Handling Date and Time Operations in Caché	Zen Excel Report
	Grant Permission for WSDL
	password encryption

Caché Objects
How to write COS code inside a unix script	Any changes in support of Spooler in newest versions
	Using %Populate and Populate method
	Setting properties on GlobalBinary stream
	parsing xml to list of object issue
	Cache security
	Export CSV
	Multicolumn Persistent List/Array Property
	ProvideAndRegisterRequest to HS.Message.XMLMessage Transformation
	How do you add a Total Phones column populated by SQL COUNT(*) expression in the Zen Quickstart Tutorial?
	%UnitTest Code Coverage
	How to track the last modified by user name

Caché ObjectScript (COS)
Tips & Tricks - Automatic removal of system methods from codebase	Convert obj to int/mac
How to execute terminal commands from a webpage
Lines of Code
How to write COS code inside a unix script
Macros in the InterSystems Caché
Ensemble: How to embed a PDF file into an HL7 message
Handling Date and Time Operations in Caché
Max function for the set of parameters

Change management
Tips & Tricks - Automatic removal of system methods from codebase	Classes removing and renaming best practice with Atelier

Code snippet
Tips & Tricks - SQL to Excel
How to add a parameter to a class programmatically
How to dismount/mount a database programmatically
Tips & Tricks - Automatic removal of system methods from codebase
How to execute terminal commands from a webpage
Lines of Code
How to write COS code inside a unix script
How to replace the CACHE.DAT of a mirrored database (i.e: when you need to upgrade a software version)
Ensemble: How to embed a PDF file into an HL7 message
Max function for the set of parameters

Compatibility
	Shadowing between Caché 5.0.21 and 2016.2.0?

CSP
Forwarding Requests in a REST Service	Setting properties on GlobalBinary stream
Manual editing of applicationHost.config in IIS to enable access to CSP Gateway Configuration page	Is it possible to use non /csp/ for SMP

Data Model
	How do you add a Total Phones column populated by SQL COUNT(*) expression in the Zen Quickstart Tutorial?

Data Transformation (DTL)
Ensemble: How to embed a PDF file into an HL7 message	Telepath PMEP File
	Parsing EDI 271 input into JSON output
	ProvideAndRegisterRequest to HS.Message.XMLMessage Transformation
	In the Ensemble DTL, how do you test if an XML element exists in the source document

Databases
Internal Structure of Caché Database Blocks, Part 1	Shadowing between Caché 5.0.21 and 2016.2.0?
How to dismount/mount a database programmatically	Mounting ECP Application Databases Read Only
Internal Structure of Caché Database Blocks, Part 2
Featured InterSystems Online Course: Designing Productions
Internal Structure of Caché Database Blocks, Part 3
How to replace the CACHE.DAT of a mirrored database (i.e: when you need to upgrade a software version)

Debugging
	Calling $ZF(-1) and $ZF(-2) from within Cache Studio on Windows

DeepSee
DeepSee Troubleshooting Guide	Invalidate DeepSee Result Cache for a Specific Cube
Ensemble's Workflow Inbox portal	DeepSee Overview Document

Developer Community
Developer Community Articles and Questions Digest, September 2016	Date for post published from draft
Markdown workflow for creating Community posts	Suggestion to enhance products
InterSystems UK Technology Summit 2016 started!	Empty emails form community
Bad format/layout to be fixed	Please shut down Google Groups and redirect here
Developer Community Update	Modify search feature
Faulty heading on Member page	Modify search summary view
2000 Members on DC!	[Feature Request] Mark Accepted Answer, indicate Answered questions
Developer Community update: new favorites and subscriptions	[Feature Requst] Default "Group" dropdown to current community
	[bug] Some Index Filters don't work properly
	How do I get the rss feed for the cache group to work? aggregator
	Create Global Summit 2017 tags
	topic vs tag?
	Removing my account from the community site
	Edit to group description
	Analytics menu item open in new window
	Exporting and Importing Roles, Resources and Users
	Ways to make NewBie post stand out.
	Better Tag Cloud needed

Developer Community FAQ
Markdown workflow for creating Community posts	topic vs tag?

Development Environment
How to write COS code inside a unix script	Source Control dialog box in Cache Studio - pre-Atelier! Cache 2016.1 version and below. Authenticate developer before commit...
Deltanji 6.1 - new release of the integrated native source code management tool for Caché, Ensemble, HealthShare

Distributed Data Management
	Shadowing between Caché 5.0.21 and 2016.2.0?

Document
Top 10 NoSQL Databases

Documentation
Sneak peek at the new documentation search	Exporting and Importing Roles, Resources and Users

ECP
Data Platforms and Performance - Part 7 ECP for performance, scalability and availability	Mounting ECP Application Databases Read Only

Encryption
	password encryption

Ensemble
RESTful way of data transfer	How to connect to JDBC database using SQL Gateway?
RESTful Exception Handling	execute .exe
Caché and Ensemble 2016.2.0 Release	Parsing EDI 271 input into JSON output
October 11, 2016 – Alert: Caché Online Backup and Journal Restore	Upgrade to Ensemble 2016
How to cope with "October 11, 2016 – Alert: Caché Online Backup and Journal Restore" in non-patched (yet) Caché 2015.x	Ensemble Event Log
RESTful API	Is there a way to search a string in all cls codes?
Ensemble: Introduction to Pool Size for Business Processes	Exporting and Importing Roles, Resources and Users
2015.2.5 Maintenance Release	Ensemble Management Portal
Why KeepIntegrity Is Important When Purging HealthShare/Ensemble Data	Grant Permission for WSDL
Creating an Ensemble MicroService using RESTful Web Services
Applying MicroServices Architecture to Ensemble
Ensemble: How to embed a PDF file into an HL7 message
Deltanji 6.1 - new release of the integrated native source code management tool for Caché, Ensemble, HealthShare
Ensemble XML VDoc Schema Editing

Enterprise Message Bank
	RabbitMQ Integration

Global Summit 2017
Global Summit 2017 - September 10-13th, 2017

Globals
How to execute terminal commands from a webpage

Graph
Top 10 NoSQL Databases

HealthShare
Featured InterSystems Online Course: Health Insight Overview	How to connect to JDBC database using SQL Gateway?
Deltanji 6.1 - new release of the integrated native source code management tool for Caché, Ensemble, HealthShare	Does anyone else have a dashboard for quick and easy access to key metrics?
	"Disclosure Report" (access audit) for multiple patients?
	Does anyone know what SearchMode is for a PatientSearchRequest?
	Duplicates for EVERY HS.Message.PatientSearchRequest?
	ProvideAndRegisterRequest to HS.Message.XMLMessage Transformation
	Grant Permission for WSDL

High Availability
	ISCAgent Auto-Startup in a Mirror Configuration on a Veritas Cluster

HL7
Featured InterSystems Online Course: Designing Productions	Rule Editor - Property Does Not Exist - PID:PatientIDInternalID()
Ensemble: How to embed a PDF file into an HL7 message	Best way to strip diacritic signs from HL7 message.

Interoperability
	Are we using callin API?

Java
	Call Java package from Caché

Journaling
	Has anyone succeeded to expose some metrics for prometheus ?
	Shadowing between Caché 5.0.21 and 2016.2.0?

JSON
Forwarding Requests in a REST Service	Parsing EDI 271 input into JSON output

Key Value
Top 10 NoSQL Databases

LDAP
	LDAP Adapter - Credentials?

Management Portal
	Can't get access to the Management Portal
	Is it possible to use non /csp/ for SMP
	Exporting and Importing Roles, Resources and Users
	Ensemble Management Portal

Mirroring
How to replace the CACHE.DAT of a mirrored database (i.e: when you need to upgrade a software version)	ISCAgent Auto-Startup in a Mirror Configuration on a Veritas Cluster
	ISCAgent debug

Monitoring
	%UnitTest Code Coverage

Namespaces
Featured InterSystems Online Course: Designing Productions

Objects
How to execute terminal commands from a webpage

ODBC
	Cache 2008 ODBC issue with PHP 5.6

ODBC/JDBC
	Data extraction using SQL Via ODBC

Online Learning
Featured InterSystems Online Course: Designing Productions
Featured InterSystems Online Course: Health Insight Overview

Other Protocols
Ensemble to RabbitMQ Java Client Quick Start Guide

Performance
Excessive memory usage caused by processes invoking JAVA 6 on AIX 7

Plugins
	%UnitTest Code Coverage

Privileges
	Exporting and Importing Roles, Resources and Users

Relational Tables
	Multicolumn Persistent List/Array Property

Resources
	Exporting and Importing Roles, Resources and Users

REST Services
Forwarding Requests in a REST Service	RSS Feed problems
RESTful way of data transfer
RESTful Exception Handling
RESTful API
Creating an Ensemble MicroService using RESTful Web Services
Applying MicroServices Architecture to Ensemble

Roles
	Exporting and Importing Roles, Resources and Users
	Ensemble Management Portal
	Mounting ECP Application Databases Read Only

Security
	"Disclosure Report" (access audit) for multiple patients?
	Cache security
	Exporting and Importing Roles, Resources and Users
	Ensemble Management Portal
	password encryption

SQL
Tips & Tricks - SQL to Excel	How to connect to JDBC database using SQL Gateway?
	ELI5: How does selecting 400,000 records take 12 seconds but selecting 500,000 records take ... to be determined?
	"Disclosure Report" (access audit) for multiple patients?
	How do you add a Total Phones column populated by SQL COUNT(*) expression in the Zen Quickstart Tutorial?
	Total Timestamp Confusion, please help.
	Data extraction using SQL Via ODBC
	Ensemble Management Portal

SSL and Certificates
	Authorization (OAuth 2.0) failure due to mismatch server name (SSL Cert)

Studio
Deltanji 6.1 - new release of the integrated native source code management tool for Caché, Ensemble, HealthShare	Calling $ZF(-1) and $ZF(-2) from within Cache Studio on Windows
	Download just the Studio?
	Source Control dialog box in Cache Studio - pre-Atelier! Cache 2016.1 version and below. Authenticate developer before commit...

SVN
	Source Control dialog box in Cache Studio - pre-Atelier! Cache 2016.1 version and below. Authenticate developer before commit...

System Admin
Data Platforms and Performance - Part 7 ECP for performance, scalability and availability	Upgrade to Ensemble 2016
Internal Structure of Caché Database Blocks, Part 1	ISCAgent debug
Internal Structure of Caché Database Blocks, Part 2	Hourly Scheduled Task
How to cope with "October 11, 2016 – Alert: Caché Online Backup and Journal Restore" in non-patched (yet) Caché 2015.x	password encryption
How to write COS code inside a unix script
Internal Structure of Caché Database Blocks, Part 3
How to replace the CACHE.DAT of a mirrored database (i.e: when you need to upgrade a software version)

Tips & Tricks
DeepSee Troubleshooting Guide
Tips & Tricks - SQL to Excel
How to Parse a URL in Caché
How to add a parameter to a class programmatically
How to dismount/mount a database programmatically
Tips & Tricks - Automatic removal of system methods from codebase
How to execute terminal commands from a webpage
Lines of Code
Macros in the InterSystems Caché
How to replace the CACHE.DAT of a mirrored database (i.e: when you need to upgrade a software version)
Ensemble's Workflow Inbox portal
Max function for the set of parameters

Users
	Exporting and Importing Roles, Resources and Users

Web Development
How to Parse a URL in Caché	Usins inputtype : select in MOJO
How to execute terminal commands from a webpage
Zen Mojo 1.1.2 released

Web Services
	how configure Ensemble web service to use HTTP Basic authenication

X12
	Parsing EDI 271 input into JSON output

XML
Forwarding Requests in a REST Service	%XML.TextReader - Looping Through Elements?
	parsing xml to list of object issue
	Importing XML to a Caché Object

ZEN
	How do you add a Total Phones column populated by SQL COUNT(*) expression in the Zen Quickstart Tutorial?

ZEN Mojo
Zen Mojo 1.1.2 released
September 2016 digest