Keeping track of things...

BillyBoy wrote on 8/13/2003, 9:48 PM
Several threads recently on finding source files and that kind of stuff. As you can probably guess media bins aren't my cup of tea. As I've said in several threads I have a extensive collection of not only videos I've made and edited also a pretty large collection of tapes, DVD's and CD's, even records, remember them?

While several years ago I just kept spreadsheets, that method not only proved cumbersome, it turned out to be ineffective once you got to the point where you added a good many fields and sorting became a pain. Next I went the database route. Trouble is to make a decent customized database first you need some pretty powerful software and a fair amount of time to set it up. Who has the time?

So why re invent the wheel? Check out the following which is a powerful yet easy customizable database with a cheap price designed specificially for video collections. Because the fields can be highly customized through wizards, and the sample database already comes with many preset fields, with the wizard offering over a hundred more which you can add to or delete or edit, even add thumbnails I've found it rather useful.

It isn't meant to automate the process of rebuilding anything, simply record keeping your way. And you know how picky I AM. The downside is if any of you never build a searchable database before its the time invested in building the records. Adding new information only takes a few minutes. Its the getting set up adding all your old infomration that takes the time.

Anyhow if anyone is interested, check out the following

http://www.fnprg.com/catvids/screenshots.html

Anyone know of anything similar, speak up.



Comments

filmy wrote on 8/13/2003, 10:42 PM
I personnally use FileMaker for my overall use. However I know in recent times (year or so) I have seen a lot of movie related database programs come out. They are tailored to keeping track of your DVD and video collections. I know there are also like programs for video stores as well to track stock, more or less the same but some tie into to the scans. I think one is called "Video Store" another is called "Movie Collector." Actually if you already have FileMaker there is a sort of free database called "Flixable" for your DVD's.
farss wrote on 8/13/2003, 10:52 PM
As a database developer its embarassing that I haven't got better organised. As BillyBoy has pointed out though having the database is only a small part of the problem.
Putting the data into it is a pain but even if you've done that I still haven't been able to build a database that will automatically update the 'last place left' and 'last person loaned to' fields.

Many years ago I worked for a slightly deranged gent who had a simple approach to such problems. He had a very deep workbench with a bin at the back. At the start of every new job he would push everything back a bit to make some room. Whatever fell off the back into the bin was automatically deemed not worth keeping.