Announcements

I used the Activate wizard to create a package for Excel (Activate.Excel). There is a class in there that seems to be what we need to open a file:

Activate.Excel.Workbooks.

 

There is a method that  has an Open() command. I tried  using it but getting an invalid pointer error.

 

The  parameters are as follows:

Last answer 11 days ago Last comment 9 days ago
0   0 1
76

views

0

rating

Update:

1. Still don't know what a foundation production does?  What does Ens.Activity.Operation.Local.cls do?

2. Why does creating additional namespaces in 2019.1 causes foundation productions to be created automatically
(with Ens.Activity.Operation.Local operation).  I can't run a foundation production and a routing production in the same namespace. (no change from 15.03)

0   0 2
104

views

0

rating

Are you all ready for something you wish you knew ages ago (or, in my case, a DECADE ago)?  Open up a portal in your favorite instance and go to:

System Administration->Configuration->Additional Settings->Startup

Scroll down to "Terminal Prompt" and click 'Edit'.  This allows you to edit what you see on your terminal prompt.  You can change that to my current setting: 8,3,2

What does this do?  It adds your instance name for your prompt.  So now your prompt can look like:

DEVELOPMENT:USER>

Last comment 5 days ago
+ 10   0 4
325

views

+ 10

rating

The question is pretty much in title. I'm developing a REST API, it has a search endpoint with 10 optional parameters. How do I pass them and stay RESTFul?

To ease the question a bit let's agree that:

  • all parameters are AND parameters, user can't make combos, ORs, etc. User can only provide values
  • all values are integers so I don't have to think about URL limits
  • all values are atomic
  • all conditions are about equivalency

Some options I know of:

1. URL parameters.

Last answer 5 days ago Last comment 4 days ago
0   0 5
128

views

0

rating

InterSystems is pleased to announce a new Developer Download site providing full kit versions of InterSystems IRIS Community Edition and InterSystems IRIS for Health Community Edition.   These are available free of charge for application development use.

 

You can download directly from the InterSystems Developer Community by selecting Download InterSystems IRIS.

+ 7   0 6
385

views

+ 7

rating

Hi,

NodeJs(v0.10.0) to Intersystems Cache2014( using cache0100.node)  network connection Not working .

This is error msg i'm getting

"{ ErrorMessage: 'Error loading Cache Library: _SYSTEMcache.dll; Error Code : 126 (The specified module could not be found.)',
  ErrorCode: 1009,
  ok: 0 } "

My Code ->

user.open({ip_address:"127.0.0.1",tcp_port:57772,username: "_SYSTEM",password: "SYS",namespace: "USER"},function(err,res){

    console.log("Error : ",err);console.log("Result : ",res);

    if(!err){

Last answer 2 days ago Last comment 2 days ago
0   0 2
55

views

0

rating

We have in DB two books, first is loaned because it has the Friend ID, and the other is in the shelf.

I execute a class query to get all loaned books:

    Query BooksLoaned() As %SQLQuery
    {
        SELECT *
        FROM Library.Book
        WHERE Friend IS NOT NULL
    }
 

Which I have tested throught the portal:

Last answer 3 days ago Last comment 3 days ago
0   0 2
96

views

0

rating

I'm trying to convert a CSV inbound to an HL7 MFN^M16 outbound.  I know I'm using book information as the CSV but I don't think that matters.  Please let me know if that's incorrect. 

My service is reading the file in just fine and when I don't have a DLT transformer the raw message passes through to outbound file folder just fine.  However, when I include a basic DLT that simply copies a couple of fields over I get the "Ens.StreamContainer" error.  Everything also seems to be good in the Record Mapper.

Last comment 9 days ago
0   0 2
0

answers

48

views

0

rating

Hi All, I am a Data Architect and am trying a method of deploying alter statements onto Cache DB.

My Data Modeling tool generates alters as this.. So question is if the Cache has a way to rename table? If so what is it?

ALTER TABLE <SchemaName>.GROUP_TYPE_NODES RENAME TO GROUP_TYPE_10082019140110000
;

This is giving error.

Last answer 10 days ago Last comment 10 days ago
0   0 1
37

views

0

rating

I  am reading the following code in ObjectScript:

GitHub repository
 

And there is a sentence which I am facing difficulties to understand:

    kill ^OPNLib.Game.CWLF(..World)

I know that kill removes variables, OPNLib.Game are the package and subpackage, and ..World is a property. However what does CWLF mean?

You could think that it is the class' name, but it is:

Last answer 5 days ago
0   0 1
0

comments

50

views

0

rating

$LIST string format and %DynamicArray and %DynamicObject classes

IRIS, and previously Cache, contain several different ways to create a sequence containing a mixture of data values.  A data sequence that has been available for many years is the $LIST string.  Another more recent data sequence is the %DynamicArray class, which along with the %DynamicObject class, is part of the IRIS support for JSON string representation.  These two sequences involve very different tradeoffs.

$LIST String Format

Last comment 9 days ago
+ 5   1 1
93

views

+ 5

rating

I have the following message when I try to import a WSDL to generate a SOAP service:

 

ERROR #5319: The type of a property of a class series cannot be recurring: SeleneHL7Service.hl71.escapeType:escape
  > ERROR #5030: Error occurred while compiling SeleneHL7Service.hl71.escapeType class

 

I have found in the documentation:

 

 

5319 The type of a property in a serial class cannot be recursive: %1

 

 

Last answer 7 days ago
0   0 1
0

comments

39

views

0

rating

Hi All, I'm in the process of trying to rollout the git version control system with our current code base within Atelier.  We use Ensemble to develop interfaces but are looking to move to IRIS in the near future.  Our code is structured similar to below:

 Site

Last comment 10 days ago
0   0 3
0

answers

51

views

0

rating

Hi, we are a veterinary lab and we use both the LAB and FIN systems of Antrim. Now we are looking to expose the data in a SQL/Object compatible way so we were wondering if same / similar things had been done by other community members already? If so, could you please share your approach / experience / gotchas with us and we are all ears. I can be reached at yang.jiao@antechmail.com . Thank you! 

Last answer 9 days ago
0   0 1
0

comments

47

views

0

rating

Hola a todos:

En este artículo quiero compartir unas funciones con vosotros, que espero os sean útiles en algún momento.

Definiciones

DNI: Documento Nacional de Identidad. Se compone de diferentes series de números y letras, que acreditan la identidad y los datos personales del titular, así como la nacionalidad española. Ejemplo: 94494452X

NIE: Número de Identificación Extranjero: Es un código para extranjeros en España.

Si necesitas generar ejemplos, puedes generar ejemplos de DNI o NIE en el siguiente enlace:

0   0 1
0

comments

20

views

0

rating

Si quieres probar mirroring de una manera simple y sencilla puedes hacerlo con estos simples scripts (ver link)

  • El fichero docker-compose.yml crea 2 contenedores con la versión que necesites
  • El script installer.sh arranca el  ISCAgent, carga la clase Installer.cls y la llama
  • Lo más interesante está en la clase Installer.cls. Esta clase contiene unos métodos muy sencillos de seguir para montar un mirror, unirse a Elisabet y crear un namespace y base de datos en mirror.  Son scripts sencillos que puedes reutilizar para crear mirrors en tus propios scripts

+ 2   0 1
0

comments

10

views

+ 2

rating