I need to record all incoming email into data classes.
After asking around , no-one has come up with an answer, I have confirmed that is is being done.
The application is in the cloud and the customer exchange server is in house.
I need to record all incoming email into data classes.
After asking around , no-one has come up with an answer, I have confirmed that is is being done.
The application is in the cloud and the customer exchange server is in house.
Is their a way to (setup) automate the removal of users accounts from the system once they have logged out of cache and than recreate them once they log in, so basically the user list only contains live logged in users plus some of the default user accounts.
Hi,
Can we create a new class in the studio using any command rather then using the Menu Item Option from Menu Bar in Studio .
Requirement : Create/Draft a new class and able to extends the other classes using a command in Cache Class .
In other words , I want to Dig in the Menu Item class from which Menu bar is created in studio and option are provided Like New..., Open..., etc
Thanks,
Ravi
I'm running this code in our application, and in the terminal:
>set query="SELECT * FROM PMG_Data_Private.RemitInstance WHERE (VoucherNumber %INLIST ? SIZE ((10)))"
>set tRS = ##class(%ResultSet).%New("%DynamicQuery:SQL")
>set ok=tRS.Prepare(query)
>d $system.Status.DisplayError(ok)
ERROR #5540: SQLCODE: -76 Message: Cardinality mismatch between the SELECT-list and INTO-list
SQLTEXT: SELECT * FROM PMG_Data_Private.RemitInstance WHERE (VoucherNumber %INLIST ? SIZE ((10)))
It's not really a problem with the query, since there's no INTO keyword int he query, and I'm not getting it on QA or a produc
Hi!
We would like to retry message so that it's restored to end of operation's queue. This is in situation where order of messages is not needed to be handled by Ensemble, there is version number in message data and receiving application can ignore incoming message if necessary.
We would try to send message until it's accepted (or manually suspended), but this should not block operation's queue.
We have already this in actions:
D - Disable the Operation, log an error and restore the message to the front of the Operation's queue.
Would be nice to have one like this:
Q - Disable the Operation, log an
Hi all,By using LDAP cache method ##Class(%SYS.LDAP).GetValuesLen(LD,CurrentEntry,Attribute) we get the list of attributes but in "ObjectSid" attribute have the SID in binary format(objectSid^U¤:c@ãºþÕLCP]). how to convert to the readable format from the binary format in cache side. Please help us to proceed further
Hi Community!
I want to share with you my impressions of Global Summit 2018.
It was my first time in the USA and my first Global Summit. And I can say that it was really amazing trip and a great experience!

I have been building Business Processes in Ensemble for a few months and in a process i'd use a combination of data from the request that started the process and context variables that where filled by earlier calls in the process as input for a data transformation. I do not know how to achieve that.
What I do currently is that in my process I first call a data transformation and then make a call to an operation. For the data transformation I use as input the request that started the business process and as output the request that I will use to initiate the call to the operation. The latter I de
Hi, Community!
I'm pleased to announce that InterSystems Open Exchange is now operating and available for everyone!
This code snippet provides a ZEN page that downloads a stream from its database directly:
/// We assume that you have stored your data within this schema:
/// MyApp.Model.Storage: Filename,FileSize,Content,ContentType
Class zen.downloadStream Extends (%ZEN.Component.page,%CSP.StreamServer)
{
/// Wrapper to get the id of the download, we assume that the id is passed to this zen page
/// as a URI parameter, i.e.: MyApp.Downloads.cls?OID=1234
ClassMethod GetId()
{
Quit $Get(%request.Data("OID",1))
}
/// Set the appropriate header for the file.
ClassMethod OnPreHTTP() As %Boolean
{
Set tId = ..GetId()
If ##Class(MyApp.Model.Storage).%ExistsId(tId) {
Set tStream = ##Class(MyApp.Model.Storage).%OpenId(tId)
// You could "guess" the content type by its file extension
// or you can store it (before) in the database separately (like in this example).
// Set Extension = $Piece(tStream.Filename,".",$Length(tStream.Filename,"."))
// Set ContentType = ..FileClassify(Extension)
Set %response.ContentType = tStream.ContentType
Do %response.SetHeader("content-disposition","attachment; filename="_tStream.Filename)
Do %response.SetHeader("Content-Length",tStream.FileSize)
}
Else {
Set %response.Status="404 File Not Found"
Quit 0
}
Quit $$$OK
}
ClassMethod OnPage() As %Status
{
Set Download = ##Class(MyApp.Model.Storage).%OpenId(..GetId())
Do Download.Content.OutputToDevice()
Quit $$$OK
}
}
Link to code on GitHub
Hi, Community!
Just came back from Global Summit 2018 and want to share my impressions.
Key highlights of my choice:
1. The announcement of a new InterSystem Data Platform: InterSystems IRIS for Health!
2. Community and Express licensing for InterSystems IRIS
3. The Launch of InterSystems Open Exchange - the gallery of InterSystems Solutions, Tools, Technology examples, Adapters, and Interfaces! E.g. test coverage tool and Ethereum Blockchain Adapter

Hello!
Is it possible to use Cache Studio on a Linux operating system? Maybe there are similar tools for Linux?
Hi all,
I'm pleased to announce this personal project to convert a number to text, in spanish, english, catalan and russian.
the aim of this function is to convert numbers into text. It allows a maximum number of 15 digits.

