Hi All,

Can you help me how to extract SQL table data into a text file and generate the text file in a particular file path 

Thanks,

Smythee

Hi Community,

Here are two video demo's of Kozo Pages.

Hello,

I try to realize a simple test in a BPL and i have this kind of error message. I don't understand why ! I have a simple CSV file in input with 3 columns (Nom, Prenom, Age) and a rule based on the age

ERROR <Ens>ErrBPTerminated: Terminating BP TestSiJeune # due to error: ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>zevaluateRuleDefinition+18 ^User.Person.IsJeune.1 *Age,User.Person.TransfoTest.Context -- logged as '-'
number - @'
if (((pContext.Age)>(25))) {'
> ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>zevaluateRuleDefinition+18 ^User.Person.IsJeune.1 *Age,User.Person.

Hi Community,

We're super excited to share with you a special session from Global Summit 2022! And it is so special to us because it is about us and with us! Please welcome:

🤩 InterSystems Developer Ecosystem @ Global Summit 2022 🤩 

Hello! I am currently creating a class for a small error trap. I have it working and all is good but I really want to change the order of the fields in the SQL return from Alphabetical to something else.  

The current Order is ID, ActionType, ErrorCount, ErrorDetails, Model, ResultCode, ResultMessage, Stock and Yard

I would really like for the field order to be ID, Yard, Stock, Model, etc.

Example of current order,  

Is this possible?

Thanks in advance!!

Is it possible to use integer with a higher precision so that something like this works:

ClassMethod BigNumbers()
{
    Set bigInt1 = 9223372036854775807Set bigInt2 = 9223372036854775808W !,bigInt1
    W !,bigInt2

    Set bigInt3 = 9223372036854775807123456789W !,(bigInt3 # 2)
}

9223372036854775807
9223372036854775810   // should be 9223372036854775808
0                     // should be 1

The docs say ". However, with extremely large numbers (larger than 9223372036854775807E127) it is not always possible to convert a numeric string to a Decimal value.

Hey Developers, 

New video is already on InterSystems Developers YouTube channel:

⏯ Using the Business Process Designer in InterSystems IRIS

Hi Guys

I have a table data in one namespace that I want to access from another Namespace  - is that possible?

Cheers

We're excited to announce the launch of the Community Roundtable series!

Roundtable sessions are for you to learn new things and connect with other Community members. Each month we'll select a new topic, provide an overview and select a specific date and time for this event.

We drafted a couple of topics for the first roundtable to choose from, but most of all we want to hear what you'd love to discuss! 

Navigate >> to this challenge << on Global Masters to choose the topic and suggest yours.

UPD: Challenge is closed. Thank you for voting and ideas! We will be announcing the topic for the first session shortly.

Is anyone aware of how to find out if a UNICODE database has been installed on an 8-bit version of IRIS i.e. is there a way of checking and actual database rather than the IRIS instance version?

Hi Team,

                I am new to InterSystems. I am trying to setup DHTML editor with ActiveX control for Trakcare 2021.7 version. I am receiving Ensemble locally not installed error. Could you please guide me for using Ensemble in local windows machine

Hello guys,

Does anyone know what is a process status IPQW ?

We get it in jobs that do some SQL..

Thanks in advance.

Yaron Munz 

I am using $Query to loop through a global. 

When I use $GET to get the data all we get back is the global name. 

How do you get the value of the global after you have looped. 

Below is my example in terminal. 

Thank you in advance 

Set node = $Query(^FromExtraMed("")) 

w node
^FromExtraMed("A02",9220)

If i try w $GET(node) it returns 

^FromExtraMed("A02",9220)

If i had this hardcoded it would have got the value

w $GET(^FromExtraMed("A02",9220))
0,66340,2120

I have already read the documentation and it is not clear. Can someone advise? 

In the August Learning Services newsletter, see how you can get hands-on with healthcare analytics tools, Embedded Python, and InterSystems Package Manager. If you're new to InterSystems ObjectScript, try out a learning path to get started!

Hey Community! 

We've always had this idea on the back burner about improving the process of collecting, analyzing, and responding to product enhancement requests from our members. We knew we needed a good user experience and even better internal processes to make sure the best ideas were gathered, heard, and responded to. And finally, this thought has come to fruition!

So in case you missed it, let me introduce to you the Official InterSystems feedback portal:

💡 >> InterSystems Ideas << 💡

Can someone help me on how the alter a table in Management table, I have tried the SQL and MYSQL way but it does not alter the table.

Thank you.

Is it possible to access (read, write) to an external Oracle database via Cache SQL Gateway using JDBC in Cache Object Script?  I am currently using ODBC successfully but wanted to see if JDBC was an option too.  If it is possible, does anyone have a basic Object Script example(s) that I can review?

Thanks!

Hi,

Is there a way to include a prefix for the instance name in the server connection? I have 1 server with multiple iris instances, using 1 webserver. Each instance can be reached using a prefix in the url: (for example https://localhost/instance1/...).

I want to use VS code remote, but can't add the prefix to the hostname (or ip), and also not to the port, as this is numeric. Any idea how to solve this?

This GitHub is the simplest way to scrap using IRIS and Python, all of that already incorporated in an IRIS PRODUCTION.
From here you can build any IRIS production in full Python or in ObjectScript as this module is interoperable.
See for more information

1. IRIS-WEB-SCRAPING

• 1. IRIS-WEB-SCRAPING
• 2. What is Web Scraping:
  • 2.1. The popular libraries/tools used for web scraping are:
  • 2.2. The BS4 tool
• 3. Using full Python to web scrap on IRIS
  • 3.1. The Production
    • 3.1.1. Starting the Production
    • 3.1.2. Access the Production
    • 3.1.3. Closing the Production
  • 3.2.

I am receiving batched results in an EDIFACT file. I need to debatch and send individual HL7 out. I have built a DTL to read the first instance of a result from EDIFACT and that generates an ORU^R01 as desired, but I have no idea how to make the DTL loop and send multiple HL7 messages outbound.

I did go down the path of stripping the first instance of a result from the EDIFACT, then sending the now truncated EDIFACT data back to itself. This works well in theory but I then need a while loop in the Rule Editor, and I cannot seem to access the source.

Hello,

  We have an IRIS installation on one drive "D"; the drive is a partition that is limited to 2TB in size; we want to move the entire D: contents to a larger partition-type not limited to 2TB.

The IRIS install is on D: as are all of the Databases the instance uses.

Are there any concerns or issues that should be considered or are not so obvious with doing this?

i.e. IRIS and all processes doing disk access to D: need be shutdown first (and a full-backup taken, all journals up to date for mirrors etc).

A new partition of E: created as say 3TB.

We are looking for a 3rd party application that can scan our IRIS based Cache Object Script code for vulnerabilities or coding weaknesses.  There are many, many applications/vendors out there that do code scanning but none seem to support Cache Object Script or scanning the IRIS environment.   If anyone is aware of a company/product that can scan our code / IRIS environment, I would love to hear about it.

Thanks in advance for the help.

Mike

I am trying to import a large base64 string into objects but I can't seem to get it to work:

ClassMethod Test() As %Status
{
Set readerForItkRequestData = ##class(%XML.Reader).%New()
 
Set file="c:\Source\test_full.xml"
 
Set status = readerForItkRequestData.OpenFile(file)
Do readerForItkRequestData.Correlate("Envelope","Phu.Epro.Schema.Itk.Envelope")
set temp = readerForItkRequestData.Next(.pOutput,.tStatus)
Do pOutput.%Save()

}

The class I'm trying to project to: 

Class Phu.Epro.Schema.Itk.Payload Extends (%Persistent, %XML.

Do we have messages.log/cconsole.log projection in SQL?

I was sure we do, but unable to find it.

Now that I have SAM up and running, out of the box I would like to add some Application Metrics. Does anyone have templates, or have suggested classes that someone could use to add custom metrics to SAM? Maybe we should start a repository somewhere? Or would someone be willing to share custom metrics on the Open Exchange? 

What I am looking to do is capture the overall HL7 message and header count per day.

• SELECT Count(ID) FROM Ens.MessageHeader WHERE TimeCreated > <date> and TimeCreated < <date>
• SELECT Count(ID) FROM EnsLib.HL7.

Hello community,

First of all thanks for reading this post:

Because of you are more experienced, pragmatic, and have a lot of knowledge and good know-how; please consider to read and answer some question, if you would like:

Why did you choose to become a software engineer / developer?

How and when did you start to generate a "flow state of mind" during your career?

What are recommend habits inside and outside, during you own time and during your work time, to be focused during you coding session and daily tasks?

📍🙏📌Thanks for reading and answering

Hi, 

I am trying to input an entire xml into a sql server table. I am doing this via an operation in Ensemble.

I keep getting the following error

[SQL Server]XML parsing: line 0, character 0, unrecognized input signature

I have setup the table with a column parameter XML.

Here is the request object that is being sent to the store procedure

<reqSQL xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://www.w3.org/2001/XMLSchema">

<SQLScript>

{ call dbo.PopulateDataTable(?,?,?,?,?,?,?

In this GitHub we gather information from a csv, use a DataTransformation to make it into a FHIR object and then, save that information to a FHIR server all that using only Python.

The objective is to show how easy it is to manipulate data into the output we want, here a FHIR Bundle, in the IRIS full Python framework.

1. Fhir-orga-dt

• 1. Fhir-orga-dt
• 2. Prerequisites
• 3. Installation
  • 3.1. Installation for development
  • 3.2. Management Portal and VSCode
  • 3.3. Having the folder open inside the container
• 4. FHIR server
• 5. Walkthrough
  • 5.1. Messages and objects
  • 5.2. Business Service
  • 5.3.

In MS SQL Server i can do this:

SELECT 
Category, CrewNumber, MedicalCertificationDate, Seat, SeatbeltUsed, Sex, ShoulderHarnessUsed, ToxicologyTestPerformed, childsub
INTO #tempfemale
FROM Aviation.Crew
WHERE Sex = 'F'

The code would create  a new temporary table with the fields defined from Aviation.Crew.   I cannot find how to do this in Cache SQL in the documentation.  Can someone show me the correct syntax or other solution?

Hey Community, 

In this video, you will learn how to use the Data Transformation Wizard in the Management Portal of InterSystems IRIS® data platform to convert messages to other formats: 

⏯ Transforming Healthcare Messages in InterSystems Integrations