Caché | InterSystems Developer Community

Question

subbarao bellamkonda · Feb 22, 2016

Exporting CSP page with table to excel and retaining the format.

Hi,

I have been working on a csp page and trying to export it to excel using the standard activex object. I would like to know if it is possible to export the table on the page with formatting to excel? Thank you in advance for any insight.

Thank you,

Subba.

#Caché #Frontend

0 4

0 1.2K

Article

Murray Oldfield · Apr 8, 2016 17m read

InterSystems Data Platforms and Performance Part 4 - Looking at Memory

This post will guide you through the process of sizing shared memory requirements for database applications running on InterSystems data platforms. It will cover key aspects such as global and routine buffers, gmheap, and locksize, providing you with a comprehensive understanding. Additionally, it will offer performance tips for configuring servers and virtualizing IRIS applications. Please note that when I refer to IRIS, I include all the data platforms (Ensemble, HealthShare, iKnow, Caché, and IRIS).

#Best Practices #InterSystems Business Solutions and Architectures #Performance #System Administration #Caché #InterSystems IRIS #InterSystems IRIS for Health

32 3

9 10.9K

Article

Murray Oldfield · Nov 25, 2016 23m read

InterSystems Data Platforms and performance – Part 8 Hyper-Converged Infrastructure Capacity and Performance Planning

Hyper-Converged Infrastructure (HCI) solutions have been gaining traction for the last few years with the number of deployments now increasing rapidly. IT decision makers are considering HCI when scoping new deployments or hardware refreshes especially for applications already virtualised on VMware. Reasons for choosing HCI include; dealing with a single vendor, validated interoperability between all hardware and software components, high performance especially IO, simple scalability by addition of hosts, simplified deployment and simplified management.

#Best Practices #InterSystems Business Solutions and Architectures #Performance #System Administration #Caché #InterSystems IRIS

10 7

1 3.7K

Question

Stephen Wilson · Nov 22, 2016

How do you ensure synchronisation between two %ZEN.Component.tablePane objects?

TablePane1 is populated when a %ZEN.Component.button on a form is clicked from a JavaScript onclick method.

#Caché #Frontend #ZEN

0 3

0 545

Article

Eduard Lebedyuk · Oct 18, 2016 7m read

Macros in the InterSystems Caché

In this article I would like to tell you about macros in InterSystems Caché. A macro is a symbolic name that is replaced with a set of instructions during compilation. A macro can “unfold” in various instruction sets each time it is called, depending on the parameters passed to it and activated scenarios. This can be both static code and the result of ObjectScript execution. Let's take a look at how you can use them in your application.

#Beginner #Best Practices #Caché #Compiler #Terminal #ObjectScript #Tips & Tricks

9 3

0 2.4K

Article

Fabian Haupt · Sep 2, 2016 2m read

Advanced URL mapping for REST

By now it's a commonplace how to implement a basic REST API in Caché and there is good documentation about it here: REST in Caché

A question that comes up from time to time is:

How can I make a parameter in my REST url optional?

Simply put, is it possible to create a URL map in Caché that maps a URL like this:

#Mapping #REST API #Caché

12 1

1 2.8K

Question

Svetlana Ilina · Nov 28, 2016

spatial data

Hello. I am a student from Syktyvakar Forest Institute(Russia).

I need to make Research : "Databases for working with spatial data
Consider MySQL, PostgreSQL and 1 to choose from". I want to explore Cache with subject library of spatial data.

Help.

Does Someone from the developers write the libraries of spatial data?

#Caché

0 3

0 426

Article

Maks Atygaev · Dec 11, 2016 4m read

Declarative development in Caché

Caché offers a number of methods for going through a collection and doing something with its elements. The easiest method uses a while-loop and lets you fulfill the task in an imperative manner. The developer needs to take care of the iterator, jumping to the next element and checking if the loop is within the collection.

#Object Data Model #ObjectScript #Tips & Tricks #Caché

14 18

1 1.8K

Article

Tirthankar Bachhar · Sep 27, 2016 3m read

Registering New Error Code and Error Message

How do we generally create an error object of %Status?

Set status=$SYSTEM.Status.Error($$$GeneralError,"Something went wrong")

Now, like $$$GeneralError there are many more macro defined within %occErrors include file by Intersystem which we can use.

#Object Data Model #Caché

3 6

