It looks like the hand crafted Content Management System we were hoping the magic coding fairies would make us is not going to materialize. 5000 bux a week to develop what we want…..so….now we are going to have to take responsibility for finding a solution ourselves…(le sigh) (les sighs) So, the first thing we need to do is expand our environmental scan. Seems like we are breaking some new ground here as far as Access Centers, but that doesn’t mean other format based archives haven’t figured this out. Sound Archives, Radio Stations, Small businesses. Somebody, Anybody! ANyway, part of taking ownership is identifying what we want this thing to do. Here is a list:

Database Requirements:

1.    Must be able to migrate existing data from Microsoft Access database

2.    Must be able to export Csv

3.    Program Playback: Searchable Fields

1. Length
2. Genera
3. Producer
4. Keywords
5. Series Title
6. Episode Title
7. Unique Identifier (Tape Number)
8. Format
9. Location
10. Archive
11. Date Created
12. Status (Played or unplayed)

4.    Program Scheduling: Reports

1. Daily playback log by time
2. Daily playback by unique identifier (Tape Number/Date Created)
3. Tape labels
4. Monthly playback statistics