go to post Rizmaan Marikar · Mar 21 @Guillaume Rongier that’s awesome thank you for sharing, will check this out.
go to post Rizmaan Marikar · Feb 7 Hi @Caio Timm, You can do something similar to thisSELECT ROW_NUMBER() OVER (ORDER BY <column_name>) AS RowNumber, <other_columns> FROM <table_name>Eg:
go to post Rizmaan Marikar · Aug 3, 2022 @Yuri Marx W $TR($ZDATETIME($HOROLOG,3,1)," ","T") //adapted from (HS.FHIRServer.Utils).ConvertToUTC #dim tSecondsPerDay = 86400 // time with offset set tTimeWithOffset = $ZDATETIME($HOROLOG,3,5) if (tTimeWithOffset [ "-") { set tOffsetSign = "-" } elseif (tTimeWithOffset [ "+") { set tOffsetSign = "+" } else { set tOffsetSign = "" } if (tOffsetSign'="") { // compute offset in seconds set tOffset = $P(tTimeWithOffset,tOffsetSign,2) set tOffsetHrs = $P(tOffset,":") set tOffsetMins = $P(tOffset,":",2) set tOffsetInSeconds = (3600*tOffsetHrs) + (60*tOffsetMins) // get date/time in $H format set tTime = $P(tTimeWithOffset,tOffsetSign) set tDateTimeH = $ZDTH(tDate_"T"_tTime,3,1) set tDateH = $P(tDateTimeH,",") set tTimeH = $P(tDateTimeH,",",2) // UTC time = timestamp value (+/-) offset // might have to increment or decrement the date set tUTCDateH = tDateH if (tOffsetSign = "-") { set tUTCTimeH = tTimeH + tOffsetInSeconds if (tUTCTimeH >= tSecondsPerDay) { set tUTCDateH = tUTCDateH+1 set tUTCTimeH = tUTCTimeH-tSecondsPerDay } } else { set tUTCTimeH = tTimeH - tOffsetInSeconds if (tUTCTimeH < 0) { set tUTCDateH = tUTCDateH-1 set tUTCTimeH = tUTCTimeH+tSecondsPerDay } } Set pDateTimeH = tUTCDateH_","_tUTCTimeH quit $TR($ZDT(pDateTimeH,3,1)," ","T")_"Z" }
go to post Rizmaan Marikar · Aug 3, 2022 Yikes my bad, v 2022.1Odbc 64 bit :https://wrc.intersystems.com/wrc/WRC.StreamServer.cls?FILE=/wrc/Live/Gen...ODBC 32 bit" https://wrc.intersystems.com/wrc/WRC.StreamServer.cls?FILE=/wrc/Live/Gen...
go to post Rizmaan Marikar · Aug 3, 2022 @Bill Colwell, @Richard Hale Best bet it to take from the Cache Installation Directory, If not dbeaver maintains a driver repository, you can download the cacheDb driver below;Cache driver : https://dbeaver.io/files/jdbc/drivers/cache/CacheDB.jar
go to post Rizmaan Marikar · Jul 29, 2022 @Robert Cemper , i believe this is possible,:for example this Url is for Open exchange Object Script Package Manager Reviews;https://openexchange.intersystems.com/package/ObjectScript-Package-Manag...Each Review is enclosed within <oex-review-card ... />Although, i have not tested this we could do a find_all get the cards and extract the stars within them
go to post Rizmaan Marikar · Jul 29, 2022 That’s awesome @Benjamin De Boe, glad this article helped, beautifulsoup is very powerful and fast, I did do some benchmark testing using the same code in python vs embedded python for beautiful soup and I do not see much difference
go to post Rizmaan Marikar · Jul 20, 2022 Hi @Smythe Smythee The best way i guess is to have the FHIR package installed and use the OOB transformations.an alternative way would be something as follows; ClassMethod TestHL7ToJson() { set hl7FilePath = "C:\Intersystems\file.hl7" #dim hl7Msg As EnsLib.HL7.Message set hl7Msg=##class(EnsLib.HL7.Message).ImportFromFile(hl7FilePath, .sc) set tMSH=hl7Msg.getSegmentByIndex(1) set tName=tMSH.GetValueAt(9,":_~\&") set hl7Msg.DocType = "2.5:"_tName //Anticipating the PID element in line 3 set tPID = hl7Msg.getSegmentByIndex(3) set jsonObj= {} do jsonObj.%Set("PatientID",tPID.GetValueAt(2)) do jsonObj.%Set("PatientIdentifierList",tPID.GetValueAt(3)) do jsonObj.%Set("AlternatePatientIDPID",tPID.GetValueAt(4)) do jsonObj.%Set("PatientName",tPID.GetValueAt(5)) do jsonObj.%Set("MothersMaidenName",tPID.GetValueAt(6)) do jsonObj.%Set("DateTimeofBirth",tPID.GetValueAt(7)) do jsonObj.%Set("AdministrativeSex",tPID.GetValueAt(8)) do jsonObj.%Set("PatientAlias",tPID.GetValueAt(9)) do jsonObj.%Set("Race",tPID.GetValueAt(10)) do jsonObj.%Set("PatientAddress",tPID.GetValueAt(11)) do jsonObj.%Set("CountyCode",tPID.GetValueAt(12)) do jsonObj.%Set("PhoneNumberBusiness",tPID.GetValueAt(14)) do jsonObj.%Set("PrimaryLanguage",tPID.GetValueAt(15)) do jsonObj.%Set("MaritalStatus",tPID.GetValueAt(16)) do jsonObj.%Set("Religion",tPID.GetValueAt(17)) do jsonObj.%Set("PatientAccountNumber",tPID.GetValueAt(18)) do jsonObj.%Set("SSNNumberPatient",tPID.GetValueAt(19)) do jsonObj.%Set("DriversLicenseNumberPatient",tPID.GetValueAt(20)) do jsonObj.%Set("MothersIdentifier",tPID.GetValueAt(21)) do jsonObj.%Set("EthnicGroup",tPID.GetValueAt(22)) do jsonObj.%Set("BirthPlace",tPID.GetValueAt(23)) do jsonObj.%Set("MultipleBirthIndicator",tPID.GetValueAt(24)) do jsonObj.%Set("BirthOrder",tPID.GetValueAt(25)) do jsonObj.%Set("Citizenship",tPID.GetValueAt(26)) W jsonObj.%ToJSON() } the above code generates a json for PID as follows; { "PatientID": "1111111^^^TEST^MR", "PatientIdentifierList": "6910315054084^^M10^RSAID^GOV", "AlternatePatientIDPID": "", "PatientName": "Geoe^Schz^^MR^^^^^^^^^^.", "MothersMaidenName": "", "DateTimeofBirth": "19330722", "AdministrativeSex": "M", "PatientAlias": "", "Race": "", "PatientAddress": "GRASRK^CAPE TOWN^AA^^0001", "CountyCode": "", "PhoneNumberBusiness": "0", "PrimaryLanguage": "E^English", "MaritalStatus": "", "Religion": "", "PatientAccountNumber": "", "SSNNumberPatient": "", "DriversLicenseNumberPatient": "", "MothersIdentifier": "", "EthnicGroup": "", "BirthPlace": "", "MultipleBirthIndicator": "N", "BirthOrder": "", "Citizenship": "" }