go to post Robert Cemper · Aug 28, 2023 The "L" in your Open makes me nervous.From the description, it seems to hang and wait for unlock not In IRIS but at OS-FileSystem Level.The description of "L" seems to give some chance for such a conflict. L Locked Exclusive: Use this mode with the “W” (Write) mode to specify exclusive write access to a file. “WL” or “WRL” specifies that the current process has exclusive write access to the file. A file opened with “RL” may still have shared read access. The effects of the “L” mode on concurrent opens are different in Windows and UNIX®. Refer to the “OPEN Mode Locking” section, below, for further details. On UNIX® systems if one process specifies “WL” (or “WRL”) access to a file, other processes requesting read access to that file must specify “RL” so that UNIX® can coordinate file locking. suggested testing: Check the situation without "L" If there is a difference: find out who else may lock at OS level
go to post Robert Cemper · Aug 26, 2023 Hi @Lorenzo Scalese I guess you are looking for class(%Utility).FormatString() USER>set lb=$lb(1,"Lorenzo",2023,"RCC"_$c(13,10)) USER>write lb LorenzoçRCC USER>zzdump lb 0000: 03 04 01 09 01 4C 6F 72 65 6E 7A 6F 04 04 E7 07 .....Lorenzo..ç. 0010: 07 01 52 43 43 0D 0A ..RCC.. ;;;;; this is it USER>set viewlb=##class(%Utility).FormatString(lb) USER>write viewlb $lb(1,"Lorenzo",2023,"RCC"_$c(13,10)) USER>zwrite viewlb viewlb="$lb(1,""Lorenzo"",2023,""RCC""_$c(13,10))"
go to post Robert Cemper · Aug 26, 2023 Objectscript uses double quotes for strings.Single quote is Negation 'Sample Data looks for variable Sample >>> NOT Sample
go to post Robert Cemper · Aug 25, 2023 Totally correct.This is what the example describes:and the consequence is that you have to spin through ALL GetOrgUpdatesResponse objectsA less impressive design.So you need to add an index on the ELEMENTS of your Property Organizationsto find all affected objects.some example of how to
go to post Robert Cemper · Aug 24, 2023 in this case store it in +$HOROLOG format as explainedand leave the conversion to YYYY-MM-DDT00:00:00Z to outputusing $system.SQL.TOCHAR(+$h,"YYYY-MM-dd")_"T00:00:00Z" or $zd(+$h,3)_"T00:00:00Z" +$h stands for your property DOB as %Date
go to post Robert Cemper · Aug 23, 2023 Your transformation produces a YYYY-MM-DD HH:mm:SS stringin contradiction Property DOB As %Date; expects an Integer similar to +$h The error is reported during Validation before %Save() of your record either you change Property DOB As %String; or use '$zdateh(source.DOB,7,,,,,,,,"")' then ##class(%Date).IsValid(...) is happy
go to post Robert Cemper · Aug 18, 2023 /// example of an extra light output to CSV Class dc.SQLExport Extends %CSP.Page { ClassMethod content() As %Status { set sep=";" set sqlStatement="SELECT ...... FROM ....." ,query = ##class(%ResultSet).%New() ,sc = query.Prepare(sqlStatement) set:sc sc=query.Execute() quit:'sc sc set cols=query.GetColumnCount() for col=1:1:cols { if col>1 write sep write query.GetColumnHeader(col) } write ! while query.Next() { for col=1:1:cols { if col>1 write sep write query.GetData(col) } write ! } quit $$$OK } /// filename should end with ".csv" ClassMethod toFile(filename As %String) As %Status { open filename:"WNS":1 else quit $system.Status.Error(5005,filename) use filename set sc=..content() close filename quit sc } }
go to post Robert Cemper · Aug 17, 2023 You OTHER thought is supported by CPIPEsee Execute Server Commands from Caché / Ensemble / IRIS
go to post Robert Cemper · Aug 17, 2023 Here is a working simple example to start withhttps://community.intersystems.com/post/download-globals-xml-using-cspwith an OEX package
go to post Robert Cemper · Aug 16, 2023 add this line to your method OnPreHTTP() set %response.Headers("Content-Disposition")="attachment; filename=""your-file-name.some"""
go to post Robert Cemper · Aug 15, 2023 good point:there are only 17 rules referring to BUGS: In total the quality check shows 106 rulesSo there is more and I personally deeply disagree with some of them
go to post Robert Cemper · Aug 15, 2023 Not a ready-to-use solution, but a way to take export the global by SMP or embed %system.OBJ.Export to create *.XML file download it using <a href="~file_location~" download> explanation
go to post Robert Cemper · Aug 14, 2023 With JOB you start an independent process in background.You can pass any variable you may need.But you can't pass the connection to the CSP page with all its settings.the connection stays with the foreground job.
go to post Robert Cemper · Aug 12, 2023 there is a standard utility %ETN that writes such logs with the stack and all other $system variables into the global ERRORsif you call it by LOG^%ETN it does a kind of snapshotdetails here take a look
go to post Robert Cemper · Aug 11, 2023 not usable for Docker Windows Desktop KITVERSION=latest is just wishful thinking 😒😟
go to post Robert Cemper · Aug 11, 2023 Are community images from intersystemsdc/ also affected ? this may relate to all templates on OEX and also 430 packages on OEX using docker