Currently, when we want to write data to a file that will be viewed in Excel, we parse the data in tab deliminated format to the file and name it with .xls at the end. That is sent to end users via email. They get a warning that the data is not formatted properly (it's not really an Excel file after all) but it does display somewhat correctly as the tabs are understood (this does not work if we deliminated with commas however).
How can we format the file for Excel?
Hi,
I need to set the label of a custom setting in the portal instead of the name of the associated property, eg.:
Class SomeClass Extends (Ens.BusinessService, %ZEN.Portal.Don't miss this month's newsletter from Learning Services! Get news on the latest content, including:
...plus, as always, upcoming classroom courses! Read February's newsletter, and subscribe today to receive monthly newsletters in your inbox!
Hi,
I'm trying to get the ECP status of 2 servers using $system.ECP.GetProperty("ServerStats") and $system.ECP.GetProperty("ClientStats"), but I'm not able to find the documentation of the values returned:
For example, on the server side I execute this:
USER>w $system.ECP.
Please note: following this guide, especially the prerequisites section requires Intermediate to Advanced level of knowledge of AWS. You'll need to create and manage S3 buckets, IAM roles for EC2 instances, VPCs and Subnets. You'll also need access to InterSystems binaries (usually downloaded via WRC site) as well as IRIS license key.
Aug 12, 2020
Anton Umnikov
Templates Source code is available here: https://github.com/antonum/AWSIRISDeployment
Table of Contents
Hi,
I am using a record map and when the less than symbol < is sent the record mapping fails. How can I escape this character so the record map will not fail.
Hi all,
i‘m traying to run a sql LIKE Query on an attribute datatype LONGVARCHAR.
I also try allready with the SUBSTRING(Attribute,1,...), when i run the query, the resultat is empty without errors.
The Query:
select text from table
where text like ‘%abc%‘
many thx for help
BR
Darko
With ^%SYSMONMGR, there are some brunches that I never found a way to quit out, like shows as the following example: do ^%SYSMONMGR --> Manage Health Monitor --> View Alert Records ...
Does anyone know the answer? thank you very much.
%SYS>do ^%SYSMONMGR
Option? 6
Option? 2 Sensor (=All
Intersystems use JReport as their reporting framework.
Are there any free version available for developers to try it out? If yes, can I avail the link?
Is there any free trial version for 'DeepSee'? if yes, can I avail the link?
Thanks in advance for your feedback.
I used the soap wizard to create a web client based on the wsdl. I was able to get a valid response back, and now it looks like the error is in decrypting the soap message response "inbound"
ERROR #6284: Security header error: SecurityTokenUnavailable.
%objlasterror = error: 0 ìŒSecurityTokenUnavailableÃCPR¹.e^zImportHeader+62^%SOAP.Security.Header.1^1(e^zProcessHeaders+48^%SOAP.WebBase.1^1-e^zProcessSOAPEnvelope+18^%SOAP.WebBase.1^10e^zSOAPRequestResponse+123^%SOAP.WebClient.1^1)e^zInvokeClient+112^%SOAP.WebClient.1^1Dd^zInvoke+2^qcpr.registration.ws.HCValidationPort.one.validate.
Ensemble beginner here. One of the downstream applications requires to send two A02 messages instead of one A17. We do it easily in Cloverleaf - either in translation or TCL. How do I create 2 target messages out of one source message in DTL?
Hi, simple mirror starting for first time, primary server give me :
AddVirtualAddress failed, cannot become primary: Host at...
Some ideas to try ?
Working on RedHat 7 and Iris 2019.2
-Arbiter
-Primary
-Secondary
-Virtual IP
Dear Community,
We're pleased to invite you to the InterSystems Iberia Summit 2020, which will take place from February 18th to 19th in Barcelona, Spain!
You're more than welcome to join us at the Melia Barcelona Sarriá Hotel!
HI I am using below code to retrieve the last inserted ID of the table. It works when we do not set any custom column as IDKey. If we define any column as
IDKey below code does not return any IDKey. I know when i am defining any column as IDKey its not auto generated , but whats the best way to get the ID column value
String sql = "INSERT INTO TestFramework_UI_Data.Execution (TotalTestSteps) VALUES (0)";
//ResultSet rs = createExecutionSt.executeQuery("SELECT * FROM TestFramework_E2E_Data_TestData.TestCases");
int t = createExecutionSt.
Hi, I try to do a JS script into a csp page for a Workflow
The problem is that in Ensemble i don't had troubles but in Iris don't recognize even the console.log inside the script
I attach the code
<form>
<table class="workflowtable">
<CSP:IF CONDITION='%task.%FormValues.IsDefined("montoDeposito")'>
<tr>
<td>
Monto Depositado:
</td>
</tr>
<tr>
<td>
<input type="text"
name="montoDeposito"
value="#(%task.%FormValues.GetAt("montoDeposito"))#">
</td>
</tr>
</CSP:IF>
<CSP:IF CONDITION='%task.%FormValues.
Hi Developers!
I stuck with one interesting problem.
For example, let's use this template repo. If you build this container A using docker-compose and then run the container it exposes REST-API which is available on:
localhost:52773/person/all
The question is how to make this REST-API accessible from another docker container B running on the same machine? E.g. with IRIS 2019.4 Community from this repo?
The problem is that for the second container localhost it's something which belongs to container B.
I think I need to set up a network between containers somehow. E.g. using docker-compose. But is there any simpler way?
Some of you on the Developer Community have probably interacted with @Luca Ravazzolo if you are interested in cloud and container topics... If so, you'll enjoy Episode 2 of our new podcast — we chatted with Luca about Kubernetes and the InterSystems Kubernetes Operator. He does a great job of explaining the technology and its benefits here!
I'm using Cache SQL and want the ability to choose a specific index.
I've boiled the problem down to one table and simplified the query down to
SELECT *
FROM Registration.PatResp
WHERE SchedApptNum=8450022
SchedApptNum is indexed, but instead of using that column, "Show Plan" indicates that it's looping through the entire Registration.PatResp table on Id (the primary key for the table).
I've done a tune-table with no change.
SQL provides %IGNOREINDEX, which allows me to ignore a specific index, but I don't need that. I need the reverse - %CHOOSEINDEX so that I can force SQL to use a specific index.
Hello,
We would like to get the XML which is being given by the requested system, directly to our Service output.
We have tried to just output directly the Message Response as follows:
Method findCandidatesXML(mensEntrada As %XML.GlobalCharacterStream(CONTENT="MIXED")) As Mensajes.Response.GestionPacientes.operacionResponse(XMLNAME="mensSalida") [ Final, ProcedureBlock = 1, SoapAction = "http://SCS.Hi guys,
I need help because I have no idea how to proceed further and documentation does not explaining this solution.
I have XML like this:
<?xml version="1.0"?>
<ProductionPackage xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" JobName="10006_8046_L69">
<Barcode>1200002101</Barcode>
<DueDate>31.12.5000 23:59:59</DueDate>
<BasicMaterial>1.
Hi:
I'm new to Cache and intersystems.
We have a live production solution that uses a file inbound adapter to collect pdf documents off a fileshare. This fileshare is accessed by many services and access is controlled to the files by AD.
A problem we are seeing is that documents either are attempted to be processed with a filesize of 0kb or more often a file gets processed that in the next buisness process then cannot be moved to a working directory and the file does not appear in the archive from the file inbound adapter.
Last week at the InterSystems BeNeLux Symposium, we announced the publication of the InterSystems iKnow Natural Language Processing technology to Open Source. This enables developers and researchers to take advantage of this unique technology at any level of their application stack, workflow or experiment.
Hi,
i have a DTL with generic source request (Inbound TCP).
i have added a parameter in the request class and compiled.
how do i now refresh or resync the DTL so that i see the new added field in the source.
Thanks
Hello everyone 
Here is a try of sending a stream object with %ToJSON() by HTTP POST request on a remote server.
First the JSON structure:
{
"document": {
"id": "{43495441-4445-4C4C-4500-0500129C762E}",
"patient_id": "5003171TC01",
"language": "fr",
"doc_type": "CONS",
"doc_time": "2019-06-12 11:02:00",
(.
This is more a WARNING than a question
Dasha.AI is a platform that allows you to create and manage voice interfaces for your applications. One of Dasha’s distinctive features is that most users believe they are talking to a human, not a robot.
Voice is the most natural way for people to interact. Dasha allows to use voice interface to interact with your application as naturally as communication between people.
The voice interface cannot completely replace the traditional user interface of the application, but some tasks could be perfectly solved with the help of the speech interface.
Hello,
We would like to convert a string which represents a dynamic JSON object, to a JSON.
We have:
linea: {"app_id":"5cf57b56-c3b4-4a0d-8938-4ac4466f93af","headings":{"en":"Cita Atención Primaria","es":"Cita Atención Primaria"},"subtitle":{"en":"C.P. ISORA","es":"C.P. ISORA"},"contents":{"en":"Aqui el contenido del mensaje si aplicase","es":"Aqui el contenido del mensaje si aplicase"},"data":"{\"centro\":\"C.P.
Hi Community,
Please welcome the new video on InterSystems Developers YouTube, recorded by @Patrick Jamieson:
⏯ A Healthcare Data Management Solution - What Kinds of Data
You may have seen earlier this week that we launched a brand-new learning podcast called Data Points! There are three episodes released, one of which was a really interesting discussion with Thomas Dyar — a product specialist here at InterSystems focused on machine learning. Take a listen and reach out if you're interested in exploring more about IntegratedML!
