Hi,

     Can anyone please explain me how to remove trailing squares from the text field (String). Trailing squares is a white space ?

I tried different things like Ltrim, Trim from sql query side and also from object scripting side something below.

 If Address1 set Address1 = $ZSTRIP(Address1,"<>P,<>C,<>W")
 If Address1 set Address1 = $ZSTRIP(Address1,"$C(9), $C(32), $C(160)")
 If Address1 set Address1 = $ZSTRIP(Address1,"*W,*C")

Nothing works for me

Can anyone please help me to solve this

 

Thanks

Last reply 5 hours 37 min ago
0   0 4
77

views

0

rating

Hello everyone smiley

We are facing what seems to be a network problem while transferring HL7 messages from Ensemble/Healthshare to a distant target through TCP/IP.

Here is the version of the system in any case it could be useful: Cache for Windows (x86-64) 2017.2.1 (Build 801U) Wed Dec 6 2017 09:07:51 EST [HealthShare Modules:Core:14.02.2415 + Linkage Engine:15.03.9901]

Last reply 8 hours 43 min ago
0   0 2
14

views

0

rating

Hi Developers!

Here're the technology bonuses for the FHIR programming contest that will give you extra points in the voting:

  • FHIR Server REST API usage 
  • The usage of SQL Schema of FHIR Resources 
  • Healthcare standards data transformation
  • Docker container usage

See the details below.

+ 1   0 2
0

replies

10

views

+ 1

rating

Hey Developers!

Want to participate again in the competition of creating open-source solutions using InterSystems IRIS Data Platform? Please welcome:

➡️ InterSystems IRIS for Health FHIR Contest ⬅️

Duration: August 10-30, 2020

 

Last reply 12 hours 34 min ago
+ 5   0 1
488

views

+ 5

rating

Hi Developers!

InterSystems FHIR contest has been started and in this post, I want to introduce several topics you may find interesting and use to build FHIR applications with InterSystems IRIS for Health.

Amongst them are:

  • a frontend mobile or web app for FHIR server FHIR REST API or SQL;
  • Backend apps to perform complex queries and maintain rules;
  • work with different HL7 data standards.

See the details below.

Last reply 12 hours 37 min ago
+ 2   0 1
44

views

+ 2

rating

Over the past year or so, my team (Application Services at InterSystems - tasked with building and maintaining many of our internal applications, and providing tools and best practices for other departmental applications) has embarked on a journey toward building Angular/REST-based user interfaces to existing applications originally built using CSP and/or Zen. This has presented an interesting challenge that may be familiar to many of you - building out new REST APIs to existing data models and business logic.

+ 9   5 7
458

views

+ 9

rating

Hi all,

 

I want to share a quick little method you can use to enable ssl with a self signed certificate on your local development instance of IRIS/HealthShare. This enables you to test https-specific features such as OAuth without a huge lift.

 

 

1. Install OpenSSL

Windows: https://slproweb.com/download/Win64OpenSSL_Light-1_1_1g.exe

Debian Linux: $ sudo apt-get -y install openssl

RHEL: $ sudo yum install openssl

 

+ 2   1 1
0

replies

39

views

+ 2

rating

I have a Read-Only Reporting Async with a Remote Database defined to a non-mirrored database on the primary failover member. I would like to update the non-mirrored database on the primary from the async; so far all my attempts fail with *protect* errors.

I found this page 

https://community.intersystems.com/post/execute-method-failover-member-m...

Last reply 1 days ago
0   0 2
23

views

0

rating

This article, and following two articles of the series, is intended as a user guide for developers or system administrators, who need to work with OAuth 2.0 framework (further referred to as OAUTH for simplicity) in their InterSystems product based applications.

Last reply 1 days ago
+ 13   7 7
5,545

views

+ 13

rating

Hi:

I have an sql outbound adapter. Sometimes we have trouble connecting to the database. 

The timeout in develpment is set to 15 seconds in live it is 150 seconds as it is an always connected Buisness operation. 

I thought adding E=S or/and X=S would suspend the message. Why does it not? 

Is the only way around then adding something to the buisness operation itself/ creating a customised SQL buisness operation rather than EnsLib.SQL.OutboundAdapter?

 

Thanks 

Mark

Last reply 1 days ago
0   0 3
52

views

0

rating

We have a vendor that every couple of days will just stop transmitting messages, but still hold the TCP/IP connection open. No matter how many times we troubleshoot and talk with them, they don't seem to think its an issue with system.  Normally if I just restart the service it will get the data flowing again.

Last reply 1 days ago
0   0 3
36

views

0

rating

Hi Community!

We are pleased to invite all the developers to the upcoming InterSystems IRIS for Health FHIR Contest Kick-Off Webinar! The topic of this webinar is dedicated to the FHIR Programming Contest.

On this webinar, we will talk and demo how to use the IRIS-FHIR-Template to build FHIR solutions using InterSystems IRIS for Health.

Date & Time: Tuesday, August 11 — 11:00 AM EDT

Speakers:  
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager
🗣 @Guillaume Rongier, InterSystems Sales Engineer
🗣 @Patrick Jamieson, InterSystems Product Manager - Health Informatics Platform

What awaits you at this webinar?

+ 1   0 1
77

views

+ 1

rating

Productions often need to receive REST requests.

Here's how to do that.

1. Create proxy Service:

/// Empty BS we would use to send Produciton requests
Class production.ProxyService Extends Ens.BusinessService
{
}

2. Add it to production as RESTService (or any other name).

+ 1   0 2
0

replies

33

views

+ 1

rating

Hello,

Recently I tried to connect to JDBC on IRIS 2020.3+ and I came across the following error:

 SQL Error [461] [08S01]: [InterSystems IRIS JDBC] Communication link failure: Communication error: Server closed communication device

This error implies that the port is not open.

Checking with the netstat command:

+ 2   0 2
0

replies

38

views

+ 2

rating

I have a service named FTP_In that is of class EnsLib.HL7.Service.FTPService.   It picks up files from multiple subfolders and sends them to an EnsLib.HL7.MsgRouter.RoutingEngine.   What I want to do is somehow capture the subfolder as a variable for use in the routing rules.  Is this possible?

Let's say I have the following files and directory structure on my FTP Server

Last reply 2 days ago
0   0 5
324

views

0

rating

Sometimes standard COS methods fails and returns low level error code (like %File(CopyFile) error code "-3").

As per ISC Support response, Cache is negating low level error codes (adding "-" prefix).

Is there any existing COS method or COS code snippet to obtain low level error description based on low level error code (positive or negative)? 

 

0   0 3
58

views

0

rating

Hello all,

I'm trying to setup the JDBC Gateway Server so customers can connect to IRIS remotely using JDBC and not ODBC. But I'm facing a problem connecting, as our system department tells me IRIS is using the loopback address (127.0.0.1) and that makes remote systems cannot connect to port 53773 (the default port for that).

So, I would like to change this 127.0.0.1 host for the hostname but I cannot see where to do it:

0   0 2
80

views

0

rating

Greeting IRIS Community,

I need some help converting XLT (XML) into DTL (XML) pragmatically using COS or any other available options in IRIS for health.
It is for HL7-TO-nonHL7 translation. 

Last reply 3 days ago
0   0 3
79

views

0

rating