Tapelog

Tapelog is YSTV's system for keeping track of what is recorded on all our video tapes, and finding where there is free space to be able to record something.

The idea is that every use of the tape should be recorded, so that even if an item is deleted it should be possible to recover the record from the administration interface, as the recording may still be on the tape. Items that pass their expiry date should automatically be marked as deleted, so they are counted as empty space when looking for space to make new recordings. Not all of this is currently working.

It started off as a stand-alone system running on a BBC Micro in the station

Later Kevin Bowman transferred the data into a MySQL database and wrote a PHP front end, which ran on it's own PC in the control room. Several features including the admin interface went and stayed missing at this point. All entries marked as deleted in the BBC database were also lost as only the current content was migrated. Dave Baker merged this into the YSTV website proper so it could be used from anywhere, and did some XHTML clean-up. David Furey later added a few of the most urgent missing features to it, after nagging from Richard Ash about not being able to edit shows or view deleted entries (which were kept in the database, but not visible).