Showing posts with label air force. Show all posts
Showing posts with label air force. Show all posts

Monday, April 7, 2014

How Do We Do This?

OK, historian and digerati friends--how should I proceed with this project? We have an Excel spreadsheet inventory of 7000 items from a defunct museum, along with 7000 individual JPEG pictures of those items. How do we put these together, attaching an image to each spreadsheet item, in a useable format?

 Some background. From 1980 until some time in the late 1990s, there was a museum on the Fairchild Air Force base in eastern Washington. The museum was one of those labors of love, mostly powered by volunteers from the local military community. The focus was not only the base, but the military history of the Inland Northwest--so the collection  ranges from minnie balls picked up from 19th-century battlefields to a B-52 flight simulator. In the late 1990s the Air Force closed most base museums, including Fairchild. As the  artifacts were boxed  for storage, a quick inventory was created for the roughly 7000 items and a digital photograph was taken of each. The boxes went into storage at the Northwest Museum of Arts & Culture. Where they remain to this day:

MAC Director Forrest Rogers unveils some
of the ~300 boxes of the collection.
 My public history class has been tasked with surveying the collection and deciding what are some of the particularly interesting and noteworthy items. Obviously whatever we do will be only a start, and a professional conservator will have to come in at some point, but whatever we can do will help the owners of the collection as they work towards their plan of establishing a new aerospace museum in Spokane. After a conversation with board president Tobby Hatley, we decided creating a database of the spreadsheet and images would be the first order of business for my students and I.

My initial thought was to simply upload the spreadsheet to Google Docs, share with the class, add a column titled "images" and start dragging and dropping. I strongly suspect, however, that this is too large a data set to work with that way. So what do we do? We are experienced with Omeka from our work with Spokane Historical--can we simply convert a spreadsheet to an Omeka database in some fashion, or are are hand-creating each item? Is there another solution we should be examining--Drupal? Wordpress?

We are looking to create a working database and not (at this time) a digital project. We want to keep it quick and reasonably simple, so my students can move to the next phase--opening some of those boxes and locating the treasures of this collection.

How do we do this?