We have some code written by earlier team that read flat files data and create SDAs and push them to ECR Input Service. Now for every test cycle we have to load files to SDAs, check error log, fix the error, clear the ECR, and try new fixed flat files. I’d like to know if there is a method to validate SDA msgs prior to pushing to EFR Input operations ?

so everything we simple load flat files, create SDAs and validate them. If files all looks good with no SDA errros then we actually load them to ECR only once.

00
0 3 30

Hi,

I need to develop a HL7 Q22/K22 query/response mechanism for a NHS Trust I am working for, but I do not know how to handle the message continuation.

Can any one give me any advise on this and/or point me in the direction of any documentation on the subject?

Thanks

Neil Thaiss

00
0 2 42
Question
Scott Beeson · Feb 12, 2016
Get columns dynamically?

In MSSQL I think you can do something like this:

select *
from HS_IHE_ATNA_Repository.COLUMNS
where TABLE_NAME='Aggregation'

 

How can I do this in Cache SQL?

[%msg: < Table 'HS_IHE_ATNA_REPOSITORY.COLUMNS' not found>]

00
0 11 1,577
Question
Jian Li · Nov 20, 2020
validate logon

When I log in to the management portal page, I want to know where to verify whether the user name and password information I entered are correct, and how to handle it in the program. Is it handled through routine? Or is there a Dispatch Class to handle?

10
0 0 48

We use ExecureProcedure() to execute a stored procedure which returns a result set. But we see lot of "Invalid cursor state" errors when the result set is empty.  The connection to SQL server database is made through ODBC. 

ERROR #6022: Gateway failed: Fetch. + ERROR <Ens>ErrGeneral: SQLState: (24000) NativeError: [0] Message: [Microsoft][ODBC Driver 11 for SQL Server]Invalid cursor state 

Here is the code snippet from the business operation class which uses EnsLib.SQL.OutboundAdapter  

00
0 2 206

Hi is there healthshare insallable for one user where one can create edge production, follow exercises to customize clinical viewer, create data loading routines takeing data from flat file and push data to ECR. Community version for IRIS for health does not have options to create edges and there is no clinical viewe

00
0 2 53

 I am looking for any pointers on how Intersystems IRIS Health can monitor a filesystem/Folder that user/s /applications can drop in CSV files via FTP and load the file  to the IRIS DB . I understand that I will need create a record map for the CSV files, I am looking for any configuration references on how how to process files using file inbound adapters  with the  intent to pick up the CSV  file as they are dropped in the  target location and pass it to a Business process and ingest into the IRIS database 

Any help would be greatly appreciated ... 

00
0 9 89

I am looking to create a routing rule that will do the following:

When transaction is not an A03, and discharge date is valued, do not transform. 

What I am having trouble with is with the conditional for the discharge date {PV1:45}.  Not sure if I can use length here or if I can use HL7.{PV1:45}>0.  I did try that, but its not working.  Not sure what I am doing wrong.

 

Thanks,

 

Nicole

00
0 2 44

version cache for windows, 2017.2.1 build 801_3 - windows 10

I had this system set up for 3+ years now, and background tasks such as converting emails,  have always worked, suddenly it's stopped working and I've tracked it down to any network references.

reading the emails, I look for any attachment files, and save them to a network drive before processing them within a class method,

I've been testing it by sending exactly the same email repeatedly and checking the saving of the attached file in both the background and in the terminal.

00
0 11 100

hi

is there is way to change the order of the charts available in the clinical viewer as client asking to change the order keep more used charts at the begining and others chart move to end . Is it possible. 

00
0 1 42
Question
Scott Fadden · Nov 11, 2020
Create Database using Python
I am trying to create a database using python. The example shows setting a Name string and a Properties object containing Directory=.

; Use class methods to create an instance
 %SYS>s Name="ABC"
 %SYS>s Properties("Directory")="c:\abc\"
 %SYS>s Status=##Class(Config.Databases).Create(Name,.Properties)
 %SYS>i '$$$ISOK(Status) w !,"Error="_$SYSTEM.Status.GetErrorText(Status)

How do I update and pass the Directory property using Python?

 

00
0 3 103

Hello there,

Someone know which impact would have my database changing the locale and its collationTable? I understand it should works fine, without any drawback.

Could someone else confirm my assumption or tell me what could happen? Has anyone changed something like that? (Not to russian, japanese, chinese, etc..) 

 About queries.. is there any side effect? 

Regards

00
0 1 38
Question
Ingo Steiger · Nov 11, 2020
leading zeros

Hallo, I need a Ensemble transformation to fill up a 6 or 7 digit Number to a 10 digit string with leading zeros.

123456 --> 0000123456

1234567 --> 0001234567

Thank you!

00
0 4 116

Hey Intersystems Community,

I have a Problem with the Session Handling in .csp.

I wrote all my Web Services in .csp-Pages and do the work for example in the OnPreHttp Method for to get some data.

After that the Web Service response is in JSON.

I call These Web Services via fetch in my react Single Page application, also Many request parallel. The react App is Rolled out as index.html.
Everything Works Fine with the session Handling via Cookie.

00
0 3 90