1 1.5K

Question

Alexander Koblov · Feb 5, 2016

How to convert JSON to %ListOfDataTypes?

Hi.

It is easy to receive JSON representation or dynamic Array from %ListOfDataTypes:

set l=##class(%ListOfDataTypes).%New()
do l.Insert("a")
do l.Insert("b")
do l.Insert("c")

set arrStr=l.$toJSON()
zwrite arrStr
set arr=l.$compose([])
zwrite arr

How to make backward conversion? How to receive %ListOfDataTypes from dynamic Array an JSON string?

I've tried

#Code Snippet #Interoperability #JSON #Caché

2 3

0 1.5K

Article

Jonathan Pham · Nov 1, 2016 1m read

Wireshark installer could affect Studio.exe and csystray.exe on Windows

A few customers have seen this happen, so I thought it would be worth mentioning here on the Developer Community. This could affect users running versions between 2014.1.3 and latest who install or upgrade Wireshark. There is a bug in the Visual C++ 2013 redistributable shipped with the current Wireshark 2.2.1.

This is from Microsoft’s bug report https://support.microsoft.com/en-us/kb/3138367 :

#Studio #Caché

9 6

0 959

Question

Shanmuga rajan · Sep 23, 2016

Cache class definition

i got an unspecified character in my try-cache i do sample class definition using stream collection what is my defect plz reply me as soon as possible

#Caché

0 2

0 328

Announcement

Stefan Wittmann · Aug 25, 2016

JSON changes in Caché 2016.2

As Bill has mentioned earlier in his post, we have carefully reviewed the JSON capabilities and made some adjustments to ensure they deliver the best benefit to you. In this post, I am going to describe the modifications in more detail and provide guidance for you to understand the implication for your code base.

#Compatibility #JSON #SQL #Caché

11 8

1 4K

Article

Brendan Bannon · Sep 1, 2016 9m read

The Art of Mapping Globals to Classes (2 of 3)

If you are looking to breathe new life into an old MUMPS application follow these steps to map your globals to classes and expose all that beautiful data to Objects and SQL.

This example is going to cram in 4 or 5 different things beyond what was covered in Part 1

#Globals #Mapping #SQL #Caché

10 2

0 2.6K

Announcement

John Murray · Jul 22, 2016

Serenji 2.6 is now available

We at George James Software are pleased to announce the release of version 2.6 of Serenji, our editor and debugger for Caché, Ensemble and HealthShare.

The main enhancement in 2.6 is the ability to run on a Linux <edit> or OS X </edit> workstation using Wine 1.8. More release details are here.

#Development Environment #Release #Caché #Ensemble #HealthShare

2 3

0 684

Question

Jenna Poindexter · Feb 2, 2016

How do we upload a document from a CSP Page

I have a CSP page that needs to allow the user to submit a file. I have a form with an element in it <input type="file" name="file"/> which allows the user to select the file they want to upload from their local filesystem.

How do I go about actually getting the file to be sent to the server?

#Caché #Frontend

0 5

0 1.4K

Question

Eduard Lebedyuk · Sep 26, 2016

Automatic removal of system methods from codebase

As we've all heard 2016.2 draws near and brings the removal of system methods with it.

There are two ways to make the code compatible with 2016.2:

Replace system methods with new methods
Replace system methods with macros

#Caché #Compatibility #ObjectScript

1 1

0 424

Question

Jose Sampaio · Jul 21, 2016

Source Control For Caché / Ensemble

Hi community members!

I'd like to know about what source control version is recommended to use with Caché / Ensemble. Can someone help me? If yes, there is some documentation to how to configure?

Thanks,

José Sampaio.

#Source Control #Studio #SVN #Caché #Ensemble

3 8

0 3.4K

Article

Brendan Bannon · Oct 27, 2016 2m read

New WRC Customer Interface

Come check out the new WRC interface we have made available to supported customer.

Some of the new features available to you are:

Organization Dashboard – gives an overview of your organizations activity for this year

#Caché

9 9

0 1.1K

Question

John Murray · Apr 6, 2016

What does the + suffix at the end of a Studio document name denote?

Here is a screenshot from my 2016.2 FT instance of Studio and Ensemble:

I don't recall having seen the highlighted "+" suffix on document names previously. Who can tell me what it denotes?

