Article Robert Cemper · May 22, 2022 1m read Debugging Trick with SQL I'm sure you have met this situation: There is a bug in a System that you can't reproduce yourself locally You need to run a few lines in the affected instance You get full access to System Management Portal But there is just no terminal, nor console, nor access with Studio, Atelier or VSCode How to run your few lines for testing ??? #Best Practices #Other 19 3 5 910
Article Robert Cemper · May 17, 2022 1m read Importance of the Online Demo Server facility In March'22 you may have seen an invitation to Share a Demo of Your Open Exchange ApplicationThe service behind it - InterSystems Online Demo Server (ODS) - is not something new #Open Exchange 5 8 0 266
Article Robert Cemper · May 14, 2022 2m read M:N in Contest #1 M:N Relationship is a recurring object of my interest for a long time.So the subject turns up with me repeatedly.For this article, I found a nice example with TWO separate M:N relationships. Some M:N². It is not pure fiction but taken from a closer view of OEX Contests that we run on a regular base. #Other 9 2 1 332
Article Robert Cemper · May 1, 2022 2m read Reviews on Open Exchange - April 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 2 2 0 184
Article Robert Cemper · Mar 24, 2022 3m read GlobalToJSON-XL-Academic This package offers a utility to export an XLarge Global into a JSON object file and to showor import it again. In a previous example, this all was processed in memory. But if this is alarge Global you may either experience <MAXSTRING> or an <STORE> errorif the generated JSON structure exceeds available memory. #Globals #JSON #ObjectScript #InterSystems IRIS 2 1 0 346
Question Robert Cemper · Mar 23, 2022 How to handle a large JSON object? I have a rather simplistic JSON Object of this structure: #JSON #InterSystems IRIS 1 3 0 544
Article Robert Cemper · Mar 21, 2022 2m read Reviews on Open Exchange - March 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. So if you did a major change and expect a changed review just let me know. Reviews by other members of the community are marked by * in the last column #Open Exchange 2 0 0 156
Article Robert Cemper · Mar 19, 2022 2m read Compare Global Write in ePy vs. ISOS/COS This example demonstrates the difference you may experience when you write toGllobals directly from Embedded Python compared to native ObjectScript. To make this demo useful I start 2 background jobs that simply write sequentiallyto a dedicated global. A common control method signals for a synchronous start.Similar a common stop & view interrupts data feeding. That's the principle process: #Embedded Python #Globals #ObjectScript #InterSystems IRIS 2 1 0 219
Question Robert Cemper · Mar 11, 2022 JOB command fails with Embedded Python It sounds strange though it's embarrassing. I have a class with ClassMethods written in ISOS and Embedded Python. The ClassMethods written in ISOS start in the Background as usual. No problems But my #Embedded Python #ObjectScript #InterSystems IRIS 1 4 0 331
Article Robert Cemper · Mar 8, 2022 2m read ePython - mixed or pure ? You may have seen my series of articles on GlobalToJSON closing with Embedded Python.And to me, Embedded means inside a Class and not PEX or other external variants.The first variants showed that ePy is not an ultimate requirement. ISOS/COS may do it as well.Here I try to position ePy inside IRIS. #Embedded Python #Globals #ObjectScript #InterSystems IRIS 6 1 0 314
Article Robert Cemper · Feb 25, 2022 7m read GlobalToJSON-embeddedPython-pure#3 In my article I described the work using iris.gref .As the official documetation is rather slim on the subject it was necessary to dig into it.Using the power of Python I was able to detect what I needed but was hidden.I decided to share this with you. pydoc did the magic. #Embedded Python #Globals #InterSystems IRIS 3 0 1 193
Article Robert Cemper · Feb 22, 2022 2m read Reviews on Open Exchange - Feb.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. New with this edition:Reviews by other members of the community are marked by * in the last column. #Open Exchange 4 3 0 181
Article Robert Cemper · Feb 9, 2022 2m read GlobalToJSON-embeddedPython-pure#2 This package was triggered by the extra bonus points in the contest for writing the examplein embedded Python only. Therefore PURE #Embedded Python #Globals #JSON #InterSystems IRIS 1 0 0 318
Article Robert Cemper · Feb 9, 2022 2m read GlobalToJSON-embeddedPython#2 I will give you some additional information on my first embedded Python package.it is written as a mix of python and ObjectScript to take the best of both worlds. #Embedded Python #Globals #JSON #ObjectScript #InterSystems IRIS 1 0 0 192
Article Robert Cemper · Feb 8, 2022 1m read GlobalToJSON-embeddedPython-pure I have created a package to export a Global into JSON object file and to re-create it by reloading from this file embeddedPython refers to the new available technologies. It should be understood as a learning exercise of how to handle the language interfaces. Only Global nodes containing data are presented in the generated JSON file.Differently from the previous example, this one is using embedded Python only, no ObjectScript. Therefore PURE #Embedded Python #Globals #JSON #Python #InterSystems IRIS 8 2 0 501
Article Robert Cemper · Feb 7, 2022 1m read GlobalToJSON-embeddedPython I have created a package to export a Global into JSON object file and to re-create it by reloading from this file embeddedPython refers to the new available technologies. It should be understood as a learning exercise of how to handle the language interfaces. Only Global nodes containing data are presented in the generated JSON file. #Embedded Python #Globals #JSON #InterSystems IRIS 1 2 0 351
Article Robert Cemper · Jan 30, 2022 2m read My Reviews on Open Exchange - Jan.2022 If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.It reflects my experience with the status I found at the time of my review.It is kind of a snapshot and might have changed meanwhile. #Open Exchange 5 5 0 191
Article Robert Cemper · Jan 24, 2022 1m read GlobalToJSON-Compact I have created a package that offers a utility to load a Global into JSON object and reverse to create a Global from this type of JSON object. Compact refers to the structure created.Globals nodes are included with data for a fast data load. But also the related code is quite compact. #Globals #JSON #InterSystems IRIS 5 3 0 329
Article Robert Cemper · Jan 24, 2022 2m read GlobalToJSON-Efficient I have created a package that offers a utility to load a Global into JSON object and reverse to create a Global from this type of JSON object. Efficient refers to the structure created.Only Globals nodes containing data are presented in the generated JSON object. #Globals #JSON #InterSystems IRIS 4 2 0 336