InterSystems FAQ rubric

The procedure for uploading/downloading from an FTP server is as follows.

1. Upload the image file to the FTP server

 set tmpfile="c:\temp\test.jpg"
 set ftp=##class(%Net.FtpSession).%New() 
 // connect to FTP server
 do ftp.Connect("","<username>","<password>")
 // set transfer mode to BINARY
 do ftp.Binary()
 // Move to the directory to upload
 do ftp.SetDirectory("/temp/upload")
 // Prepare a stream of files to upload  
 set file=##class(%File).%New(tmpfile)
 do file.Open("UK\BIN\")
 // upload file
 // 1st argument: File name to create at upload destination
 // 2nd argument: F

Hi,

Hi have problems to import globals, this is a testing only.

From Caché (v.2012, very older, 8 bits character, Latin1 encode) I created a file exporting globals, file *.gof with de web system utilities,.

When  I import these globals to Iris (v2024.1  16 bits character), the restore utility show this error:

Importar a namespace FENIX.
Carga iniciada en 06/17/2024 16:21:39
Cargando arch. C:\Users\Administrator\Desktop\export.gof como gbl
Global importado: ^PREG
Global importado: ^PREGM

ERROR #6069: Error al cargar archivo global 'C:\Users\Administrator\Desktop\export.gof' : ERROR #

In Index types, I can see "Extent Index", Please tell me in detail about it

InterSystems FAQ rubric

If you want to run an OS executable file, command, or a program created within an InterSystems product when the InterSystems product starts, write the processing in the SYSTEM^%ZSTART routine. (The %ZSTART routine is created in the %SYS namespace).

Before you write any code in SYSTEM^%ZSTART, make sure that it works properly under all conditions.

If the ^%ZSTART routine is written incorrectly, or if it is written correctly but the command does not return a response or an error occurs during processing, InterSystems products may not be able to start.

For more informa

Hello,

With my team, we're evaluating the different streams existing in order to find good pratices for our project using InterSystems IRIS. In doing so, we found that there exists different forms of the same stream with the %Stream.FileBinary and %Stream.FileBinaryGzip classes. We think that the %Stream.FileBinaryGzip takes less space to be stored, but is there other diferences between these two classes and what would you recomend to use ? Is it the same thing for %Stream.FileCharacter and %Stream.FileCharacterGzip ?

Thanks for your help,

Vincent Dheilly

Hello My Friends,

I have a problem with my script, In another code it works fine, but in this script It not display anything in InterSystems portal, when I try to debug, it gives the data, but why in portal it show nothing?

Can anyone help me please? Thank you

in Portal it show nothing

Hy Friends,

I need some help, how to calculate date and time in different columns ?  

Does Anyone could help me ?

Thank you

Best Regards,

Steven Henry

Hi Developers!

Welcome to the 14th edition of the InterSystems Ideas news!! This time, you can read about the following:

​​​​✓ Hints & Tips for the participants of the 3rd InterSystems Ideas Contest

✓ Brand new Ideas Portal landing page

✓ Recently implemented ideas

I'm scraping my way through some code that's been around for a while, and came across the use of $ZTRAP and (dear GOD) GOTO for trapping and handling errors.

In an effort to "modernize" it and make it, I don't know, less M-ish (sorry old-timers!), I'm replacing it with Try/Catch blocks.

Some questions:

1. Is this a dumb idea?
2. Anything I should look out for?
3. Did I hurt anyone's feelings?

And if the answer to number 3 is Yes, my deepest apologies ... I love you guys! 🤩

Hello Community!

The past two days at the InterSystems Global Summit have been nothing short of extraordinary, and I'm thrilled to share the highlights of this incredible experience with you!

From the early hours, @Anastasia Dyubaylo and me welcomed our friends from the Community at our booth

which became a bustling hub of activity.

@Guillaume Rongier, Luc Chatty, @Raj Singh, @Dmitry Maslennikov, @Olga Zavrazhnova, Lucian Rotar, @Thomas Dyar, @Irène Mykhailova

@Claudio Devecchi, @Anastasia Dyubaylo, @Irène Mykhailova, @Daniel Franco

 
@Olga Zavrazhnova, @Dean Andrews, 

We've implemented some notable new features and enhancements inspired by your feedback.

Here's what's new:

1. Acknowledgement of Active Contributors: The main page now highlights the most active contributors from the past 30 days. This includes members who posted reviews, published apps, made major app releases, and participated in contests. It's our way of celebrating and recognizing your contributions!
2. New List View Catalogue on Desktop: By popular demand, we've introduced a list view catalogue for desktop web users. Navigating and finding the apps you need is now easier and more convenie
3. 

Hi Community,

I seek your assistance for below scenario.

Scenario-1: How to add filter or where clause while displaying data with listing fields ( I have not used Custom SQL listing to display this data).

For below table, I have created a Cube Student and I have created listing fields of the columns mentioned in the table. Also I have created the pivot and  I am able to create the same table as shown below.

Now in another pivot, if I want to display all same detail with Student marks greater than 82. How to do that. Basically I want to know how to apply filter when using listing fields in

Hi Guys,

Not really familiar with how to secure URLs and using SSLs, but we currently looking to change our url from http:/www to https:/www so my understanding is once we get a certificate its a matter of creating a new SSL/TLS configuration and assign the certificate to it, then what how to apply it in out URL, or do we have to do this in IIS?   

Thanks

Collision Theory Confirmed

What causes the ![CDATA[ in a string field?

<QueryParameters><![CDATA[showportalonly=1&leaveunprocessed=0&limit=5000]]></QueryParameters>

Hello community,

I guess this one will be easy to answer, but trial and error took me too long meanwhile, so I thought it might better to ask the experts.

I would like to get rid of %all rights for routine use at our productive environment. The things, that we have to do in routine are:

- Open productions and start / stop components
- Read messages and message logs
- Search and resend messages
- Deploy new Applications
- Edit settings and default settings
- Read database tables

All in all, it is quite equal to everything but System Administration.

I tried to configure this by assigning combina

I receive request xml object as 

pRequest =

<getURL>
<Url1><![CDATA[https://test/cs/icdfg?&RevisionSelectionMethod=LatestReleased&allowInte…;
</getURL>

I need to send this to a stream

 Set XmlStream = ##class(%Stream.GlobalCharacter).%New()
 
 // how do I send my pRequest into XmlStream ??
 
 Do httpRequest.EntityBody.CopyFrom(XmlStream)

Hi Developers!

This is the second post on the resources for Developers. This part is about Open Exchange

Using Open Exchange to Learn InterSystems

InterSystems Open Exchange is a applications gallery of tools, connectors, and libraries which InterSystems Developers submit to share the experience, approaches and do business. All the applications are either built with InterSystems data platforms or are intended to use for development with InterSystems data platforms.

If you are a beginner developer you can take a look at applications in Technology Example category. All the applications in this category come with open source code repositories, so you are able to run the samples and examples in a docker container with IRIS on your laptop or in the cloud IRIS sandbox. Examples:

I would dearly love to avoid manually creating a SEF or XSD file to get the X12 832 (4010) schema into IRIS, but I have been hard pressed to find either downloadable resources or commercial options. The typical recommendation, edi-dev, seems to just do tooling that will help create SEF files, but no longer sells actual SEF files.

Anybody got any good resources that might have these schema files?

Thanks for any help!

Cordially,

Jonathan

Hi Community ,

I have a csv file to read and validate the data in the file 

How can i ready only 1st line from the file using Readline()

Thanks,

smythee

Is there any way to include a CSP page within a CLS?
Example: #Include file.csp 

Context: I work with a legacy that most screens are built using only CLS. I'm trying to change this by separating the frontend layers to be built only with CSP and backend layers using CLS. I improvised a method that injects an iframe to render the CSP in CLS through that iframe, but I'm still not happy. I need to know if there is any way to include this CSP using some specific resource for this.

Im trying to run a local instance of the UCR/Patient Index in a container but its giving me an error. 

Here is my docker compose file:

version: "3.2"

services:
  iris:
    image: container.intersystems.com/intersystems/healthshare_unifiedcarerecord_insight_patientindex:2023.2
    platform: linux/amd64
    command: --key /dur/key/iris.key
    ports:
      # 1972 is the superserver default port
      - "9091:1972"
      # 52773 is the webserver/management portal port
      - "9092:52773"
      # 52773 is the JDBC Gateway port
      - "9093:52773"
    volumes:
      - ./data:/du

hi !

now I want to insert data to third party database directly, Link Table wizard how to insert  except by sql? 

s obj=##class(YBFXJC.LABINFO).%New()
  ;s obj.ID="1"
  s obj.HISID="1"
  s obj.APPYNO="1"
  s obj.HOSPITALID="1"
  s obj.BILGDRNAME="1"
  s sc=obj.%Save()
  w sc_$System.Status.GetErrorText(sc),!

 there is error <CANNOT SET THIS PROPERTY>zSaveData+3^YBFXJC.TestSaveObj.1

Let's say I have an InterSystems IRIS instance with 6 Namespaces:

• Foo1
• Foo2
• Foo3
• Foo4
• Foo5
• Bar

And the number of Foo# namespaces can increase at any time for a number of reasons.  I need to ensure that they all have identical configuration globals stored in a DB called CONFIG, so I do the following in my configuration file:

[Map.%ALL] 
Global_SYS=%DEFAULTDB 
Global_SYS("CommonConfig")=CONFIG 
Global_SYS("CommonOtherSettings")=CONFIG 
Global_SourceControl=CONFIG 

This will ensure that all Namespace see the exact same settings when they reference ^SYS("CommonConfig") or ^SourceControl,

Hi:

We are looking again into DB size. Looking at our Ens.MessageHeaderI GSIZE is 3767107

Looking at the global i'm not sure if we have had an issue in the past so much of the data looks the same, we only have 3 values in the  $zwc and although some of the data in the $c between 1 and 18630 it looks very similar as if there was an issue in the past. But if anyone has any examples of their index param this would help to know if our global is abnormal. 

Data below 

^EnsLib.H.MessageI("Extent",18631)	=	$zwc(152,8000)/*$bit(1..64000)*/^EnsLib.H.MessageI("Extent",20750)	=	$zwc(152,8000)/*$bit

I'm having problems with an HL7 message that is not properly parsed by IRIS (any version, including Ensemble).

The message is a OML_O21 and is valid, in fact is similar of what is described in the document "IHE Laboratory Technical Framework, Volume 2a (LAB TF-2a) version 6.0".
This is the sample from the IHE document (paragraph 2315):

MSH|^~\&|OF|Chemistry|AM|Automation|200309060825||OML^O21^OML_O21|msgOF101|T|2.5|123||||USA||EN
PID|1||12345^5^M10^Memphis_Hosp^PI||EVERYMAN^ADAM^^JR^^^L|19800101|M 2320
PV1|1|O|Ward|||||||||||||||12345
ORC|NW|||666^gastric|||||200309060824|222221^NURSE^NANC

Hello everyone,

Recently, I've been working on a Business Process that processes a large JSON FHIR message containing up to 50k requests in an array within the JSON.

Currently, the code imports the JSON as a dynamic object from the original message stream, obtains an iterator from it, and processes each request one at a time in a loop.

The performance meets the requirements, even with much larger requests than the one exposed above. However, I am interested in learning the best practices for handling large JSON in ObjectScript (and why not, Embedded Python) to achieve better performance for

Hi, I am trying to optimize a method, I am only occasionally receiving Internal Server Error from GUI interaction and when viewing the Application Error Log in IRISHealth this is what I see. <UNDEFINED>%0Ac+3^%sqlcq.QM.uEgYAnxQ4duxnAiaOpZgvilz1tlo.1 *sqldata15d : CSP Error .

I have no idea how to read this and pinpoint the issue.

Full details below.

Hi Community,

Watch the new video on InterSystems Developers YouTube:

⏯ Introduction to HealthShare Unified Care Record

I have a table that is already created and contains data.  I need to create a unique constraint that is a combination of two fields. Is there a way to do this in a SQL statement?  Also, I would lke to know how to add it in the table class.