go to post Dmitry Maslennikov · Oct 17, 2016 XLS, files much more difficult that plain CSV. And depends on which version you want. XLS - it is a binary format, but XLSX already bunch of XML files but compressed in one file.You can try to use ZEN reports, which supports XLS as one of output formats.
go to post Dmitry Maslennikov · Oct 17, 2016 I think not so many people know about Ultiview and even how it could be connected with Caché. So, in this case, you should some more details in your topic, how it connected, and how this question depends on Caché.
go to post Dmitry Maslennikov · Oct 17, 2016 There are lots of ways how to export data in CSV format in Caché. Add here your or code, or some more information. How you did it, and after that we may help.
go to post Dmitry Maslennikov · Oct 17, 2016 And demo server still available here, just switch to map, at the toolbar close to combobox with a list of databases.
go to post Dmitry Maslennikov · Oct 17, 2016 You can use this linkhttps://community.intersystems.com/rss
go to post Dmitry Maslennikov · Oct 15, 2016 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.
go to post Dmitry Maslennikov · Oct 14, 2016 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.
go to post Dmitry Maslennikov · Oct 11, 2016 I'm just repeat my answer from google groupsThis 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.
go to post Dmitry Maslennikov · Oct 11, 2016 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.
go to post Dmitry Maslennikov · Oct 11, 2016 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.
go to post Dmitry Maslennikov · Oct 11, 2016 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?
go to post Dmitry Maslennikov · Oct 11, 2016 Thanks for review, and I think you right, and fixed as you offer.
go to post Dmitry Maslennikov · Oct 10, 2016 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.
go to post Dmitry Maslennikov · Oct 10, 2016 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.
go to post Dmitry Maslennikov · Oct 7, 2016 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
go to post Dmitry Maslennikov · Oct 7, 2016 I think you can create some issue in this repoyou 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