Welcome, Guest
Username: Password: Remember me

TOPIC: Listing Templates in use

Listing Templates in use 7 months 2 weeks ago #106052

  • macanics
  • macanics's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 10
  • Karma: 0
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---
The administrator has disabled public write access.

Listing Templates in use 7 months 2 weeks ago #106056

  • amit
  • amit's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
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
The administrator has disabled public write access.

Listing Templates in use 7 months 2 weeks ago #106065

  • tpartner
  • tpartner's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 4272
  • Thank you received: 806
  • Karma: 369
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.

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
Last Edit: 7 months 2 weeks ago by tpartner.
The administrator has disabled public write access.

Listing Templates in use 7 months 2 weeks ago #106069

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: 7 months 2 weeks ago by fransmarcelissen.
The administrator has disabled public write access.
The following user(s) said Thank You: DenisChenu
Moderators: ITEd
Time to create page: 0.116 seconds
Donation Image