I recently had to upgrade a site from Umbraco 4.0.x to 4.5.x. Because there are numerous datatypes that are not (yet) compatible with 4.5 I spent a long time looking at the installed packages, the datatypes, and doctypes to see where those datatypes were used.
I've wanted to do this every time I've upgraded a site, and also when documenting what is custom about a particular site implementation.
As part of the standard reports, a list of datatypes and where they are used would be helpful. Especially if it flagged those datatypes that are not part of the umbraco core since they are the ones most likely to be "interesting" to people using Concierge.
As a double-check to my manual checking (I probably should have started here), I looked at the cmsDataType table, and then looked to see if any of the non-standard datatype id's were in the cmsPropertyType table.
Since not everyone has access to the database this would be a very helpful addition to Concierge's reporting.
/* return all doctypes that use a given datatype Id */
DECLARE @dataTypeId AS INT SET @dataTypeId = 1350
SELECT DISTINCT(B.alias) FROM cmsPropertyType A INNER JOIN cmsContentType B ON A.contentTypeId = B.nodeId WHERE A.dataTypeId = @dataTypeId ORDER BY alias ASC
Hendy, you're a rock star. That should work nicely. Though if it did the reverse lookup by dataTypeId to the name of the datatype -- and also the property alias(s) and docType(s) on which it is used -- would be ideal. That's why I thought it best to be part of Concierge (which I really like, just wish it were free so everyone would use it!).
Suggestion: Also list datatypes and their use
I recently had to upgrade a site from Umbraco 4.0.x to 4.5.x. Because there are numerous datatypes that are not (yet) compatible with 4.5 I spent a long time looking at the installed packages, the datatypes, and doctypes to see where those datatypes were used.
I've wanted to do this every time I've upgraded a site, and also when documenting what is custom about a particular site implementation.
As part of the standard reports, a list of datatypes and where they are used would be helpful. Especially if it flagged those datatypes that are not part of the umbraco core since they are the ones most likely to be "interesting" to people using Concierge.
As a double-check to my manual checking (I probably should have started here), I looked at the cmsDataType table, and then looked to see if any of the non-standard datatype id's were in the cmsPropertyType table.
Since not everyone has access to the database this would be a very helpful addition to Concierge's reporting.
Thanks for your consideration.
cheers,
doug.
Hi Doug,
Would this SQL snippet be of any use ?
Hendy, you're a rock star. That should work nicely. Though if it did the reverse lookup by dataTypeId to the name of the datatype -- and also the property alias(s) and docType(s) on which it is used -- would be ideal. That's why I thought it best to be part of Concierge (which I really like, just wish it were free so everyone would use it!).
cheers,
doug.
is working on a reply...