//adapted from (HS.FHIRServer.Utils).ConvertToUTC#dim tSecondsPerDay = 86400// time with offsetset tTimeWithOffset = $ZDATETIME($HOROLOG,3,5)
if (tTimeWithOffset [ "-") { set tOffsetSign = "-" }
elseif (tTimeWithOffset [ "+") { set tOffsetSign = "+" }
else { set tOffsetSign = "" }
if (tOffsetSign'="") {
// compute offset in secondsset 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 formatset 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 dateset tUTCDateH = tDateH
if (tOffsetSign = "-") {
set tUTCTimeH = tTimeH + tOffsetInSeconds
if (tUTCTimeH >= tSecondsPerDay) {
set tUTCDateH = tUTCDateH+1set tUTCTimeH = tUTCTimeH-tSecondsPerDay
}
}
else {
set tUTCTimeH = tTimeH - tOffsetInSeconds
if (tUTCTimeH < 0) {
set tUTCDateH = tUTCDateH-1set tUTCTimeH = tUTCTimeH+tSecondsPerDay
}
}
Set pDateTimeH = tUTCDateH_","_tUTCTimeH
quit$TR($ZDT(pDateTimeH,3,1)," ","T")_"Z"
}
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
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
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 3set 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()
}
ObjectScript
ObjectScript
the above code generates a json for PID as follows;
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 command for example, zipping a folder with some text files
go to post
Have you tried using a Installation Manifest
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post
Congratulations to all, amazing articles
go to post
@Guillaume Rongier that’s awesome thank you for sharing, will check this out.
go to post
Hi @Caio Timm,
You can do something similar to this
SELECT ROW_NUMBER() OVER (ORDER BY <column_name>) AS RowNumber, <other_columns> FROM <table_name>
Eg:
go to post
Hi @Lucas Enard
Sure, you are most welcome.
go to post
@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
Yikes my bad, v 2022.1
Odbc 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
@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
thank you, hope you get to feeling better soon!
go to post
@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
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
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
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 command
.png)
for 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
Congratulations all, and happy new year
go to post
github URL ;
https://github.com/RizmaanMarikar/ObjectScriptExcelGenerator
go to post
Hello all, is the contest for May started? where can i find details about it?
go to post
Hi,
Is it possible to share the entire query / code that you are using to perform the update?
go to post
what is the data type of
and can you post the error that you are getting
go to post
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
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
any idea why