go to post Neerav Verma · Jun 4, 2019 Yes, that I was already doing in my business operation that sends the emailRead through some data. Iterate it and display a simple html in tables / rows. It worksNow requirement is to generate an excel file and then attach it to the email itself instead of displaying html table in the email
go to post Neerav Verma · Jun 4, 2019 Can you please send it to me as well nv@nv-enterprises.bizThank you in advance
go to post Neerav Verma · Jun 4, 2019 HI. I have tried this but getting this error even after giving all rights to directoryset sc = ##class(Converter.LibreOffice).convert("C:\Temp\a.csv", "C:\TempC:\InterSystems\Ensemble2018\mgr\Temp\b.xlsx", ".xlxs")ERROR #5001: Error moving 'C:\InterSystems\Ensemble2018\mgr\Temp\145158\a..xlxs1C:\TempC:\InterSystems\Ensemble2018\mgr\Temp\b.xlsx' with code: -2
go to post Neerav Verma · Jun 4, 2019 So you saying we make a static csp file that will display excel. This may be an easy solution but really hard to configure and pass params too and then attach it as an excel in email
go to post Neerav Verma · Jun 4, 2019 JAVA_HOME was not set. It was directly set into PATHNow it's running. Starting ZRExcelServer... Executing: C:\InterSystems\Ensemble2018\lib\ExcelExporter\runserver.bat -port 5005 -numthreads 5 -loglevel 3 -logfile C:\InterSystems\Ensemble2018\mgr\Temp\ -maxlogfilesize 32000 -logrotationcount 100 -numpingthreads 5 -pingport 5006 Returned from execution: CACHEPATH=C:\InterSystems\Ensemble2018\lib\ExcelExporter\..\.. LOCALCLASSPATH=;C:\InterSystems\Ensemble2018\lib\ExcelExporter\..\..\lib\ExcelExporter\excelexporter.jar jun. 04, 2019 8:30:14 A. M. com.intersys.excel.ExcelServer go INFO: Listening on port 5005 jun. 04, 2019 8:30:14 A. M. com.intersys.excel.PingServer init INFO: Ping Server Listening on port 5006 The Excel Server has been successfully started However the command still shows same error. How to route it to use the above tcp ports? J‰"Cannot contact server on port 0.
go to post Neerav Verma · Jun 1, 2019 Yes that's gone. Had never needed java before.Now new error. Which I posted too.
go to post Neerav Verma · Jun 1, 2019 HII am using example 1and getting this error X.1^1e^^^00 J‰"Cannot contact server on port 0. w ##class(Utils.XLSX).generateFileFromSQL("a.xlxs")
go to post Neerav Verma · Jun 1, 2019 I am getting this error0 ´‰AError rendering: java probably not in path, Use $LOG=1 to checkdRESTARTV:e^zcomputeDirectStatus+2^%SYS.ZENReportExcelExporter.1^14e^zCommonExport+45^%SYS.ZENReportExcelExporter.1^12e^zgenerateXLSXfromXML+11^Utils.XLSX.1^11e^zgenerateFileFromSQL+6^Utils.XLSX.1^1^^Utils.XLSX.1^01E^zgenerateXMLFromSQL+12^Utils.XLSX.1^11e^zgenerateFileFromSQL+4^Utils.XLSX.1^1e^^^0
go to post Neerav Verma · May 21, 2019 Well finally I figured it out myselfWe have to use DrawFilter and there use resultSet etc and use page property as a parameter.There seems to be no other simpler way.If anyone needs any help in ever implementing the same. Pls feel free to ping me nv@nv-enterprises.biz
go to post Neerav Verma · May 21, 2019 Well finally I figured it out myselfWe have to use DrawFilter and there use resultSet etc and use page property as a parameter.There seems to be no other simpler way.If anyone needs any help in ever implementing the same. Pls feel free to ping me nv@nv-enterprises.biz
go to post Neerav Verma · May 21, 2019 May be rephrase the question.Also Java and Cache are polls apart.
go to post Neerav Verma · May 21, 2019 Hey Vladimir,Apology for a late reply, was tied up in something else.Pls pardon me if I am wrong , from what I can tell this code and all other codes are filtering the table by state which is like saying Select * from Patient where State = 'CA' . Correct?My problem is quiet the opposite. I have picked up this snippet from your own code<column colName="City" colExpression="Home_City" width="25%" filterType="text"/><column colName="State" colExpression="Home_State" width="10%" filterType="query"filterQuery="SELECT DISTINCT Home_State FROM ZENDemo_Data.Patient ORDER BY Home_State" filterOp="="/>City needs to be "filterQuery" and query should saySelect Distinct city from Patient where State = this.stateSo basically this city filter should only show cities of the state we are working on.
go to post Neerav Verma · May 16, 2019 Zen stores data in snapshots for pagination. May be its not able to do so by a callback method.
go to post Neerav Verma · May 14, 2019 Callbacks are for Stored Procedures which are a part of Database.What I would suggest is make a minimal view in your namespace 2 and just share that with Namespace1 , if that works for you
go to post Neerav Verma · May 14, 2019 Context dies in the call thus can't be carried forward to next calls. That's why we have request / responses.Theoretically it's not possible.Context superclass is if you want to have a class with basic properties you need everywhere, like an Abstract Class
go to post Neerav Verma · May 14, 2019 Share globals and packages across Namespaces. Thats the only way
go to post Neerav Verma · May 14, 2019 <column colName="State" colExpression="Home_State" width="10%" filterType="query"filterQuery="SELECT DISTINCT Home_State FROM ZENDemo_Data.Patient ORDER BY Home_State" filterOp="="/>Just in this we need to add a where clause which takes a page property which is not working<column colName="City" colExpression="Home_City" width="10%" filterType="query"filterQuery="SELECT DISTINCT Home_City FROM ZENDemo_Data.Patient Where Home_State = #(%page.State)# ORDER BY Home_City" filterOp="="/>
go to post Neerav Verma · May 13, 2019 Thank You VladimirHowever the problem is in FilterQuery param not the table. Table params are working fine.
go to post Neerav Verma · Apr 25, 2019 If you have team viewer,I can take a look at your code and resolve it.
