A lovely and very enriching discussion

Am I reading it wrong? Dont see port number anywhre

• 2 - Namespace name. For example, %SYS>. The current namespace name is contained in the $NAMESPACE special variable. It can be an explicit namespace name or an implied namespace name.

• 3 - Config name. The name of your system installation. For example, IRIS2>. This is the same for all of your terminal processes

Json parsers are parsing it. 

However I haven't tried to run it by code to see if it works.  

No, it is JSON . Just one simple missing bracket. Here is the correct json for the same

{
error:[
{ txt1:'error msg1'},
{ txt2:'error msg2'},
],
error2:[
{ txt1:'error msg1'},
{ txt2:'error msg2'},
]
}

Also disable win firewall once you do resolve licence issue

Link you have given and the json you have pasted are totally different

If you can put the right json or point to the right rest, should be able to help you out

JSONStreamToObect should do it.

If you can just paste the exact json, I can write it for you. No biggy

You can use this site to verify if json is correct

http://jsonviewer.stack.hu/

Really nice guys. 

I do not have a use for it now, but definitely a really good one

Can you please send it to me as well nv@nv-enterprises.biz

Thank you in advance

HI. I have tried this but getting this error even after giving all rights to directory

set 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

JAVA_HOME was not set. It was directly set into PATH

Now 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.  

How to start that? 

Just installing java not enough? 

Yes that's gone.  Had never needed java before.

Now new error.  Which I posted too. 

HI

I am using example 1

and getting this error 

X.1^1e^^^0
0 J‰"Cannot contact server on port 0.  

w ##class(Utils.XLSX).generateFileFromSQL("a.xlxs") 

I am getting this error

0 ´‰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

May be rephrase the question.

Also Java and Cache are polls apart.  

Zen stores data in snapshots for pagination. May be its not able to do so by a callback method.

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

If you have team viewer,I can take a look at your code and resolve it.