OK folks, What System do you use to store, organize, and preserve your millions of rolls of developed and proofed film?
This stuff takes up space. After about 10,000 developed roll of film, its remarkably difficult to find a particular roll / exposure,
Wow! Where to begin? I am sure that others have they own (and maybe better ways of doing this ....):
First thing I'd do is devise a Filing/Naming system: year-month-roll#, etc. Ask yourself how you anticipate searching through these negatives.
I assume that you've cut these negatives and are storing them in those standard envelopes, 6 frames by 6 or 7 rows? If not, then you'll need more help than I can provide (maybe someone else on this forum will be helpful?).
Basically, I place the cut negatives in plasticine pages (along with any handwritten notes) in three-ring binders. Along the top of each plastic page I record the "label" based upon my filing/labeling scheme. I put no more than fifty or sixty rolls in a binder. Next, I use a label maker to create labels for the spines of each binder. Labels include years (inclusive), and roll numbers. These three-ring binders are then organized in bookshelves in chronological order.
If you have contact sheets these should be labelled (on the back sides) with the same filing/naming system you use for negatives. I keep the contact sheets in a different place than the negatives for a number of reasons. For one, adding the contact sheet to the negative sheets increases the weight and makes handling the books somewhat awkward. I also care less about losing or misplacing a contact sheet because I have the negatives and the scans ...
If you're scanning these negatives, I'd consider investing in a good metadata editing program; I use PhotoMechanic, but I'm told that a lot of freely available software works well. Before creating lots of metadata, I'd carefully think about Keywords (structured or not), and some standardized way of titling, crediting, etc., these images so that you don't have to revise lots of metadata. I keep "lightweight" (i.e., lo-res JPEGS) of complete rolls on my main computer. Note, I name the directories to conform to the same filing/naming convention that I used for the negatives and contact sheets (if any). This way I can quickly look through all of the scanned negatives in a much larger format than what I might obtain with a loupe on a contact sheet. But, in order to do this I had to spend LOTs of TIME scanning and providing metadata for these older negatives. Because I do maintain keywords and metadata, I can load these scans (directories) into PhotoMechanic (or any other metadata editor) and quickly find topics, dates, locations, etc.
Now, depending upon what you're doing with these images, you can then create Excel Spreadsheets using any number of fields and including your Reference numbers when creating portfolios, photo books, submitting images/product to the copyright office, etc.
I am sure that this gives you an idea of one way to proceed here. I'm curious to know if more "automated solutions" are available, which is one reason I'm writing such a long post.
Let's see what others do and have done.
TR