go to post Dmitry Maslennikov · Nov 6, 2020 You can download these versions. Community Edition just has a few limitations, but still can be used. And look at the installation guides
go to post Dmitry Maslennikov · Nov 4, 2020 Are you sure that, your insert queries send null and not an empty string? Null and empty strings are different, what are you trying to achieve it's a null, and $c(0) is an empty string. Documentation
go to post Dmitry Maslennikov · Nov 3, 2020 Unfortunately, it does not fully support work with CSP files. If you use local instance, you can just open the folder with CSP files in VSCode, and edit them as any local file. If your server is remote, so, the only way right now is using virtual filesystem isfs.
go to post Dmitry Maslennikov · Nov 2, 2020 In VSCode you just had to open any local folder. And it's a manual choice. When you opened any folder, which is supposed to be as a project root. Configured the server connection, you then should be able to open ObjectScript Server Explorer (by InterSystems logo icon). There you can observe your code on the server, and do export from context menu. Export will be logged to ObjectScript output, with full path's of exported items. Go to File explorer in VSCode (default view), and from context menu on any folder or class, you will have action Import and compile.
go to post Dmitry Maslennikov · Oct 31, 2020 Extracting such amount of data with using JDBC/ODBC, will be much slower than any sort of native access in Cache. InterSystems Cache offers a way to export the whole table, with selected columns Open System Management Portal, System Explorer, SQL. Switch to the desired namespace. Click on Wizards and select Data Export The next steps should be pretty much simple, just select what you need to export and starts in the background. So, you will be able to control how it is going. Look at the documentation for more details
go to post Dmitry Maslennikov · Oct 30, 2020 Extract data could be quite tricky depending on how old is application there. If you sure that the desired data is available through SQL, so you can use any SQL tools, DataGrip, DBeaver, Squirrel-SQL. DBeaver already supports Cache out of the box, and very soon will support IRIS as well.
go to post Dmitry Maslennikov · Oct 30, 2020 What kind of editor do you need? What do you need to do with this editor?
go to post Dmitry Maslennikov · Oct 19, 2020 @Bob Kuszewski, what do you mean by better processes? What does it mean for jdbc driver or any other jar files, which have only one place where they supposed to be published is, maven central. Currently, InterSystems - JDBC and InterSystems XEP just contain empty files, which have to be deleted. JAR files here, just only 155 bytes in size or even less. https://repo1.maven.org/maven2/com/intersystems/intersystems-jdbc/3.0.0/ https://repo1.maven.org/maven2/com/intersystems/intersystems-jdbc/2018.1... https://repo1.maven.org/maven2/com/intersystems/intersystems-xep/2018.1....
go to post Dmitry Maslennikov · Oct 19, 2020 The most interesting, is why current files on maven central us completely useless? Just empty jar files.
go to post Dmitry Maslennikov · Oct 16, 2020 In chrome you can open developer console, switch to console tab, and copy an actual link in the latest error message.
go to post Dmitry Maslennikov · Oct 16, 2020 I can confirm that it happens due to changes in Google Chrome, it prevents downloading files from http:// when the site is opened as https://.
go to post Dmitry Maslennikov · Oct 12, 2020 At the same time, I would not recommend spending time on official webgateway docker image, as it made to be too specific for ICM and/or Durable %SYS. And at the same time, needs some magic to get it working. e.g. apache will not start without specifically saying so. And even if it started, it does not mean, that it will be started with the CSP module enabled.
go to post Dmitry Maslennikov · Oct 12, 2020 Instructions of what? If saying just about Apache+webgateway. The repo I've provided is quite complete. With some basic knowledge of docker. So, you just have to build the docker image, publish it to some docker registry, public or private and deploy it with AWS Deploying just IRIS itself as a container does not make so much sense at all. As it needs to be packed with some application it should run. Containerized IRIS it's not the same as IRIS running on a virtual machine, it's very different, and not so easy to explain it in a simple way. For instance, you can look at this article, about deploying some web-based IRIS application on Amazon I would recommend, to contact me through info@caretdev.com, so, we could schedule a discussion, where you could give more details, and I will say the ways how it can be solved.
go to post Dmitry Maslennikov · Oct 12, 2020 Are two of these dates 202010011000 and 8/6/2018 9:10 PM equal? Or, what the format for the numeric one?
go to post Dmitry Maslennikov · Oct 10, 2020 Having separate Apache it's not something unordinary, and in fact, is just a recommended way for web-based applications. And Apache in docker or not have no difference. The configuration will be exactly the same. You can look at my example I made some time ago. It uses docker-compose, but the key feature, that it should use the same network, which creates by default in docker-compose configuration for the services in the same project. So, you just have to prepare apache with webgateway, and properly configured. Or like in my case, webgateway can be configured by environment variables, so, the same image can be used multiple times with different IRIS servers.
go to post Dmitry Maslennikov · Oct 9, 2020 Look at my project, it implements a backend, where frontend can be any, In my example it uses Vue by default, and Angular and React as option. Frontend, is that something, that completely not related to InterSystems at all. You can do it in any way you like. In project RealWorld you can find lots of realizations of exactly the same frontend. And any of this realization can be used with any of realization of backend, and in our case, it can be IRIS as well. And this project is very cool in case, when you would like to see, how to do the same in a different way.
go to post Dmitry Maslennikov · Oct 6, 2020 There is only one way to do it, is to use any supported webserver, Apache or Nginx, and do not use built-in apache. Configure the chosen server to work with InterSystems products. And configure SSL for that server, in any way by instructions you can find on the internet.
go to post Dmitry Maslennikov · Oct 4, 2020 You can use property "links" in "objectscript.conn", to add some links to your projects, which you will be able to open quickly "objectscript.conn": { "active": true, "username": "_system", "password": "SYS", "ns": "MYAPP", "port": 52773, "links": { "MyApp": "http://${host}:${port}/csp/${namespace}/main.csp" } } After this, you will get a new item in the menu shown by click on the status bar with connection info.
go to post Dmitry Maslennikov · Oct 2, 2020 While you are working with JSON, I would recommend to not do it manually and use native JSON support, available since 2016.2 (2016.1 with notes). So, you can do it just set json = {}.%FromJSON(str) or set json = {}.%FromJSON(stream) and value will be available by write json."Not Working Example" If you have a version with no native JSON support, look at this project
go to post Dmitry Maslennikov · Sep 30, 2020 I don't see XML here, but for your examples, I would use Regex Set regex = ##class(%Regex.Matcher).%New("(""[^""]*""):\s(""[^""]*""|[^,]*)") Set regex.Text = """Working Example"": xyz," Write !,regex.Text,! If regex.Locate() { Write !?5,regex.Group(1) Write !?5,regex.Group(2) } Write ! Set regex.Text = """Not Working Example"": ""x, y""," Write !,regex.Text,! If regex.Locate() { Write !?5,regex.Group(1) Write !?5,regex.Group(2) } And the output will be "Working Example": xyz, "Working Example" xyz "Not Working Example": "x, y", "Not Working Example" "x, y"
