Creating file names in excel

When we send videos out to be digitized, we also send a spreadsheet with the file names for each. Our initial convention was Collection_Location_AuthorLName_DateOfForum, which might translate into a file name of WF_bro_Baxter_19870305. We have since dropped the Collection_Location segments. I am recording here the formula used to get Excel to generate the file name, as it is not commonly used every day. Here are the columns found on the spreadsheet when we begin:
Box#;LName;FName;Date of Appearance;Format;Barcode with a final generated column for FileName.

Step one is to create a duplicate Date of Appearance column that will convert the date into a text field. The formula for that is: =TEXT(D2,"yyyymmdd") where D2 contains the original Date of Appearance formatted as mm/dd/yyyy.

Step two is to use the formula: =CONCATENATE(B2,"_",E2) where B2 is the LName field and E2 is the properly formatted date field. The "_" is necessary to create the _ between the two.

Kudos to Kelly Deltoro-White for figuring this out on her own, as well!

Writers Forum Open Access Project

In late October, 2015 I received notification that I was awarded a $1500 Harold Hacker Award Fund for the Advancement of Libraries. Here is the budget narrative:

The funding would be used to hire an intern for 300 hours @ $12.00/hr, who would first update the 2007 inventory to determine the current state of the collection. He or she would then build a showcase collection on Brockport’s open access institutional repository, Digital Commons@Brockport (http://digitalcommons.brockport.edu/), and move 40 existing audio files currently behind a firewall in iTunes, 22 existing video files found on SUNY’s DSpace platform, and 18 existing digital files that are stored on local hard drives to this site. Metadata would be added to enhance the discoverability of the collection, and the catalog records would be created or updated, and links would be updated on the departmental and library webpages. Historical posters, programs and other archival material would be scanned to round out the collection.

While I asked for $3600, I received less than half of that. Since the premiere goal was to create an online, open access collection that is what I will have to focus on. 

 

Posting video content from Kaltura Media Space

http://digitalcommons.brockport.edu/drakepubs/24/

Ken recently videographed a historical society meeting. Here are the instructions.

Ken has uploaded the raw content to kmc. Sign into kmc.kaltura.com using brockport email and special password {3}ER

Click on Name - Preview in Player - Select Player - Media Space Main Player - Advanced Options (Delivery Type - Kaltura Auto, Embed Type - Auto Embed)

Copy the tiny URL generated at the bottom - paste into the appropriate metadata field. Choose other Rich Media for streaming media choice.