Question
John Flippance · Jun 2, 2017
Decoding Base64 PDF File

Hello, I am writing some cache code that will pick up a PDF file, Base64 encode the contents and then send on to a third party system within a Long String (via their API). I have been testing this and discovered that the PDFs do not open within the supplier system (I get an error saying that it hasn't been decoded correctly). I wanted to prove that the issue does not lie with the way that I have Base64 encoded it within Ensemble, and therefore as a test wanted to Encode the PDF stream, then decode the stream and write out to a new file.

0 11
0 4,055

Let's consider these two ways of passing an obj to a function:

//var is a structured obj
(1) do ..methodX(var)
(2) do ..methodX(.var)

In c++ if we pass an obj by reference like in (2) we save a lot in computation because we are not copying the whole object, and when the object is modified within the function it is modified also for everyone.

In this case does (2) achieve any better performance than (1)? Is passing with the "." save any computation? the object is copied anyway?

Is there a simple way of passing obj to a function?

0 3
0 109

I am trying to pull the status of operations in health connect. I'm successfully pulling if it's enabled/disabled, but I'm not getting access to where the current item status is held (for example, items in error). I found "##class(EnsPortal.Utils).ItemStatuses", but I can't retrieve data from that. Is this data readily accessible via another means?

Thank you!

0 4
0 66

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.

0 8
0 216

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

0 2
0 137

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')

0 2
0 85
Question
Davidson Espindola · Apr 29, 2017
Parameters

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

0 5
0 535

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?

0 2
1 102

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

0 2
0 66

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

0 5
0 104

Have a Zen report with a huge query that we are trying to break down and be more efficient.  

Looks like Zen only wants to take a result set class as the data (or XML, but writing to a file to generate these reports is probably even more overhead).

Is there a way I can move through a result set object, delete rows I don't want based on some objectscript commands and the pass that to the report?

Or can I pass a dynamic object?

Thanks.

0 3
0 98

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

5 8
3 705

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?

0 1
0 156
Question
Kurro Lopez · Dec 19, 2016
HL7 Section to JSON

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

0 6
0 1,063