Spreadsheet of Drupal 4.6 modules and their terms in categories

I'm working on filling this out and making good headway. I'll post my updated copy when I'm done.

Here is the spreadsheet updated with all modules categorized. Some modules seem to fit well in more than one category, and some don't seem to fit in any, but they have all been put somewhere. I added a new category called Content Links, which are modules which display or provide links to some other page, since there seemed to be a lot of those kind of modules. I also indicated whether an item in the list was a module, a theme, a theme engine or a translation. Another thing that I did was to go through the lists that are on drupal.org and add any items that were not in the spreadsheet (some don't have node numbers listed), and note any in the spreadsheet that I did not see on the project pages. Hopefully this will be of use.

Great work guys!

I just started writing a parser so I can turn this document into a number of SQL queries.

Some projects do not seem to have node IDs:

no nid in ':: Sanity:Administration::Module:' ...
no nid in ':: Portuguese (Brasil) Translation:::Translation:' ...
no nid in ':: Playlist Module (Favorite Nodes):Media::Module:' ...
no nid in ':: Galician Translation:::Translation:' ...

I found there are 3 categories with the term 'content':

Content
Content Links
Content display

Maybe 'link management' is better than 'content links'?
What is the difference between 'content' and 'content display'?

I parsed the file and plotted an overview showing all the categories along with the number of projects in each of the categories.

Two more questions:

1. What is the 'Term' category? There is only one project in it (as can be seen on the attached graph). Maybe a small bug in the spreadsheet?
2. Is the 'Theme' category necessary?

Okay, I'll try to reply to all the questions at once. :^)

One other thing I forgot to mention is that all the names have leading and trailing spaces. I did not attempt to remove any, but I also did not attempt to add any trailing spaces on the items that I added. It may be a consideration when doing the parsing/importing, which is why I brought it up.

Missing node IDs: I know about that, but I didn't know where to get them. Those items w/o nids had names (path aliases) in the URLs. I left that up to Amazon, since he has more access to drupal.org than I do.

Also, the "Portuguese (Brasil) Translation" item is a duplicate of the "Brazilian Portuguese Translation" item. I added the one w/o the NID, based on the Translation project page, and then noticed the duplication later, but forgot to correct it.

Duplicate Content Terms: Items termed "Content" are modules that deal with the content itself, either adding, modifying or removing. Items termed "Content display" are modules that deal with how the content is presented to the user. I think "Link Management" is a better name for "Content Links". I couldn't come up with anything better last night, and just went with that term.

The Term item is probably a column header, and not an actual category, since I don't see it in the list I have.

I agree that "Content display" and "Theme" should probably be merged into something a little more generic, like "Display" or "UI" or something similar.

Thanks for the explanation. I'll keep preparing the parser/upgrade scripts but will make sure to grab a new copy of the spreadsheet later on.

I finished the parser and tested it on scratch.drupal.org with the latest spreadsheet taken from http://drupal.org/node/50091. You can see the result at http://scratch.drupal.org/project/Modules. (Whenever the spreadsheet is updated, I'll do a fresh import.)

Please take some time to test it out. If you have suggestions for user interface improvements, please post these to the project module's issue tracker (http://drupal.org/project/project).

Updated spreadsheet fixing miscategorized modules:

Admin
http://scratch.drupal.org/project/Modules/category/51?page=1
Diff -> Content display
Feedback ->: Mail
Google Sitemap -> 3rd party integration
Trackback -> 3rd party integration

Commercial advertising should be renamed 'Commerce / Advertising', it contains Ecommerce / paypal modules
Checkout -> Utility
Wishlist -> content

Community:
CiviCRM -> 3rd party integration

Content:
CitizenSpeak -> Community (or maybe mail?)
Disknode ->: File management
Family -> 3rd party integration
Port Stemmer ->: Utility
SQL Search -> Utility
Voting API -> evaluation / rating

Content display
stockapi -> 3rd party integration
Tagadelic -> categories

Eval / rating
Source Forge -> 3rd party integration

Events
Where is the 'sign up module' ?

Files:
http://scratch.drupal.org/project/Modules/category/60
Asterisks -> 3rd party integration imo

Editors
E-Journal -> content display
E-Publish -> content display

Utility
Chatbox -> community
L:atest and greatest -> Eval / ratings
Legal -> security?
Node list -> content display
Paging -> content display
Print friendly page -> content display
quicktags -> filter / editors
Swish e indexer -> 3rd party integration

terms have been applied