If I run SELECT * FROM HS_Message.PatientSearchRequest ORDER BY ID Desc every row has a unique ID but every other row is an exact duplicate.  Why would this be?

This is a follow-up to Murray's article for scripting pButtons data extraction on Unix/MacOS:     Extracting pButtons data to CSV for UNIX/MacOS

###Extracting pButtons data to a CSV file on Windows

PowerShell scripting was used in this article because it is available by default on Windows platforms.

The script, Extract_pButtons.ps1, will search the given pButtons file until it finds the marker for the beginning of the section. The section will be printed line-by-line, from the header to the line before the section end marker.

Hi,

Is there any way to track the 'last modified by' cache user name and datetime of last modification for a class or routine definition [Track Last Code Changes]?

Thanks,

Tirthankar

Hi-

I have created a class that extends %Persistent and %Populate and have set the various POPSPEC attributes of my properties to control how the  properties are populated.  However, when I compile the class and try to run the Populate() method it tells me the method isnt defined.

Here is the class definition:

Class My.

The iKnow documentation shows an example for adding sources to a domain after an initial loading of sources.

The example uses text files. However, our data is now in Cache SQL tables.

Is it possible to add sources from a Cache SQL table, and is there an example of how this is done?

Thank you.

Hi everybody,

My name is Sérgio Fernandes and I'm from Brazil.

I need to get the size of file that the user wants to upload in my application.

I'm getting it name with %request.GetMineData("fileName").FileName, but not found it at Ensemble documentation how would i get the size of file.

My version is Ensemble 2013.1.6.950.0 and I'm doing it at csp.

Thaks 

InterSystems is pleased to announce that Caché and Ensemble 2016.2.1 are now available as maintenance releases.

For a complete list of the corrections in 2016.2.1, please review the release notes.

Caché and Ensemble 2016.2.1 are available for the same platforms as 2016.2.0.  The complete set of supported platforms, including specific point releases and patches, is detailed in the Supported Platforms document.

The HealthShare team will announce availability of its products separately.

The build corresponding to this release is 2016.2.1.803.0

I'm trying to start a Production and the following error is shown.

Any idea how to solve?

translations:   -  Produção 'BUS.BusProduction' está sendo iniciada...
                              - Production 'BUS.BusProduction' is being initialized

                             - A produção não pode ser iniciada - precisa ser ativada 
                             - The production can't be initialized - it must be activated.

11:10:01.549:Ens.Director: Produção 'BUS.BusProduction' está sendo iniciada.
11:10:01.

I try to run the cmd command in the studio terminal, but i am getting the <NOTOPEN> Error.

Even ZF(-1) also not working. Any help, Please!!!

Note: i restart the Cache instance service with full privilege

Code:

Set Path="mkdir E:\Sample\New"

Open Path:"QR":10

Error:<NOTOPEN>

This command working on my PC, but on server throws error.

Many Thanks

I'm trying to setup a webserver in health share.

I'm stuck in premission set up.

When I select Unauthenticaded login method in  EDIT WEB APLICATION the page freeze and after some time, about a minute, the login page is shown.

Someone knows what is happening?

Hello,

I'm sending http request through %Net.HttpRequest and I have html page in response. Is there any built-in tool for beautify html for printing in terminal?
Thanks.

Can somebody explain this behaviour of Cache (and many other calculating machine as well) :

WRITE 1/3*12

4

WRITE 1/3*5

1.666666666666666667

W 1/3*18

5.999999999999999999

W 1/3*21

6.999999999999999999

W 1/3*24

7.999999999999999999

How can we make more occurate caculations in Cache ?

I'm writing an operation to use the LDAP Outbound Adapter to query AD.

The operation's settings include a basic Credentials selector, to allow you to use the built in Credentials function of Ensemble. This can be referenced in the operation with ..Adapter.Credentials

But when it comes to specifying the credentials in the Bind method, the documentation indicates that only a format of $lb(Username,Domain,Password) is supported. I tried ..Adapter.Credentials and $lb(..Adapter.Credentials) but the only thing that worked was setting the three variables in plain text first in the operation itself

I'm trying to schedule a task hourly. It's currently set to execute "Daily" but run every 60 minutes. It's only running daily. Do I need to change the "Daily" to OnDemand in order to get it to run hourly?

Hi All,

     How to create a .xlsx or .xls (Activate.Excel ) file using cache.

Thanks, Sansa.S

I have recently updated assigning authority in the Registry . How can I update the existing patient records in Health Insights with new code? (HSAA.Patient.PatientNumbers)

There is an interesting discussion in the Russian forum going. 

What is the best solution for the function which returns the max for the set of parameters?

From the listed solutions I like this one:

ClassMethod max(args...) {
  for i=1:1:args {  s max(+$g(args(i))) = i }
  s i="", max=$o(max(i),-1, i) Q $lb(max, i)
}

A group of students at the Chalmers University of Technology (Gothenburg, Sweden) tried different approaches to automatically rating the quality of emergency calls, including iKnow.

Excerpt: "The most impressive results produced by iKnow is its ability to correctly classify 100% of the calls using the Average algorithm. This is quite surprising since iKnow only compares low-level concepts, how words relates to each other."

Full story: http://publications.lib.chalmers.se/records/fulltext/244534/244534.pdf

Hi,

I am using iknow text categorization to classify texts. I have 11 medical articles as my training set. Here is part of the source code:

ListerAndLoader
  SET domId=domoref.Id
  SET flister=##class(%iKnow.Source.File.Lister).%New(domId)
  SET myloader=##class(%iKnow.Source.Loader).%New(domId)
UseLister
  SET dirpath = "D:\iKnowTestCase\SmallDataBase\Medical"
  SET stat = myloader.SetLister(flister)
  SET stat = myloader.ProcessList(dirpath,$LB("txt"),0,"")
  IF stat '= 1 {WRITE "The lister failed: ",$System.Status.DisplayError(stat) QUIT } 
TrainingSet
  SET tTrainingSet = ##class(%iKnow.Filters.

Hi,

I'm working on a project that integrates the Subversion source control tool with Intersystems Cache Studio. I realize that Atelier has come out with 2016.2 developer edition which has built-in support for source-control, but it needs Cache version 2016.2. We don't work on that as yet. My question is simple. I've built a menu, interfaced with Subversion, validated my globals, and built a fully functioning source control system. However, I need to authenticate the user before every commit to the master repository.

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.

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.

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?

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.

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.

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.