On a previous CMS I used to develop on, you could obtain a list of the pages that have been created from a specific template. It is possible to get this type of info from Umbraco/Umbraco package? Always found this useful for site audits, as you could see how the client was using the templates. And offer ways to improve or update a template that had little or no use.
Concierge (part of the Pro offering) has a similar report that shows all DocTypes, their properties, what Content (pages) are using them, and what Templates are allowed on each.
Not aware of any way to do this in the free version, short of writing some database queries.
Most clients are using the free version, so I think I'll go down the SQL approach with a custom section (Dimitris thanks for the reference to the article, very useful), which I can then (hopefully) use on all projects.
Number on pages created from a template
Hi Guys
On a previous CMS I used to develop on, you could obtain a list of the pages that have been created from a specific template. It is possible to get this type of info from Umbraco/Umbraco package? Always found this useful for site audits, as you could see how the client was using the templates. And offer ways to improve or update a template that had little or no use.
Thanks
Eddie
Concierge (part of the Pro offering) has a similar report that shows all DocTypes, their properties, what Content (pages) are using them, and what Templates are allowed on each.
Not aware of any way to do this in the free version, short of writing some database queries.
-Tom
If you have db access you can use sql
You can find the template id, by placing your mouse over the template node on the umbraco templates tree.
The id is the parameter of a javascript command. Look at your browsers status bar.
If you need to visualize your results or just need something reusable you can create a custom section. There's a great article here.
One thing to note is that content isn't created from a template, rather you apply a template to a given piece of content.
The following snippet of XSL will accomplish the same as the above mentioned SQL:
That said, it sounds like Concierge will meet your auditing needs.
Hi Eddie
If you want to get an overview of the the use of all your templates you can use the following SQL.
SELECT templateId,
COUNT(nodeId)
FROM [dbo].[cmsDocument]
where published = '1'
group by templateId
This will get you the count of every templateId in use on published nodes in a list so you get an overview of the usage :)
You can easily extend this query if you would rather want the template aliases.
I hope this helps.
Kim :)
Hi All
Thanks for al the great replies.
Most clients are using the free version, so I think I'll go down the SQL approach with a custom section (Dimitris thanks for the reference to the article, very useful), which I can then (hopefully) use on all projects.
Thanks again
Eddie
is working on a reply...