Article
· Sep 11, 2021 5m read
iris-analytics-for-money

I regret getting a late start in the InterSystems Analytics contest. I had tried a couple of times before to use Analytics, but I had not gotten too far. I have been recording financial transactions in Excel workbook ever since I had to retire Microsoft Money. Since my iris-for-money was not fully functional, I created a worksheet per account I was tracking. I had developed a CSP page in iris-for-money to import transactions by reading a CSV file.

Open Exchange app
8 1
0 304
InterSystems Developer Community is a community of 23,405 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hey Community

A new video is already on InterSystems Developers YouTube

⏯ Best Practices for InterSystems API Manager

https://www.youtube.com/embed/FYq8rIqmz2w
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 394

I'm using FOP 1.1 for ZEN reports and would like to install fonts within the Windows/Fonts directory.

I added the xml tags in fop.xconf but so far I have been unable to get the correct font.

<renderers>
<renderer mime="application/pdf">

<fonts>
<directory>c:\windows\fonts</directory>
<!-- automatically detect operating system installed fonts -->
<auto-detect/>
</fonts>

</renderer>

</renderers>

Any advice would be appreciated.

1 5
0 560

Hi Developers,

It's time to announce the Winners for August 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in August 2021:

🥇  @Sergey Mikhailenko, Chief Specialist, AO Mosvodokanal, Russia

🥈  @YURI MARX GOMES, Software Architect, YM Services, Brazi

🥉 @Nigel Salm, Senior Systems Architect at Health System Technologies, South Africa

       

Learn more about the competition and our awesome winners below.

4 3
0 246

I'd like to share with you some storage features that also exist in Caché but are almost
unknown and mostly not used. They are of course available in IRIS and gain importance
with large and distributed storage architectures.

15 0
1 522

I am trying to get a list of databases using the DatabaseByServer method but I am only getting an empty string. I have not found any useful examples of the proper usage of this class/method.

I have tried 2 formats. First

set dbList=""

set db=##class(Config.Databases).DatabasesByServer("my-host",.dbList)

I also tried:

set db=##class(Config.Databases).DatabasesByServer("my-host",.dbList,"/cachesys/")

In each case dbList is empty string. I can not figure out what I am missing.

0 2
0 126

Hello,

I am a clinician and we use Trakcare Lab LIMS at our institution.

We understand histopathology reports are directly typed, stored and uploaded directly to the LIMS.

For clinical audit purpose we need to download these reports directly in text format in bulk. Can anyone offer some technical assistance in retrieval of these histopathology reports? Is there any script that can be run to access, retrieve and download these reports?

0 1
0 203

Previously I have already tried to play with Google Data Studio when I connected it to InterSystems FHIRaaS. It has quite a nice UI, with a few chart types available out of the box, it can be quite easily connected to some plain tables (stored as CSV or JSON, for instance), and gives the ability to build quite flexible analytics over it. So, I have decided to implement a new connector to InterSystems Analytics (DeepSee), with the ability to select a cube and do some queries on it.

Open Exchange app
3 0
0 361
Question
· Sep 8, 2021
Force YYYY format

Hi Guys,

when using $ZD(mydate,4) sometimes it returns year as 4 digits and sometimes two, and the documentation is saying ([YY]YY is a two-digit year if hdate falls within the active window for two-digit years; otherwise it is a four-digit year), what active window for two means and how can I force the year to be always 4 digits ?

Thanks

0 2
0 245

Hey Developers,

New video is already on InterSystems Developers YouTube:

⏯ Deploying & Upgrading IRIS with Kubernetes Operator

https://www.youtube.com/embed/TnHfrWv6s5Y
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 245
Question
· Aug 15, 2021
Post Deployment Support

Hello,

Does anyone know if intersystems has a support document/ support guide on "Healthshare"? We need to share it with our L1 support team.

Any support document with a few known issues with their resolution, that the L1 team can expect and resolve?

0 1
0 160

