Article Robert Cemper · Jan 30, 2023 1m read JSONfile-to-Global #2 The power of the presented tool becomes visible with a large JSON file.The example I have prepared is composed of the daily results of AoC 2023.Anonymization makes it usable for demo purposes. #Globals #JSON #Tips & Tricks #Tools #Video #InterSystems IRIS #Open Exchange Open Exchange app 2 1 0 293
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 #Video #InterSystems IRIS #Open Exchange Open Exchange app 7 1 2 307
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: #Video #Other 1 0 1 278
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. #Video #InterSystems IRIS #Other 2 0 0 300
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. #Video #Caché #InterSystems IRIS Open Exchange app 6 1 1 547
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 149
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 163
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 221
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 293
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 220
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 218
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 161
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 136
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 218
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 265
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 231
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 180
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 1.2K
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 190
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 196