All
Accepted answers
Robert Cemper · Sep 29, 2017 go to post

Hi Ken,

For some odd reason Execute() requires he same parameters as Prepare() again !


%SYS>set rs=##class(%ResultSet).%New("Config.MapGlobals:List")
%SYS>write rs.Prepare("ENSDEMO","*")
1
%SYS>write rs.Execute("ENSDEMO","*")
1
%SYS>write rs.Next()
1
%SYS>.....
 
      Just hacking around.
Robert Cemper · Sep 26, 2017 go to post

As you said all are unique

I try to summarize it simple:
IDkey is used in storing object s. Best to be translated : Global subscript of data store.
Could be defaulted to %Integer >0

Unique key defines an index with unique values of a property in parallel to IDkey. Checked during object save.

PrimaryKey comes from SQL world and could be interpreted  mostly as a synonym to IDkey
 

Robert Cemper · Sep 25, 2017 go to post

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.Credentials
1.      select * from Ens_Config.Credentials
 
ID      BusinessPartner PasswordObject  Password        SystemName      Username
 
.... Rows(s) Affected

Robert Cemper · Sep 25, 2017 go to post

or more object style

write ##class(%Library.TimeStamp).XSDToLogical(obj.biometrics.%Get(0).timestamp)

Robert Cemper · Sep 22, 2017 go to post

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") _ "'"
}

Robert Cemper · Sep 22, 2017 go to post

assuming variable payload holds your content of "payload"

set profileId=$piece($piece(payload,"profile_id"":""",2),""",")

set timestamp=$piece($piece(payload,"timestamp"":""",2),""",")

Robert Cemper · Sep 20, 2017 go to post

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/or

Property Name As %String (MAXLEN="");

and/or

;; the last comma in rowType looks also suspect to me.

set  rowType=" . . . .    ,ActiveStatus Boolean" 

HTH

Robert Cemper · Sep 20, 2017 go to post

yeah,
that's for slow typing senior writer's without  autocomplete. laugh

BTW. wrapping of this editor is sometime more than disturbing.

Robert Cemper · Sep 20, 2017 go to post

like this:

set ts=20160105125915

 ;; convert to $H
set th=$zdth($e(ts,1,8)_" "_$e(ts,9,10)_":"_$e(ts,11,12)_":"_(ts#100),8)

 ;; convert to UTC
set tu=$ZDTH(th,-3)

 ;; show $ZTS format (on UTC+0200 Vienna,Austria)
write $ZTD(tu,3)

2016-01-05 13:59:15

You can of course do it in a single unreadable long cascaded function chain.

HTH

Robert Cemper · Sep 19, 2017 go to post

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"

Robert Cemper · Sep 19, 2017 go to post

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.

Robert Cemper · Sep 15, 2017 go to post

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.

Robert Cemper · Sep 15, 2017 go to post

in namespace ENSDEMO use Demo.Dashboard.Production as an example for repeating calls

Robert Cemper · Sep 15, 2017 go to post

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:  ^%zmyLOGIN
and 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.

Robert Cemper · Sep 15, 2017 go to post

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 file
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…

Whatever better fits to reach your goal.

Robert Cemper · Sep 14, 2017 go to post

Take the example from %Net.SMTP to SAMPLE or USER independent of any ENS*

http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?…

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

~~~

Robert Cemper · Sep 14, 2017 go to post

- 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. 

Robert Cemper · Sep 14, 2017 go to post

another disapointment.  
eventually a THANKS icon instead of the HOOK would help ?

Robert Cemper · Sep 12, 2017 go to post

I haven't seen $mvv(58) before in any CSP application.
So this might be an action for WRC to find out why / where it is lost

Sorry,