RE: DIYHA Digital Jukebox

["Keith Doxey" <lists.diyha@xxxxxxx>]

Hi Mark,

There would be "some" album details where I could extract the
data from what
I have got but my knowledge of albums is largely no existant.

I spent 20 years as a DJ and my collection consist almost entirely of
Singles and Compliation CD's. I probably have 20 or 30 CD's that are by
individual artists and they are largely "Greatest Hits".

During the 70's and 80's I could bet someone that whatever jukebox they
could find, I would have >95% of the songs on it but since I gave up
DJ'ing
in 1991 I have hardly bought any CD's at all. Now I cant even say that I
have HEARD of 10% of the songs on a Jukebox never mind owning them!

The Application is written in ASP and runs on Personal Webserver or IIS and
uses Media Player for playback. It can either run in Internet Explorer or
its own standalone VB application which can be remotely controlled from an
iPaq or other browser. The database is an Access database and there are no
duplicated MP3's in it. The only time a song will be there as more than one
MP3 is where it is a different or extended mix. I have a long way to go
before all my CD's are entered but so far there are

Total Albums  	86
Total Artists  	714
Total Songs  	1305
Total Tracks  	1691

The discrepancy between 1691 tracks and 1305 songs is because I have
already
eliminated 386 duplicates due to the same song appearing on more than 1 CD.

There is only 1 entry for an album.
This points to the tracks table which contains the ID's of the songs on
that
album
The songs table only contains a single entry for the MP3 but can be
referenced from as many track entries as needed. The jukebox allows me to
click on a song and list the CD's that contain that song, I can than click
on the CD icon against that CD to see what other tracks are on it. At any
point I can instantly play any of the songs. I can also run whatever live
reports I want, for instance here is the first part of the report for
"Songs
on more than One CD" with the number of CD's that contain that song.
ie what
would have been duplicates...

I Will Survive   Gloria GAYNOR  4
What Do You Want   Adam FAITH  4
A World Without Love   PETER and GORDON  3
Ain't No Stoppin' Us Now   McFADDEN and WHITEHEAD  3
Do Wah Diddy Diddy   MANFRED MANN  3
Excerpt From A Teenage Opera   Keith WEST  3
Get Down On It   KOOL and the GANG 3
Got To Get You Into My Life   Cliff BENNETT and the REBEL ROUSERS 3
How Do You Do What You Do To Me?   GERRY and the PACEMAKERS 3
I Get Around   The BEACH BOYS  3
I'm Alive   The HOLLIES  3
I'm Into Something Good   HERMANS HERMITS  3
Lady Marmalade   LABELLE  3
Little Children   Billy J. KRAMER and the DAKOTAS 3
Love Train   The O'JAYS  3
Ms. Grace   The TYMES  3
Pretty Flamingo   MANFRED MANN  3
Shakin' All Over   Johnny KIDD and the PIRATES 3
The Game Of Love   Wayne FONTANA and the MINDBENDERS 3
There Goes My First Love   The DRIFTERS  3
Three Steps To Heaven   Eddie COCHRAN  3
When Will I See You Again   THREE DEGREES  3
You Bet Your Love   Herbie HANCOCK  3

I am already looking at using the Tag info to "suggest" what the
correct
info should be. I have a Class fiule that can read MP3 tags and display
them
in an ASP although I need to look at the code to trap some of the errors it
generates. some malformed tags cause the ASP to crash out but the intention
is that it would read the tag, generate several possibilities that match my
schema, retrieve any possible matching existing entries and also give me
the
option for free text entry for totally new artists/songs. A simple click
would then set the correct information into the database.

Still a way to go but if I can make it useable to others without too much
work then I will make it available, if not, it will remain what it started
life as, which is my own totally customised MP3/Video player.


Keith

www.diyha.co.uk
www.kat5.tv


-----Original Message-----
From: Mark Hetherington [mailto:mark.egroups@xxxxxxx]
Sent: 18 May 2002 23:27
To: ukha_d@xxxxxxx
Subject: RE: [ukha_d] DIYHA Digital Jukebox
Would the database be accessible from an external program (e.g. Access) or
is it custom for the application?

> Obviously it wont contain the MP3's or any actual Album details
> but most of

No MP3s obviously, but why no Album details? One idea for albums is to have
them stored as playlists. That way people could contribute
"albums" that
referenced the main database entries.


Not sure if you are already doing or have this planned, but it would be
good
to reduce repeated MP3s as you mentioned above by allowing one song to be
linked to multiple database records. An album playlist would do this for
album based lists, but for multiple artist/title issues, it would likely
fall within the realm of database itself. If the database became a
contributory system, eventually it would likely collect all permutations of
artist/title for a particular track which would help identify those works
you are unfamiliar with and those you suspect as being repeats of each
other.

Might be useful to have some form of MP3 tag import system. Well written
tags could then be accepted by a user while badly ones could be skipped or
replaced with better information possibly taken from the database.

> If I can get the data import to work, what would be made
> available would be
> a semi-populated database containing over 1500 artists, 3000 albums,
30000
> songs. It would be upto the end user to point the database at the
correct
> MP3 file but that task would probably be semi automated just
> requiring mouse
> clicks to find the tracks.

How about a kind of fuzzy search across the MP3s. E.g. search for
Frankie+Goes+Hollywood+Relax in any order in an MP3 filename then
"suggest"
linking it to the appropriate database entry. Possibly extend it so that
Frankie+Hollywood+Relax and Frankie+Relax would also bring up the same
suggestion but with maybe a lower result rating.

I am not too familiar with your Jukebox project yet so hope something in
there is of use/interest and apologies if I am suggesting stuff you already
have in there or planned.

Mark.




For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/