#Caché

Hi,

My routine contains embedded SQL including this:

&sql(DECLARE C1 CURSOR FOR

The error "SQLCODE=-52 : Cursor C10 already declared" comes up on compilation in Studio. Does anyone know a way around it please?

Bob

In this article I'll show you how you can easily convert between many different document formats, these to be precise:

• in: html, odt, doc, docx, rtf, sdw, txt...
• out: html, odt, docx, rtf, pdf, txt, tex, xhtml...

and many more, check out this table. We'll use LibreOffice as a conversion engine.

Hi team,

I have a PDF file which has come report data and images (like XRAY) in it. How I can read text from a PDF file in  cache

Hi ,

How to Convert Excel message into a SDA3 format in Ensemble?

In my Python script I import intersys2.pythonbind3 to create the connection and define a database object as db

I execute the method 

     res = self.db.run_class_method("%Library.GlobalEdit", "GetGlobalSize",[<db>, allocated,used])

This executes correctly as I loop through a list of databases.

Upon success I see that the return arg of "res" contains the string "status(0,)" which I interpret as successful. This is verified by the returned values of allocated and used being accurate. But I want to use the class/methods to get the status values from the returned structure

I have a REST Service that I want it to receive a json string request I have set up my URLMap as follows the top URL when populated and requested works fine but I would like my request to be a json string and that is not working I am getting a 500 error am I missing something please advice.

XData UrlMap
{
<Routes>
<Route Url="/:emailAddress/:sendUserEmail/:password" Method="POST" Call="ResetPassword"/>        this works fine
<Route Url="/test" Method="POST" Call="test"/>              I would like this to receive a json formatted string for the above
</Routes>
}

Hi community,

I have to do a development that should to connect with a external REST API and it throws different HttpStatus and a body content with the description of the problem.

I'm using the following code:

set tSC = ..Adapter.SendFormDataArray(.tHttpResponse,"POST",tHttpRequest,,,URL)

If the external API responses throws a 400 Status (Bad Request)

the tSC values is an error status and the value of tHttpResponse is empty, so I'm not able to check what is the Status Code and the content.

Hi Guys

Is there a zen control that exposes the "Copy code to clipboard" functionality , as seen in the code sample of this page?

Cheers

Hello All,

I have a class method on the DocRepo server that needs to query the data value of a global variable on the Edge server. 

I have looked at the documentation for 'Global Structure,' but I didn't find anything that helped.

Global Structure | Using Globals | InterSystems IRIS Data Platform 2022.1
 

I am able to access this global easily from the Edge server using the $Get function, but I need to access it from the DocRepo server.

Any suggestions would be greatly appreciated!

Thanks!

Craig

Hi All

I'm building a ZEN page that will dispay HL7 from a database, and am currently displaying it an textarea.

 Is the HL7 viewer that is displayed when HL7 message is selected in a visual trace available as an out of the box tool I can plug into a webpage?

Andy

How can we insert into a table using a stored procedure? 

Table structure :

CREATE TABLE SampleHospital (
    Hospital VARCHAR(50),
    Location VARCHAR(50),
    UserName VARCHAR(50),
       UserFullName VARCHAR(70),
       LastLogin TIMESTAMP,
       LoginCount int)

Procedure Name:

call Custom_MENS_Other.samplesp('2021-11-02','2021-11-04','H001')

Hi

The following page references the Zen Demo

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…

Where can I find it to download. I'm drawing a blank here.

Cheers

Hello friends,
I am having the following problem when passing a parameter in the execution of a zen query?
If the parameter has more than 50 characters of the error.
Http://127.0.0.1.57772/csp/sistema/CLINICA.Rel.Atestado.cls?nome="José Roberval Benedito da Silveira Gonçalves Sobrinho "

Is there a configuration or solution to this problem?

Hugs

Davidson Espindola

Credentials for a Productions are stored as plain text in ^Ens.SecondaryData.Password and exposed as plain text via SQL table Ens_Config.Credentials which is not ideal as only admins should know the credentials.

I can create my own adapter etc... to store and use encrypted passwords but does anyone know if there is a standard way to do this in a Production?

Alternatively, am I missing how to secure this so the production can run and someone can monitor and operate a production without access to the SQL table or global?

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

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 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!

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'

Hi,

When i am using $$$LOGERROR("Message is Discarded") in the class  i am getting "Referenced Macro Not defined" error 

Can you help me how to use $$$LOGERROR in a class

Thanks,

Smythee

Hi Community

I have created a simple package that allows the use of Cache with the Laravel Framework.

From my initial testing everything seems to be operating smoothly but I would like to appeal to the PHP users in the community to help me improve this package.

For those of you out there who have time and would be interested in this, please visit the repo at https://github.com/jeandormehl/laracache

Thanks in advance

Hi ,

     When I use jdbc driver to query the column info ,the "REMARKS" field always show the same as the "COLUMN_NAME" field.

When I use the sql "select * from INFORMATION_SCHEMA.columns a where a.table_name='some table name ' " to query columns info,there has a "DESCRIPTION" field ,the value is some comment for the current field.

So is there anyway to return the description to the jdbc  remarks field? And is there anyway to update the desciption or remarks field? Or is there some other way that I don't know to manage column comment info?

Hi all,

Does anyone backing up with CommVault version 11 (but lets forget the version for now) and had problems using vss to backup Cache/Iris ?

Can you tell me what you did to overcome that problem/problems?

Thanks,

Yossi.k

Hello community,

First of all thanks for your time reading and answering this post:

We have read the following topics:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

https://community.intersystems.com/post/using-regular-expressions-cach%…

https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic…

https://community.intersystems.com/post/string-manipulation

https://community.intersystems.com/post/string-manipulation

We have the following need:

There is an URL which has 3 parameters:

Hi,

I am receiving a JSON File as Stream container Using  pRequest As Ens.StreamContainer and output as  Output pResponse As %Persistent in a Custom Business Operation 

Please find the code below

Method OnMessage(pRequest As Ens.StreamContainer, Output pResponse As %Persistent) As %Status
{
    Set tFilename=..Adapter.CreateFilename(##class(%File).GetFilename(pRequest.OriginalFilename),..Filename)
    Set tSC=..Adapter.PutStream(tFilename, pRequest.Stream)
    Quit tSC
}

Question:How can i extract name,DOB,SSN from the pRequest and save the same values in SQL persistant table?

Hi all,

I'm trying to convert a HL7 section to a XML or JSON string.

We need to save the content of PID section into a SQL Column, therefore we need to convert it into a XML o JSON string

is there any easy way to convert it?

I've tried to convert it directly into a DTL, but all my attempts have been unsuccessful

Best regards,

Francisco Lopez

Hi there have been various posts around how to clean up globals without parent data but none have gone into how you solve these issues. 

Our database is approaching 600gb in size so i am looking into how to reduce this. 

We use standard purge tasks. 

Our cache stream class has a global size of 2463243 from running global size so it is what i would like to tackle first. 

1) is there any way i can find based on my oldest message session for where most of these globals 

2) in the class where these are created what can be done to ensure purping. Basically we have 

Healthcare interoperability is instrumental in improving patient care, decreasing healthcare provider costs, and providing a more accurate picture to providers. However, with so many different systems, data is formatted in many different ways. There are many standards that have been created to try to solve this problem, including HL7v2, HL7v3, and CDA but each one has its drawbacks.

Hello,

Is it possible to read an Office 365-mailbox over POP3 with OAUTH.

Basic authentication doesn't work anymore.

Regards,

Kurt Hofman,

ASCI nv.

Hi

I created a password validation routine for the management portal, which is called from the System-wide Security Parameters.
The validation process works correctly, but the error message that is displayed to the user when the entered password fails validation, consists of two separate error codes and messages

I see the following message when I click on my User at the top of the Management Portal screen (which then opens the popup window), to change my password and enter an invalid password:
ERROR #1446: Password change failed ERROR #5001: Password must contain at least one upper-case character

During a major version upgrade it is advisable to recompile the classes and routines of all your namespaces (see Major Version Post-Installation Tasks).

do $system.OBJ.CompileAllNamespaces("u")

do ##Class(%Routine).CompileAllNamespaces()

To automate this administration task and keep a log of any errors, below is an example of a class to import and compile into the USER namespace that you can use after each upgrade : admin.utils.cls