go to post Robert Cemper · Mar 28, 2023 I see you disliked my previous reply and retitled your article.so again: Could be, I misunderstand the purpose of the example.Before LOAD DATA was available with IRIS this was the still valid approach I opened my CSV in EXCEL Connected by the EXCEL DSN over SQL Gateway using ODBC and did the import. %XML.Adaptor does the rest. If required at all. And was done before my breakfast coffee became even lukewarm.And not a single line of code was required! Sorry, where is the advantage? And personally, I prefer to work with well trained qualified engineersinstead of a guess & try a program somewhere whether for Py or COS or anything else.
go to post Robert Cemper · Mar 28, 2023 What about this ? USER>set r="" for i=1:1:7 set r=$O(^$ROUTINE(r)) quit:r="" write r,! %APILIB %APILOG %APISERV %ASKDIR %ASKSYS %AUDIT %Activate.Enum.0 USER> https://docs.intersystems.com/iris20223/csp/docbook/Doc.View.cls?KEY=RCOS_sroutine
go to post Robert Cemper · Mar 27, 2023 I would like to see this as an important and useful Tutorial! And definitely more useful than copying the use of Class queries 3 times at least.
go to post Robert Cemper · Mar 27, 2023 if you take a look to method ##class(EnsLib.HL7.Segment).getAtFromArray(...)you see that the segment data is assembled in row 1008 of the class by Set data=data_value without checking the size.So it is designed to fail with large documents as your Base64 encoded PDF (~+33% of original)So just using a reference to an external stored file as you suggested should work. BTW datatype %VarString is just a shortcut of %String(MAXLEN="") and a sometimes appropriate SQLTYPE.
go to post Robert Cemper · Mar 21, 2023 At your own risk!You can set the Code DB of your namespace to R/W.
go to post Robert Cemper · Mar 19, 2023 Oh Dear! but Memory was expensive.But my first DSM-like OS on VAX was only ~ 80KB code at run time. (40+ years back)All the rest for Partitions and Buffers, .
go to post Robert Cemper · Mar 18, 2023 Fully with you.But in migration, you have no choice.With several thousands of Globals, there is no chance to find outif some crazy chap had used it decades ago.When I saw it the first time I must have looked like Kong Kong.
go to post Robert Cemper · Mar 17, 2023 Does it work if you call your class with full reference? I mean not for Login?NOT found is suspicious somehow
go to post Robert Cemper · Mar 17, 2023 Another idea:Just to see that the port is open and you are on IRIS you may try to accessover ODBC/JDBC gateway any table in %SYS
go to post Robert Cemper · Mar 17, 2023 if you insist on that line you need Set Jsonobj="{""Doctype"":""ADT^A01"",""PatientId"":""123"",""PatientName"":""Alex""}"
go to post Robert Cemper · Mar 17, 2023 ODBC/JDBC QUERY tools connect to 1972no Idea which runs on Linux
go to post Robert Cemper · Mar 17, 2023 by using {} your Jsonobj is already a %Library.DynamicObjectUSER> ZWRITE JsonobjJsonobj=<OBJECT REFERENCE>[1@%Library.DynamicObject]no need for Set Dynjsonobj=##class(%Library.DynamicObject).%FromJSON(Jsonobj)
go to post Robert Cemper · Mar 16, 2023 I miss [MultiDimensional] properties that need no type at all.see more
go to post Robert Cemper · Mar 16, 2023 You are correct it is working inside docker in the container.But I asked for the external real IP of my (Windows) Host.I know that is wrong for my purpose, as I sit just in front of itand use it some 100 times daily. So I really know it. It's an odd situation: IRIS -> Ubuntu in container -> Docker -> WSL -> Windows.I didn't add NAT and Port mapping used by Windows.
