[peel] Re: ULTIMATE Festive 50 resource

[Phil Edwards]

I was about to answer for you Ken (being a recipient of your sessions Word
Doc).
However, I do have a database of track listings which has been compiled from
numerous sources over the years (including Lorcan's website, which he
extracted from teletext and a program I wrote to export from the BBC's track
listings pages).
I've extracted a simplified table to a separate Access database and Excel
spreadsheet from my master database and uploaded to files section.
(The master database contains your original Word Docs converted to an Access
table Ken).
Please bear in mind this is a work in progress and I started this circa 1999
and well before I set up my FTP server.

Phil
  -----Original Message-----
  From: peel@yahoogroups.com [mailto:peel@yahoogroups.com]On Behalf Of ken
garner
  Sent: 31 January 2008 17:35
  To: peel@yahoogroups.com
  Subject: [peel] Re: ULTIMATE Festive 50 resource


  sorry, roger and everyone, it's not quite that grand. On my brother
  Pete's advice, I stuck with what I knew how to operate, and
  crucially, what the old sessions were already in: an excel
  spreadsheet. So it is not a database, really - you can't search it
  relationally, though you can sort it and rank it. I'll put an extract
  of the first ten entries up here under files. It just goes on like
  that for 4434 rows. Not quite so amazing, now, huh? The Peelenium
  (groan), F50s and Shows Chronology are all word documents only. Also,
  to be honest, it has gone through so many corrections and revisions
  since I converted it to a word file in the middle of last July, that
  to go back and enter the corrections (still dribbling in, one or two
  a week) in the last known spreadsheet version would be really
  tedious. My excuse is, I focussed on the end product - a book - and
  did what I had to do with that end in view. There are others on this
  list who have far more impressive and rigorous data management
  systems of their sessions and shows collections - you know who you
  are - who were invaluable help. But I would be dishonest if I did not
  admit that I too have been wondering what the eventual collective
  outcome of all this show sharing might be. For now, I think it best
  to let things evolve naturally, organically, as they are, at a
  staggering pace. But one day it all might come together in some kind
  of quasi-collective, quasi-official, shared online archive resource,
  perhaps. But let's get it all out there first!

  ken

  --- In peel@yahoogroups.com, ROGER CARRUTHERS <roger.carruthers@...>
  wrote:
  >
  > Funny thing - a few weeks ago i handed in an
  > assignment for a college course which was along these
  > lines; a Peel database with info on various shows,
  > sessions, recordings & where you could download 'em
  > from.
  > Sadly my SQL chops weren't really up do it, but I
  > remember at the time marveling at all the work that
  > must have gone into the creating database used for
  > Ken's book (which, of course i referred to constantly)
  > which I beleive was made by his brother (?).
  > Putting that online, with download links for any
  > recordings available, would be the mother of all Peel
  > resources...
  > cheers
  > Roger
  >
  > --- vinpinman <vinpinman@...> wrote:
  >
  > > Thanks for the comments so far. This could basically
  > > go in any
  > > direction we wish to take it. It'll be a lot of work
  > > unless a lot of
  > > people chip in. I've made a start with what could be
  > > a farily
  > > reasonable format to follow, but of course it's not
  > > set in stone.
  > > Actually, I'd be quite happy for there to be no set
  > > style to the
  > > entries, just reflecting the way that any individual
  > > might wish to
  > > represent the info.
  > >
  > > Ken, I can't get your book in Istanbul which remains
  > > a constant
  > > pisser. If I order it from Amazon, someone might
  > > nick it as I live in
  > > an apartment block.
  > >
  > > Using the wiki is unbelievably simple, so I hope a
  > > lot of you do
  > > contribute.
  > >
  > > Format could be
  > >
  > > details of the show
  > > tracklist
  > > where you can download it
  > >
  > >
  > >
  > >
  > > --- In peel@yahoogroups.com, "andthezmore"
  > > <andthezmore@> wrote:
  > > >
  > > > I was thinking about some kind of listing the
  > > other day, I'd just
  > > > gotten round to downloading Jon Hornes 1987 200+mb
  > > files and
  > > > discovered that I had some of them on tape
  > > already, fortunately I
  > > > hadn't started to mp3 these tapes so no
  > > duplicated/wasted effort.
  > > >
  > > > I'd like to know what was on those 17dvds worth
  > > just in case I
  > > copied
  > > > some up when i needn't have bothered. For
  > > instance, is all the
  > > > peelenium on them?
  > > >
  > > > Are you thinking of attaching links to each entry?
  > > Even a list
  > > which
  > > > just refers to somebody here or a source (eg
  > > "17dvd")would be very
  > > > useful.
  > > >
  > > > I'm willing to help if possible. It'll be
  > > interesting to see what
  > > the
  > > > lads with servers think.
  > > >
  > > > Keep up the good work all you people with blogs
  > > etc - very much
  > > > appreciated. Speaking of which, Gary is very
  > > quiet, hope you're
  > > > feeling brighter soon mate.
  > > >
  > > > Cheers
  > > > Andrew
  > > >
  > > >
  > > > --- In peel@yahoogroups.com, "vinpinman"
  > > <vinpinman@> wrote:
  > > > >
  > > > > A lot of you don't recognise the monicker, but
  > > I'm Entrailicus
  > > from
  > > > > Fades in Slowly.
  > > > >
  > > > > I recently started a wiki for Peel:
  > > > >
  > > > >
  > > > > http://peel.wikia.com/wiki/Main_Page
  > > > >
  > > > > I think this would be a really efficient way of
  > > cataloguing
  > > > > everything known about shows and fifties.
  > > > >
  > > > > Here are a couple of examples:
  > > > >
  > > > > 1978 Festive fifty
  > > > >
  > > > > http://peel.wikia.com/wiki/1978_Festive_fifty
  > > > >
  > > > > 30th December 1977
  > > > >
  > > > > http://peel.wikia.com/wiki/30th_December_1977
  > > > >
  > > > >
  > > > > I think this could be an efficient way for all
  > > of us to keep
  > > track
  > > > of
  > > > > what's out there.
  > > > >
  > > > > I'd love help in making this work...
  > > > >
  > > >
  > >
  > >
  > >
  >