Article Robert Cemper · Jan 30, 2023 2m read JSONfile-to-Global #1 The similarity between JSON objects + arrays and Globals in IRIS or Caché is evident.With small and medium size JSON objects navigation across %Dynamic Objects is comfortable.But with large and/or deep cascaded objects it becomes a challenge. The presented tool offers 3 variants loading an already existing %Dyamic object or Array into a global of your choice loading a %Stream containing a JSON object into a global of your choice loading an external File containing a JSON object into a global of your choice #Globals #JSON #Tips & Tricks #Tools #InterSystems IRIS #Open Exchange 7 1 2 250
Article Robert Cemper · Jan 27, 2023 1m read Global-Streams-to-SQL #3 Seeing results in SMP or Terminal If you run the suggested queries from Terminal in SQL shell you see: #Other 1 0 1 203
Article Robert Cemper · Jan 23, 2023 2m read Global-Streams-to-SQL #2 Some technical background information There is not just one class in this package: rcc.gstream.cls but also rcc.gstreamT.cls While rcc.gstream works with direct access to the stream globals, the *T version usesa Process Private Global (PPG) as Temporary storage.using SELECT * FROM RCC.gstreamT WHERE RCC.useT('^jpgS')=1 and similar. #Other 2 0 0 230
Article Robert Cemper · Jan 23, 2023 2m read Global-Streams-to-SQL In general Global Streams are data objects embedded in Classes / Tables.Using and viewing them with SQL is normally a part of the access to the containing tables. SO WHAT? During debugging or searching for strange or unexpected behavior there could be the need to get closer to the stored stream. No big problem with direct access to Globals with SMP or Terminal.But with SQL you are lost.So my tool provides dynamic access to Global Streams wherever you may need thisSpecial thanks to @Oliver Wilms for the inspiration for this tool. #Other 6 1 1 414
Article Robert Cemper · Dec 19, 2022 2m read Reviews on Open Exchange - #23 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 0 0 0 129
Article Robert Cemper · Dec 4, 2022 2m read Reviews on Open Exchange - #22 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 0 0 0 141
Article Robert Cemper · Nov 28, 2022 2m read Reviews on Open Exchange - #21 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 2 0 0 200
Article Robert Cemper · Nov 25, 2022 2m read Reviews on Open Exchange - #20 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 3 0 0 267
Article Robert Cemper · Nov 11, 2022 2m read Reviews on Open Exchange - #19 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 1 0 0 205
Article Robert Cemper · Oct 22, 2022 2m read Reviews on Open Exchange - Oct. 2022 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 1 2 0 187
Article Robert Cemper · Sep 27, 2022 2m read Reviews on Open Exchange - Sep. 2022 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 1 0 0 141
Article Robert Cemper · Sep 18, 2022 1m read Reviews on Open Exchange - Statistics I produce my monthly Review Report on OEX packages now for 18 months.These are a view figures and some comments: #Open Exchange 5 1 0 116
Article Robert Cemper · Sep 2, 2022 1m read Reviews on Open Exchange - Aug. 2022 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 0 1 0 203
Article Robert Cemper · Jul 28, 2022 2m read Reviews on Open Exchange - July 2022 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 0 0 0 238
Question Robert Cemper · Jul 2, 2022 Technical Dictionary for translations I just met a personal challenge translating my article to French.Tough I had to learn it at school and could read and understandfamous literature (Sartre, Molière, Mauriac, Proust, Saint-Exupéry, Anouilh, ...) I missed the specific terms used with ISC technology.Thanks to @Lorenzo Scalese my errors were corrected.But no dictionary was able to answer. #Other 1 2 0 193
Article Robert Cemper · Jul 1, 2022 2m read Reviews on Open Exchange - June 2022 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 0 0 0 160
Article Robert Cemper · Jun 20, 2022 7m read Working with Globals in Embedded Python My major interest is Working with Globals in Embedded Python.So I checked the available official documentation. #1 Introduction to Globalsan attempt of a generic description of what a global is. Pointing to #Embedded Python #Globals #Python #InterSystems IRIS 20 8 3 1K
Article Robert Cemper · Jun 6, 2022 1m read Update - InterSystems Contest Statistics The 24th contest was dominated by already well know winners+ 3 new winning contributors GROWTH: 8,6%Participation by my 5 regions: as: 1, br: 4, eu: 4+1new, us: 1+2new, ru: 5, total:18 With is distribution: #Other 2 2 0 169
Article Robert Cemper · May 30, 2022 2m read Reviews on Open Exchange - May 2022 If one of your packages on OEX receives a review you get notified by OEX only own YOUR package. The rating reflects the experience of the reviewer with the status found at the time of review. It is kind of a snapshot and might have changed meanwhile. Reviews by other members of the community are marked by * in the last column. #Open Exchange 3 2 0 176
Article Robert Cemper · May 29, 2022 1m read ZPM - Adding CSP pages into an existing Namespace ZPM is a great tool.You can compose a large WebApplication following the existing examples. But differently, to Classes, Routines, Macros, or Globals I found no direct way to deploy a few additional CSP pages directly into an existing Namespace without touching the existing content. A side issue was to find a solution that is independent of WIN or Linux directories. My solution acts in 2 steps #CSP #InterSystems Package Manager (IPM) #InterSystems IRIS 2 0 1 185