#Ensemble

This is a detailed guide to develop RESTful services using InterSystems Ensemble. The goal of this guide is to make you understanding the basic concept and building blocks of a RESTful service. The service is going to provide a very basic functionality (a “Hello world!”).

You will learn how to create required components as Ensemble classes, configure the run-time as an Ensemble Production and create a service configuration as a web application.

Hi Guys,

My understanding is that Count in SQL query returns a integer but I'm using this query in a loop where is the count is bigger than 2 skip and go to next record but it looks like it's not doing it, because I'm expecting that ^badis("retries",2,ID) will always be 2 or less but ^badis("retries",2,ID) did have 4 or 5 and I'm thinking that TryCount is actually not a number that's why Continue:TryCount>2 didn't work?

Credentials for a Productions are stored as plain text in ^Ens.SecondaryData.Password and exposed as plain text via SQL table Ens_Config.Credentials which is not ideal as only admins should know the credentials.

I can create my own adapter etc... to store and use encrypted passwords but does anyone know if there is a standard way to do this in a Production?

Alternatively, am I missing how to secure this so the production can run and someone can monitor and operate a production without access to the SQL table or global?

Hi All,

Can you help me how to extract SQL table data into a text file and generate the text file in a particular file path 

Thanks,

Smythee

Hi Team,

                I am new to InterSystems. I am trying to setup DHTML editor with ActiveX control for Trakcare 2021.7 version. I am receiving Ensemble locally not installed error. Could you please guide me for using Ensemble in local windows machine

Now that I have SAM up and running, out of the box I would like to add some Application Metrics. Does anyone have templates, or have suggested classes that someone could use to add custom metrics to SAM? Maybe we should start a repository somewhere? Or would someone be willing to share custom metrics on the Open Exchange? 

What I am looking to do is capture the overall HL7 message and header count per day.

Hi, 

I am trying to input an entire xml into a sql server table. I am doing this via an operation in Ensemble.

I keep getting the following error

[SQL Server]XML parsing: line 0, character 0, unrecognized input signature

I have setup the table with a column parameter XML.

Here is the request object that is being sent to the store procedure

<reqSQL xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://www.w3.org/2001/XMLSchema">

<SQLScript>

{ call dbo.PopulateDataTable(?,?,?,?,?,?,?)}

</SQLScript><lstInputParams><lstInputParamsItem>

test

</lstInputParamsItem><lstInputParamsItem>

666666

Hi Guys,

I'm a newbie in Ensemble productions and I've been asked to create an Inbound adapter and specify a port of which clients can send through JSON files and I did as attached, but now I've been asked to provide the URL to give to our clients so they send their JSON files to and I don't know what URL is should look like!? 

Thanks 

Hi Guys,

I've newly joined a new company and have been asked to get the number of classes in their system and was wondering if Ens, EnsLib and EnsPortal are normally a system or default packages that comes with default classes that developers can use or override? 

Hi Guys,

is there an easy way to count all line of codes in all classes in a namespace ?

I've been asked to give the total lines of code in all our system and we have over 3000 classes, so opening each one of them to check total line would take a long time.

Thanks

Hi,

When i am using $$$LOGERROR("Message is Discarded") in the class  i am getting "Referenced Macro Not defined" error 

Can you help me how to use $$$LOGERROR in a class

Thanks,

Smythee

Hi Guys,

My application is running in Chrome but not in IE and I'm guessing it's a security issue, where when I open IE it tells me that ESC in on, but checking the configue in Server Manager tells otherwise? 

Thanks

Looking for a new position working on InterSystems and Interface/Ensemble development/implementation, engine migration/upgrade, custom interfaces, message format conversions, or ETL.

Ideally looking for part-time and corp-to-corp. 

Profile:

I'm trying to develop monitoring API for the following requirements:

Hi,

I am receiving a JSON File as Stream container Using  pRequest As Ens.StreamContainer and output as  Output pResponse As %Persistent in a Custom Business Operation 

Please find the code below