I originally posted this in the Field Tests group but it turned out to be a 2016.1 feature that I hadn't previously noticed. So I subsequently moved the post to the Cache group.

#Studio #Caché

2 11

0 861

Article

Mike Kadow · Apr 9, 2016 1m read

Kindle Edition of Caché and MUMPS – Part II is released

Kindle Edition of Caché and MUMPS – Part II is released

All data is present and readable, albeit with some minor formatting issues.

Thank you for your patience in waiting for the kindle edition.

#Caché

3 2

0 571

Article

Eduard Lebedyuk · Sep 13, 2016 7m read

User authentication using Arduino with RFID

In the previous article, I had just started working with Arduino, and got a meteorological station to show as a result. In this article, let's go further: we will set up authentication via RFID cards and Arduino against the InterSystems Caché application.

#Authentication #Security #Terminal #Access control #Caché

8 3

2 5.1K

Article

Timur Safin · Aug 19, 2016 10m read

Caché MapReduce - introduction to BigData and MapReduce concept

Several years ago everyone got mad about BigData – nobody knew when smallish data will become BIGDATA, but all knows that it’s trendy and the way to go.

#Artificial Intelligence (AI) #C++ #Data Model #Distributed Data Management #Machine Learning (ML) #Caché

8 3

1 1.9K

Article

Timur Safin · Aug 26, 2016 8m read

Caché MapReduce - Basic interfaces for MapReduce implementation (part II)

In the prior part of this series we have provided introduction to Google MapReduce approach, but still not covered their possible ObjectScript implementation. Which we will start to explain today.

#C++ #Data Model #Globals #Key Value #Caché

4 4

1 748

Article

Timur Safin · Sep 2, 2016 11m read

Caché MapReduce - putting it all together – WordCount example (part III)

In part I of this series we have introduced MapReduce as a generic concept, and in part II we started to approach Caché ObjectScript implementation via introducing abstract interfaces. Now we will try to provide more concrete examples of applications using MapReduce.

#Data Model #Distributed Data Management #Object Data Model #Caché

5 3

1 1.2K

Article

Benjamin De Boe · Jul 4, 2016 8m read

Introduction to the iKnow REST APIs

After a five-part series on sample iKnow applications (parts 1, 2, 3, 4, 5), let's turn to a new feature coming up in 2017.1: the iKnow REST APIs, allowing you to develop rich web and mobile applications. Where iKnow's core COS APIs already had 1:1 projections in SQL and SOAP, we're now making them available through a RESTful service as well, in which we're trying to offer more functionality and richer results with fewer buttons and less method calls. This article will take you through the API in detail, explaining the basic principles we used when defining them and exploring the most important ones to get started.

#Best Practices #Caché #InterSystems Natural Language Processing (NLP, iKnow)

6 1

0 1.5K

Question

Jiri Svoboda · Nov 7, 2016

CLS location from INT code

Given location in INT code, as Cache usually reports on error (zWriteReport+25^SomeFile.1), is there any programmatic way to determine corresponding place in original source code?

Jiri

#Caché

2 10

1 937

Question

prabakaran a · Dec 27, 2016

Upload and strore the file

Hi all,

How to store the upload file in CSP?

Thanks,

Prabakaran A.

#CSP #Caché

0 6

0 2K

Question

Chris Stewart · Jun 9, 2016

REST Services Cataloging

I've been building up a REST services API, consisting of a dozen or so classes referenced from a Dispatch class, which has route mappings for the first piece of the URI. I'd like to have the Dispatch class be able to output all of the available Services, with some documentation. Is there something like a %Library resource that I could use to pull this information from each of the classes?

Thanks

Chris

#Data Model #REST API #Mapping #Caché

0 7

0 879

Article

Carter Tiernan · Dec 22, 2016 2m read

The Polymetric Dashboard

> Customizable System Monitoring. ## Introduction The Polymetric Dashboard is a stand-alone module that provides enhanced monitoring tools for a Caché environment. Equipped with over one hundred sensors that monitor key system metrics, a robust REST API, and a modular AngularJS user interface, the Polymetric Dashboard is fully functional out of the box. However, the Polymetric Dashboard is designed to be customizable; any system metric can be monitored by creating a new sensor, and the visualization of collected data can be tailored to specific requirements and purposes.

#Tools #Monitoring #Visualization #Caché

9 20

1 1.6K