Attached is a configurable python script which creates/updates Kindle collections based on the data in Calibre. Simplest way to use it is:
0) Download and install Python 2.6 or 2.7 on your computer. Then extract the script from the attached zipfile and copy the .py file to the root of your kindle
1) Set up your tags/series/author metadata in Calbire as normal. Any tags which you want to become kindle collections should start with a dash (-) character
2) Set Calibre's "metadata management" setting to "automatic management" in Preferences->Send books to device
3) Attach your kindle and allow calibre to send its metadata to it
4) Run the script (with Python installed, you can run it, in Windows, just by double-clicking on the copy of the script in your Kindle drive's root folder)
5) Restart your kindle once it's finished (using Home->Menu->Settings->Menu->Restart)
Once it's restarted, the kindle will take a few minutes (depending on how many books/collections are on it) to sort out what goes where but once it's done all your new collections should be created and populated.
There are a lot of possible configuration options in the script, which are detailed in the enormous comment at the start of the .py file itself (you can open it in notepad to read it), which can limit the number of collections created.
For example, by default an Author will only have his/her own collection created if he has at least 4 books on your kindle, but values like those can be changed and the comments in the script explain what can be changed and how.
Note on the thread:
This topic has been discussed in several other threads (and other websites), most notably http://www.mobileread.com/forums/sho...06#post1253906
but I thought it should be made a bit more visible, hence this thread.
The attached script is based on various people's prior work, so thanks muchly to them. And apologies to Python developers for the probably poor quality of the code but I've never written anything in Python before (so if you want somebody to turn this into a Calibre plugin don't look at me).