Question Larry Pinsky · Oct 27, 2017

Recordmap within a BPL

I have a text file that is fixed width delimited and am using a BPL to process this file, ultimately performing a transform from the text file to an HL7 message. I created a DTL, mapping from the recordmap to the HL7. In my BPL, I am performing some loops and other logic (that all is working). My issue is what to do when I perform the Transform.

I thought I could just call the transform and pass in the string as the source and a HL7 Message as the target. This results in an OREF error. I assume because the processing of the text file to the recordmap is not occurring. I assume I have to

#Ensemble #Business Process (BPL) #Mapping
1
0 761
Question Soufiane Amroun · Oct 30, 2017

Oauth 2.0 framework

Hi Team

i want to implement  an Oauth 2.0 framework in my application , i define my  connexion IHM, i want to check if the login and password are right when a user connect

do you've any idea ?

thank's

#Caché #OAuth2
2
0 605
Article Brendan Bannon · Nov 29, 2016 7m read

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

The Art of Mapping Globals to Classes (3 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.

If the above does not sound familiar to you please start at the beginning with the following:

The Art of Mapping Globals 1

The Art of Mapping Globals 2

This example is going to show you how to map a classic parent-child structure.

Same disclaimer:  If you can’t make heads or tails of your globals after reviewing these articles please contact the WRC and



#Caché #Globals #Mapping #SQL
9
0 2032
Question Jason Ip · Sep 20, 2016

Caché SQL error (ODBC?) - <<METHOD DOES NOT EXIST>Prepare+41^%SYS.SQLSRV *%New,%sqlcq

So just this morning we started to get this error from all of our SQL-client based tools that connect to our Caché SQL via ODBC: 

[%msg: <Error instantiating cached query class in Prepare(): <METHOD DOES NOT EXIST>Prepare+41^%SYS.SQLSRV *%New,%sqlcq>] (State:S1000, Native Code: 190)]

No queries work... any help? stumped over here.

doing a SQL query via Class %SQL.Statement

##class(%SQL.Statement

in Caché command line works... so that's why I think it's an ODBC issue..

I can't seem to find a SQLSRV class in the %SYS documatic

#Caché #SQL
6
0 1301
Question Nadirbek Nurlybekov · Nov 1, 2017

Property Deleted, %OnDelete

Greetings to all! Faced with such a problem, I ask for help, someone with great practical skills I think has already implemented this.The task was not to delete any objects from the database, but somehow mark this data deleted by client, because of this, I added Property Deleted As% Boolean [InitialExpression = 0];in the class.And in the redefined method %OnDelete:

