Hello Everyone.

Sorry if it is a dumb question, but I'm new.

First: I have to create a Excel MultipleSheet Report. That I'm fine with doing.. but they want me to give every Workbook that is created it's unique reportName, that is generated with the user input on the page. Is it possible to do so?

Second: I saw when creating the report.. Everything is placed in it's own column.. Is it possible to have some of the values next to each other and some Beneath each other.. Example.. BusinessProcess, TransactionType and NumberOfSteps must be next to each other and Step1, Step2 and Step3 should be benea

Hi, Community!

We've updated Developer Community (DC) portal and here are some good news.

Now you can insert in your post highlighted parts of code. It works with help of highlight.js library.

To illustrate it I took some code snippets from Fabian's article.  

 
Method OnPreServer() As %Status
{
 set ..SharedConnection=1
 set room=$GET(%request.Data("room",1),"default")
 set:room="" room="default"
 if (..WebSocketID'="")
  {
   set ^CacheTemp.Chat.WebSockets(..WebSocketID)=""
   set ^CacheTemp.Chat.Room(..WebSocketID)=room }
 else
  {
   set ^CacheTemp.Chat.Error($INCREMENT(^

I am using OAuth2 Cache framework, acting as a client to an authorization server. My setup is based on this excellent previous post [Caché Open Authorization Framework (OAuth 2.0) implementation – part 1].

I'm facing ‘Authorization Server Error: Error Processing Response - No match between server name 'googleapis.com' and SSL certificate values google.com…’

It looks like I should set SSLCheckServerIdentity to false but I can’t figure out how. Has anyone had the same issue?

Hey guys

We have a need to mount remote databases using ECP, but with the Application servers mounting some of the remote databases as Read Only.  The Data servers will keep them R+W as normal.

From what I can gather this isn't possible using a "Mount Read Only" option, it looks like ECP just inherits the Database servers settings.  My reading seems to require roles/access/permissions to enforce Read Only on these remote mounts.  Does anyone have an easy guide/cheat sheet to set up read only ECP Application server read-only mounting using roles/permissions?  Or an alternative method to achieve t

Hello, trying to figure out how to configure an Ensemble web service to use HTTP Basic authentication.  I have a web service client that will not be able to send SOAP headers.  I did not see that option at all in the documentation.  thanks

Has anyone ever used the LogoutAll method in the %CSP.Session class successfully? I'm wondering what I need to do to use it.

Thanks,

Laura

Can please update the UI on

https://community.intersystems.com/top-stories

Use pagination rather than the old UI of loading more content as you scroll(chasing the footer)

When running the built in Ensemble Purge task (Ens.Util.Tasks.Purge) there are three parameters DaysToKeep, BodiesToo, and KeepIntegrity.  This article focuses on the KeepIntegrity boolean parameter, but more information about running this task can be found here:

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…

KeepIntegrity determines which Ensemble Messages are marked for deletion within the time specified by DaysToKeep. 

With KeepIntegrity marked as true, the Purge will only mark “completed” messages for deletion.  A completed message has a status of Complete,

This post is meant to provide a quick possible explanation for a very perplexing problem.

Scenario:  You’ve just created your own administrative user in your 2014.1 (or later) instance of Caché.  You gave it every possible security role (including %All), so it should in theory be able to do anything within the instance.

You’ve written a very advanced routine with a break command in it for debugging:

MyTestRoutine
            set ^MyInitGlobal = 1
            write "Hello, my name is..."
            break
            write "Steve"
            quit

You log into Terminal with your new user, r

1. Don’t use Python built into Mac.  Because of System Integrity Protection (SIP) you will not be able to access the libraries that the InterSystems Python binding requires.  The Python build into the MAC has baked in what libraries it can use.
2. Install another Python.  Don’t put this other ahead of Mac Python on path since this could break things.  Apple regards its Python as part of the its OS, and may use that Python in its system operations.
3. This Python will not be installed into the protected area.  Mac does not want you messing with its Python.
4. Use explicit path to invoke this other Python.  Yo

How can we make sure that the Cache userid passwords are encrypted on storage? We want to make sure that the Cache passwords cannot be decrypted - how can we ensure that?

The topic of reflection hasn't been raised in Caché forums or blogs too often. Perhaps, it happened because the notion of reflection is not explicitly defined in Caché. However, it exists in Caché and can be a very useful development tool.

Hi,  

In Cache Studio under the View/Find in Files.  Anyone knows how to search multiple words in the string?   For example,

In my routines 1, it has "Patient Name   Test Name    Provider    Address   Status  " and

In my routine 2 , it has "Patient Name   Test Name    Provider    Address "

In my routines 3, it has "Patient Name      Address "

 When I search, I want to search all the routines, it has the words  Provider and Status which I want it returns only routine 1 because it has both words "Provider and Status".   Thank you very much for your help.

Hi, We have been upgrading our application to ensemble 2016.1.1. I have moved my data to a particular namespace which i have created and now in management portal i have been getting an error message "namespace does not support Ensemble". Please give solutions to resolve this issue.

Thanks and regards

I implemented a WebService in edge of HeathShare but it is asking for user and password, so it isn't possible to publish.

How can I grant permission for that service?

PS. When I type the user and pass the WSDL shown is correct.

Hi, Community!

Here is the digest of Articles and Questions published on InterSystems Developer Community in October 2016.

Most viewed

Internal Structure of Caché Database Blocks, Part 1  407

Caché and Ensemble 2016.2.0 Release  306

How to execute terminal commands from a webpage  214

How to Parse a URL in Caché  196

Internal Structure of Caché Database Blocks, Part 3  191

Tips & Tricks - SQL to Excel  188

Internal Structure of Caché Database Blocks, Part 2  184

Data Platforms and Performance - Part 7 ECP for performance, scalability and availability  180

Lines of Code  147

How to add a parameter to a cla

I am looking for samples for integrating Ensemble and RabbitMQ. Any pointers appreciated.

Best,

Harish

See 

http://www.datasciencecentral.com/profiles/blogs/ten-top-nosql-databases

What will it take before Cache begins to appear on (or at the very least be considered for) such lists?

hi,

1. Created a class(test) and added a classmethod(checkdata).

2. Assigned a object with xml.

3. Created a new class for response and initialized in classmethod(checkdata). 

4. Created a new class for request parsing with list of object parameter.

5. While parsing xml in request for list of object,  the  result count is "0". But the xml has value for "2" object list.

6. XML has follow:

<Request>
    <party>
        <to name=""mohan"" address1=""India""  />
        <to  name=""sujay"" address1=""USA"  />
    </party>
</Request>

Hi, Community!

We deployed the new update on DC and it brings:

• The new post subscriptions/favorites model
• Some menu changes
• Bug fixes.

The new post subscriptions/favorites model:

with every post you now see the star in the left bottom corner of the widget in the feed or of the post.

Click on it and it turns to yellow which means that you store it in your "Favorites" tab which you can find later in your member's page like it is shown in my one.

Also, that means you automatically subscribed to email notifications on all the changes in this post.

Click it again to unfavorite/unsubscribe the article.

The nu

I used the Members option from the Community button to look up Evgeny's profile. Above the tabs ("View", "Mentions", "Posts (53)" etc) his name was displayed (correct).

Then I clicked on the "Posts (53)" tab. It showed his posts, but displayed my name above the tabs.

I create the NewBie posts.

And as directed I use the Beginner tags.

However, a lot of people are using the Beginner tags for other posts.

Is there a way for separating the NewBie posts from the other Beginners?

Failing that, can I in someway make the Newbie Index more visible?

I am doing a lot of work on the NewBie Index to make it more useful.

I have a post I have published.

Now I need to do some substantial work on it.

I cannot do it all at one time, so I save it after I do some work.

Trouble is, each time I save it, it is published and sent out in mail, which is not what I want.

How can I save a post and not get it sent out?

Is there any method or routine available to export and import the user roles and the sql table and sql procedures associated with each role?

NewBie's Corner Session 22 Parameters Part III

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Parameters

In Sessions’ 20 and 21 on Parameters we saw how to call one routine from another with parameters as well as calling one Label from another with parameters. In these examples, the data was passed through the parameters from the calling routine or label to the called routine or label.

Now suppose you wanted the called routine or label to pass data back?

There are two ways** of doing this.

1) Returning a Status through a User-Supplied Function

2) Using Passed by

We are finally planning to migrate some ancient Caché applications that are run on Caché 5.0.21 to a new server with Caché 2016.2.0 or so.

I wonder if we could use Shadowing between those to keep the data on the new server up to date?

We would copy the Caché backup from the old environment to the new and do a RESTORE there and then start shadowing.

I know than 5.0.21 is no more officially supported by ISC.

Hi,

We have created a dll with .Net that generates a MS Word document with a template. The .Net method works, we have tested it with Visual Studio and it generates the document.

But once we have created the dll and embebed it in Ensemble through the Wizard, when we try to execute the method that generates the document, it doesn't work. It doesn't throw us an error, it simply doesn't open the template.

We have seen that MS Word program is opened, but that's all.

We are using Microsoft.Office.Interop to generate the Word document. It must be Word 97 version document.

What are we missing? Are we doing

After reading Stephen Wilson's article "Windows 7 performs shutdown too fast for Cache to close and so it gets forced down" I've recalled another solution that was based on Local Group Policy, which allows to control extra actions that should occur on computer startup or shutdown. How to add a computer shutdown script is well documented in MS Technet article. In short:

• being logged on as a domain admin, run Local Group Policy Editor (gpedit.msc)
• open Computer Configuration\Windows Settings\Scripts (Startup/Shutdown)
• double-click Shutdown
• in the Shutdown Properties dialog box, click Add, then Bro

I'm working with a custom code in Studio and I'd like to know where a Class is being used.

The standard ctrl+f  search only in current file.

Hi-

I was wondering whether or not the Ensemble Event Log was accessible using SQL?  If so, what schema and table would that be contained in?

Thanks