InterSystems Developer Community is a community of 17,854 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 Developers,

See how you can get high-performance relational access using SQL to manage data within your InterSystems products:

⏯ Using SQL with InterSystems IRIS

https://www.youtube.com/embed/7l-YT5y-nJo
[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 2
0 219

Hi,

We need a web-based SQL tool to connect to Ensemble/Cache, that will offer more functionality than what the Management Portal offers.
It needs to be web based, so that we can host it on a machine that has connectivity to the server via the superserver port. We (the devs and support) only have browser access to the environment via Remote Desktops, hence the requirement.

Has anyone gotten OmniDB to connect to Ensemble/Cache? If so, can you please advise on how to configure it?

Any other suggestions for such a tool are also welcome.

0 1
0 248

Hi folks!

Sometimes we need to import data into InterSystems IRIS from CSV. It can be done e.g. via csvgen tool that generates a class and imports all the data into it.

But what if you already have your own class and want to import data from CSV into your existing table?

There are numerous ways to do that but you can use csvgen (or csvgen-ui) again! I prepared and and example and happy to share. Here we go!

8 2
0 969

Hi developers!

InterSystems Grand Prix unites all the key features of InterSystems data platforms!

Thus we invite you to use the following features and collect additional technical bonuses that will help you to win the prize!

Here we go!

  • InterSystems FHIR - 5
  • IntegratedML - 4
  • Native API - 3
  • Interoperability - 3
  • Production EXtension(PEX) - 4
  • Embedded Python - 5
  • Adaptive Analytics (AtScale) Cubes usage - 4
  • Tableau, PowerBI, Logi usage - 3
  • InterSystems IRIS BI - 3
  • Docker container usage - 2
  • ZPM Package deployment - 2
  • Online Demo - 2
  • Unit Testing - 2
  • First Article on Developer Community - 2
  • Second Article On DC - 1
  • Code Quality pass - 1
  • Video on YouTube - 3

0 0
0 258

In our latest episode of Data Points, I had a conversation with Senior Instructional Designer @Michelle Spisak about accessibility in Online Learning and in the tech industry as a whole. We discussed some of the ways the Online Learning team at InterSystems has improved accessibility in our learning content and some of the ways it can still be improved in the future! For more information and to subscribe to the podcast, head over to https://datapoints.intersystems.com.

2 1
0 165

Hello community!

I'm creating a script to remove an item (component) from the Ensemble production, I know there is a manual way to do it but as there are several components the idea is to use a script to be faster.

I tried using %Delete() and doing a select on Ens.Config.Item, but this ends up generating several errors in production. Does anyone have any idea how I can do this simply?

0 2
0 224

I am sure I came across this in the past with Cache and just saw this again in IRIS.

When rebuilding or swapping a DAT file for a database it retains the Resource of the DAT file, not the Resource of the Database it is being used for.

For instance, if I have a local Database called APP with a resource %DB_APP and I want to refresh the data from another Database called TEST that has a Resource %DB_TEST I can just copy the DAT file from the TEST folder to the APP folder.

0 5
0 181
Question
· May 6, 2022
User code location

Hi

Does anyone know where the user generated code resides, the stuff one might write for a production, I presume it lives in a table somewhere within a database?

Basically, I want to do some dependency analysis of what I've written - find out what's in use, how it's referenced, etc. I know I can export it to an XML file and work on that, but direct access on a table would be quicker for me.

Cheers

0 1
0 190
Question
· Apr 29, 2022
%JSON.Adaptor

Hi.

Is it possible to set in XData mappings (or any other way) to serialize the property value as display value rather than value it self?

Regards,
Matjaž

0 5
0 281

Hi

I have an a Ens.Request subclass (Invoice) that has a relationship property to another persistent class (InvoiceItems), with properties of its own and the inverse relationship defined referring back to Invoice.

When building a DTL with these classes, the Relationship’s inverse relationship (Invoice, within InvoiceDetails) is displayed.

0 5
0 254
Question
· Apr 4, 2022
FTPS TLS session resumption

We are attempting to update some old FTP interfaces to use FTPS and having an issue with an outbound operation to a FileZilla server.

The connection to the the server works, however it fails to transfer files with the error "TLS session of data connection not resumed."

It appears that "TLS session resumption" is no longer optional in FileZilla Server, and I cannot find any details in the IRIS documentation about it.

Does IRIS support TLS session resumption, or know how to set up FTPS to a recent install of FileZilla Server?

0 3
0 752
Question
· May 4, 2022
HTTP post request

Hi Guys,

How do I do a HTTP post request using a curl and get a response, the response should be a JSON file ? a sample code would be really appreciated.

Thanks

0 4
0 322

Hey Community,

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

New Videos
№ Video Views
1 Creating Pivot Tables with InterSystems IRIS Business Intelligence 171
2 Containerizing InterSystems IRIS Applications 100
3 Online Meetup with Globals Contest Winners 65
4 InterSystems Globals Graph Database 51
5 Update on Intelligent Chart Review 62
6 Global Mindmaps InterSystems IRIS and Mind Elixir 57
7 Cubes Demonstration 53
8 GlobalToJSON AEC 37
9 GlobalWrite ePy vs ISOS 13

0 0
0 134

Learning Services has posted the calendar for virtual classroom training through September! All classes are held 9am to 5pm US Eastern time as live, instructor-led virtual classrooms with hands-on exercises and interactive discussions. Go to classroom.intersystems.com to view the schedule, register for a class, or request a private training for 5-15 people at your company.

2 1
0 210

This year at Global Summit we will have several members of the InterSystems internal applications team (AppServices) on site to present topics of interest to developers. There will be General Sessions that we teach on a number of topics related to tools we're launching to the OEX, knowledge gained based on migrating our Caché app portfolio to InterSystems IRIS, best practices for following OWASP Top 10 with ObjectScript, and a survey of the application landscape offering services to our customers and prospects.

2 9
0 197
Announcement
· May 4, 2022
CCR Angular Pages Update

We have released 6 angular pages to all users from their beta testing phase:

Transition, Create, Clone, Merge, Standard Changes, and Peer Review Docs.

Any issues or feedback can be reported here or in your regular support channels. Non beta users can toggle their beta status here in the CCR app.

1 1
0 176

Hi Community,

Imagine enabling your application to read text to your customer? This is now possible with the new IRIS feature, Embedded Python. With this new functionality IRIS can natively run any open source or commercial Python libraries natively. gTTS (https://pypi.org/project/gTTS/) is a free library that transforms text into audio using the Google Translate service.

Open Exchange app
5 2
2 338

Given I have a property 

Class All.AllBooks Extends %Library.Persistent
{

Property ID As %Integer;

Property Title As User.Book;

}

In the class method

ClassMethod GetABookById(id As %Integer) As %Status
{

SET MyBooks = ##class(All.Allbooks).%OpenId(id)

SET obj = {

     "ID" : (MyBooks.%Id())

     "Title" : (MyBooks.Title)

}

WRITE obj.%ToJSON()

Quit 1
}

How do Access the foreign key in JSON() data

0 7
0 494

Hey Community,

New video is already on InterSystems Developers YouTube channel:

⏯ Embed Business Intelligence into your Applications with InterSystems IRIS

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