For a long time, we have been using a utility in production to export the result of a query to an Excel spreadsheet. Moreover, we have applied a modification of it, in which the explicit setting of column formats is a priority.

This utility used the module %SYS.ZENReportExcelExporter and is based on a java program. Every year the report grew and there was not enough java RAM, so we had to increase the value of the environment variable. The value has reached 7gb and now it has become a problem.

We decided to find and create a replacement for the utility.

Hello everyone,

I created a Class with this 3 properties

Class TestDynamic Extends (%RegisteredObject, %XML.Adaptor)
{

Property number As %xsd.string;

Property exam As %xsd.string;

Property result As list Of %DynamicObject;

}

I'm adding objects to list normally

set objTest=##class(TestDynamic).%New()
set objDynamic={"field":"value"}
do objTest.result.Insert(objDynamic)

But when i use this method to convert to JSON

##class(%ZEN.Auxiliary.jsonProvider).

Has anyone else seen this error?  From the API Manager Catalog, I can select an API and use the "Try it Out" feature.  An error is returned - TypeError: Failed to fetch.

The same Curl can be imported into Postman and executed successfully.  For us, API Manager is in a container and the container can ping the server.

Currently we're using InterSystems Cache Studio Client 2017.2.2 Build 865

I'm currently going through training and one of the videos mentioned using Control+Space to bring up the content assist window.

It's in reference to Atelier IDE, but I'm curious if Studio also might have a tool similar to that?

Hi Team,
I have a requirement to disable the Production Start/Stop buttons for specific support users. But they should be able to stat/stop Ensemble Hosts.
For that new Role, As per documentation along with other Ens resources, I have added %Ens_ConfigItemRun with RWU access and didnt add %Ens_ProductionRun resource.
This makes the Start/Stop buttons disappear from Production Configuration page ( meeting my requirement). But those users are Unable Start/Stop/Restart Ensemble Business Hosts.

Hi, Community!

I'm pleased to share that we have a dedicated InterSystems Developer Community GitHub - github.com/intersystems-community!

Newbie question.

Looking for documentation on loading HL7 messages into the messagestore?

Would then use HL7Spy as a front-end tool.

Thanks

A VIEW in SQL is basically a prepared SQL statement.
It has to be executed and assembled like any other SQL query.
MATERIALIZED VIEW means that the content is collected before hands and can be retrieved rather fast.
I saw the concept first with my favorite competitor named O* and they made a lot of noise about it.
  { favorite: because I could win every benchmark against them }

Hi!

I'd like to know how to get feature importance after creating and training a model, using IntegratedML with AutoML provider?

Thanks!

The purpose of this post is to raise the profile of a powerful mechanism that has long been available to us, and to open a discussion about ways in which it can be used or abused.

You can read more detail about the mechanism here. To summarize, your class definition can use the Projection keyword to reference one or more projection classes. A projection class can implement methods that get invoked at key points in the lifecycle of your class.

A projection class must extend %Projection.

A sudden and short delivery date task has come into being. What is the fastest way to recreate a Cache 2018 application schema definition in SQL server?

Thanks in advance,

Dan

Hi,

We have an immediate requirement for an experienced Intersystems Ensemble/Healthshare Connect developer to join our team with a good grounding programming ,Healthcare Integration and experience with InterSystems Ensemble/Healthshare Health Connect.

Contractor or Full Time.

 Please if you are interested and need more info contact :

Perez.bertamaria@srft.nhs.uk

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Installing InterSystems API Manager

InterSystems SAM is a great tool to monitor your InterSystems IRIS and InterSystems IRIS For Health clusters on prem or in a cloud environment. This article describes how you can implement a customized alert handler. This is currently an undocumented and most likely an unknown feature of InterSystems SAM. With future releases it will be probably made easier to leverage this useful concept.

In the interest of shortness, I will only mention InterSystems IRIS in this article, but the following applies to InterSystems IRIS and InterSystems IRIS For Health.

Hi Guys,

for some reason the height in my tablepane are very big, how can I adjust the height in the rows in a tablepane?

