That worked Dmitry! Thank you very much!

-Roberto

Thank you! I have given this recommendation to my team. It makes sense to go this route instead of changing the $ZSTORAGE on the fly.

Hello Vic. I'm more on the development end (SQL / Stored Procedure / Web Services / Zen) and not sure why we have it set to 16,384. I will have to ask the people on my team as to why this was the number that was set. But it could be what we have had previously and we just retained this number through our various upgrades.

I will do more research with POI. It looks like something we could use here at work. But for now, I figured out how to use %Activate with Excel to do what we need to do.

Thanks for your help Eduard!

We have used this method in LibreOffice to convert but it ignores some of the formatting (cell colors, etc) that we have in the Excel XML.

Thanks! I'll go to the Apache page and read up on this.

Do you know if this java library will be able to read an Excel XML file and convert to Excel XLSX file while retaining all of the formatting that we created in the Excel XML file?

No, we are not trying to consume data from Excel. We created an Excel file with one of our routines. It is a nicely formatted Excel file in Excel XML format. We have a group that is requesting that we send that data over in XLSX format. We have figured out a way to use Excel COM operations through Powershell to get this to work. We would like to figure out how to do this in Cache using the Activate classes. There's not that much documentation out there on how to do this.

Hello Evgeny, yes we use those methods in that link already for exporting and importing roles.

What's happening is that the resources / tables that were in the destination server that should not be there anymore is still there. It looks like it is only copying what we exported from the source server. It is not making the role the same.

We figured out how to remove the resources using the Security.Roles.Modify() method by setting the Properties("Resources") parameter. But how would we do something similar to the tables which should not be there anymore in the destination server?

Hi, it's still not clear. Do I have to define both a GET and  POST for the same Route?

Is that what I'm missing?

How do I allow a method then with %CSP.REST?

Here is what I'm trying right now just to  check if the POST code is working or making it to the method.

The Route:

The Method:

ClassMethod Test1() As %Status
{
Set tSC=$$$OK
W "test...",!
Quit tSC
}
 

This GET works:

I would just like the option of changing it in a function.

I see, it was meant to be used in the QA environment.

I am using it in our DEV environment, testing bits of functions as I complete them.

Thank you.

Oh great! Thank you!

Why is it deleted as a default?

The problem is that it is generating the correct PDF. I am puzzled.

This works:

//68000 is the correct render server port

Set st=obj.GenerateReport(filename,2,0,68000)

This works too:

Set st=obj.GenerateReport(filename,2,0,"ABCDEFG")

Hi Nicole,

I will check those resources out.

We will not generally be working with different projects. We will usually be working with the same project and making modifications to them like adding a new routine to an existing MAC, adding a button to a Zen page, etc.

We have been testing our process using git with Studio, but now it looks like we are going to use Atelier.

We have a server repository (in Bitbucket) that currently contains XML copies of our MACs and CLSs files. We create a branch from there and pull it down locally to our own personal environment (local Cache instance).

When working with our current task (modifications, new functionalites, etc), we import the needed files into our Cache instance and make our changes. We made hooks to export to XML the files we are working with when we compile.

When done, we commit these changes locally and then push them back to the server (Bitbucket).

What changes now with Atelier besides the files being saved automatically in UDL format when compiling?

Hi Fabian,

We are not familiar with Atelier yet at this point, so we are currently using the tools we have for our workflow.

Our company uses Bitbucket for the server repository and SourceTree for the client side of git.

Let me do research on Egit and see how that fits into all of this.

Thank you.

Thanks Eduard for your help. We will be contacting WRC then.

I'm going to test this (SetConnectionLimit).

Will this affect our own internal tasks?

If our Cache service account is running our daily tasks and we set this connection limit to let's say 5, will some tasks fail then?

The argument/discussion now with our team is that if developers have local files (macs) that they personally use only for themselves then we don't want those deleted. 

We are thinking of having a convention where if we have these macs that begin with "z" (zTest.mac, zDataFeedABC.mac, etc) then we will leave those alone both in git and in Cache.

Thank you! I was able to check the documentation on %Routine and was able to get it to work.

Hi John,

We are committed to git because our company's other developer group is on git and have been using it for a while. I've heard about the George James Software package and heard good things about it for Cache.

Edward, I've been talking about the solution that you proposed to my team members about marking the class or mac as DEPRECATED.

We are looking now in the documentation on how to programmatically  do this. I think we found the Cache class to open a class and mark it as DEPRECATED.

We can't find a way to open  mac file and mark it with a comment like you mentioned.

Would you know how to programmatically do this or should we call WRC?

Thank you for your help.