Posted by LarsKramer on August 14, 2011 at 12:37pm
7 followers
Jump to:
| Project: | Project |
| Version: | 6.x-1.x-dev |
| Component: | Usage statistics |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
On Project usage overview it would be nice being able to see most installed projects on Drupal 7, if possible. Many contributed projects are no longer relevant for Drupal 7 because they are now in core.
If this is possible , the ranking should ideally be based on D7 installations, not the total number of installations. On the Module page, if you filter by Drupal 7, and sort by most installed, it counts the total number of installations (including D6 and before).
Comments
#1
+1 this page can not be used to find the best and greatest anymore, and better modules tend to be overlooked by older more popular ones. There are about 11 modules in the top 25 that I personally would not use in D7 or are only for D6 or less.
#2
2nd half of the original report (about the project browsing/search pages) is duplicate with #377736: Module filter or sort by release should impact what information is displayed.
However, yes, it'd be nice to be able to filter the usage overview page by version. Moving to a more appropriate queue for where this code lives to actually implement the change. We already have the data separated by version in the {project_usage_week_project} table, so it's mostly just a UI and caching question to get this done. The code lives in project/usage/project_usage/includes/pages.inc in the project_usage_overview() function. It's pretty evil code, generating an insane query that lets you table sort by any week. Currently it's also doing some nasty
SUM(DISTINCT p{$i}.count) AS week{$i}stuff to get the total across all versions. So, if you *did* filter by a version of core (stored as {project_usage_week_project}.tid) it'd actually simplify the query tremendously.Maybe we could filter by a specific version by default, but retain the option to show totals across "all versions" or something in case people really want that.
Cheers,
-Derek
#3
I would be very happy with just a singular version per page and that sounds like it follows the KISS principle, but other users would (maybe) still prefer being able to see the combined results? Is there an easy way to poll users before starting work on this issue?
#4
Personally, I would find a separate page per major core version to be completely acceptable, and much better than the current combined page. I have no objections to a combined page if people want that, but I can't think of a time when that was ever the information that I wanted. Considering we already have the combined page, I'm not clear what is gained by removing it, but a huge +1 to providing per-major-core-release pages.
#5
Marked #1297804: Project usage: Option to display overall module usage statistics by Drupal version a duplicate, and replied to http://drupal.org/node/329620#comment-4623900. If anyone finds any other duplicate issues or places asking about this, please link them to here. Let's get some eyes on this.
#6
Here's the query I ran manually from the d.o database, slightly cut down from the full 3-week comparison query that project_usage_overview() runs:
SELECTn.nid,
n.title,
pp.uri,
SUM(DISTINCT p0.count) AS week0
FROM node n
INNER JOIN project_projects pp ON n.nid = pp.nid
LEFT JOIN project_usage_week_project p0 ON n.nid = p0.nid
WHERE
n.nid IN (SELECT nid FROM project_usage_week_project)
AND n.status = 1
AND tid = 103 /* This is new; 103 for Drupal 7; Drupal 6 is 87 */
GROUP BY n.nid, n.title
ORDER BY week0 DESC;
Here are the results, as CSV.
It'd indeed be nice if we could find this information out whenever we wanted, since the delta between the two is quite significant. Hope that query helps someone who has time to make that happen. :)
#7
Hm. D.o's file upload doesn't seem to be working. Let's try this:
D7: http://dl.dropbox.com/u/10160/d7-top-modules.txt
D6: http://dl.dropbox.com/u/10160/d6-top-modules.txt