Jump to content


Help needed with Juno release dates


  • Please log in to reply
8 replies to this topic

#1 thijs

thijs

    Knowledge provider

  • Admin
  • PipPipPip
  • 3962 posts

Posted 09 July 2005 - 10:24 AM

I have been trying to look into this myself, but have not been able to figure it out yet.

You might have noticed the release years are transformed into actual release dates. With newer releases it is relatively easy to add. However for the older ones things are a bit more complicated. However our very own Manipulator still has all the older 'New Releases' pages as published on the Juno website.

Thing is, in order to import those dates into the database, the format needs changing. So what we are after is someone who is willing to check out these HTML files and make the output one big list containing:

label name - catalogue - release date (dd-mm-yyyy)

If someone has got some spare time, experience with regexps and is willing to help out a little, it would be very much appreciated. If there are more questions about this please let us know.

#2 Ornette

Ornette

    Knowledge provider

  • Members
  • PipPipPip
  • 3752 posts

Posted 20 August 2005 - 08:21 PM

Thijs,
I have been intreged by your request about this for a little while now.  What is the problem you are having importing these HTML files into the database?

Can I confirm, are you saying that since the 4th June 2001, each weekly Juno update is automatically logged in the RDB database? Not too sure what the differences could be...

Funnily enough I used to get the Juno 'mailing list' sent to me every week via e-mail.  I used to copy out the drum & bass releases section and paste into a large text file.  I still have these, if thats at all helpful.

The Juno Mailing List, on March 30 1998, said:

Issue 106: Monday 30 March 1998
-------------------------------------------
A complete weekly listing of new UK dance releases and imports
extracted from the Dance Music Resource Pages at http://www.juno.co.uk
-------------------------------------------
...

Maybe I could have a little go at this.  What is this 'regexps' thing?  Do I need to use it?
LATE NIGHT JAZZ DNB SESSIONS
FRIDAY NIGHTS 12-2am GMT/BST on jungletrain.net

#3 thijs

thijs

    Knowledge provider

  • Admin
  • PipPipPip
  • 3962 posts

Posted 20 August 2005 - 08:24 PM

i will be using it to add  release day to the release years. i would be VERY interested in that list as well as what Juno is offering of that mailing list.

please send anything you can miss to rolldabeats@gmail.com ;)

thanks in advance!

#4 The_Manipulator

The_Manipulator

    Knowledge provider

  • Admin
  • PipPipPip
  • 2259 posts

Posted 22 August 2005 - 11:43 AM

I think what they had on the mailinglist is the same as what I basically downloaded. But if Ornette made a text file from it, it may be in a more usable format...

They just used to have this archive of weekly lists, untill they had a big crash... since that time the archive is gone fromt he site.
Thanks to RollDaBeats I've finally found a use for all the records and CD's I have bought...
Collection: http://www.rolldabeats.com/collection/the_manipulator/ (partial) or http://home.wanadoo.nl/jari/dnb_records.html (full)

#5 Christopher

Christopher

    Knowledge provider

  • Members
  • PipPipPip
  • 153 posts

Posted 01 May 2006 - 09:58 AM

View PostThe_Manipulator, on Aug 22 2005, 11:43 AM, said:

I think what they had on the mailinglist is the same as what I basically downloaded. But if Ornette made a text file from it, it may be in a more usable format...

They just used to have this archive of weekly lists, untill they had a big crash... since that time the archive is gone fromt he site.


Did anybody make any headway with this? I've noticed that http://classic.juno.co.uk still has release information for some old stuff (example: http://classic.juno.co.uk/drum-n-bass/ , I just scrolled down a bit and clicked on http://classic.juno.co.uk/products/109608-01.htm and it had the full release date on the page)...

Regular expressions are a pain in the arse sometimes, you should look for someone who knows how to get around unix well because invariably they're the ones with regex experience ;) I've had to do some regular expression stuff though as part of my old IT course, so I know how tough it can be sometimes _
Never mind 2007's relick, RDB's rollin' into '09 with a total redesign. Big!
collection ((always) in progress): http://rolldabeats.c...ion/Christopher

#6 thijs

thijs

    Knowledge provider

  • Admin
  • PipPipPip
  • 3962 posts

Posted 01 May 2006 - 11:17 AM

all those are already added to the site :smile:

it's the releases which are in their database, but not shown online since out of stock items don't get listen. those are the ones i am afer...

#7 Christopher

Christopher

    Knowledge provider

  • Members
  • PipPipPip
  • 153 posts

Posted 01 May 2006 - 11:22 AM

View Postthijs, on May 1 2006, 11:17 AM, said:

all those are already added to the site :smile:

it's the releases which are in their database, but not shown online since out of stock items don't get listen. those are the ones i am afer...


Ah. Gotcha. :)
Never mind 2007's relick, RDB's rollin' into '09 with a total redesign. Big!
collection ((always) in progress): http://rolldabeats.c...ion/Christopher

#8 Ornette

Ornette

    Knowledge provider

  • Members
  • PipPipPip
  • 3752 posts

Posted 01 May 2006 - 01:12 PM

Thijs, will you explain what is this 'regexps' exactly?
LATE NIGHT JAZZ DNB SESSIONS
FRIDAY NIGHTS 12-2am GMT/BST on jungletrain.net

#9 Christopher

Christopher

    Knowledge provider

  • Members
  • PipPipPip
  • 153 posts

Posted 01 May 2006 - 01:44 PM

View PostOrnette, on May 1 2006, 01:12 PM, said:

Thijs, will you explain what is this 'regexps' exactly?


When he said 'regexps', he meant 'regular expressions' - it's a way of coding a syntax which will take an input and manipulate it, depending on how you configure the regular expression to be applied to the input - and then give out an answer. So, for example, you can input a string of raw text, and (and this is just a simple example) you can write a regular expression which will take this raw string, look through it for any instances of where the letters A and B are next to each other, and then just output them with a space inbetween each of them, discarding all the other letters.

There's WAY more complex ones than that, that's merely the simplest one I could think of - see Wikipedia for a much more comprehensive explanation. I can do regular expressions, I just can't explain them very well. :) I learn by doing. ;)

http://en.wikipedia.org/wiki/Regular_expressions
Never mind 2007's relick, RDB's rollin' into '09 with a total redesign. Big!
collection ((always) in progress): http://rolldabeats.c...ion/Christopher