Jump to content

Help needed with Juno release dates


thijs

Recommended Posts

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.

Link to comment
Share on other sites

  • 1 month later...

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.

 

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?

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 8 months later...
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 ?_?

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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. :)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

×
×
  • Create New...