Thanks

Hello there community, 

I recently posted an article regarding a technological aspects that could boost the internet speeds of every individual/s personal work station in the given situation of the pandemic. 

But, unfortunately my article is not published and I see it under draft. 

Is there a particular reason for this please?

Have I missed something that needs to be followed? 

Is that why the article that was published is now under the draft section? 

I would like to know more on this please. 

Regards. 

I'm in a process of acquiring a corpus  of documents on educational courses. 

For example there is an educational course called "OOP" and it can have documents from 2008, 2009, ... 2016 etc.
And there are a lot of these courses, each one with programs from different years (hopefully)

So 1 document is 1 programm of one course for one year.

I want to calculate how much does a course changes per year.

Hello,

I have a Business Process where I am receiving a JSON payload in the "Body" property of the my request class. I defined a context variable as an object of a class that represents the JSON schema I expect to receive and load the JSON payload in that context variable.

e.g.

/// BPL Definition
XData BPL [ XMLNamespace = "http://www.intersystems.com/bpl" ]
{
<process language='objectscript' request='mapi.core.msg.rq.RestBusinessServiceRequest' response='mapi.core.msg.rp.RestBusinessServiceResponse' height='2000' width='2000' >
<context>
<property name='cm' type='mapi.exchange.msg.

Hi,

Just what to know how Can I connect to Local HAPIFHIR server from production?

Thanks

Hi,

Is there any objectscript command available to start or stop production from object script?

Thanks

Hello community...
As there is a certain restriction of commands in Caché, and assuming that the base of most colleges ends up being MySQL, Oracle, SQL Server and others... And the last two with very simple IDEs to use and with the possibility to handle the operation in the database very well, which IDE (if there is an "official" or something like that) would be the best for me to start working more effectively with Caché?

Hi Guys,

I've a combo inside a tabGroup inside a form and using :

var MyInput = zen("MyCombo").findElement("input").value;

is not finding the current input, any help pls?

Thanks

We are seeking experience or best practice for Sharding on IRIS and doing some testing on 2021. Appreciate if anyone can share your stories here. Thx!

@Qiao Peng @Nicky Zhu 
@Jingwei Wang 
@Li Yan 
 

Hi,

Is there any functionality available to generate FHIR bundle id (GUID)?

Thanks
 

Hi Community,

Please welcome the new video in Hebrew on DC YouTube:

⏯ The Best of the Virtual Summit 2020: Highlights in Hebrew

Besides objectscript's own list, array data structure, are there any other data structures that have been implemented, similar to the "collection" package in java, or is there a ready sorting tools for the collection class.

I am using .net to connect to the cache database via ODBC, OdbcConnection connection = new OdbcConnection(dbConnection); connection.Open(); This error is reported when the link is opened, how should this be solved? Thank you very much!

There are many options to do a full security scan in your docker images, the most popular option is Anchore community edition.

Anchore will use the main public vulnerabilities databases available, including CVE.

To install Anchore is very ease (source: https://engine.anchore.io/docs/quickstart/), follow the steps:

1. Create a folder in your OS and download the anchor docker compose file to the created folder.

   curl -O https://engine.anchore.io/docs/quickstart/docker-compose.

I am working on tweaking our current patient load process. The roster input is in text pipe delimited format, parsed out and transforms it to a standard HS.Message.PatientSearchRequest, and send to business process for patient matching. Result is transformed into a standard ADT HL7 message using EnsLib.HL.Message class. I would like to know if there is another class I can use that will transform my output to a text flat file pipe delimited instead of HL7 format? any advice on how to do this is greatly appreciated.

Thanks!

Hello All,

InterSystems Certification has designed another certification exam and we need input from our community to help validate the exam topics. Here's your chance to have your say in the knowledge, skills, and abilities that a certified InterSystems CCR Technical Implementation Specialist should possess. 

Here's the exam title and the definition:

InterSystems CCR Technical Implementation Specialist

A development professional who:

• Uses Tier 1 CCRs to document and process change workflow
• Makes code changes in their Integrated Development Environment of choice.