All time
InterSystems Developer Community is a community of 24,468 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Hi Community!

This is the update on what are the new applications submitted on OpenExchange in April 2019

New Applications

Arduino Snippets published by @Eduard Lebedyuk

Connect your Arduino to InterSystems IRIS or Caché via com port (or usb<->com)

Japanese Calendar published by @Hiroshi Sato

Japanese Calendar Converter for InterSystems products

Cache Quality for Atelier published by @Daniel Tamajon

IDE extension that helps you detect and fix quality issues as you write code. Like a spell checker, this extension squiggles flaws so they can be fixed before committing code. You can install it directly from Atelier and it will then detect new bugs and quality issues as you code (ObjectScript and JavaScript).

ETL Interoperability Adapter published by @Guillaume Rongier

Extend EnsLib.SQL.OutboundAdapter to add batch batch and fetch support on JDBC connection for Ensemble and IRIS.

R Gateway published by Shiao Bing Sung

Use R language with InterSystems IRIS

The Folding Staff published by @John Murray

'The Folding Stuff' is a simple VSCode extension that adds Visual Studio Code's existing code folding / unfolding features to the editor context menu.<--break->

0 0
0 218

hi

I restored one database on Server B with EXTSELCT^DBREST command from backup file (this backup file is taken from Server A).

When I execute select some rows from one table, it return error like this,

the same select sql can return correct data in server A

But when I select other rows from same table on Server B, it return correct data.

Why? maybe the backup file corrupted?

Thanks

0 1
0 217
Question
· Apr 21, 2017
Cache 5.02 License Error

Hi All,

We are using the InterSystems cache 5.02
We having 80 license unit but don't the reason 50 unit have been consumed (CSP unit)
This happen because of this page ran frequently "/apps/docmatic/%CSP.SysConnection.cls"
Can anyone explain why this page ran frequently and consume license?

Thanks,
Sansa.

0 1
0 217

Hi, Community!

Here are some news on Developer Community enhancements.

In March we fixed a lot of bugs and rearranged the notification system, so I hope you'll be happy with it now.

Enhanced content of the notification

With this new release in every email notification you'll see the reason, why did you get this particular notification and the option to unsubscribe of this types of notifications.

0 0
0 218

I'm excited to let you know that we at George James Software have released some new VS Code training courses. Following the success of our Basics course we have expanded our offering to help InterSystems users looking to move to VS Code improve their knowledge.

Here's what's on offer...
Studio to VS Code Migration - The Basics (2.5 hours)

4 2
0 177

Hi all,

Does anybody have the same issue?

$ZF(-100) to run python script not work when directly execute in studio or in storedproc called by TrakCare, but can work when do in iris session.

The python script imports a "barcode" package. It seems that when directly execute in studio or in storedproc called by TrakCare, the package can not be imported.

1 2
0 215
Question
· Jan 19, 2024
INSERT OR UPDATE only inserts

I am trying to do a INSERT OR UPDATE SQL query, but the query always inserts new rows to table. Is it how I defined the table or am I mising something in the query?

table defines as,

Class AH.AHCOMMON.Tables.HospDepartmentData Extends %Persistent [ Language = objectscript ]
{

0 1
0 216

Hi Developers,

This June, you've posted the whooping 105 new questions on the Developer Community:

Questions

10 Best Questions Ever

3 0
0 217

Hi Developers!

Check out our new Ready, Set, Go fun campaign on Global Masters where you can swim 🏊‍♂️ , bike 🚴‍♀️ , and run 🏃‍♂️ your way through eight challenges to collect points and earn bragging rights.

Don't miss the opportunity to tell us a story of why you started programming and read stories of other participants, share with us the hardest part in coding for you and even leave a review for any of the Open Exchange applications and get bonus points 🌟 .

So, are you ready?😉 🏁

4 1
0 197

The most recent release of Serenji features our innovative gj::locate technology. It was a standalone tool we originally created for a Developer Community contest earlier this year, but we've incorporated it into our debugger after some great feedback from developers. 

It works by navigating you directly to the source of your server-side errors in just a couple of clicks - enabling you to quickly fix errors without the need to count tedious lines of code... and let's be real, who has got time for that when you're under pressure to fix this bug? 

It's simple and straightforward to use:

1. Click on the gj::locate panel in the status bar

2. Enter the ObjectScript error message or line reference from a class/.mac routine..

3. gj::locate then does the work for you by taking you straight to the corresponding line in your source code.

Easy peasy... and with time to spare to make yourself a coffee before your deadline! 

The video below shows it in action - let us know if you've already given it a go. Or, if you're interested in trying it out we offer a free 30 day trial license, just drop me a message through the Developer Community or email us at info@georgejames.com.

Serenji 3.2.0 utilising gj::locate technology

2 0
0 217

Hi InterSystems Architects,

Please may I know the relationship between

1. Menus, Workflows, Workflow Items, Components, Code Tables, etc

Detailed relationship diagrams, how each element in each of the above are related to another.

2. When I extracted the data. I see ID number, but they aren't unique or related. I wanted to build a relationship between them myself in the absence of documents but I am missing the critical unique primary key of each and how they are referred in another table.

0 3
1 214
Announcement
· Oct 28, 2020
InterSystems Certification Survey

Hello Everyone,

We are working on growing the InterSystems Certification program, and would like to gather some input from the community.

Please participate in this brief 6-minute survey to share your thoughts with us regarding the new certification exams we have planned and other program improvements that we are considering.

0 0
0 217

Hi Community!

Thank you for being with InterSystems Developer Community yet another year! We appreciate it very much!

We want to know how helpful DC for you today and how could we make it better.

Could you please go through this short 5 min survey which will let us know what do you think about DC and what could be improved.

We wish you a Merry Christmas and a Happy New Year!

Sincerely,

Your InterSystems Developer Community Team

1 0
0 217

Abstract

In a recent benchmark test of an application based on InterSystems Caché, a sustainable rate of 8.9million database accesses/second, with peaks of 16.9 million database accesses/second, was achieved. These results were from a test performed on a connected system of eight applications servers, using Intel Xeon 5570 processors, and running Linux as the operating system. This benchmark shows that:

0 0
0 217