Hello!
We want an Integration that should be moving files from a FTP server in a DMZ zone into another FTP server on our local network.
I tried using EnsLib.FTP.PassthroughService(EnsLib.FTP.InboundAdapter, EnsLib.FTP.OutboundAdapter)
Using this approach ensamble write data to the database, causing the CACHE.DAT to grow for every file that is moved.
Looks like the entire file is written to the database, is this the case?
We are not really interested in storing any file content information in ensamble in this particular case.
Does anyone has a good suggestion on how to accomplish the file transfer

I have a class that has a list property, which contains a list of other objects, and I want to join against it in SQL.

Class Foo Extends %Persistent
{
Property MyBars As list Of Bar;
}

Class Bar Extends %Persistent { Property Name As %String; }

Simply querying the Foo table, I see that MyBars looks like a $LIST, so I tried using a query with the %inlist operator but that didn't seem to work as expected. The following query produces zero results:

select bar.name from foo join bar on bar.id %INLIST MyBars

Is there some convenient way to do this sort of join?

I have implemented a csv record mapper to read files into the production in ensemble but it errors every time I read a file with headers on the columns as these are not recognised as the specified data types .Is there a way to ignore the headers when reading in values from a file with headers. Please note this have been built using the pre built components.

Hello,

we have to implement some application logic using either Java or .NET. Which should we choose? Given that all other considerations are equal, which is in your experience better way performance-wise to interact with external components in Caché: .NET Gateway or Java Gateway?

Thanks.

Hi

Reading through the installation guide I found a fairly stern warning in the robustness checklist not to use the inbuilt apache web server.

>Use a robust web server. Do not use the limited Apache server installed with
>Ensemble. It is provided as a convenience for use on development systems and
> is not a fully capable web server.

We only have a few users, the Interface team (3), an integration consultant(1) and an interface monitoring/development vendor.

Do we need a 'robust web server' for using HealthShare Health Connect Integration engine?

I suspect we might need it to deal with

Hi

Please can someone send me an example of how to auto refresh a table pane. 

Thanks

Nigel

Hi-

