go to post Robert Cemper · Jul 7, 2020 You use set patientMRN = msgIn.GetValueAt("PID:3.1") and get back a value the reverse is do msgOut.SetValueAt(patientMRN,"PID:3.1") deails: https://docs.intersystems.com/irisforhealthlatest/csp/documatic/%25CSP.Documatic.cls?PAGE=CLASS&LIBRARY=ENSLIB&CLASSNAME=EnsLib.HL7.Message
go to post Robert Cemper · Jul 6, 2020 My personal opinion:WIN* is a nice Desktop OS good for mom and aunt Betty. With an incredible paranoic approach. In post VMS times all *X (LinuX,AIX, OS X, Solaris(rip+), ***UNIX, ....) are real server OS systems by nature.
go to post Robert Cemper · Jul 6, 2020 I did this implicitly during my Sharding Evaluation https://community.intersystems.com/post/sharding-evaluation-1and more on https://community.intersystems.com/post/sharding-evaluation-2
go to post Robert Cemper · Jul 6, 2020 Good observation. Try run a "force" down of the image. For Caché it's .../bin/ccontrol force <instance> The service calls itself always "Controller" .I've seen such orphans rarely every now and then. but I don't have any explanation.stopping it should allow a new start. Check if there are other processes with Ensemble or Cache.exe
go to post Robert Cemper · Jun 23, 2020 I see just nothing in SQL that relates to the error message.my only wild guess: some NULL value results confuse the VB end.You could eventually bypass it using NVL() function SELECT NVL(PROE,'*'),NVL(DESP,'*),NVL(ID,0) FROM ZVBMAPEAMENTO.SVINFOUVNDWHERE JOB=1224 GROUP BY PROE
go to post Robert Cemper · Jun 23, 2020 OK. I understand those records where created BEFORE you defined your new column.I checked the internal code $s(%val="":"",1:$zdatetime($zdTH($zdatetimeh(%val,3,,,,,,,,0),-3),3,,3)) This tells me:- Your value is Not Empty - it has no valid time format, so it is trapped by the ERROR option and set to Zero ==>> 1840-12-31 00:00:00 Suggestion:- set value to NULL for old records.or- create your own data type for this case. or - use a calculated Property to trap the values
go to post Robert Cemper · Jun 22, 2020 embedded SQL is probably an overkill for this formating.Just convert it to the internal format, add what you need and assemble the pieces in COS ; set datein=201906192359; set add=60 ;; seconds to addset dh=$ZDH($e(datein,1,8),8)set hh=$e(datein,9,10)set mi=$e(datein,11,12)set new=$ZTH(hh_":"_mi_":00",3)+addset zdt=$zdt(new\86400+dh_","_(new#86400),3)set dateout=$tr($e(zdt,1,*-3),"-: ")
go to post Robert Cemper · Jun 19, 2020 for the fixed part you still can use classic mapping.for the variable section you may set CONTENT = "MIXED" for the containing propertyand get the raw XML structure in hands .You can then analyze this "inner" XML using class %XML.TestReader
go to post Robert Cemper · Jun 18, 2020 The example and the class are simply wrong A %Library.DynamicObject that is composed here just has neither a method %Clone nor a method %Compose You may report the bug to WRC
go to post Robert Cemper · Jun 13, 2020 Allmost! 3rd Update since if the left side is a Unix Timestamp, then you get this result: write $zdt($zdth(1591891200000\1000,-2),3) ==> 2020-06-11 18:00:00 docs: https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=RCOS_fzdatetime timezone conversion from UTC may compensate the 6 hours difference ! in Middle Europ we have we have 2 hrs+ to UTC so write $zdt($zdt($zdth(1591891200000\1000,-2),-3),3)2020-06-11 16:00:00
go to post Robert Cemper · Jun 9, 2020 see: https://cedocs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=RSQL_into &sql(SELECT Name, DOB, Gender INTO :Name,:DOB,:Gender FROM osuwmc_RQGPatient.DataTable WHERE MRN=:MRN)
go to post Robert Cemper · Jun 3, 2020 finally found it do $system.OBJ.SetQualifiers("/exportversion = 2016.2.")
go to post Robert Cemper · Jun 3, 2020 As I have investigated the code, I saw that this part of the functionality is just not supported.But there is also neither Warning nor Hint in the docs.If you try you just get nothing.
go to post Robert Cemper · Jun 2, 2020 Class DC.ZWSYS Extends %CSP.Page{ ClassMethod OnPage() As %Status{ &html<<body><h2>run ZW ^SYS to Browser</h2><pre>> znspace "%SYS" set h=$zhorolog zwrite ^SYS set h=$zhorolog-h write !!,"<b>" zwrite h znspace "USER" &html<</b></pre></body>> quit $$$OK } }
go to post Robert Cemper · Jun 2, 2020 17:45 Intermediate data each run stand aloneTotal lines in MgmtPortal / Explorer = 388947 $ZH shows seconds Command: s h=$zh zw ^SYS s h=$zh-h w !! zw hTerminal: h=187.786676PuTTY: h=11.962381WebTerminal: *** to be supplied once finished *** 18:10 *** 1st run ended with no result no new sessions, browser restart required. *** 19:59 *** not completed *** ~60% done terminates with "See you!" Additional: test for HTTP influence. A small CSP page (next reply) does it with h=9.835974even faster than PuTTY
go to post Robert Cemper · Jun 2, 2020 You need to start with require("cache") to have the basic access module. you find it a cache.node for various rather old versino0n of Node. it is in %instaldir%\bin\ more details in %instaldir%\ \dev\node.js\samples\installed_software.js and more ......
go to post Robert Cemper · May 29, 2020 To use a DSN it has to be a SYSTEM-DSN and have the same bit as Cache / IRIS. Depends on your EXCEl instalationTherefore 64bit.Activate as you might know from Cache is not available in IRIS