Excitement of the Most Annoying Kind

Not quite 6AM on Saturday morning, and I discover that I'm locked out of the office with all the photographic materials in it. Not locked out of the Communications Department, just the office that has the computer and working materials. Well, as I ride in with my husband who works between 3 and 4pm on Saturdays, this puts me in a bit of a quandary. Fortunately, I can set up shop in the office of my full-time job and do a bit of further research on the actual database. Last week, I had thought mayhaps a PHP/MySQL database would be the way to go. However, I realized that would also require setting up a webpage that would likely require more time to accomplish than this summer's semester will allow. Then I thought perhaps a Microsoft Access database, which would be feasible until I remembered something that Mary Cone mentioned last April when I was just getting all my capstone ducks in a row: Picasa.

Now, I can be a little OCD, even a little Frank Sinatra-ish (to paraphrase, "I'll do it...MY WAY!"), but I'm also disinclined to reinvent the wheel. So sitting here on Saturday morning, I set up Picasa on my work 'droid and, with emailed guidance from Kyle Rosenblad, I downloaded Picasa and started to sync the existing archive of photos (which will take approximately 8 hours). I'm not certain, not having worked with Picasa before, if I'll have to do the same thing on the 'droid in the Communications Department but, if that's the case, so be it. I am able to poke around in Picasa while it's syncing and noticed 1) the Communications Department has already established their existing photo archive by years (easy to work with) and 2) Picasa has a tag function.

{visualize lightbulb over my pointed little head}

Now part of the current problem which we need to resolve is long term storage and access to these photos, slides, and negatives. I confess I have been near to weeping whenever I find myself gently trying to separate photos which have become stuck together, carefully removing the rubber bands which have melted onto the materials, or delicately sliding the paper clips which have been in place for a decade from pages of negatives. So if it is possible to render these materials into a digital format and store them in Picasa with appropriate tags (which would make them searchable), this could be the best possible solution. Critical images could still be kept in photo/negative/slide format as well, but I suspect that would be a far more manageable number than at present. Also, at the beginning of this project, the possibility of outsourcing the digitization of the collection was discussed. This now seems more like a possibility, so if Mary Cone is in agreement, I can look into getting bids for this. If this appears cost prohibitive, I have looked into equipment to handle this in-house and HP has very reasonably priced scanners equipped with transparency materials adapters (http://www.hp.com/united-states/consumer/digital_photography/organize_archive_photos/tips/scanning_slides.html#5)and so photos, negatives, and slides could all be scanned and tagged in Picasa (http://www.hp.com/united-states/consumer/digital_photography/organize_archive_photos/tips/scanning_slides.html)

So, wow! What started out as a day that looked like a complete bust has actually brought me to some potential solutions!

Edit: And I just realized that if, in fact, we can do this in-house, it would actually be a little more efficient in terms of tagging, as I could upload and tag small groups of materials immediately after scanning them, determine if they could be discard at that time, and minimize the times an item is touched (I'm a firm believer in the time savings of a "touch once" system).