I have created some roles, and would like to know if there is a way to export the Roles and save them off to a file? I want to create a backup file of these roles for DR purpose, and in case I ever get hit by the preverbal bus.
Thanks
Scott Roth
The Ohio State University Wexner Medical Center
Hello,
I am a beginner with Object Script and I hope anyone can help me solving my questions.
1. Is there a way to time a loop in Object Script?
2. My code leads to the following error, even though it executes the method.
Is there a way to ignore this specific error, so that I can repeat my code in a time loop over and over again without stopping?
<<THROW>%CreateProperty+85^%DocDB.Database.1 *%Exception.StatusException FEHLER #5805: Der ID-Schlüssel ist nicht eindeutig im Extent '%Dictionary.PropertyDefinition' : '^oddDEF("db.stream","a","Datum")' ist bereits vorhanden. Speicherort des ID-Zählers
Hi all. We are going to find duplicates in a dataset using Apache Spark Machine Learning algorithms.
Note: I have done the following on Ubuntu 18.04, Python 3.6.5, Zeppelin 0.8.0, Spark 2.1.1
In previous articles we have done the following:
In this series of articles, we explore Machine Learning and record linkage.
Imagine that we merged databases of neig

Hi
Anyone worked on "ccontrol list " command execution through Cache Object Scripting.
I executed through bat file passing this ../bin ccontrol list . Icould not get the results through COS but executed in command prompt
it pops up with notepad and list down Cache instances.
Need help here to address the same stuff through cache object scripting.
Hello everyone,
i want to create an iris document database with Atelier with some properties, where i can import my JSON formatted data from an API to the database which i created. Right now i know how to import my local JSON formatted data to my created database:
ClassUser.Classtest
{
ClassMethodgetFile()as%Status
{
setfilename="/home/student/Downloads/own_scrobble.json"
IF$SYSTEM.DocDB.Exists("db.Streamingdatabase"){
SETdb=##class(%DocDB.Database).%GetDatabase("db.Streamingdatabase")
Hi,
This is available on github and wairing for approval on the Open Exchange.
It allows you to
Hey folks,
I've shared a debug stack we created on the Open Exchange.
I want to post the link here, but need the link to this article for the Open Exchange. Which came first, the chicken or the egg? ![]()
The github link:
https://github.com/stefanc82/Cache-Debug-Stack
Hi folks,
I've created a datatype class whoch extends from %Library.String with a REGEX parameter and the validation of the value against the regular expression. The class does not support Populate using the regular expression as a template for data population.
Hi, Community!
It's October! And we have DC October 2018 release here!
What's cool?
See the details inside!
Newbie question.
We have a desire to leverage apigee to do a call to our MPI system.
Not sure if this is something we can do via HealthShare.
Anyone doing a soap request or restful call from InterSystems through Apigee?
If I am overlooking the obvious (documentation) any guidance is greatly appreciated.
Thanks in advance
Hello World;
i have a problem to call function from cache ,
cache-call:functioninmaccache^MyFileMac(" + id+ ")
This rule works but always gives the same link
thanks for yours response
Can anyone tell me where to find good resources to learn Caché besides InterSystems. I am looking foe material (ie books, white paper, exercises, ect). There does not seem to be a lot of information on Caché.
Thank you for all of your help
Justin
Using our cool new debugging extension for Visual Studio Code I'm trying to debug a CreateProjection method of a class, but when I compile it the work apparently gets done in one of the worker jobs, so my breakpoint never triggers.
Is there a compiler flag or qualifier to force the compilation to be done in-process rather than getting handed off to a worker job?
You have a global ^CODE("TNO","BIO",291,"AKI") that may or may not exist. On the data side of the global ref it can have a boolean value of 0 (false) or 1 (true) and this global is wrapped up in a Caché class accessible from myobject.AKI property. At the object level, how do you check whether the property is defined ie. is there a $DATA equivalent for Cache Object properties? Also, how would you kill /null the property as opposed to making the value 0 (false) or an empty string?
I did a clean install of InterSystems ensemble on a new computer. However, even though my OS and my browser are set the English, the Ensemble installation is in dutch. Does anyone know how I can change the language of my InterSystems Studio so that it is in English?
Hi All,
I need urgent help,
I want to export the values from Global to CSV file.
Values are in global are :
^Global1(1)="1,2,3,4"
^Global1(2)="5,6,7,8"
.
.
.
^Global1(n)="n,n,n,n"
I want output in CSV File as:
1,2,3,4
5,6,7,8
.
.
.
n,n,n,n
I made a class:
ClassMethod ExportNewSchemaGlobals(pFile)
{
Set ary("^Global1")=""
Set pFile = "C:/Test.csv"
Set ary = ##class(%Library.Global).Export(,.ary,pFile)
}
Hello,
I have a question about creating properties with curl.
I already did create properties in Java with the following command.
<DO db.%CreateProperty("TotalSteps","%Integer","$.TotalSteps")>
It created the property TotalSteps with the type %Integer and the data path $.TotalSteps (since the header of my data source is also TotalSteps).
Now I would like to create the same property in curl with the following command
<curl -i -X POST -H "Content-Type: application/json" http://localhost:53774/api/docdb/v1/namespaceName/prop/databaseName/ propertyName?type= propertyType& path= propertyPath&