All
Accepted answers
Dmitry Maslennikov · Oct 15, 2016 go to post

Please add more details. What HTML report? And what the final goal, you have to achieve ?
Looks like you have to use %Net.HttpRequest, but I'm not sure, because of your description.

Dmitry Maslennikov · Oct 14, 2016 go to post

While it is possible to do with COS, there are so many different ways to achieve it.

Most easiest and preferable way, is to write some code on server side, and call it from batch script.

To work with users, you can use class Security.Users.

Also you can look at %Installer manifest, which has some functionality about security.

Terminal scripts, can help to automate some things. And how to run it.

And even you can read this article, about COS and Linux. It is quite simple, but as an example.

Dmitry Maslennikov · Oct 11, 2016 go to post

I'm just repeat my answer from google groups

This process names decompile, and it is quite difficult process, and may not be legal in some cases I think. 

I saw only one very old project, for version 5 or less.

And actually answer is yes, it is possible, but we don't have such tool now. To do it, you should know exactly how works compiler, and it's lots of work.

Dmitry Maslennikov · Oct 11, 2016 go to post

Yes, Studio, it is just a part of client components for the database. You can install only studio if you want, but you should use full installer.

But you can try to use Atelier, which standalone application, with own installer.

Dmitry Maslennikov · Oct 11, 2016 go to post

Your clarification does not help actually. But any way, deleting any object, leave just ID on a link, and again, everything here depends on your application. In most cases it could cause for some different issues, when application have not expected deleted object. And I would recommend to use some flag like "isDeleted", which can help to hide such objects in most of places, and still have an access to the content of this object, to show if it would be needed. Completely delete object recommended only in case when no any other objects has links to this one. 

Dmitry Maslennikov · Oct 11, 2016 go to post

It is completely depends on application which you use. Some developers create their own table for users independent from Caché users.

Or maybe you talking about  HealthShare or TrakCare?

Dmitry Maslennikov · Oct 10, 2016 go to post

While your code interrupted when server shutdown, you can't do it directly. But I think you can try to call restart service of cache. So you should look at possiblilties OS, which you use for this server.

Dmitry Maslennikov · Oct 10, 2016 go to post

You can't reset query, and loop again on the same result. You should execute as many as you need their results.

But I think you can store result somehow, to some you buffer, and use it in next time.

Dmitry Maslennikov · Oct 7, 2016 go to post 
    set url="http://www.intersys.com/main.csp?a=b&QUERY=abc&QUERY=xyz"
    Do ##class(%Net.URLParser).Parse(url, .aComponents)
    
    set query=$lfs($get(aComponents("query")),"&")
    for i=1:1:$ll(query) {
        set $lb(name,value)=$lfs($lg(query,i),"=")
        set index=$order(data(name,""),-1)+1
        set data(name,index)=$g(value)
        set data(name,index,"O")=i
    }
    zwrite data

 

data("QUERY",1)="abc"
data("QUERY",1,"O")=2
data("QUERY",2)="xyz"
data("QUERY",2,"O")=3
data("a",1)="b"
data("a",1,"O")=1
Dmitry Maslennikov · Oct 7, 2016 go to post

I think you can create some issue in this repo
you can also look at my example of Dockerfile, when I delete installation folder in the same command RUN with installation, which should became in the same layer

Dmitry Maslennikov · Oct 5, 2016 go to post

When you upgrade Caché from any previous version, every time you should look at Upgrade Checklist in the documentation, and this checklist while upgrade from such old version as 5

And even with just a search by documentation you may find this link, with a text

SPOOLER Heading Processing Changed
In this version, a number of changes have been made to the HEADING and FOOTING statements, and general printer/terminal output in this context. Applications that depend on the format of SPOOLed output should be carefully checked to make sure the output still conforms to expectations.
Dmitry Maslennikov · Sep 30, 2016 go to post

Have you tried it in cmd.exe instead of PowerShell, or the same troubles there ?
Please show screenshots from page Securty, Services

Dmitry Maslennikov · Sep 27, 2016 go to post

Sorry my mistake, I don't have widows system currently, for windows you should change %Service_Console

to check access, you may use this command

..\bin\cache -s.

Powershell or cmd does not matter.

Dmitry Maslennikov · Sep 27, 2016 go to post

Ok, looks like, it does not matter who tried to connect to cache, any terminal access is forbidden. 

You should allow Password or Unauthenticated method for %Service_Terminal.

Dmitry Maslennikov · Sep 27, 2016 go to post

first sample is correct, but depends on what is login.scr contains. This file should only contains 'answers' for login.

so, it is a plain file, with login and password, in each line, and last empty file.

login<\n>
password<\n>

<\n> - it is just a line break, which is required 

Dmitry Maslennikov · Sep 22, 2016 go to post

I'm just in the begin, I'm working on developing FHIR-based application, and currently it's enough, mostly because so far for production.  

Dmitry Maslennikov · Sep 21, 2016 go to post

in your code,

obj - it is some object, it may have some ID or not, if it just created

name1 - it is a value for property name in that object

but I completely don't understand why is here name2 and name3, and what do you suppose should be happens after this line ?

and how it should save data in other objects which we even don't know which ?

you should know somehow which objects you want to update. If you know only some other properties, you can use SQL command UPDATE 

Dmitry Maslennikov · Sep 21, 2016 go to post

What does you mean ? In this case we get all data in property Name, if you need data from other property just use it.

Write !,obj.Address
Dmitry Maslennikov · Sep 21, 2016 go to post

You should actually read this tutorial.

Every class, has some types of elements, and some of them like Property and Parameter may contains some data.

Property stores data for every objects in this class, Parameter, for class itself.

In your example, saving data to properties of object was right. But in method PrintDetails, you try to read data from Parameter, not from property. To read data from property you should open this object before, but you also need to know an ID for such object.

#; open object by known ID
set obj=##class(Sample.Employeedetails).%OpenId(1)
#; if obj is empty, so this object could't be found, and open

#; ouptut property Name for this object
​Write !,obj.Name
Dmitry Maslennikov · Sep 21, 2016 go to post

Please forget about old-way programming. We now have so many features out-of-the-box which helps write understandable code quite easy.

set fs=##class(%Stream.FileCharacter).%New()
set fs.Filename="c:\csvfile.csv"
while 'fs.AtEnd {
  set line=$listfromstring(fs.ReadLine(), ",")

  #; in line you will get listbuild for all columns in a row
​}

class %Stream.FileCharacter helps to read text files, which may contain text in different codepages, and line ends.

Or if you need to read some binary data, which should have some conversion on the fly, use %Stream.FileBinary.

Dmitry Maslennikov · Sep 21, 2016 go to post

I've already answered for exactly the same question at google groups

In first you should look at the official documentation which is available online here. 
You have very old system, so you should install new version of Ensemble at new windows server. Installation Guide 

And copy all of you data from old server to new. But it is may be very difficult task, without knowledge about your application.

As well you should look at Cache Upgrade checklists archive and latest, and Ensemble Release Notes