Beginner

Syndicate content 14 

All responses are appreciated.  I am new to both scripting and CACHE so please bear with me.  I am setting up a nightly backup script for freezing cache then backing it up and then thawing it back out.  Currently when I enter the freeze command I am getting a response of access denied even though my id has %all access.  I've tried passing the userid/password as a parameter in the externalfreeze command and passing it from a file.  I've used my id and lastly I used the _system id in the file.  What ID should I use for this or am I passing it wrong?

sample 1:  ..\bin\cache -s. -u%%sys ##class(backup.General).externalfreeze() <c:\temp\login.scr

sample 2:  ..\bin\cache -s. -u%%sys ##class(backup.General).externalfreeze(username="?????",password="???????")

..\bin

Last answer 28 September 2016 Last comment 17 October 2018
0   0 3
405

views

0

rating

Hi!

I am not system admin. But it used to be very simple to install CSP Gateway on an apache system on Linux with Apache installed. I used to run the CSP Gateway installation program and after it was done, all I had to do was fine tune some configurations on CSP Gateway portal on http://<ip>/csp/bin/Systems/Module.cxw and I was up and running.

Last answer 30 August 2017 Last comment 21 December 2016
0   0 4
574

views

0

rating

I am looking for a general overview of how you would attach a document to a patient record in healthshare.  For instance, an Advance Directive or Living Will.

 

Here are some starter questions:

  1. What format is required, if any?  Can it be a PDF or DOC?
  2. How can/should it be submitted?  HL7? XDS.b?  Embedded in a CCD?

Sorry for the open endedness.  Any info would be helpful while I research this.

Last answer 9 March 2017 Last comment 16 November 2016
0   0 0
227

views

0

rating

Hi All,

I am new to this technology and I have installed the trial version of cache 2016.1 with Normal security.

I was trying to develop the sample cinema application and mean while when I tried to view the csp webpage, it opens the browser and ask for login after logging in it shows Service Unavailable error instead of preview of webpage.

Could you guys suggest an answer to resolve this issue.

Last answer 6 January 2017 Last comment 9 January 2017
+ 1   0 3
265

views

+ 1

rating

Hi

   I am facing issue with cache database it is part of schneider PES software..the issue started with below:

and after some reinstallation i became not able even to install it.

receiving always message: 

"could not locate installation directory" angry....i can only select new instance ...

How i can remove all the registry and old cache instance  to have new fresh installation.

Last answer 5 January 2017
0   0 2
0

comments

148

views

0

rating

I am trying to create a query that returns the best and worst performing products for a given customer, based on this year's net sales versus last year's net sales, weighted by the total net sales for all of the products sold to this customer in the last two years.

I have created Last Year Net Sales (up to the last month end): AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])

This year Net Sales: AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-1]),measures.[Net Sales])

Percent change: ((AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-1]),measures.[Net Sales]) - AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])) /AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])) * 100

Last answer 30 December 2016 Last comment 29 December 2016
0   0 4
164

views

0

rating

Hi,

I have a ZEN page class with the following annotation. What I try to accomplish is to display data from Object of Type MyPckg.Message. Each Message shall be displayed in a component of type <html>. The outline is somekind the following.

Last answer 19 December 2016 Last comment 20 December 2016
0   0 2
184

views

0

rating

All replies are appreciated.  We have put our first client into our production cache database and we are looking at what kind of regular maintenance is needed.  We were questioning whether we should defrag the database files using windows defrag program and whether we need to run the defrag for Globals regularly?  Should we be doing these routinely , occasionally or not at all?

Last answer 6 December 2016
0   0 2
0

comments

208

views

0

rating

Good afternoon!
I faced a problem with HealthShare complete transfer to another PC. I have on the old computer a lot of interesting developments and test projects, including widgets, developments on DeepSee and other stuff.
Would you please describe the details how one HealthShare installation can be correctly transferred to another PC. And that this should be done.

Last answer 1 December 2016
+ 1   0 1
0

comments

144

views

+ 1

rating

Coming from a C/C++/C# background, I was expecting the & and | operators in Cache ObjectScript to perform bitwise operations on integers, but apparently they don't.

 

I checked the online documentation http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

but couldn't find any information on bitwise integer arithmetic.

 

So given the following code:

set x = 10  //bit pattern is : 1010

set y=3      //bit pattern is:   0011

What operator can be used to return z = x <BITWISE AND> y  = 1011 (binary) = 11 (decimal)

 

Thanks,

Bill