ClassMethod %OnDelete(oid As %ObjectIdentity) As %Status [ Private, ServerOnly = 1 ]
{
        s person = ..%Open(oid)
        s person.Deleted = 1
        d person.%Save()
        Quit $$$ERROR(2112, "DeleteOperationNotAll
#Caché
3
0 892
Question Nicky Zhu · Oct 24, 2017

How to immigrate calculated dimensions of a pivot table

Hi guys,

I'm trying to immigrate some of my HealthInsight dashboards and pivot tables to another HS instance.

In some pivot tables, I defined them with a set of calculated dimensions defined in the analyzer, e.g as below:

Then when I exported the cubes and pivot tables in used to my new envirmonment. When I open my pivot tables again, the calculated dimensions are missing and hence my pivot tables no longer work:

Is there any way to export those calculated dimensions so that I can used them else where? 

#InterSystems IRIS BI (DeepSee) #Analytics
6
0 522
Article Danny Wijnschenk · Nov 1, 2017 8m read

Advent of Code 2016 Day1: No Time for a Taxicab

Advent of Code is a series of 25 small programming challenges, it's an ideal way for beginners to start learning a computer language, and for advanced people to sharpen their programming skills.

There are small and bigger puzzles, which you can solve typically in half an hour to a few hours. (Looking at the leaderboard, the top aces can do them in less than 10 minutes.)

Advent of Code is created by Eric Wastl, you can find all info on https://adventofcode.com/.

To help you get trained for this year's challenges which start at December 1st, we* will try to solve and comment the puzzles from

#Caché #Caché #Code Snippet #Contest #ObjectScript
0
1 1442
Question Pravin Barton · Oct 30, 2017

How to put a character limit on a textarea?

I want to limit the length of the value of a textarea in Zen. In HTML the textarea element has a 'maxlength' attribute, but the Zen component doesn't have an equivalent property. Is there any way to add a maximum length in Zen short of creating my own custom component?

#Caché #ZEN
3
0 818
Question Eduard Lebedyuk · Oct 30, 2017

Zstrip to clean string

I'm extracting text from HTML (more on how - here), and after I extract text it has two problems:

  • Lot's of $c(10) control characters
  • Multiple whitespaces

Here's an example of the text extracted from HTML page:

set text = " "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(10)_" Word1"_$c(10)_" "_$c(10)_" "_$c(10)_" "_$c(
#Caché #Beginner #ObjectScript
2
0 2023
Question Alexey Maslov · Oct 17, 2017

Yet Another Way to Duplicate Quotes in String

This small function is of great need sometimes. My solution is straightforward:

dupquote(str) ; duplicate quotes in str    quit $replace(str,$char(34),$char(34,34))

I'm just curious whether other solutions exist. Is there some "standard" and/or quicker approach which I've just overlooked?

#Caché #Tips & Tricks
6
0 1243
Question Eduard Lebedyuk · Oct 26, 2017

Get class property position in storage $lb

I have a classname and a property name. I want to know, when I get object value directly from a global, which property corresponds to which position in the $lb structure.

Here's what I got so far:

Class Utils.Storage {

/// write ##class(Utils.Storage).GetPosition()
ClassMethod GetPosition(class As %Dictionary.CacheClassname = "Sample.Address", property As %Dictionary.CacheIdentifier = "Zip") As %Integer
{
    set strategy = $$$comClassKeyGet(class, $$$cCLASSstoragestrategy)    
    set strategyId  = class _ "||" _ strategy
    &sql(SELECT Name INTO :position
         FROM %Diction
#Caché #Globals
6
0 698
Question Mohan Kumar · Oct 27, 2017

Why there is no entry in Workflow tasklist after raising a task

Hi All,

  I have a rasing task from BPL using <call>, it needs to add an entry in workflow task list and the task has to rais.

  after performing, 

  I didn't see the entry in workflow task list, but the task gets raised.

  In What is the root cause for this.

  Why there is no entry in tasklist after raising task?, How to verify it?

Thanks

#Ensemble
1
0 365
Question p rd · Oct 25, 2017

JDBC connection cache can not save long string

I defined the variables in Cache, as follows:

Property Content As% Stream.GlobalCharacter [Required, SqlColumnNumber = 3, SqlFieldName = B_Content];

And then use the SQL statement to add:

insert into table_name (B_Content) values ('very long string');

But the error:

 org.springframework.http.converter.HttpMessageNotWritableException: Could not write content: No serializer found for class com.intersys.jdbc.CacheInputStream and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: com .sxxxx

#Caché #Java #JDBC
3
0 684
Article David E Nelson · Mar 9, 2017 9m read

Machine Learning with Spark and Caché

Apache Spark has rapidly become one of the most exciting technologies for big data analytics and machine learning. Spark is a general data processing engine created for use in clustered computing environments. Its heart is the Resilient Distributed Dataset (RDD) which represents a distributed, fault tolerant, collection of data that can be operated on in parallel across the nodes of a cluster. Spark is implemented using a combination of Java and Scala and so comes as a library that can run on any JVM. Spark also supports Python (PySpark) and R (SparkR) and includes libraries for SQL (SparkSQL)


#Caché #Artificial Intelligence (AI) #Analytics #Big Data #JDBC #Machine Learning (ML) #Python #Vector Search
5
1 2844
Question Raymond Lawrence · Oct 23, 2017

Ensemble/Healthshare server sizing on Amazon AWS EC2 servers

I am designing the software architecture for an Ensemble/Healthshare production to be deployed on Amazon AWS EC2 servers (2 mirrored m4.large - 4 vCPUs / 16 GiB RAM running RedHat Linux  3.10.0-327.el7.x86_64 and Healthshare for RHEL 64-bit 2016.2.1). It's a rather CPU-intensive production involving massive XSLT 2.0 transformations (massive both in terms of size and volume). I was wondering if anyone has experience configuring Ensemble productions on EC2 servers. My question or concern has to do with the following statement in the Ensemble documentation:

"InterSystems recommends that, as a

#Ensemble #HealthShare #AWS #Cloud #Performance #Red Hat Enterprise Linux (RHEL)
2
0 883
Question Nadirbek Nurlybekov · Oct 26, 2017

Content-Type in REST

Greetings to all!!!How to get the value of the Content-Type field from the object of the class %Stream.Object obtained with: 

stream=% request.GetMimeData (FormDataName, 1)

I tried:

write stream.GetAttribute("Content-Type")write %request.Get("Content-Type")

but always returns a void, although it should be "image/jpeg", "application/pdf" or something like that.
In JS:

    var formData = new FormData();
    formData.append('file', element[0].files[0]);
    console.log(element[0].files[0].type);

The console of browser displays "image / jpeg", "application / pdf",  etc.

#Caché
2
0 531