Announcements

Hi,

I have a large XML zen report file that I want to convert to a CSV, what is the most efficient way to do it.

XML file:

<Details>
<Col1> aa1 </Col1>
<Col2> bb1</Col2>
<Col3> cc1 </Col3>
</Details>
<Details>
<Col1> aa2 </Col1>
<Col2> bb2</Col2>
<Col3> cc3 </Col3>
</Details>

Expected Output:

Col1,Col2,col3
aa1,bb1,bb1
aa2,bb2,bb2

Thank you.

Last answer 10 September 2019 Last comment 10 September 2019
0   1 3
187

views

0

rating

Hi Community,

I am trying to remove a duplicate OBX from a result, but I am running into some issues. Let me explain.

First I had a OBX where the observation Value had the blood type in it and the following OBX had the result in it.

The clients wants the blood type and the result in one field. therefore I merged / concatenated the observation values of the two OBX's.

I tried removing the OBX:2 but just cant take the whole segment out. 

please see examples below

This is the result.

Last comment 2 days ago
0   0 3
0

answers

107

views

0

rating

Hi community, 

I created a business operation class using the FTP Outbound Adapter, and it works when configured for SFTP but when I try to use it for FTPS, it does not work as expected.  The connection is established, it creates the file on the destination server but then is disconnected in the middle of the transfer and the PutStream returns 0 and never seems to finish the write of the file.  Anyone have any idea of what's happening or any steps I can try to troubleshoot?  

Thanks in advance.

 

Info:

Last comment 4 days ago
0   0 2
0

answers

66

views

0

rating

Hi all,

Over the next few months I'm going to be setting up continuous integration via Jenkins for some Angular UI's.  The goal is to, on each build:

1. build the code

2. run the unit tests and get a report

3. get a code coverage report

Just wanted to poll the community in case someone else has already worked with any of this before.  All ideas are appreciated.

Cheers,

Johnny

Last answer 1 October 2019 Last comment 6 days ago
+ 1   0 4
112

views

+ 1

rating

In this article, we will explore the development of an IRIS client for consuming RESTful API services that have been developed to the OData API standard.

We will be exploring a number of built-in IRIS libraries for making HTTP requests, reading and writing to JSON payloads, and seeing how we can use them in combination to build a generic client adaptor for OData. We will also explore the new JSON adapter for deserializing JSON into persistent objects.

Last comment 9 days ago
+ 3   2 1
161

views

+ 3

rating

Every developer has made the mistake of accidentally leaving temporary debug code in place when they meant to remove it after debugging is complete.  The great thing about writing in ObjectScript is that there is a way to make temporary code be truly temporary and automatically self-destruct!   This can also be done in such a way that the code has no change of making it into your source control stream, which can be helpful as well.

Last comment 10 days ago
+ 3   0 2
134

views

+ 3

rating

I have a scenario where I'm using a EnsLib.File.InboundAdapter to collect files from an external file system.  The files require to meet a certain criteria before they are moved to another remote file system.  If they don't, I would like them to stay where they are so that they can be collected again when the criteria has changed.    I have set the adaptor property DeleteFromServer to false - which is fine - the file stays put in its original location, but the file is never collected again as I receive a  "Skipping previously processed file  " info

Last comment 4 October 2019
0   0 4
0

answers

61

views

0

rating

Hello, everyone,

I'm trying to find solutions to a problem that's becoming quite boring.
On only one namespace, the sudio is very slow.
The studio freezes completely for 5-10 seconds when I save or compile a class. Sometimes it also freezes for no apparent reason at a random time...
It stops when I change namespace...

Do you have any idea what that could be?

Thank you in advance

Last answer 3 October 2019 Last comment 24 September 2019
0   0 3
123

views

0

rating

Hi Everyone,

New Coding Talk, recorded by @Evgeny Shvarov, is already on InterSystems Developers YouTube:

GitHub Repository Template To Develop and Debug ObjectScript in InterSystems IRIS

 

