Interesting project!
1. I've mostly worked at history museums, though my last job was at a combined history/art museum, and am now at a living history museum with a substantial gallery collection.
2. Currently using CatalogIt, but I've also used PastPerfect (non-browser version), TMS (non-browser version), and SKINsoft.
3. Like most institutions, we use it to catalogue objects, search for them, and host them online.
4-6. CatalogIt is browser-based, and you're able to open multiple tabs and use them independently, which is a huge help to e.g. copying info from one record to another. The one upside of SKINsoft is that it also allows you to open multiple object records within the single browser tab where you've got it open. This is a critical need for any CMS. TMS and PastPerfect were a bit more of a struggle this way as I had to flip back and forth from one record to another. On the other hand, the visual layout of both of the latter programs - a dense grouping of fields laid out in logical ways, all easily accessible - was MUCH more preferable to me than the amount of scrolling and dropdown-opening CatalogIt requires. TMS also offers a good amount of customization anyone can do, and a lot more if you're willing to learn some xml/xslt, and I'm really missing that.
7. Users should be able to create their own report formats within the program - for instance, if you want to be able to export a spreadsheet with a media thumbnail, object number, object name, and description inserted into the first four columns for inventory purposes, you should be able to do so with minimal fuss. They should also be able to do at least a bit of reorganizing of fields to make sure the ones they want to use are near the front of the list/top of the page/etc.
------------------------------
Cassidy Percoco
cpercoco@gcv.orgCurator of the John L. Wehle Gallery
Genesee Country Village and Museum
Mumford, NY
------------------------------