Last answer 27 November 2016 Last comment 27 November 2016
+ 1   0 1
334

views

+ 1

rating

Since now i have been working from external connection but i want to work with the SQL utility of Management Portal

i dont know how to do with several instructions like in other editors like this example

update Prod.Articulos set Alto = 1646, Ancho = 16, Fondo =  80 where CodigoNum = '100' and Empresa = 'CO'
update Prod.Articulos set Alto = 1646, Ancho = 16, Fondo =  400 where CodigoNum = '101' and Empresa = 'CO'
update Prod.Articulos set Alto = 1646, Ancho = 16, Fondo =  400 where CodigoNum = '102' and Empresa = 'CO'

it returns

ERROR #5001: 25: SQL ERROR #25: Input (UPDATE) encountered after end of query^ 
UPDATE Prod . Articulos SET Alto = ? , Ancho = ? , Fondo = ? WHERE CodigoNum = ? AND Empresa = ? 
UPDATE action = (parse) rtn = () $ze = (<SYNTAX>errdone+2^%qaqqt) err = (qaqperr)

neither it works with a structure like thi

Last answer 16 November 2016 Last comment 17 November 2016
0   0 2
321

views

0

rating

Hi,

I have a problem which i think has a simple solution but which i and others haven't yet cracked. I want to display text output to a text box in monospaced font. At the moment the style sheet is shown below, I have tried various other options such as specifying a specific font such as Courier New.  None of the browsers I have tried (Safari, Firefox on OSX, IE) display as monospace, although the last 2 come close. I wonder whether I need a <pre> tag, but I can't see how to do that in Zen.

Suggestions?

XData Style
{
<style type="text/css">
/* style for title bar */
/* style for text box, non proportional (although in practice doesnt work)*/
#txaSPRINT {
    background: #C5D6D6;
    color: black;
    font-family: monospace, monospace;
    font-size: 1em;
    padding: 5px;
}
</style>
}
 

Last answer 7 November 2016
0   0 1
0

comments

111

views

0

rating

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 beneath each other.. Is it possible to have it like this..

 

Thanks in advance

Christopher

Last answer 2 November 2016 Last comment 3 November 2016
0   0 1
331

views

0

rating

Hi,

I'm new with writing Caché Objectscript so I need some assistance. I have XML which contains information like this:

<?xml version="1.0" encoding="UTF-8"?>
<session>
   <sessionId>124364</sessionId>
   <cabinet>demo</cabinet>
   <eventType>IN</eventType>
   <eventTime>20161006160154</eventTime>
   <login>test</login>
   <loginFirstName>test</loginFirstName>
   <loginLastName>test</loginLastName>
</session>

I have a class representing this object as follows

Last answer 31 October 2016 Last comment 1 November 2016
0   0 0
672

views

0

rating

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?

Last answer 30 October 2016
0   0 1
0

comments

105

views

0

rating

I had default csp application: /csp/<namespace>  for a namespace.

Later I created another application: /csp2/<namespace>  and  made it default.

Yet all namespace-specific (Ensemble, DeepSee, SQL, etc.) links in management portal still point to/csp/<namespace>.

Is there any way to make the links in management portal point to /csp2/<namespace>?

Last answer 24 October 2016
0   0 1
0

comments

151

views

0

rating

Hi All,

We are Upgrading the Application from Ensemble 2009 to 2016.1. We have imported the user, Roles and Resources.
But the Sql Tables and Sql Procedures are not being visible in Management portal -> Security Management -> User.
Please give me a solution or basics steps for importing those.

Thanks,
Manoj J

Last answer 20 October 2016 Last comment 21 October 2016
+ 1   0 3
305

views

+ 1

rating

Hello community; this may seem odd, but I need to know if there's any way we could be using callin functions from a C application without knowing?  e.g. if other developers created some C programs that call in to Caché that we don't realize are running.  Is that possible?  If so, where would I look to see these programs?  Perhaps the server's task manager? 

Thanks --Laura

Last answer 17 October 2016 Last comment 17 October 2016
0   0 2
180

views

0

rating

Very new to this side of cache.... 

So, currently in the habit of keeping all users forever, up to over 5000... ? is what if we decided to start deleting old users who have been gone from the company, how would it affect any account level information? notes, payments etc....  Is there any documentation anywhere that would answer this or describe this process or maybe best practices??

Sorry if this seems stupid but i am working on a proof theory for work.

Last answer 11 October 2016 Last comment 12 October 2016
0   0 2
260

views

0

rating