Method OnMessage(pRequest As Ens.StreamContainer, Output pResponse As %Persistent) As %Status
{
    Set tFilename=..Adapter.CreateFilename(##class(%File).GetFilename(pRequest.OriginalFilename),..Filename)
    Set tSC=..Adapter.PutStream(tFilename, pRequest.Stream)
    Quit tSC
}

Question:How can i extract name,DOB,SSN from the pRequest and save the same values in SQL persistant table?

Healthcare interoperability is instrumental in improving patient care, decreasing healthcare provider costs, and providing a more accurate picture to providers. However, with so many different systems, data is formatted in many different ways. There are many standards that have been created to try to solve this problem, including HL7v2, HL7v3, and CDA but each one has its drawbacks.

Hi

I created a password validation routine for the management portal, which is called from the System-wide Security Parameters.
The validation process works correctly, but the error message that is displayed to the user when the entered password fails validation, consists of two separate error codes and messages

I see the following message when I click on my User at the top of the Management Portal screen (which then opens the popup window), to change my password and enter an invalid password:
ERROR #1446: Password change failed ERROR #5001: Password must contain at least one upper-case character

Hi Guys,

Is there online tutorials or samples on how to use Inbound Adapters ?

All I'm looking for at this stage is to create and inbound Adapter in a production to request to connect to a client where I can Get JSON file and what do I need to establish the connection?

Thanks

During a major version upgrade it is advisable to recompile the classes and routines of all your namespaces (see Major Version Post-Installation Tasks).

do $system.OBJ.CompileAllNamespaces("u")

do ##Class(%Routine).CompileAllNamespaces()

To automate this administration task and keep a log of any errors, below is an example of a class to import and compile into the USER namespace that you can use after each upgrade : admin.utils.cls

Hi all,

I am looking at a task which involves processing an XML file. Picking the file up from a folder (c:\test.xml) reading the data out of the XML and archiving the xml after it has been processed.

I was wondering what the best way of doing this would be?

I have got as far as creating a service in Ensemble. The Service I have created uses the class name EnsLib.XML.Object.Service.FileService.

Any advice or tutorials/guides would be much appreciated.

Many Thanks

we are currently using Libre office to generate a PDF from docx file. but we want generate a PDF file without using the External libraries.

Is there any tool is available with in the Ensemble to covert a file from docx to PDF.

appreciate your help.... 

Hi Guys,

this might be a dumb question but is Crystal report 2020 compatible with Ensemble 2014 datasource driver?

Thanks

Hi Guys,

usually when I want to find out which class is a zen page is, I just right click on the page and go to properties and this will show me the class url, but with this client I don't get properties as below !?

Thanks

Hi Guys 

how do I deal with single Quote inside string in an SQL query?

currently this type of query is failing with an error asking me for a closing quote :

Select * from cnd.Facilities  where name like ''%Grill's BBQ%'

Thanks

Hi Guys,

We use the below code to send JSON file to one of our clients and was working fine but I think lately they did a windows update and now whenever we send file we aren't getting any HTTP responses, success or Error, just empty response ()

the think is that it works fine and we get 200 response if we send the JSON file using our client's portal called swagger which is a website where you can assign the token and url (Swagger UI (vibra-api-prod.azurewebsites.net))

nothing has change from our end so why we aren't getting any HTTP response as all (see below)?

Hi guys,

I've a zen page report that I would like to export to .csv file, any ideas on how to do that?

Thanks

Hi Guys,

is there a way to get an audit or a record of deleted records in a class?

so basically, I'm looking for way to track delete record or from which class or class method call that delete statement was executed,  my understanding is that so for example using %OnfterDelete  I can track any deleted record using %Delete(), so if the user execute a (Delete from myclass)   sql statement can OnfterDelete track that ?

As I was thinking what I could develop for InterSystems Full Stack Contest, I saw this post:

https://community.intersystems.com/post/how-access-production-items-through-objectscript

I developed ProductionManager.csp. It displays items in the active production. It also displays the Class in use and the date and time of last message. I believe these data points can help you make decisions which items to remove from the production.

Hi,

I am wondering if anyone would know where I can get a copy of the ASTM E1394 specification for an ASTM-XML file based instrument to LIS interface I am writing?

The instrument vendor refers to ASTM 1394-97.

Cheers,
Patrick