Santa Claus is not coming this year

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:Image

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

Talking with the Salesman about Content Management

Once you buy a big bucket, you have to organize all the pieces. Sadly, It looks like Drupal is not even on the page for this project. It’s either a homejob from the service that is installing OR StandPoint. It is all shrouded in mystery for me now. My only feeble happiness is that the death knoll for MicroSoft Access has sounded. There is no joy in MudVille because StandPoint looks really hard to learn.