DBGallery’s Collection Report Card

DBGallery’s Collection Report Card

There are a whole lot of files in your company’s media collection and its often useful to know more stats than simply the number of files and folders. DBGallery provides a quick one-pager overviewing its entire collection, in a dashboard-like layout.

Click for a full size view.

The image above and the description below is for DBGallery’s Desktop version. For the Web version’s Dashboard, similiar to the Report Card, see our screenshots page.

The Report Card includes:
– Breakdown of the number of specific photo, video and audio file types.
– Shows the number of photos for the various dimensions; how many are 5 megapixels, etc.
– How many has no data at all, and how many have keywords and GPS data.
– A count of Authors, Cameras and Subjects.
– Then there’s the convenient overview of activity: how many added in the past day, week, and month; as well as how many updated and opened during those timeframes.
– And of course, how many were taken in each of the past ten years.
– Plus a bunch others.

Whether you’ve just added a batch of folders to the collection, or want to bring it up at any point in time, the report card is a wonderful source of dashboard-level collection information.

Is it useful beyond curiosity? That might be enough in itself, but it does go beyond that. Knowing that you even have .orf files in your collection might be a complete surprise. Did you even know you had images great than 30 megapixels? (Chances are they’re panoramics unless someone contributing to the collection has a Hasselblad or access to the Hubble). The Activity numbers can be very useful in that has an overview of what’s been going on with the collection lately. If there’s been a huge spike you may want to find out why; same if there has been zero activity for the past while. Given the amount of rich information shown, many will find their own useful ways to have the report card gleam insights into what’s stored in your company’s media database.

To show the actual images for numbers shown, can all this info be queried for specifically within DBGallery? Absolutely! There are no new or special queries used in the report. Getting into each areas is beyond the scope of this short blog, but a couple examples…

– To find all .wav files, choose DBGallery’s + tab in the Search area, then key “.wav” in the File Name Contains field.
– To find how many, or to list, photos updated in the past day, week, month or year, again choose the + tab, select the Last Updated radio button, key 1, then chose from the list of timeframes shown.
– Year Taken: see Logical Views. Or for a full count of media files by year, see the Year by Year Counts report under the main menu’s Reports.

Where do you find the Report Card in DBGallery? Every time you drag and drop new folders onto DBGallery or use the new Managed Locations Wizard, it automatically pops showing the new stats for the collection. Its also the first menu item under Reports in DBGallery’s main menu.

The DBGallery Team