Hey Developers,
The InterSystems Analytics Contest is over. Thank you all for participating in our exciting coding marathon!
And now it's time to announce the winners!
A storm of applause goes to these developers and their applications:
Hi Community,
Learn how to use validation tools in InterSystems IRIS to assess and validate the behavior of a production:
There are couple of options to do this.
1. You can extend your class &JSON.Adaptor, it will do it for you with inbuilt logicaldtodisplay methods
2. Create another request class and do your transformations
3. Before calling the json convert to stream methods, transform the object's field with a ZDT.
---------------------------------------------------------------------------------------------------------------------------------------
I have an extremely simple example where there is a class with 3 properties
Class NV.Operations.FileOutbound.Data.P1 Extends (%Persistent, %Populate)
{
Property ClaimId A
Hi Developers,
Thanks to all who participated in our competition for your awesome ideas of applications that can be developed in 2021. See what a great list of ideas you all created! Now it's time to announce the winner:
Meet the Author of the Best Idea: @Yuri Marx 👏🏻👏🏻👏🏻 Congratulations!
💡 Yuri's idea: "HTML 5/Node.js documentation generator app, based in markdown and with the option to execute ObjectScript class methods like a developer portal. It is not to swagger API, but to Object Script".
Yuri gets our special prize: a personalized handmade leather wallet.
See the complete list of ideas in the comments to this post. You are very welcome to leave more of your ideas! We hope this list will bring inspiration to all of you.
I have implemented a web service that inherit from %SOAP.WebService
It exposes classes with string properties :
Class Employee Extends (%RegisteredObject, %XML.Adaptor) [ ProcedureBlock ]
{
Parameter XMLNAME = "Employee";
Parameter XMLSEQUENCE = 1;
Property FirstName As %String(MAXLEN = "", XMLNAME = "FirstName") [ Required ];
Property LastName As %String(MAXLEN = "", XMLNAME = "LastName") [ Required ];
...Here is the issue: those properties are filled from a huge Caché database which contains forbidden XML characters (usually control characters in the 0-31 range).
Ideally, the
Hi Developer!
During the last 4 days of the year, December 28-31, 2020, the price in points for these rewards will be changed:
JBL Clip*: 8000 points instead of 12 000 points (only 2 left!)
Socks: 800 points instead of 1200 points
Car Phone Mount: 800 points instead of 1 700 points
Any 1,5 hour consultation on InterSystems product: 3 000 points instead of 5 000 points
Certification Voucher*: 8 000 points instead of 10 000 points
🏃🏼Hurry up to redeem your prize!
Even if you are not a Global Masters member yet, but you made posts/comments on DC, or you have an application on Open Exchange - visit Global Masters to check your points, as they automatically adjusted for all your contributions.
Hi Developers!
This is a release of how did we improve the Developer Community in December 2020. The key features:
- version product field for Question posts;
- $ZV - exact product version for Question posts;
- new tag tree page;
- SVG Support.
See the details below.
Hi Developers,
This post is a compilation of Top Authors, Top Experts and Top Opinion Makers of the InterSystems Developer Community in 2019. And it is a good guide "Who to Follow" in 2020.
We're glad to present these people who have contributed a lot to our community in 2019.
Let's take a closer look at the DC Wall of Fame 2019 and greet everyone with big applause! 👏🏼
Hi all,
I added an additional shard node to an existing shard by accident.
After the add， it can not be removed and query from the master shard now fails. I did not find any data from shard master in the shard node.
How to recover it and remove the shard node from the shard master?
Thanks.
Hi guys.
That time I'll show you a way to use a machine learning model implemented using IntegradeML as source for an IRIS analytics cube dimension.
Creating the ML model:
Execute this SQL in order to create a new ML model using IntegratedML SQL extension:
CREATE MODEL AppointmentsPredection
PREDICTING (Show)
FROM (SELECT
Canal,
CreacionDate,
CreacionHora,
Edad,
Especialidad,
Latencia,
ReservaDate,
ReservaHora,
Sexo,
Tipo
FROM dc_myapp_model.MedicalAppointments
Now, you can train you model:
TRAIN MODEL AppointmentsPredection FROMThe question has come up several times and I saw mixed answers and no quick example
My personal preference is using CPIPE device as you get back exactly the output you will get at the command line interface of your OS .
The tricky thing is to stop reading in time.
The example just displays what you normally see in your console.
it becomes useful if you look for things that you can't get from any $system.whatever()
e.g.
- your servers IP address or addresses depending on your configuration.
- pinging any other server to see if it is still visible on the network
- running nslookup
Zpipe quit
Hi developers!
We had a set of technology bonuses for the InterSystems Analytics contest.
And here is how projects collected it:
| Project | docker | zpm | IRIS BI | IRIS NLP | Integrated ML | Real Data | ISC Reports | Total |
| Nominal | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 8 |
| iris-analytics-notebook | 1 | 1 | 1 | 3 | ||||
| website-analyzer | 1 | 1 | 1 | 1 | 4 | |||
| dataking-server | 1 | 1 | 2 | |||||
| iris-analytics-package | 1 | 1 | 1 | 2 | 5 |
This table is subject to change upon project improvements or if we missed something.
Fill free to claim the bonus in the comments here or on discor
How difficult is it to create a report using InterSystems Reports?
Spoiler
Good day, Developer Community!
As you know we have Company listings on Open Exchange. It lets publishing Open Exchange applications on behalf of companies so one can check which solutions in certain industries are being provided by companies.
Sometimes people are also looking for qualitative and proven implementation or consulting services on InterSystems products: IRIS, Caché, Ensemble, or HealthShare.
And recently we introduced a new option on Open Exchange to list the services your company provides related to InterSystems technology: implementation, consulting etc.
How to do that?
Open your company profile in the Services tab and create a service. Choose the type of service and give a description of what the service is about and why it is worth ordering it. Instructions.
Then publish the service by sending it for approval.
The InterSystems IRIS has two major paths to a digital service: API/Web Service into Interoperability module and multimodel Database/Analytics. Each of them has your security configuration.
To do API security you apply an OAuth or JWT plug-in to the API endpoint. So in the Admin Portal, API producer and consumers get the keys to authenticate the API and consume it. The Admin Portal allows you configure RBAC policies too.
To do WS security the best strategy is to use SAML.
Did you know that you can get IRIS Analytics features as an REST API?
In this article I'll show some endpoints of IRIS Analytics Business Intelligence REST API, used in my project iris-analytics-notebook to create a pivot table component in Angular.
Getting all cubes in namespace
Method: POST Endpoint:
/api/deepsee/v1/:namespace/Info/Cubes
Example:
http://localhost:52773/api/deepsee/v1/myapp/Info/Cubes
Response example:
<iframe style="width:100%; height:200px;" src="//jsfiddle.net/jrpereirajr/74ep301q/15/embedded/result/" allowfullscreen="allowfullscreen" allowpaymentrequest
Hey Developers,
Advent of Code 2020 is over! Thanks for participating in InterSystems ObjectScript marathon!
And now we're pleased to introduce the winners and distribute all the prizes!
Big applause goes to these winners:
@Fabian Haupt (w/ repo )
@Yuval Golan (w/ repo )
And here's the final InterSystems leaderboard:
Hey Developers,
This week is a voting week for the InterSystems Analytics Contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.
🔥 You decide: VOTING IS HERE 🔥
How to vote?
Please meet the new voting engine and algorithm for the Experts and Community nomination:
Hi everyone,
It's the bottom of the 9th inning, but I have a few more plays to make in our technical World Series 
The InterSystems IRIS has a very nice container class to allows you have your Dashboards as classes source code. It is %DeepSee.UserLibrary.Container.
With this class is possible group all your dashboard and pivot table definitions.
This is useful to automatically create your dashboards when you build your docker project and other automation scenarios.
See:
Class dc.WebsiteAnalyzer.WebsiteAnalyzerBIContainer Extends %DeepSee.UserLibrary.Container
{
{
<items>
Hey Developers,
Are you ready to participate in the annual December competition?
Join the Advent of Code 2020 with InterSystems and participate in our ObjectScript contest to win some $$$ prizes!
Today, is important analyze the content into portals and websites to get informed, analyze the concorrents, analyze trends, the richness and scope of content of websites. To do this, you can alocate people to read thousand of pages and spend much money or use a crawler to extract website content and execute NLP on it. You will get all necessary insights to analyze and make precise decisions in a few minutes.
Gartner defines web crawler as: "A piece of software (also called a spider) designed to follow hyperlinks to their completion and to return to previously visited Internet addresses".
There
Hello guys.
Can anyone help me about Global ^Errors? Only in 1 specific namespace is it growing fastly. It grows from 2 to 3 Gb per hour when all services are active. Which commands exactly do this? In another similar namespaces, there is not that Global in the class list.
Thanks.
Hi guys!
I'd like to present you my new project: iris-analytics-notebook, a notebook approach to use IRIS analytics capabilities.
Project description
In past few years, notebooks tools like Jupyter are gaining popularity due its natural way to express ideias.
An almost unipresent tool for data scientists, notebook can also help to improve the impact of analytics tools for all sort of users.
This project is my attemp to implement a simple notebook system, combining IRIS Analytics capabilities, with a custom notebook system - largelly inspired by Jupyter notebooks.
With this project you can:
- Create
I am trying to create an ODBC class that includes all of these as records, but I don't see how I can since the first record has 3 subscripts, the rest have 4 subscripts:
.png)
Here is my current storage definition:
<Storage name="Test">
<ExtentSize>100000</ExtentSize>
<SequenceNumber>25</SequenceNumber>
<SQLMap name="Test">
<Data name="ModificationDate">
<RetrievalCode> set {ModificationDate}={L4}</RetrievalCode>
</Data>
<Data name="Operator">
<Delimiter>":","|"</Delimiter>
<Piece>36,2</Piece>
</Data>
<Data name="CreationDate">
<Delimiter>":",","</Delimiter>
<Piece>24,1</Piece>
</Data>
<Data name="CreationTime">
<D
Hello,
I am trying to use %ZEN.proxyObject to send out in JSON format so I do:
set tProxyRequest = ##class(%ZEN.proxyObject).%New()
set tProxyRequest.notanumber = "28001"
set tProxyRequest.aboolean = "true"
set tBody = ##class(%GlobalCharacterStream).%New()
do ##class(Ens.Util.JSON).ObjectToJSONStream(tProxyRequest,.tBody,"aelotwu")
w tBody.Read()
set tProxyRequest.notanumber = "28001"
set tProxyRequest.aboolean = "true"
set tBody = ##class(%GlobalCharacterStream).%New()
do ##class(Ens.Util.JSON).ObjectToJSONStream(tProxyRequest,.tBody,"aelotwu")
w tBody.Read()
and I get:
{
"aboolean":"true",
"notanumber":28001
}
But I want this:
{
"aboolean":true,
"notanumber":"28001"
}
Help please !
I compiled some data about past InterSystems DC constest. Some statistics:
- 64 applications (17% of all current apps into OEX - 377 apps in december/2020)
- 08 contests
- 29 developers
See the summary:
| Contest | Winner Apps | Total Apps | Benefits to the community |
| InterSystems IRIS, Docker and ObjectScript | BlocksExplorer, ISC DEV, sql-builder, isc-generate-db, declarative-objectscript | 20 | New open source utilities to maintain and develop SQL and admin Caché and IRIS |
| InterSystems IRIS with REST API | iris-history-monitor, Production Manager, JSON-Filter, simple-spellchecker | 7 | New |
About this article:
In InterSystems IRIS, the default form of access to the management portal is HTTP, which means that if the client is in the office and the server is in the cloud, many clients probably desire to encrypt their traffic in some way.
Thus, we would like to show you some ways to encrypt your traffic to and from the IRIS management portal (or various REST services) running on AWS.
This article uses the IRIS built-in apache server for access.It should not be used for benchmarking purposes or as a method of access from production environments applications.
Caché running on Windows Server includes a built in telnet service. Unfortunately though telnet is a plain text protocol, which generates a security violation from our network security scanner. Is there a way to replace telnet with SSH to connect to a Caché system running on Windows 2012 R2?
Web Crawling is a technique used to extract root and related content (HTML, Videos, Images, etc.) from websites to your local disk. This is allows you apply NLP to analyze the content and get important insights. This article detail how to do web crawling and NLP.
To do web crawling you can choose a tool in Java or Python. In my case I'm using Crawler4J. (https://github.com/yasserg/crawler4j).
Crawler4j is an open source web crawler for Java which provides a simple interface for crawling the Web. Using it, you can setup a multi-threaded web crawler in few minutes.
After create your Java project,
