Check out the LimeSurvey source code on GitHub!

Listing Templates in use

More
2 years 11 months ago #106052 by macanics
Is there a method for listing all templates that are in use - i.e. selected for any survey? I'm looking for a way to cull our unused custom templates.

---john---

Please Log in to join the conversation.

More
2 years 11 months ago #106056 by amit01
Hi
I have not yet come across with such a method present in current version of LimeSurvey. I guess you will have to write it manually , if you actually need it.

--
cheers
amit

Please Log in to join the conversation.

More
2 years 11 months ago - 2 years 11 months ago #106065 by tpartner
Sorry, no, you'll have to do it the painful way ;)

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Last Edit: 2 years 11 months ago by tpartner.

Please Log in to join the conversation.

More
2 years 11 months ago - 2 years 11 months ago #106069 by fransmarcelissen
The following solution is not painful if you understand a tiny bit of mysql:
Run the following sql statement in phpmyadmin, R or php

select folder,count(s.template) from
(SELECT * FROM `lime_templates` left join lime_surveys on folder=template
union
select * from lime_templates right join lime_surveys on folder=template ) as s
group by s.folder

This leads to a list of templates and the number of surveys that uses this template:
basic 0
bluengrey 0
citronade 1
clear_logo 0
default 2
DigiPsy 10
..
..

(I am not very good in sql, probably this can be done in a simpler way, but this works)
Frans
Last Edit: 2 years 11 months ago by fransmarcelissen.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form