Last comment 3 October 2019
+ 8   3 5
218

views

+ 8

rating

How do I manipulate a string in Ensemble DTL (X12 document) to extract a string starting from the right, or end, of the string?

I need to have 10 digit phone numbers, however some of the source data records include the "1" for the long distance dialing and I need to exclude this.

I have tried using Right(), SubStr(), and even SubString(string,*,-10) but it will not compile.

I find it hard to believe that Ensemble does not have the ability to read a string from the right. 

Thank you for any assistance.

Last answer 30 September 2019 Last comment 1 October 2019
0   0 2
46

views

0

rating

Hi Community, 

We are pleased to announce the Global Summit 2019 social media contest called "Twitter Rush"

Help us share Global Summit 2019 with the world by tweeting live about the keynotes, breakout sessions, newest technologies and awesome moments as they happen! To participate in the contest, post your updates to Twitter with the hashtag #GlobalSummit19 between the dates September, 19 – September, 25 2019.

Our #1 social media Ambassador will win a 10.5-inch iPad Air Wi‑Fi 64GB!

🎉Check out the winner announcement below! 🎉

Last comment 1 October 2019
+ 2   0 0
307

views

+ 2

rating

Hola Comunidad

¿Cómo puedo borrar una carpeta de un servidor FTP?
¿Es posible usar el método Delete del adaptador FTP para borrar carpetas de un servidor FTP?

Cuando uso el método Delete sobre la carpeta la respuesta es "ErrFTPDeleteFailed Permission denied 550", pero tengo todos los privilegios necesarios en el servidor.

Gracias

Last answer 30 September 2019 Last comment 1 October 2019
0   0 2
25

views

0

rating

¡Hola Comunidad!

Recientemente, escuché que alguien se refirió al ECP como "capaz de hacer magia". Y la verdad que tenía razón, ya que hay un diseño muy inteligente detrás de su funcionamiento. La siguiente secuencia de diagramas muestra de forma sencilla y visual cómo se recuperan y utilizan los datos a través de una arquitectura distribuida.

0   0 2
0

comments

17

views

0

rating

A permanent job opportunity has arisen for a Caché/Ensemble developer with at least 5 years experience. My client is a specialist resource provisioner of developers for high profile clients in the finance,  healthcare, retail, distribution and credit business that are mainly based in central London. My client is looking for a highly-motivated individual who thrives in an environment where problems are open-ended.

0   0 1
0

comments

179

views

0

rating

Hello everyone :-)

I would like to update Atelier from version 1.0.262 to the 1.3 one. So I clicked on Help --> Check for updates, and I get these first error messages:

"No updates were found in available software sites."

"Some sites could not be found. See the error log for more detail." etc. cf picture below talking about Proxy Authentication.

Last answer 16 September 2019 Last comment 30 September 2019
+ 1   0 4
90

views

+ 1

rating

I am playing with the FHIR Sandbox.

I want to sort the patients returned in the bundle from the Patient search using the _sort (according to FHIR standard the _sort parameter is what should be used to sort), but I get: "Invalid request URL parameter _sort specified"

 

So I am having to assume that InterSystems did not implement _sort.

Last answer 30 September 2019
0   0 2
0

comments

37

views

0

rating

Good morning -

I am attempting to pass some HL7 content (say, a complete ADT message) from one server to another via REST/JSON - for reasons. 

I can get the data across but when I try to create an EnsLib.HL7.Message object from the message in the JSON body, I end up with just the start of an HL7 msg in the resulting object. Looks like: MSH|^~\&

The start of the code accepting the data looks like this:

Last answer 30 September 2019 Last comment 30 September 2019
0   0 2
69

views

0

rating

HI

We have a local running WINDOWS MySql, which we connect to via MySQL Workbench  :::Mysql@localhost:3306

We have java :: C:\Program Files\Java\jdk1.8.0_221\bin

 

How do we create a DSN that we can use in the business service settings to connect and run our query?

Do we make a ODBC or JDBC DSN.

What settings for either 

 

