All
Accepted answers
David Underhill · Mar 10, 2022 go to post

Not 100% sure of the requirement but if you write the output from the Cache code as if it was to the terminal then you can redirect the output to a file by appending >output.file but I don't think cterm is the way to do that as cterm will trap all the output itself, you would need to use csession for that.

You could just write to a file in your Cache code or run an external command/script from inside the Cache code?

David Underhill · Nov 25, 2021 go to post

Microsoft used to have an Excel Viewer but it is retired, though it may still work.
Download the latest online Excel Viewer - Office | Microsoft Docs
If you don't have an MS Office license I'd suggest LibreOffice.
Home | LibreOffice - Free Office Suite - Based on OpenOffice - Compatible with Microsoft
However, you mention CSV files and these are not actually Excel Spreadsheets, they can just be viewed in a text editor if needs be, or any Spreadsheet software will open a formatted view.  There are also CSV specific viewers such as Nirsoft's
CSV / Tab delimited file viewer and converter for Windows (nirsoft.net)
 

David Underhill · Mar 3, 2021 go to post

That command isn't available and versions are held in the Windows Registry (HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Intersystems\IRIS\Configurations\{configuration}).

This is set up when you install an instance/configuration and shouldn't be edited.

David Underhill · Feb 24, 2021 go to post

As Eduard suggests, you need to know the class that the pInput object is derived from as it doesn't seem to be a valid Stream if .Size fails.

It also looks like you might be expecting a file as you retrieve the name so why not use the %File class if the file already exists.

In fact, noting how you get the Filename using the Attributes method this looks like the pInput object is a response with content which means the actual stream will be in pInput.Content

David Underhill · Feb 9, 2021 go to post

It is far too long since I worked on Hospital systems to give an authoritative answer given extra restrictions you may have but for https the connection and data are already secure.

For outbound infrastructure can ensure it is routed outside appropriately and you could even limit traffic to specific external endpoints.

For inbound a load balancer or reverse proxy in the DMZ can keep your system away from the outside world and limit traffic both between the two and only allow specific external endpoints to have access.

David Underhill · Sep 7, 2020 go to post

Hello Robert,

Did you resolve this or log with our helpdesk?

Regards

David Underhill @ Chess

David Underhill · Aug 21, 2019 go to post

We coded all the journal and data file monitoring in Cache itself and just had simple checks on the running status and alerts.log externally, keeps it fairly platform independent.

On windows we used vbscript to check service status and log contents.

David Underhill · Aug 20, 2019 go to post

Hello Gagan,

Have you checked the value in sc from ftp.Store?

Also at that point you can check the values in ftp.ReturnCode and ftp.ReturnMessage for more details on the failure. 

This is also assuming that the status from ftp.Connect is ok and ftp.Connected is true.

David Underhill · May 10, 2019 go to post

A valid point but it can depend on how the command string is formed in the first place, unless you write a parser to break a command string down into a command plus arguements.  I agree that you may as well use $zf(-1 but as the documentation will point you to use $zf(-100 then it can be valid.

It's also usefull to know you can use brackets in this way for general knowledge.

David Underhill · May 9, 2019 go to post

If you want to store the files in the database rather than the filesystem then you can use the Global* streams instead of File*, these also do not create the .stream files in the filesystem.

David Underhill · Sep 29, 2016 go to post

We have built our own schedulers in the main but for the odd Cache Task Manager task we have created we just export and import the subclass.