InterSystems Developer Community is a community of 19,609 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi Community!

While we're on a roll with new ideas for the Developer Community, we decided to also give the credit where the credit is due (meaning you, our dearest members), and share your creativity and imagination with others.

We're going to introduce a new rubric "InterSystems Memes"! 😜

3 0
0 361

I am doing a HL7 data transformation with object script but need to only write a substring from the first "(" of the NTE-3 field to the end.

example

Input: NTE|1|||Some text (HI) (321)|ABC

Desired Output: NTE|1|||(HI) (321)|ABC

Basically I'd like to delete "Some text ".

If I were writing a shell script I would use sed 's/^.*(/(/' with perhaps a modification to get only the first.

I use the function wizard but can't seem to get the right code.

0 9
0 551

This is the fourth in a series of releases that are part of the developer preview program for 2022.2 Future preview releases are expected to be updated biweekly and we will add features as they are ready. Many updates, fixes and enhancements have been added in 2022.2, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas.

1 0
0 287

Hey Developers,

In July, you posted 83 questions on Developer Community:

Spoiler

How to Answer an Unanswerable Question

And now it's time to announce the Key Questions of July, chosen by InterSystems Experts!

1 0
0 239

Hey Community,

See how data integration features in InterSystems IRIS data platform enable you to easily connect your systems, processes, and people:

⏯ Integration Features of InterSystems IRIS

https://www.youtube.com/embed/N5Rba1zhJgc
[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]

0 0
0 199

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in July 2022:

New Videos
№ Video Views
1 InterSystems Full Stack Contest 2022: Winners! 5068
2 Using Node js to connect to InterSystems IRIS 326
3 Multi Model Capabilities of InterSystems IRIS 184
4 Using Java to Connect to InterSystems IRIS 164
5 Using .NET to Connect to InterSystems IRIS 102
6 Continuing Success 73
7 Pulling Out All the Stops Disrupting Healthcare 68
8 Working with Globals in Embedded Python 63
9 InterSystems IRIS What’s New, What’s Next 58
10 Online Meetup with InterSystems Full Stack Contest Winners 54
11 The first Demo Day of InterSystems FHIR Startup Incubator — Caelestinus 47
12 Kozo Pages - Part 1 46
13 InterSystems Healthcare. What’s New, What’s Next. A panel discussion 44
14 Start Up Brilliance 39
15 Managing Brain Health at Scale Transforming Healthcare with AI & Interoperability 36
16 Greenhouse emssions calculator using GHG Protocol and InterSystems IRIS 36
17 Hackathons Fun & Innovative 34
18 Customer Success 28
19 Gaining Acceptance & Adoption Panel Discussion 28
20 Smart Data Fabric Enabling Future Innovations 20
21 Customer Innovations InterSystems IRIS Success Stories 20
22 Kozo Pages - Part 2 19
23 Breaking the Bank.How BBTS Integrated Data to Enable Open Banking 18
23 Leaving No Stone Unturned SPAR’s Transformation via Connected Retail Data 17
24 Learning as the Cornerstone of Success 15
25 Dealing with large content in Iris Python Native API 10

1 0
0 138

Now available: InterSystems Learning News for July 2022! See how you can:

• Sign up to be a beta tester for the InterSystems IRIS System Administration certification exam.
• Find opportunities to keep you and your team learning.
• Connect to InterSystems Cloud Services.
• Take a classroom course on InterSystems Change Control Record (CCR).

And more! Read all about it and subscribe in the July 2022 Learning News.

1 0
0 162

Hi team,

I'll start with an apology as I am trying to wrap my head around the architecture of how InterSystems IRIS database management works. I am attempting to connect to the platform remotely through say a JDBC or ODBC connection in order to run queries, searches (through SQL statements) on my laptop and was trying to understand whether this would be possible? It is possible to setup an inbound client connection and wanted to better understand the architecture of how the database association works for IRIS database management. Does it use it's own internal SQL database or are we able to connect to our own database and which databases are certified to run against the platform?

0 2
0 319

Where can I download the Cache ODBC drivers?

Where can I download the Cache ODBC drivers for Windows?

