go to post Robert Cemper · Sep 25, 2017 ENSDEMO>d $system.SQL.Shell()SQL Command Line Shell---------------------------------------------------- The command prefix is currently set to: <<nothing>>.Enter q to quit, ? for help.ENSDEMO>>select * from Ens_Config.Credentials1. select * from Ens_Config.Credentials ID BusinessPartner PasswordObject Password SystemName Username .... Rows(s) Affected
go to post Robert Cemper · Sep 25, 2017 or more object stylewrite ##class(%Library.TimeStamp).XSDToLogical(obj.biometrics.%Get(0).timestamp)
go to post Robert Cemper · Sep 22, 2017 Just add another IF condition and replace all "Country" by " Relation"If ($g(pInfo:filters("Relation"))'="") { Set tWHERE = tWHERE _ $S(tWHERE="":"",1:" AND ") _ "Relation %STARTSWITH '" _ pInfo:filters("Relation") _ "'"}
go to post Robert Cemper · Sep 22, 2017 assuming variable payload holds your content of "payload"set profileId=$piece($piece(payload,"profile_id"":""",2),""",")set timestamp=$piece($piece(payload,"timestamp"":""",2),""",")
go to post Robert Cemper · Sep 20, 2017 try Do ##class(%SQL.Util.Procedures).CSVTOCLASS(2, .rowType, pFileName, pDelimiter,,1) ;; no defaults if not required or the EXACT count: 9 params = 8 comma ;; I counted 9 and/orProperty Name As %String (MAXLEN="");and/or;; the last comma in rowType looks also suspect to me.set rowType=" . . . . ,ActiveStatus Boolean" HTH
go to post Robert Cemper · Sep 20, 2017 yeah,that's for slow typing senior writer's without autocomplete. BTW. wrapping of this editor is sometime more than disturbing.
go to post Robert Cemper · Sep 20, 2017 It's still the same answer as in one of your previous questions:only difference 1 hour instead of 24 hourshttps://community.intersystems.com/post/configure-business-serviceSee the example on ENSDEMO namespace
go to post Robert Cemper · Sep 20, 2017 like this:set ts=20160105125915 ;; convert to $Hset th=$zdth($e(ts,1,8)_" "_$e(ts,9,10)_":"_$e(ts,11,12)_":"_(ts#100),8) ;; convert to UTCset tu=$ZDTH(th,-3) ;; show $ZTS format (on UTC+0200 Vienna,Austria)write $ZTD(tu,3)2016-01-05 13:59:15You can of course do it in a single unreadable long cascaded function chain.HTH
go to post Robert Cemper · Sep 19, 2017 Sebastian,I share your considerations.My personal interpretation of the IRIS message: - go for Java for any application code and make use of the large developer market - stay in COS ( or .int) for internal DB manipulation with in depth "System Engineers"
go to post Robert Cemper · Sep 19, 2017 my full support to 3 !!!! and to 5, 2, 4 in this priority.The difference between ANSWER and COMMENT causes more confusion than being helpful.Especially in the actual sequence.Comment to Answers eventually may make sense. More than once I found myself in a Comment where it should have been an Answer. My suggestion: -handle all editing just in a modal pop-up .- allow deleting (or hiding) your entry if you don't feel it appropriate anymore.
go to post Robert Cemper · Sep 15, 2017 WebServerPort =Web Server port number. Setting this number to any non-zero value enables the Web Server on that port. If you set this number to 0, the Web Server is disabled.
go to post Robert Cemper · Sep 15, 2017 For the cube you have servermgr.exe where you define the ports you want to use docs: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... In CSP gateway (from Mgmt Portal) you have Configuration -> Deault Parameters ->Instance Host Name: to set server + portdocs: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
go to post Robert Cemper · Sep 15, 2017 in namespace ENSDEMO use Demo.Dashboard.Production as an example for repeating calls
go to post Robert Cemper · Sep 15, 2017 if you disable authentication for Username / PW you always come in as "UnknownUser"in Mgmt Portal go to System > Security Management > Users > Edit User for "UnknownUser"and set Startup Tag^Routine: ^%zmyLOGINand then do your own authetication.if you intend to go to Prorammer Mode you just have to call "do ^%PMODE" at the end.otherwise the terminal closes.
go to post Robert Cemper · Sep 15, 2017 Conversion of XML to objects is a standard function in Caché.start with http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... and continue http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... the principle steps generate a package o classes from XML Schema import your XML File to this package - - - change whatever you want to change use %XML.Writer to generate a new export file. a different approach could be to use XSLT to transform your XML filehttp://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... Whatever better fits to reach your goal.
go to post Robert Cemper · Sep 14, 2017 Take the example from %Net.SMTP to SAMPLE or USER independent of any ENS* http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P... and see if it runs on all 3 instances to verify SMTP access.If it fails you may take a closer look to your firewalls outgoing and on SMTP server incoming. If this works on all 3 instances than your config in ENSEMBLE is somehow different . OR in SAMPLES use Class Cinema.Utils. SendEmail(...) and adjust is to your needs ~~~
go to post Robert Cemper · Sep 14, 2017 - For JAVA take a look on IRIS or today to XEP ( which is incredible fast )- For JavaScript you have nodes.js / cache.node (also speedy)- C# lives by it's Windows bound libraries.