Last answer 30 September 2019
0   0 3
0

comments

47

views

0

rating

¡Hola a tod@s!

Cuando se ejecuta la tarea integrada de Purga en Ensemble (Ens.Util.Tasks.Purge) existen tres parámetros: DaysToKeep, BodiesToo y KeepIntegrity. Este artículo se centra en el parámetro de tipo booleano KeepIntegrity, pero podéis encontrar más información sobre cómo ejecutar esta tarea en el siguiente link:

0   0 2
0

comments

11

views

0

rating

Todo el mundo tiene un entorno para realizar pruebas.

Algunas personas tienen la suerte de tener un entorno totalmente separado para Producción.

-- Anónimo

.

En esta serie de artículos, me gustaría presentar y discutir varios métodos posibles para el desarrollo de software, con las tecnologías de InterSystems y GitLab. Trataré temas como:

  • Git 101
  • Git flow (development process)
  • Instalación de GitLab
  • Flujo de trabajo de GitLab
  • GitLab CI/CD (Integración Continua/Entrega Continua)
  • CI/CD (Integración Continua/Entrega Continua) con contenedores

En esta primera parte se abordará la piedra angular del desarrollo de software moderno - el sistema de control de las versiones de Git y varios flujos de Git.

0   0 2
0

comments

24

views

0

rating

Hi Developers!

When you prepare your modules for ZPM (InterSystems Package Manager) it expects the certain directory structure for ObjectScript source files.

ObjectScript in your source folder need to be stored by types in the following subfolders. E.g. if you have the source folder named as /src the structure should be as follows:

/src

        /cls - for classes

         /inc - for include files

         /mac - for mac files

         /int - for interpretable files

+ 1   0 1
0

comments

85

views

+ 1

rating

Hi ,

 

I am new to cache and I want to check with the experts to see if using the ctrl-c option while checking the list of databases is valid one or will it cause any issues. Below is my scenario

I use the below command to check the list of database 

 

%SYS>do ^MSU

Last answer 29 September 2019 Last comment 29 September 2019
0   0 3
85

views

0

rating

Hi Developers!

Just want to share the information with you that we support TechCrunch Disrupt Hackathon 2019 this year!

It will take place from 2-4 of October in San Francisco, CA.

We introduced InterSystems special prizes for participants which solutions will use InterSystems IRIS $4,000 and InterSystems IRIS for Health 4,000.

Learn more here.

If you happen to participate we wish you luck and hope you'll leverage InterSystems IRIS data platform functionality to win Disrupt Hackathon 2019!

0   0 1
0

comments

63

views

0

rating

Hey Developers!

Please join the upcoming InterSystems Developers Meetup in Boston which will be held on September 25th, 2019! 

It will take place in Boston Marriott Copley Place from 5:30 p.m. to 9 p.m.

We meet to discuss solutions development on InterSystems IRIS. Come to tell your stories and share experience with InterSystems data platforms, for networking and developer conversations. Drinks and snacks will be provided.

The format is usual: 15 min for a session, 5 min for Q&A. 

Last comment 27 September 2019
+ 3   0 3
259

views

+ 3

rating

I learned about the Open Exchange tab here at Intersystems. I wanted to look at one of them, but when I clicked it, it tried to go to the site, then brought me back to openexchange.intersystems.com.  I then saw a "not secure" icon in the browser bar. I tried this on IE, Chrome, and Firefox, and could never seem to get into the site to look at the site https://openexchange.intersystems.com/package/Cach%25C3%25A9Quality.

Last answer 26 September 2019 Last comment 27 September 2019
+ 1   0 2
40

views

+ 1

rating

Hi everyone,

I am pleased to announce that the Evaluation Service is now LIVE!

If you are an InterSystems End User or an InterSystems Partner and you want to try the latest version of IRIS with all its enterprise features (mirroring, ECP and sharding), and you want it NOW, this is for you.

Last comment 27 September 2019
+ 12   4 6
486

views

+ 12

rating