I need to connect to a cache database by odbc but the FPTs that I have found do not work,
could you tell me where to download the ODBC drivers

0 15
0 9.6K

Hi guys,

Does rebuilding of Data Quality Manager cubes affect patient index linkage definition data?

What I want to understand is, does DQM have any negative impact on the data each time you rebuild the cubes.

Additionally, if I make changes to the cube and rebuild it..will this have any impact on the original data?

0 6
0 346
Question
· Jul 20, 2022
Inbound Adapters

Hi Guys,

Is there online tutorials or samples on how to use Inbound Adapters ?

All I'm looking for at this stage is to create and inbound Adapter in a production to request to connect to a client where I can Get JSON file and what do I need to establish the connection?

Thanks

0 1
0 220

Hi, we are trying to run a dynamically generated Oracle Insert SQL script using Do $SYSTEM.SQL.DDLImport("Oracle",""," sql.txt",[Error Log]) to insert multiple rows into a Linked Table within HealthConnect to an Oracle database.


We have tried using statements that are accepted within Oracle but not when using Intersystems DLL along the lines of :

0 4
0 520

What are other's thoughts, opinions and experiences going from CSP to RESTful services, specifically when it comes to reusing code in CSP files?

One could define a method in CSP as follows:

<script language="cache" method="SubmitSomethingAwesome" arguments="aswesomeId:%Numeric">

And it's generated in csp.mycsppage.cls ascsp.mycsppage.SubmitSomethingAwesome(awesomeId as %Numeric).

Have people had success defining there rest call by calling the generated CSP classmethod?

Things that work well I've found:

0 3
0 332
Hello everyone! Don't miss the Developer Community Post Digest for July 2022.
General Stats
✓ 151 new posts published in July:
– 26 new articles
– 37 new announcements
– 83 new questions
– 5 new discussions
✓ 153 new members joined in July
✓ 9,935 posts published all time
✓ 11,316 members joined all time
0 0
0 122
Article
· Jul 30, 2022 5m read
Introduction to Django part 3

Continuing to observe the possibilities of Django, and usage with IRIS. The first we have looked how to define models and connect to tables already existing in IRIS, than we extended embedded Django Administration portal, with an ability to see what data we have in that models, with filters, editing and even pagination.

Time to go to real action, now we a going to create some REST API, on Django, based on the same data, we used before from the package posts-and-tags.

To do so, we will use Django REST Framework

Django REST Framework

Django REST framework is a powerful and flexible toolkit for building Web APIs.

Some reasons you might want to use REST framework:

  • The Web browsable API is a huge usability win for your developers.
  • Authentication policies including packages for OAuth1a and OAuth2.
  • Serialization that supports both ORM and non-ORM data sources.
  • Customizable all the way down - just use regular function-based views if you don't need the more powerful features.
  • Extensive documentation, and great community support.
  • Used and trusted by internationally recognised companies including Mozilla, Red Hat, Heroku, and Eventbrite.

Open Exchange app
4 0
0 348

Your application is deployed and everything is running fine. Great, hi-five! Then out of the blue the phone starts to ring off the hook – it’s users complaining that the application is sometimes ‘slow’. But what does that mean? Sometimes? What tools do you have and what statistics should you be looking at to find and resolve this slowness? Is your system infrastructure up to the task of the user load? What infrastructure design questions should you have asked before you went into production? How can you capacity plan for new hardware with confidence and without over-spec'ing? How can you stop the phone ringing? How could you have stopped it ringing in the first place?

23 13
5 4.5K
Article
· Jul 25, 2022 8m read
Introduction to Django part 2

In the first part, I've shown how to start a new project on Django, as well as define new models and add already existing models.

This time, I'll introduce an admin panel, available out of the box and how it can be useful.

Important note: do not expect that if you try to repeat actions from this post it will work for you, it does not. During the article, I had to do some fixes in the django-iris project, and even in DB-API driver made by InterSystems to fix some issues there as well, and I think this driver is still in development, and we will get more stable driver in future. Let's decide that this article only explains how it could be if we would have all done.

11 2
0 413