Cloudron Forum

Thank you, @nebulon!!!

I believe I am one step closer to what I need. If I manage to locate the LimeSurvey config.php, I will know dblocation, dbname, dbuser and dbpwd. It should be easy from there.

In self-hosted LimeSurvey environments, it seems to be located here:
[limesurvey_installation]/application/config/config.php.

The question now is where is the LimeSurvey config.php stored on Cloudron?

Unfortunately, config.json does not seem to provide the answer.

Hello everyone,

I would be super grateful if someone could help me set up an importxml connection from Google Sheets to Limesurvey.

More specifically, this is what I would like to achieve:

---

I personally use to read directly ( using "IMPORTXML" function) some data collected with LS in a GG spreadsheet. Its very easy; No required use neither of LS nor GG APIs. Note that new survey responses are not exactly transmited in real-time, because there is usually a 15 to 30 minutes delay with the spreadsheet update, but it's ok .

Some interessant features are:

• updated reports without LS admin login (for people who know the url)
• very large library of powerful functions, well documented for calculation, charts, terrific mailing, etc.
• possibility to build reports merging several surveys
  (https://forums.limesurvey.org/forum/can-i-do-this-with-limesurvey/103747-experiences-using-ls-with-google-drive-spreadsheets#132260)

---

I am trying to follow this manual.

I suppose this is what I need to do:

1. Create the php.file:

Is the dblocation https://mylimesurveysite.com/admin/index.php?
What is the dbname?
dbuser and dbpwd are the LimeSurvey user credentials?
(No questions about sid :-)).

2. Save it at http://mylimesurveysite.com/test.php
   Here is where I run into difficulties since we run LS on Cloudron.

3. Paste the following formula in Google Sheets:
   =IMPORTXML("http://mylimesurveysite.com/test.php?refresh=&GoogleClock()", "//mytaglabel")

Can you help me figure out how to use it?
It would be awesome to get it to work.

Thanks!

Since we are not in a particular hurry and Cloudron is just super comfortable to use, I guess we'll wait and see.

@scooke
The quote is from @andirahmat.

I represent a non-profit. We would like to start our own journal to quickly publish results from (our) European education projects.

Is this the dockerfile you mentioned?
https://github.com/marcbria/docker-pkp/blob/main/Dockerfile

Hello!

I believe the Cloudron documentation may be outdated:

Bitwarden now supports SSO: https://bitwarden.com/help/about-sso/

Can we expect SSO to be added to Vaultwarden?

It would be absolutely amazing to have publishing software from the Public Knowledge Project (PKP) on Cloudron:

• OJS: Open Journal Systems
• OPS: Open Preprint Systems
• OMP: Open Monograph Press

There are now docker images available for OJS and OMP:
https://forum.pkp.sfu.ca/t/docker-images-for-ojs-and-omp/83312

• https://github.com/pkp/docker-ojs/

I believe docker images would make packaging for Cloudron easier?

@girish Any chance we'll see OJS etc. on Cloudron in the future?

Hi,

I’m unsure if this issue is caused by the app itself or the Cloudron packaging.

We need the ability to set custom links for our privacy policy and terms. Currently, even after configuring the custom variables as instructed, the links still redirect to cal.com.

And mine are still there.

YEAH!!!!!!!

Thank you SO SO SO much, @girish.

Fun fact: the order of the menu buttons changed (for lack of a better word, it is also the word used in the kimai documentation) from CSV / Excel / Print / PDF to CSV / Excel / PDF / Print.

But there is now a fifth template in the PDF dropdown and it has the file name as a name.
Again, thank you so much!!!

Updating now.
Just to be sure: I delete the path I added to local.yaml, correct?

I also tried.

• 'app/data/export/'
• '/data/export/'
  I reloaded the cache every time. The additional templates do not appear.

What I don't understand is how Kimai should know what to call the additional template in the dropdown menu.
This is why I think it it's necessary to also modify the export-en.xlf.

Edit: I suppose it will get an id once it is located and the translation file would translate the ID into whatever "resname" you select. So I should expect to see an ID in the dropdown.

I tried documents first, then defaults.

Copying the default files into the folder did not work.

Thanks, @joseph.
Could you please check my reply here: https://forum.cloudron.io/topic/12943/add-custom-export-templates-where-to-create-the-folder-export-and-how-to-modify-export-en-xlf/2

I don't want to add invoice templates but export templates. They need to be in a different folder. I can't get Kimai to show them.

Hi @joseph,

Thank you for your reply in the other thread on invoice templates, but I am trying to add export templates, not invoice templates.

They need to be in a directory called "export": https://www.kimai.org/documentation/export.html

So I tried adding to local.yaml

kimai:
    export:    
                documents:    
                        - '/app/data/export/'

Unfortunately,my templates are not added to the dropdown menu.

When I try to change documents to "templates", I get the following error message when I try to rebuild the cache:

ERROR] Unrecognized option "template" under "kimai.export". Available options are "defaults", "documents".      

When I use "defaults", the default templates disappear from the menu.

kimai:
    export:    
               defaults:    
                        - '/app/data/export/'

So I guess I could try to copy the defaults into the folder and point to defaults.

@girish said in Templates:

@subven Fair enough. If other people stumble on this, maybe we can make a default directory for templates.

I looks like I stumbled upon it as well. Would it be possible to make a default directory for (in my case export) templates?

I am trying to add custom templates to our Kimai installation.

I tried to follow the Kimai documentation and adapt it to the Cloudron installation.

• I copied, renamed and adapted one of the default templates.

• I created a folder in "data" called "export".
  Since in Cloudron plugins are installed in /data/plugins rather than in var/plugins, I thought it might work.

• Similarly, I created a folder "translations" and added a copy of export.en.xlf that included my custom template.

• I reloaded the kimai cache and restarted the app.

bin/console kimai:reload --env=prod

Unfortunately, my template is not shown in the export window.

I suppose that adding a folder "export" to "data" does not work. With regard to invoice templates, @girish suggested that you can perhaps add a default directory for templates.

Maybe configuring the directory data/export through the config key kimai.export.documents in local.yaml could do the trick as suggested in the Kimai documentation, but I don't know how to do that.

And I am not sure how to modify the export.en.xlf either.

Any help would be much appreciated.