Are there any objectscript functions (not wizards) to export and then import table data (including RowID)?

It doesn't matter what format the exported file is.

The import and export process should preserve all relationships, foreign keys, etc. I need to be able to export and import multiple tables at the same time.

I need this to implement the ability to export multiple tables from one instance and load them into another.

Hi Developers!

Welcome to the 16th edition of the InterSystems Ideas news! Here's what you can expect from it:

​​​​✓ Ideas implemented in Q3 2024

✓ Select an idea to implement from "Community Opportunity" ideas

✓ Vote and comment on new ideas submitted in Q3 2024

Hi Guys,

Given that Analyst property is defined as class object I'm getting the Analyst ID in the below dataBinding, but I'm looking to display the Analyst name, I tried using dataBinding="Analyst->Name" but no luck, I got the same issue when binding to dataCombo or comboBox ?

Hi Community,

Play the new video on InterSystems Developers YouTube:

⏯ Using LLMs with InterSystems IRIS Interoperability Productions @ Global Summit 2024

https://www.youtube.com/embed/IQ9r0OWYSZ8
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

I’m trying to connect to an InterSystems Caché database from my local development environment using an IPv4 address. Most examples I’ve found show how to connect using the ODBC driver with the localhost or the default IP address (127.0.0.1). However, I want to know how to connect using my local IPv4 address.

Here’s what I need help with:

Hello Community!

We are pleased to invite all our clients, partners and members of the community to take cart in the InterSystems DACH Symposium 2024. The registration is already open!

For all those who were unable to travel to the Global Summit in the USA this year, there is once again the opportunity to get all the important information at our InterSystems DACH Symposium in November.

➡️ InterSystems DACH Symposium 2024

🗓 November 5 - 7, 2024

📍 Scandic Frankfurt Museumsufer | Wilhelm-Leuschner-Straße 44 | 60329 Frankfurt am Main

I'm experimenting with adapting SDA3 object model to store medical data in relational form, e.g.:

class Demo.DemoPatient extends (%Persistent, HS.SDA3.Patient) {}

The HS.SDA3.Patient class has the Aliases property which is a nested collection (list) of objects of type HS.SDA3.Name:

json file failing in conversion to SDA

• DO^zToQuickXML+11^HS.SDA3.NVPair.1 +2
• DO^zToQuickXML+34^HS.SDA3.CustomObject.1 +1
• DO^zToQuickXML+8^HS.Local.SDA3.CodeTableDetail.HealthCareFacilityExtension.1 +1
• DO^zToQuickXML+28^HS.SDA3.CodeTableDetail.HealthCareFacility.1 +1
• DO^zToQuickXML+6^HS.SDA3.Location.1 +1
• DO^zToQuickXML+12^HS.Local.SDA3.ProcedureExtension.1 +1
• DO^zToQuickXML+29^HS.SDA3.Procedure.1 +1
• DO^zToQuickXML+155^HS.SDA3.Container.1 +1
• $$^zToQuickXMLStream+5^HS.SDA3.QuickXML.1 +1

Hello,

First of all: thanks for your help, and thank you for your time.

Thanks for your time.

We have the following situation:

We are in a BPL, and we have defined 4 <call> asynchronous as follows:

First one name: "Enviar a Proceso NEGRIN"

The second one, named as: "Enviar a Proceso HUNSC"

How can I display the patch version?

The command Write $system.Version.GetPatchId()
doesn't show anything.
What other options are there?
Thanks.

I have a BPL iterating over Dynamic arrays. Can I add Dynamic Array (%Dynamic Abstract Object) and also %Iterator.Array to BPL context? I tried and I see Error: %AddToSaveSet method does not exist for %Iterator.Array

I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created

CREATE PROCEDURE Silk.sp_InsertRecord (
IN RecordDate TIMESTAMP,
IN UserName VARCHAR(50),
IN RecordType INT,
IN RecordID VARCHAR(50),
IN CategoryID INT,
IN ApprovalDate TIMESTAMP,
IN FileSize BIGINT,
IN WorkstationName VARCHAR(50)
)
BEGIN
INSERT INTO DummyRecords (
RecordKey,
FilePath,
RecordDate,
UserName,

Hello Community,

We use $ZF(-1 synchronous call to generate the pdf files. Now I want to change to asynchronously. So, I use $ZF(-100 with "/ASYNC" function. I use "/ASYNC" directly write $ZF(-100,"/ASYNC","notepad.exe") in windows/linux it throws the <NOTOPEN> error, However If I use $ZF(-100,"/ASYNC /SHELL","notepad.exe") it opens the notepad without issues.

Many programming languages use the try-and-catch construct to handle runtime errors gracefully. If the code within the try block encounters an error, it will throw an exception to the catch block, where the error handling occurs.