Topics created by MolallaComm

Thank you, I've updated the steps based on your suggestion and tested it on RHEL 8/9
https://jsreport.net/learn/red-hat

Thank you - seems to work well and was easy!

Thanks for the example and reply. Turns out, we were still using 3.6.2 and while it had the component feature in the UI, i think it was maybe buggy. As soon as I updated to 3.11.3, passing parameters works as documented. Posting this just in case anyone else runs into it. Should have known to upgrade to latest before trying a new feature!

Actually i jumped the gun here in blaming it on jsreport. I turned the old server on and compared the results of:

https://oldserver:5489/odata/templates('WREPnPpjt5FaVlAu')

vs

https://newserver:5489/odata/templates('WREPnPpjt5FaVlAu')

and the old one is also malformed. Both return something like:

{ "0": { "shortid": "Ssh0qJ_M1t", "name": "Multiple Data Sources to XLSX", "recipe": "html-to-xlsx", "engine": "handlebars", "chrome": { "printBackground": true }, "htmlToXlsx": { "htmlEngine": "chrome" }, "creationDate": "2021-02-12T22:16:32.865Z", "modificationDate": "2022-03-21T21:02:06.922Z", "_id": "WREPnPpjt5FaVlAu", "data": { "shortid": "alzfT9oXW" }, "scripts": [ { "shortid": "YV1W9PMikJ" } ], "content": "...", "helpers": "...", "folder": { "shortid": "sYpZKHs" } }, "@odata.context": "https://192.168.7.198:5489/odata/$metadata#templates/$entity", "value": [ { "shortid": "Ssh0qJ_M1t", "name": "Multiple Data Sources to XLSX", "recipe": "html-to-xlsx", "engine": "handlebars", "chrome": { "printBackground": true }, "htmlToXlsx": { "htmlEngine": "chrome" }, "creationDate": "2021-02-12T22:16:32.865Z", "modificationDate": "2022-03-21T21:02:06.922Z", "_id": "WREPnPpjt5FaVlAu", "data": { "shortid": "alzfT9oXW" }, "scripts": [ { "shortid": "YV1W9PMikJ" } ], "content": "...", "helpers": "...", "folder": { "shortid": "sYpZKHs" } } ] }

I believe the corrrect odata response for a "by key" URL would be just:

{ "@odata.context": "https://192.168.7.198:5489/odata/$metadata#templates/$entity", "shortid": "Ssh0qJ_M1t", "name": "Multiple Data Sources to XLSX", "recipe": "html-to-xlsx", "engine": "handlebars", "chrome": { "printBackground": true }, "htmlToXlsx": { "htmlEngine": "chrome" }, "creationDate": "2021-02-12T22:16:32.865Z", "modificationDate": "2022-03-21T21:02:06.922Z", "_id": "WREPnPpjt5FaVlAu", "data": { "shortid": "alzfT9oXW" }, "scripts": [ { "shortid": "YV1W9PMikJ" } ], "content": "...", "helpers": "...", "folder": { "shortid": "sYpZKHs" } }

Turns out we also upgraded our server code from .net 3.1 to .net 6 and switched from newtonsoft the the microsoft json stuff, and something with that is causing the problem which i will track down. Sorry for the false alarm in my first post.

At some point it would be nice if jsreport returned valid odata responses for "by key" type queries but we can work around it for now.

Can you use folders?

Yes, you can, with "allowLocalFilesAccess:true" in the config. It will create the full path you specify.

Relatedly, is this scalable - are there people actually storing/serving a lot of files using this method?

It should be, let us know if you experience problems.
However, you should consider using a full database instead of the file system for such data volume
https://jsreport.net/learn/template-stores

I have a bunch of legacy PDFs that were created by the system we used before jsreport, but i will still need to have somewhere and serve up for a period. Could i import them in using the odata api maybe or do i just copy the files over into the storage folder and jsreport will automatically pick them up - the documentation is kinda thin on this?

The report consists of Report entity and blob. You can create a Report entity using OData POST and create the respective file representing the blob.

This is how the Report entity looks like

{ "name": "main", "creationDate": "2021-10-16T15:34:48.360Z", "modificationDate": "2021-10-16T15:34:48.377Z", "shortid": "ZAXTmgE", "_id": "mzwMGlnxAFwlICPv", "recipe": "docx", "fileExtension": "docx", "templateShortid": "I2t_EIx7A", "contentType": "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "public": false, "blobName": "folder1/folder2/myfilename.docx", "state": "success" }

You could POST such json to OData to create Reports, and then create files in blobName path representing the blobs,

In addition or in lieu of the current config file cleanup mechanism, it might be nice to come at it from the other way via the API

Thank you for the idea. I submitted the request to the backlog, you can subscribe here
https://github.com/jsreport/jsreport/issues/825

Do you have to do anything special to get emojis to work when using the html-to-xlsx recipe?

i will take a look, i see it fails because some validation we do about legal xml chars, will need to verify why we do that, probably it has to do with the support of such chars in xlsx generation.

subscribe here for updates about when this is fixed

FWIW, a better workaround I think is just to switch the CA that acme.sh or whatever you ACME client may be uses - everybody is getting in on the free certificate game now:

https://github.com/acmesh-official/acme.sh/wiki/ZeroSSL.com-CA

That fixed it for me.

thank you!

I just submitted a pull request that has the fixes to both update this module to 2.9 and fix the tiny problem that was causing nodegit to core dump.

Thank you very much. Its merged.

Also, following your on-prem guide for Ubuntu 20.04, in addition to what was there, i had to manually do:

Perfect, thank you. I pushed a commit with docs update.

Thanks - that worked!

Thank you for your suggestions.

Could somebody update the jsreport-version-control-git module to use nodegit@0.24.0 instead of 0.23.0

Yes, we will do it. But don't hesitate to send us a PR the next time.

One thing I would like to see if it isn't too hard to add would be an option in the config to allow specifying a remote

Good idea. We will consider it.

one other tiny nitpick on the module - the web gui is showing the ".git" repo folder as a normal folder

Yes we will ignore this folder in fs store.

one thing to note too is that it appears that the data/settings file gets changed each time you run a report - could it possibly be added to a .gitignore by default during install?

We will consider it.

Thanks for following up on this - sure enough using plain old object fixed it! I think i used map originally just to see if newer ES5/6 stuff worked which i guess it does minus this serialization issue.

Thanks for feedback. I will add to the post also debugger keyword. Lets see what others will experience....

FWIW - I figured it out - at first I tried "http" and "[http]" for AllowedModules - but that didn't work for some reason, but * does work - the example should be something like this

You can also use .Configure(cfg =>cfg.AllowLocalFilesAccess()) instead. You can see here it does the same.

FWIW - I also think you should change it so the jsreport folder gets created in the project folder instead of in the bin folder - then it would be easy to keep everything in version control as well as in your database.

Thank you for recommendation.I will give it again some thoughts. For now I consider running jsreport studio and web server through jsreport.Local as advanced scenario which requires some additional configuration. Like you have done.