#Beginner

Has anyone ever worked with a load balance for ECP servers access? If yes, wich one? 

What are the pros and cons of such a solution? We use ECP servers as data servers via ODBC, thanks!

In a comment on this post in the Field Test - 2016.2 community Bill McCormick suggested using Atelier's "Check for Updates" option from the Help menu. Here's what I get:

Clicking "Yes" gets me here:

Looks like I need to use the "Add..." button:

What URL should I enter here?

Hello. New to the forum and was hoping I could get some expert help here. I have one data set that is using CHD Logic to combine Procedure and Diagnosis codes to define Sensitive data and flag the record for additional protected filtering. The files coming in define what is flagged and the Clinical Info Rule and Clinical Info Type are tied to the flag in the file which identifies it as a additional protected record.

The article makes an attempt to demonstrate that Atelier is not just repeating the functionality of Caché Studio on a new IDE platform (Eclipse) but goes far beyond. Due to my personal experience, and challenges in former projects I picked first XSLT Debugging. Is it an ordinary task? Not at all. Who is doing XSLT every day? Probably none of us. Than why XSLT Debugging? Simply because there are solutions in our product portfolio which are using XSLT inside and those solutions require customization. Customizing XSLT without some sort of toolkit is more than challenging. The examples of such solutions starts with HealthShare IHE message, CDA vs. SDA transformations, goes through ZEN Reports, and ends by HealthShare CDA document viewer. Is that enough reason to spend time reading the whole article through not just the teaser?

Hello experts,

Good afternoon. I am a new member here and was wondering if any of you can help me with creating my own instance of Healthshare with MPI.  This will serve as a sandbox and a learning environment for me.  What is the minimum requirement to have such an environment setup, meaning will I only need to setup HSBUS, HSREGISTRY(HUB), MPI, HSACCESS, and EDGE Gateway(s)?  If so, how do I properly set them up without just installing an environment with ENSDEMO?  

I am a brank new cache developer. I am trying to create a new server, such as Samples, in the Studio and create a new namespace under the server, how do I do that?

I want do to a "simple thing". Show a dynamic log of actions in the browser as we can see on Terminal. For that, I guess to make a simple CSP Page that show a new line every WRITE command is the thing I need.  

But how I refresh after each WRITE?

How I can refresh the content automatically?

I made a simple CSP Page and in method OnPage I do this test:

Don't work... because the browser show me only after the process finish.

I guess I should use another way... any help?

How do i do the following:

Pass multiple values from one class to an excel report class using multiple tabs?

I want to request the data in the request class using a SQL statement changing values in the SQL statement, and then parse the values to the excel report to each sheet respectively.

How do I do it?

All,

Totally new to Cache and Encryption.  Have a project requirement for SHA-512.  

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.

Development productivity? Isn’t it kind of an oxymoron? Anyhow, we all dream a magic tool which does the tedious job of the software development and leave the intuitive or creative part on the developer. Atelier is the next generation tool of InterSystems aiming to boost the productivity of Caché/ Ensemble based software development. Atelier is based on the popular Eclipse IDE platform, which makes available the “infinite” pool of third party tools for Caché developers. Those tools can truly boost the productivity. This short article gives some examples how third party plug-ins can help developing for Caché. It is an absolute beginner’s guide, beginner to Eclipse but experienced to Caché.

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])

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.

If you have a lot of SQL queries to external systems (or even internal dynamic ones), you can encounter something like this:

Set SQL =    "SELECT "_
                "c.cid                        AS Id,"_
                "c.nid                        AS Nid, "_
                "FROM_UNIXTIME(c.created)     AS Created,"_
                "c.uid                        AS Uid,"_
                "IFNULL(vv.average,0)         AS AvgVote,"_
                "IFNULL(vv.amount,0)          AS VotesAmount,"_
                "body.comment_body_value      AS Text,"_
                "'comment'                    AS Type "_
            "FROM comment AS c "_
                "LEFT OUTER JOIN node ON node.nid = c.nid "_  
                "INNER JOIN field_data_field_forum_ref AS ref ON ref.entity_id = node.nid "_
                "LEFT OUTER JOIN field_data_comment_body AS body ON c.cid = body.entity_id "_
                "LEFT OUTER JOIN (SELECT entity_id , SUM(value) AS average, COUNT(1) AS amount "_
                                  "FROM votingapi_vote "_
                                  "WHERE entity_type = 'comment' "_
                                  "GROUP BY entity_id) AS vv ON vv.entity_id = c.cid "_
                ....
                + 100 more lines of SQL code omitted, but you get the idea

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?

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.

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 OR> y  = 1011 (binary) = 11 (decimal)

Thanks,

Bill

Good Morning,   All replies are appreciated.

We have a development instance of cache that was installed and the person that installed and set it up is no longer here.  We have no id's that we have the passwords for.  I have brought the database up in emergency mode and I can get access thru the terminal using my emergency id but I do not know how to add  a user/password thru the terminal.  Can someone enlighten me or point me to documentation that I haven't found yet.

As stated in title, I want to log everything I type/get in the terminal to a log file, is there a setting like this somewhere?

Preferably I'd like to enable it once and that's it.

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'

Hi,

I have a requirement to convert uname -n (Unix comamnd) with its equivalent Cache class. Can anyone help on this please

Thanks & Regards,

Sadagopan TS

Is there any alternate way to run .exe in Ensemble without using $zf command?

Hi,

I have a requirement to replace $ZF("%ZSET_DIR","/hold/rsm") to its equivalent Cache Class. The $ZF("%ZSET_DIR") sets the Current folder equivalent to "cd" command in Unix.

Can anyone help on this, please

Thanks & Regards,

Sadagopan TS

Thanks for all replies in advance.  In monitoring our audit log we are getting the error below.  We have 4 different servers running CACHE  2014.1.1 and this is happening on all 4 of them.  I have not been able to find what process is trying to logon but it is happening every 30 minutes.  We have no user processes that are running so this has to be a CACHE process.  Does anyone have an Ideal what could be running to cause this?  What kind of trace can I run to determine what process is running it?

Hi,

How to post and get data using php. I'm using a php external url. In the body in parsing the request as xml and when i execute this using fiddler it response the result as xml but when i consume it in classmethod it fails. I don't have a wsdl file how can i work it out?

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?

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)

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.