go to post Roberto Cahanap · Jan 31, 2020 Hello Dmitry, is there any instructions out there on how to connect VSCode with Cache. I downloaded the extension and followed the instructions on how to configure but I am not clear on how to actually get it to work. Thank you for your reply.
go to post Roberto Cahanap · Nov 22, 2019 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.
go to post Roberto Cahanap · Nov 22, 2019 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.
go to post Roberto Cahanap · Oct 9, 2019 As per Eduard, this is how we were able to use %Activate with Excel. 1. Go to the Activate wizard and look for the Excel object. In our case it was Microsoft Excel 16.0 object library. This will create the appropriate package/classes. 2. In our case, the functionality we needed was the Save As function of Excel. Through the Microsoft documentation and also trial and error: Set SourceFile="location of file" Set DestFile="location of file" Set App=##class(Activate.Excel.Application).%New() //this will create an Excel application object Set Workbooks=App.Workbooks.Open(SourceFile) //bring that Excel file into memory Set XLSXFormat=51 //the format that we need, found some docs //here: https://www.rondebruin.nl/win/s5/win001.htm DO Workbooks.SaveAs(DestFile,XLSXFormat) DO Workbooks.Close() Understanding the structure of this package now, it looks like we can explore more with other features/functions of Excel.
go to post Roberto Cahanap · Oct 8, 2019 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!
go to post Roberto Cahanap · Oct 7, 2019 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.
go to post Roberto Cahanap · Oct 7, 2019 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?
go to post Roberto Cahanap · Oct 7, 2019 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.
go to post Roberto Cahanap · Apr 18, 2019 Yes, I have Visual Studio Code installed and installed also the new Serenji 3.0.2. I can't figure out a way to connect to a Cache server. Let me check that link you posted.
go to post Roberto Cahanap · Apr 18, 2019 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?
go to post Roberto Cahanap · Apr 18, 2019 Is there documentation on how we can connect Visual Studio Code + Serenji with Cache?
go to post Roberto Cahanap · Mar 6, 2019 Hello Mike, yes we have figured out how to implement unit testing in Cache. It's an excellent way to test all cases. But for the type of current work we are doing (reporting), it might be too much work. Once you get the hang of it, it's a pretty simple process. It's up to you to cover all of the test cases. If you need help, you can just post your question here. There are a lot of Cache experts in this community that can help.
go to post Roberto Cahanap · Sep 14, 2018 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?
go to post Roberto Cahanap · Sep 14, 2018 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: <Route Url="/test1" Method="POST" Call="Test1"/>The Method:ClassMethod Test1() As %Status{Set tSC=$$$OKW "test...",!Quit tSC} This GET works: <Route Url="/status/:ClientID" Method="GET" Call="GetActiveStatus"/>
go to post Roberto Cahanap · Aug 16, 2018 Hi, what issues are you having with ODBC? We have a lot of clients connecting to our Cache DB through ODBC.
go to post Roberto Cahanap · Aug 16, 2018 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.
