- Posts: 9
- Thank you received: 0
Listing Templates in use
4 years 1 month ago #106052
by macanics
macanics created the topic: Listing Templates in use
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---
---john---
Please Log in or Create an account to join the conversation.
4 years 1 month ago #106056
by amit01
amit01 replied the topic: Listing Templates in use
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
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 or Create an account to join the conversation.
Less
More
- Posts: 6738
- Karma: 601
- Thank you received: 1807
4 years 1 month ago - 4 years 1 month ago #106065
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
tpartner replied the topic: Listing Templates in use
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: 4 years 1 month ago by tpartner.
Please Log in or Create an account to join the conversation.
- fransmarcelissen
-
- Offline
- Gold Lime
-
Less
More
- Posts: 204
- Karma: 13
- Thank you received: 52
4 years 1 month ago - 4 years 1 month ago #106069
by fransmarcelissen
fransmarcelissen replied the topic: Listing Templates in use
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
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: 4 years 1 month ago by fransmarcelissen.
The following user(s) said Thank You: DenisChenu
Please Log in or Create an account to join the conversation.