Hi Developers,

The new video from Global summit 2019 is already on InterSystems Developers YouTube:

⏯ Intersystems IRIS Kubernetes Operator

https://www.youtube.com/embed/PvlDp6xLQ5U
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 4
0 735

Hi Community,

join the fun "Wonders of the World" journey on InterSystems Global Masters advocate hub!

You'll see a challenge to provide feedback on Global Masters, a challenge with selfie photos (OMG that's so great to see the Community's selfies! That's not a public challenge so don't worry we will not publish it unless you gave us your permission!), challenges with interesting facts and tech video.

3 9
0 358
Question
· Sep 5, 2021
Global Access command query

Hello everyone,

I am new to cache. I want to know is there any direct command to know how to find maximum number of subscripts in global A through direct command.

I mean the answer is 9 but how to check it using a direct command on terminal.

Thanks in advance!!

^A(1)="A"

^A(1,2)="B"

^A(2,1)="CVB"

^A(3,2,7)="'DFGH"

^A(4,1,8,9)="ASDASD"

^A(5,1,2,4,5,6,7,8,9)="ASDASDASD"

0 3
0 302

Hello all,

I have a problem where one of our 3rd party systems is only able to accept HL7 messages with UTF-8 encoding but the originating messages have Windows 1252 encoding. Does anyone know a way in which I can change the encoding for the entire message from Windows 1252 to UTF-8? I have only been able to find the CONVERT method to change individual charachters but we would like to change the entire HL7 message encoding.

Thanks!

1 1
0 677
Question
· Aug 12, 2020
dotnet core

Is there an InterSystems supported dotnet core library or community contributed repo on the horizon? At this time we are exploring installing the ODBC driver in our containers but would rather use more robust solution.

2 15
0 1.4K

The OKR methodology (Objectives and Key Results or Objectives and Key Results) is used by the largest companies in the world (such as Google, Netflix, Spotify, BMW, Linkedin, etc.) for agile performance management. It was created in the 1970s by Andrew Grove, president of Intel, and introduced to the general public in his famous book “High Output Management”.

Around 1998 John Doerr, one of the world's top venture capitalists, after coming into contact with Intel's OKR, introduced the model to Larry Page and Sergey Brin, who started a small company called Google.

Open Exchange app
6 0
1 276

Hi,

I'm processing POP3 emails using the standard EnsLib.EMail.InboundAdapter adapter and %Net.MailMessage. I'm basically processing documents that are attached to received emails. This works fine if the document is simply attached to the email itself. But some systems are sending documents that are attached to an attached email which has content-type = message/rfc822.

How do I get the attached file from the attached email?

0 3
0 788

Hi everyone - In IRIS we would like to arrange the access of two users in such a way that each has access to exactly one (his) database only. Which resource does this (%DB_%DEFAULT allows each of the two users access to both databases). If you create new resources (%DB_Database1 and %DB_Database2) and then add them to individual roles (each for the user to), the access for the users, for example, via a REST client does not give the desired separation (instead once Ok, other database 401 Unauthorized both OK).

0 2
0 346

Hello everyone

I am new to cache. In an interview i was asked how to optimize a sql query.

I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries.

I want to know what will be the answer for how to optimize SQL query in cache.

Thanks in advance!!

0 2
0 260

Hello Everyone

I am new to cache. I know there are 2 types of methods in cache. One is Instance method (Which can be call through object creation of particular class) and other is Class methods (which can be call through ##Class(MyPackage.Car).CarModels()).

I want to know the difference when to create a instance method vs when to create a class methods.

Thanks in advance!!.

0 3
0 256

I wanted to write it as a comment to article of @Evgeny Shvarov . But it happens to be so long, so, decided to post it separately.

Image result for docker clean all images

I would like to add a bit of clarification about how docker uses disk space and how to clean it. I use macOS, so, everything below, is mostly for macOS, but docker commands suit any platform.

6 6
3 7.1K