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": "" }
go to post Rizmaan Marikar · Jul 15, 2022 Hi @Dhruva Mishra, Try installing Cygwin, which allows you to run UNIX commands, find/xpath/zip etc, once you install and add it to environment path you can run the above commandfor example, zipping a folder with some text files the exe can be downloaded here.https://www.cygwin.com/setup-x86_64.exe Hope this helps
go to post Rizmaan Marikar · Dec 25, 2021 github URL ; https://github.com/RizmaanMarikar/ObjectScriptExcelGenerator
go to post Rizmaan Marikar · May 6, 2020 Hello all, is the contest for May started? where can i find details about it?
go to post Rizmaan Marikar · Oct 30, 2019 Hi, Is it possible to share the entire query / code that you are using to perform the update?
go to post Rizmaan Marikar · Oct 29, 2019 what is the data type of RESTR_DATETo and can you post the error that you are getting
go to post Rizmaan Marikar · Oct 29, 2019 Hi @Jude Mukkadayil Please try this; DATEADD will return a timestamp, such as '2020-07-26 00:00:00', Just need to convert it back to Date and insert UPDATE RB_ResEffDateSessPayorRestr SET RESTR_DATETo = DATE(DATEADD('year',1,RESTR_DATETo)) WHERE YEAR(RESTR_DATETo)=2020 Hope this helps. Rizmaan.
go to post Rizmaan Marikar · Oct 15, 2019 thank you, I am using the following method set tSC=oRpt.GenerateReport(filename,2) which the filename is a .pdf file, and when i check the output folder a .xml, which has my output and a .xsl file tSC returns this tSC="0 "_$lb($lb(5001,"Unable to create ReportDisplay object.",,,,,,,,$lb(,"TRAK",$lb("e^%DrawToXSLFO+7^%ZEN.Report.reportPage.1^1","e^%MakeToXSLFOFile+14^%ZEN.Report.reportPage.1^1","e^%DisplayPDF1+6^%ZEN.Report.reportPage.1^1","e^%DisplayPDF+7^%ZEN.Report.reportPage.1^1","e^zCallReport+33^%ZEN.Report.reportPage.1^1","e^zGenerateReport+4^%ZEN.Report.reportPage.1^1","e^zGenerateReport+38^Region.MEXX.Report.RQM.App.Utils.1^1","e^zRepotToCSV+27^Region.MEXX.Report.RQM.App.Utils.1^1","d^zProcessNextReport+27^Region.MEXX.Report.RQM.App.Utils.1^1","d^zDebugStub+30^%Debugger.System.1^2","d^^^0"))))/* ERROR #5001: Unable to create ReportDisplay object. */ any idea why