go to post Eduard Lebedyuk · Feb 13, 2020 Ensemble uses $$$GetLocalizedName macro to get localized settings names. You can add caption directly: set ^CacheMsg("EnsColumns","en-us","HelloWorld")="Hello World" Where HelloWorld is a property name, value is a caption and en-us is a session language. It should work like this: ClassMethod Add() { quit $$$Text("@HelloWorld@Hello World", "EnsColumns", "en-us") } but for me it doesn't set the global. Not sure why.
go to post Eduard Lebedyuk · Feb 9, 2020 As other commenters have stated you can use Python Gateway to drive Python process, in that case check this article, the Data Transfer section specifically. Also join our MLToolkit@intersystems.com usergroup - it's focused on AI/ML scenarios. I'm a user of Python Native API so I can give the following advice. There are two cases here: You need to iterate the result set - in that case you may want to call %Next() and retrieve values as you go. You just need a complete dataset for downstream processing (your case). In that case yes, serialization is required. I see two ways to do that: JSON and CSV. If the size of the dataset is small you can use JSON, no problem, but (I haven't run any tests but fairly sure) CSV serialization can be faster and less CPU/Memory intensive.
go to post Eduard Lebedyuk · Feb 8, 2020 Looks like this is not possible by default: You can use this trivial workaround: set nl = $c(13,10) set replace = "*" set search = "MRN" &sql(DECLARE C1 CURSOR FOR SELECT REPLACE(%iFind.Highlight(REPLACE(Text, :nl, :replace),:search), :replace, :nl) ... And as long as your text does not contain replace sequence it should work.
go to post Eduard Lebedyuk · Feb 8, 2020 %File provides a way to get creation and modification dates, but to set them you'll need OS level tools.
go to post Eduard Lebedyuk · Feb 7, 2020 You can try %ZEN.Auxiliary.altJSONProvider or %ZEN.Auxiliary.JSONProvider.
go to post Eduard Lebedyuk · Feb 6, 2020 The reason I say this is that the method has extra parameters that don't correspond to the SQL %Fimd.Highlight SQL function. What do you mean? Highlight method signature: ClassMethod Highlight(pText As %String, pSearchString As %String, pSearchOption As %String = {$$$IFSEARCHNORMAL}, pTags As %String = {$$$IFDEFAULTHLTAGS}, pLimit As %Integer = 0, pLanguage As %String = "en", Output pSC As %Status) As %String [ SqlName = Highlight, SqlProc ] Shows that it is available in SQL context (bolded). All classmethod arguments (except sc) can be passed from SQL.
go to post Eduard Lebedyuk · Feb 6, 2020 Try double quotes inside: SELECT %iFind.Highlight(Text , :pSearchString , ,'<span style="background-color:yellow;">') into :results FROM SSA_OCR.TempSearchable I checked on my dataset and this query works for me: SELECT *, %iFind.Highlight(Text,'hello', , '<span style="background-color:yellow;">') FROM Test.Data WHERE %ID %FIND search_index(TextIndex,'hello')
go to post Eduard Lebedyuk · Feb 6, 2020 Read method does read 32000 characters by default, you can specify an amount of characters up to $$$MaxStringLength (3 641 144 characters). If you want to set property to a stream you can do it like this: do objInArrMain.%Set("Content", fileStreamBase64, "stream") I'm not sure when it became available, here's a simple check code: set stream = ##class(%Stream.TmpCharacter).%New() do stream.Write(123) d obj.%Set("prop", stream, "stream") It should output: {"prop":"123"} One other note: you're using file streams for temporary outputs (when building fileStreamBase64), replace file stream with temp stream for better performance.
go to post Eduard Lebedyuk · Feb 6, 2020 You should initialize the Signature object not with %New method, but with Create or Create509 method. set sig=##class(%XML.Security.Signature).CreateX509(cert) do sig.SetSignatureMethod($$$SOAPWSrsasha1)
go to post Eduard Lebedyuk · Feb 6, 2020 Since ##class(%iFind.Utils).Highlight and %iFind.Highlight are the same method, you can pass fourth pTags argument to it: SELECT %iFind.Highlight(Narrative,'"visibility [1-4] mile*" AND "temp* ? degrees"', , "<span>")
go to post Eduard Lebedyuk · Feb 5, 2020 You can get columns like this: $$$LOGINFO("current result print: " _ result.clave) Instead of set printed = result.%CurrentResult.%Print() $$$LOGINFO("current result print: "_printed) printed value is 1 because %Print outputs data into the current device and returns %Status.
go to post Eduard Lebedyuk · Feb 5, 2020 These particular bindings are deprecated. Replacements are listed in the InterSystems IRIS Adoption Guide which is available in WRC (Downloads - Documents).
go to post Eduard Lebedyuk · Feb 5, 2020 Another suggestion. You can define a %ZSTOP routine which would automatically clear ^HITLIST global on job end. You can also use PPG which would be automatically deleted when job ends.
go to post Eduard Lebedyuk · Feb 4, 2020 Hi Neerav! I agree that postconditionals are an acquired taste :)
go to post Eduard Lebedyuk · Feb 4, 2020 Recommended approach - always use macros for al your GLVN needs (see: DeepSee, %Dictionary). This way reporting is easy - just open inc file and you're done. %Compiler package contains Traveler/Visitor implementation for ObjectScript but it's not officially supported - use at your own risk. Although the task is unfortunately unsolvable at compile-time due to the abundant meta programming, such as indirection and xecute. In your proposed solution you can enable checkbox "Use Wildcards" in Find & Replace and search for * which is essentially everything.
go to post Eduard Lebedyuk · Feb 4, 2020 <PROTECT> error means you can't access database in the /folder/NSOne_SRC/ directory. Give the user required rights (at the very least R on that DB) and start a new session.
go to post Eduard Lebedyuk · Jan 30, 2020 From InterSystems IRIS adoption guide: Python Binding Applications using the Python Binding should migrate to PyODBC. 2019.1.1 does not have Python Native API - you'll need 2020.1 preview or 2019.2+ container release for that.
go to post Eduard Lebedyuk · Jan 29, 2020 Have you tried sending the message to several recipients directly? Not CC but TO: do m.To.Insert("mail1@domain.com") do m.To.Insert("mail2@domain.com") Or you can send the same email object to several recipients one by one: for to = "mail1@domain.com", "mail2@domain.com" { do m.To.Clear() do m.To.Insert(to) set status = ..Adapter.SendMail(m) do:$$$ISERR(status) $system.OBJ.DisplayError(status) }
go to post Eduard Lebedyuk · Jan 29, 2020 Check Apache POI integration LibreOffice integration Apache POI would be faster and more specialized, LibreOffice is the best bet on converting arbitrary documents between arbitrary formats.