I have an IP address (or hostname) and a port (in this case a super server port #) and I want to try to verify that network communications can be established between the host I'm on and the given hostname and port number of a remote server.

Is there any way pragmatically to do this within Cache?

Hi

We have a need in our Ensemble production to take HL7 ver 2.3 and provide an XML representation of it to provide to non-HL7 consumers.

What would be the prefereed way to do it.

Are there are pre-defined XML schemas in Ensemble that could be use ?

We are currently on Ensemble 2015.2

I am trying connect DB using Oracle DB link (ODBC).  I am getting the following error. Please help me fixing this error.

I am using Oracle 12 c.

Thanks,

Raj

Hi, Community!

This post is a digest of the Developer Community postings in September 2017.

Most viewed

DeclarativeCOS — Declarative Programming in Caché  503

New Programming Language - Discussion  318

InterSystems IRIS Data Platform  253

? Where/How can we touch IRIS ?  207

InterSystems Global Summit 2017 Key Notes Live Stream  199

Filtering non-printable characters  188

Double dot?  172

Search InterSystems documentation using iKnow and iFind technologies  168

SPOOL - the fogotten device  167

InterSystems Cloud Manager and Containers at GS2017 XP-Lab  166

Vue.js: getting started with a basic HTML/REST/JSON example  162

Pro Tip: Controlling your SysTray Cube icon appearance   155

Widgets Direct  141

Horizontal Scalability with InterSystems IRIS  138

UnitTest : A Mocking Framework for InterSystems objectscript classes.  13

Hi, folks!

Is there any way to use $CASE or $SELECT functionality in SQL SELECT query?

E.g. something like this:

SELECT product, $CASE(status,"New":field1,"Payed":field2) as data from sales

To see either in data column either field1 or field2 values in regard of status value.

Hi-

I am running the latest version of Cache and am trying to use the Config.* classes in the %SYS namespace to be able to gather information from a cache.cpf file that was provided to me by a customer.  The customer is running an older version of Cache which had a different Version number in the cpf file.  Theirs is 2013.1 and mine is 2015.1.  

My question is, are the Config.* classes backwards compatible.  Can I use a 2017.1 version of Cache to read information from cpf file from a 2014 system?

Hi all-

We used to have this Java applet in our CSP page to "print all" and "download all" PDF medical reports.  We want this applet so that the user won't have to open each PDF in the browser just to print it.

But now most browsers do not support Java applets anymore due to security concerns, so that Java application is down.  We tried to migrate to Java Web Start but don't know how to invoke the JNLP file from the CSP page.  I am new to Cache so any help would be greatly appreciated.

Also, is there an easier solution to this print all problem?

I have a SOAP Business Operation that will to alert when the EMR returns NACK but I don't want to stop file flow? I would just like ENS.Alert to send out the email and then move onto the next message and not to stop the BS or the BO. Is that a setting in the BO?

Hi there.

I was wondering if there was a supported way of editing the Title bar of the management portal so that at a glance it is clear as to what environment is being worked on. This would be in addition to the namespace and server name being displayed.

Ideally I would like to make it clear at a glance that a user is working within the Dev or Live environment.

Hello,

I am looking for ObjectScript implementation of crypt-compatible function, that generates md5 salted hashes (output is in the form of $1$salt$hash). From what I understand it uses its own spin on md5 algorithm:

https://en.wikipedia.org/wiki/Crypt_(C)
http://php.net/manual/en/function.crypt.php
http://www.gnu.org/software/libc/manual/html_node/crypt.html

Does Cache have something like that built in?

Has somebody here seen it implemented somewhere?

Thanks.

Added:

I have found description of the underlying algorithm here: https://www.vidarholen.net/contents/blog/?p=32

If you are facing out the license expire warning message on your terminal ("*** Warning: This Cache license will expire in 3 days ***") and you do not want that message to be displayed, you can disable/enable that by rinning the following commands:

Do ExpirationMessageOff^%SYS.LICENSE - Disable

Do ExpirationMessageOn^%SYS.LICENSE - Enable

Hi , i have a JSON record as follow {value1,value2, value3}

i want to write my switch statement in this form:

<switch> my value
<case> value1</case>
<case>value2</case>
<case>value3</case>
​</switch>

is there any possibility to extract values from JSON record and put them in a  switch statement?

thank's

Hi, Community! 

This week we have two videos. Check all new videos on InterSystems Developers YouTube Channel:

1. What is InterSystems Cloud Manager?

This video provides an introduction to InterSystems Cloud Manager (ICM) and its capabilities.

2. Instant Gratification: Pick Your Cloud

Hi, folks!

When you deploy DeepSee solutions you often do not want grant a User  %All Role to work with a particular Dashboard.

Consider a Dashboard 'Dash' with a few widgets where listings are being used.

If you manage a Role to get access to the Dash you need to grant access to %DB_DBNAME resource to have a database access,  grant access to a Dashboard resource (if any) and ...  grant SELECT accesses to all the tables involved in SQL queries being used in all the listings of widgets.

And every time(!) when you update a listing you need to rearrange that access level in a Role (either grant new

I need to create a standards document for new developers who are coming to Cache from other backgrounds.

Does anyone have an in-house document they could share with me?

Regards

Mike

Hi, Community!

Consider I have ResourceA which is used by role RoleA in dev environment and want to deploy it with the solution on a target system.

Would you please share the best practices to make it?

Thank you in advance!

Has anybody devised a process that would allow the render and printing of BPL diagrams created in Studio? Thank you.

Hoping someone can help.

I had posted a similar question outside this group a while ago "Errors requesting data from local Ensemble FHIR Repository" but haven't had the chance to follow up on it since. It was suggested I re-post inside this group.

I'm trying to request data from my local FHIR repository using a simple JavaScript client and am getting the following CORS errors . ( It is a standalone client not inside HealthShare without CSP etc. on my localhost ).

Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at

Hello again and welcome to the Part 3 - Using the SQL API!
If you have been wondering about how to use SQL along with Frontier, you came to the right place. That's because since Frontier wraps the common Caché SQL API within it's own, you need to use the API provided from it. But you don't need  to worry about its learning curve, because the Frontier SQL API is really simple.
If you arrived here without checking the Part 1, I'd recommend you doing so, because Part 1 covers the essential for getting started with Frontier routers.

1. Core concepts
   • Getting started
   • Creating a simple request
   • Quer

The definitions of these two compiler keywords looks very similar to me.

Is there any difference between these two keywords ?

When I declare a parent class as Abstract, its child class could be compiled successfully.

However, when I  declare a parent class as NoExtent, some compile errors about storage references get pop up for its child classes.

Thanks.

Hi Team,

                 I understand health share insights feature. But How to try this features  and will need some real time examples .Any one please guide me.

Thanks ,

Ponnumani.

How to Archive SDA from Post processor and save it in txt file at some location.

I have a class name stored as %String,

How could I get the names of all its child classes?

Thanks you.

Hi, 

I am a beginner on intersystems technologies ! and i want implements Oauth2 for our projects ( Angular 2 + Caché REST  Backend). 

i read the article that the link  is below : 

https://community.intersystems.com/post/cach%C3%A9-open-authorization-framework-oauth-20-implementation-part-1

But : i need to create  all servers ( Auth and Resource ) on Caché and dont' to use google server.

Also, i need   to be able to consume Oauth from my web services as caché REST application (whitout csp ui) .

An Idea  Please ?

Thank you

Yani