go to post Robert Cemper · Mar 25, 2022 Enfin la communauté dans la langue deRobert le Magnifique et son fils Guillaume le Conquérant. !* * * * * + + + * * * * *
go to post Robert Cemper · Mar 24, 2022 That raised the level but was no general solution. As I failed in my Docker container I didn't push it to DemoServer not to break it. Neither Embedded nor (external) Python was able to handle it by standard approach. I did my customized solution to handle any size of JSON file.
go to post Robert Cemper · Mar 23, 2022 Does $ZSTORAGE also affect available memory in Embedded Python ?
go to post Robert Cemper · Mar 23, 2022 sorry, I have no idea what X12 204 EDI is structured. or what you talk about
go to post Robert Cemper · Mar 21, 2022 in System Mgmt Portal / Operation / Database you find a Free Space view
go to post Robert Cemper · Mar 21, 2022 I have added a new version for the GLOBALS contestTo take care of large Globals that may break your available memory.The JSON Object is exported to a file. and there is also the related loader New Version 0.1.0 USER>write ##class(dc.GblToJSON.EX).export("^dc.MultiD") File gbl.json created And the related loader creates the Global USER>write ##class(dc.GblToJSON.EX).import() Global ^dc.MultiD loaded It is of course also available in the Online Demo facility. And to see the generated file there is a show() method USER>write ##class(dc.GblToJSON.EX).show() {"gbl":[ {"node":"^dc.MultiD","val":5}, {"node":"^dc.MultiD(1)","val":"$lb(\"Braam,Ted Q.\",51353)"}, {"node":"^dc.MultiD(1,\"mJSON\")","val":"{}"}, {"node":"^dc.MultiD(2)","val":"$lb(\"Klingman,Uma C.\",62459)"}, {"node":"^dc.MultiD(2,2,\"Multi\",\"a\")","val":1}, {"node":"^dc.MultiD(2,2,\"Multi\",\"rob\",1)","val":"rcc"}, {"node":"^dc.MultiD(2,2,\"Multi\",\"rob\",2)","val":2222}, {"node":"^dc.MultiD(2,\"Multi\",\"a\")","val":1}, {"node":"^dc.MultiD(2,\"Multi\",\"rob\",1)","val":"rcc"}, {"node":"^dc.MultiD(2,\"Multi\",\"rob\",2)","val":2222}, {"node":"^dc.MultiD(2,\"mJSON\")","val":"{\"A\":\"ahahah\",\"Rob\":\"VIP\",\"Rob2\":1111,\"Rob3\":true}"}, {"node":"^dc.MultiD(3)","val":"$lb(\"Goldman,Kenny H.\",45831)"}, {"node":"^dc.MultiD(3,\"mJSON\")","val":"{}"}, {"node":"^dc.MultiD(4)","val":"$lb(\"\",\"\")"}, {"node":"^dc.MultiD(4,\"mJSON\")","val":"{\"rcc\":122}"}, {"node":"^dc.MultiD(5)","val":"$lb(\"\",\"\")"}, {"node":"^dc.MultiD(5,\"mJSON\")","val":"{}"} ]} ***** gbl.json *****
go to post Robert Cemper · Mar 21, 2022 I have added a new version for the GLOBALS contestTo take care of large Globals that may break your available memory.The JSON Object is exported to a file. and there is also the related loader New Version 0.1.2 USER>write ##class(dc.GblToJSON.CX).export("^dc.MultiD") File gbl.json created And the related loader creates the Global USER>write ##class(dc.GblToJSON.CX).import() Global ^dc.MultiD loaded It is of course also available in the Online Demo facility.And to see the generated file there is a show() method USER>write ##class(dc.GblToJSON.CX).show() {"gbl":[ "^dc.MultiD=5", "^dc.MultiD(1)=$lb(\"Braam,Ted Q.\",51353)", "^dc.MultiD(1,\"mJSON\")=\"{}\"", "^dc.MultiD(2)=$lb(\"Klingman,Uma C.\",62459)", "^dc.MultiD(2,2,\"Multi\",\"a\")=1", "^dc.MultiD(2,2,\"Multi\",\"rob\",1)=\"rcc\"", "^dc.MultiD(2,2,\"Multi\",\"rob\",2)=2222", "^dc.MultiD(2,\"Multi\",\"a\")=1", "^dc.MultiD(2,\"Multi\",\"rob\",1)=\"rcc\"", "^dc.MultiD(2,\"Multi\",\"rob\",2)=2222", "^dc.MultiD(2,\"mJSON\")=\"{\"\"A\"\":\"\"ahahah\"\",\"\"Rob\"\":\"\"VIP\"\",\"\"Rob2\"\":1111,\"\"Rob3\"\":true}\"", "^dc.MultiD(3)=$lb(\"Goldman,Kenny H.\",45831)", "^dc.MultiD(3,\"mJSON\")=\"{}\"", "^dc.MultiD(4)=$lb(\"\",\"\")", "^dc.MultiD(4,\"mJSON\")=\"{\"\"rcc\"\":122}\"", "^dc.MultiD(5)=$lb(\"\",\"\")", "^dc.MultiD(5,\"mJSON\")=\"{}\"" ]} ***** gbl.json ***** USER>
go to post Robert Cemper · Mar 18, 2022 ATTENTION: US Summer time (EDT) started already Sunday, 13 March
go to post Robert Cemper · Mar 17, 2022 Hi @Joel Solon , I see it that way:COS is aged but was not as short as M (even more aged)but InterSystemsObjectScript are 24 Character to type ! At least 18+ chances for mistyping with my old fingers. So I have my personal FLA (4 letter abbreviation) to write "new-speak" and get it sorted right.
go to post Robert Cemper · Mar 15, 2022 LOAD DATA was released with IRIS 2021.2 and was unknown beforeYour version is 2020.1 only.Sorry
go to post Robert Cemper · Mar 14, 2022 If your global is part of a class/table class parameter DSTIME could be an approach.or any SQL trigger or any %OnAfterSave, %OnAfterDelete, ... For pure Globals all you have is the Journal (if enabled)
go to post Robert Cemper · Mar 14, 2022 You may try an external RTF parser to run your conversion using CPIPE or $ZF(-100-)and then consume the result. 1 Example of many others in Google: striprtf (py) Once you move to a version supporting Embedded Python you can run it even internal
go to post Robert Cemper · Mar 13, 2022 OK. after some detailed analysis I found these facts that I forward to WRC: normal JOB command ISOS/COS returns $TEST to signal success/fail $ZC the id of the started job. this happens after complete init of the job or eventually timed is always ASYNCHRONOUS to the background job JOB command for Embedded Python if not timed Hangs until AFTER completion of the started job then return $TEST and $ZC which is useless as the job is gone! acts SYNCHONOUS to the started job timed JOB command for Embedded Python returns after the timeout with $TEST = 0 ==> FAILED does not return the id of the started JOB though the started Job may work fine you just don't get info and may find out by other means if it is OK Workaround until a fix. Start a background job as ISOS/COS Class Method let this class method start your method in Embedded Python. Another reason why Embedded Python Pure is just a fiction
go to post Robert Cemper · Mar 11, 2022 Hi @Scott Roth. I'm sure you have access to WRCunder Previews there is a standalone kit Studio-2022.1.0.131.0-win.msiand it is backward compatible as usual.
go to post Robert Cemper · Mar 10, 2022 in namespace %SYS you may run DO ^JRNDUMP from the terminal prompt
go to post Robert Cemper · Mar 7, 2022 What you see is typical for an inappropriate double encoding. USER>r c Gômez Jesús María USER>zzdump c 0000: 47 F4 6D 65 7A 20 4A 65 73 FA 73 20 4D 61 72 ED Gômez Jesús Marí 0010: 61 ;;; this is already encode in UTF-8 !!!!! ;;; what you name RAW is already UTF-8 !!! a USER>s z=$zcvt(c,"O","UTF8") USER>w z Gômez Jesús MarÃa ;;; now its just broken USER>zzdump z 0000: 47 C3 B4 6D 65 7A 20 4A 65 73 C3 BA 73 20 4D 61 Gômez Jesús Ma 0010: 72 C3 AD 61 rÃa USER>
go to post Robert Cemper · Mar 4, 2022 Hi @Stuart Strickland ! This well-known effect is named Proleptic Gregorian Calendar.A bunch of other DBs is using it as well. As well as my favorite competitor O*****.This means it calculates backward as if we always had the Gregorian date since the beginningand the lost days in October 1582 and other adjustments are ignored.In fact, at that time almost every country and smaller had its own calendar. Often like "in the 3rd month of the 7th year of the reign of Duke Goofy 4th". And converting regional dates from Spain to England or Franc or Italy or Ireland or even Scandinavia is a special mathematical exercise for students of History. On top of that, you often don't have the information if they counted years by Sun calendar or by Moon calendar.
go to post Robert Cemper · Mar 3, 2022 from session use the SQL Shell PROMPT>do $system.SQL.Shell() SQL Command Line Shell ---------------------------------------------------- The command prefix is currently set to: <<nothing>>. Enter <command>, 'q' to quit, '?' for help. [SQL]PROMT>>SELECT whatever single line SQL or PROMPT>do $system.SQL.Shell() SQL Command Line Shell ---------------------------------------------------- The command prefix is currently set to: <<nothing>>. Enter <command>, 'q' to quit, '?' for help. [SQL]PROMPT>> << entering multiline statement mode, 'GO' to execute >> 1>>