RE: Library Software

[Keith Doxey <ukha.diyha@xxxxxxx>]

I still am :-)

My jukebox has the graphical appearance of a classic Wurlizer and will
allow
unlimited creation of playlists. It looks great when displayed on a TV :-)

I dont use MP3 tags because I didnt really know about them at the time I
started ripping.

My collection is mostly Compilations and many of them dont appear on CDDB
anyway.

My MP3 files are called xxxyy.mp3 where xxx is the album number and yy is
the track number.

One interesting point to note when people are quoting how many Gb's of
mp3's
they have.... my database currently stores the info on

Total Albums 86
Total Artists 715
Total Tracks 1691
Total Songs 1305
MP3 Files 1305

Themes 7
Genres 27
Eras 7
Chart Entries 0
Playlists 0

I havent started to enter the Chart info or playlists yet but you will
notice that the number of songs is less than the number of tracks. This is
because of duplicates that are on several CD's. The current saving of 386
tracks not ripped is over 1Gb of space saved.

>From a song title I can return a list of all the Physical CD's that
contain
the track. I can then click on the title of the album to list all the other
tracks on the album.

At any stage I can instantly play the MP3 file.

Future features will be the ability to create Audio or MP3 CD's from the
database so that I can create "The Best <whatever> Album At The
Time"

Searching can be done as follows.....

For the title Search, if less than 4 characters are entered then the search
is for titles starting with the entered characters e.g. LOV will search for
LOV* finding songs starting Love, Loving etc. If 4 or more characters are
entered the search will be for any title containing the entered string e.g.
LOVE will return any song with Love anywhere in the title. If the entered
string contains any spaces it is automatically split and will search for
titles that contain ALL the entered words e.g. “LOVE WHAT” will return with
Tina Turner’s “WHAT’s LOVE  got to do with it?” etc.

The Artist search performs in a similar way with the primary search being
on
the Artist Surname/Groupname. Entering “JO” would return “Elton JOHN, Tom
JONES” etc. If the entered string contains a “\” (backslash) then the
search
is also performed on the Artist firstname.  “E\JO” will match “Elton JOHN “

There is also a "Digital DJ" mode with 2 embeded media players at
the top
left and top right of the screen and a search page in the lower half. From
the listing returned by the search you can either LOAD a track into a media
player and manually start it, or PLAY a track in a media player whereby it
will auto start.

I wish I'd had access to this technology when I was a DJ.... it would have
saved an awful lot of backache lugging 20 crates of records about :-)

One day I will post a demo version on the net when I get it to a stage that
I am happy to let people play with.

Keith.



-----Original Message-----
From: Mark McCall [mailto:mark@xxxxxxx]
Sent: Thursday, March 15, 2001 13:19
To: ukha_d@xxxxxxx
Subject: Re: [ukha_d] Library Software


Lovely setup!

Looks like a commercial product.  Keith was working on something similar I
think.

M.


----- Original Message -----
From: "Adam Stevens" <adam@xxxxxxx>
To: <ukha_d@xxxxxxx>
Sent: Thursday, March 15, 2001 12:52 PM
Subject: RE: [ukha_d] Library Software


> I use an Access database (soon to be SQL Server) to catalog MP3 tracks
which
> I've ripped from my CDs.  I also found the CDDB problem with
compilation
> CD's, but there are a few bits of software out there which will rename
the
> ID tag depending on the file name - This works quite well as the files
are
> generally saved as "<artist> - <track>.mp3".  I
found it surprisingly
> pain-less to re-ID tag all my MP3s.
>
> I'm not at home at the moment, and can't remember the name of the
software
I
> use to do this, however it also has a really nice feature which allows
a
CSV
> file to be created of all MP3 files, which can then be imported into a
> database (or Excel).  I'll dig it out this evening if you're
interested.
>
> Take a look at http://zz9.dyndns.org/home/music/mp3search.asp
to see what
it
> looks like (click on "login as guest", and wait a while...
The database
> access is a little slow at the moment, hence the change to SQL Server
> soon! - Mind you, there are over 10,000 MP3s there!).
>
> Cheers,
> Adam.
>
>
> > -----Original Message-----
> > From: Mark Harrison [mailto:Mark.Harrison@xxxxxxx]
> > Sent: Thursday, March 15, 2001 12:11 PM
> > To: 'ukha_d@xxxxxxx'
> > Subject: RE: [ukha_d] Library Software
> >
> >
> > Stuart,
> >
> > It's not what you want to hear, but I used Excel for my fiction
library
> > (about 2000 books.)
> >
> > My logic was that
> >
> > - the data is fundamentally a single table so there wasn't
> > particularly any
> > mileage to gain out of normalising the data into anything
relational.
> >
> > - where I've got repetitive data (like Author name) Excel does
the "copy
> > down" or autofill nicely
> >
> > - I figured up front that I'd want to muck around with the
fields. I
> > subsequently added stuff like "series name" and
"series number" to the
> > original
> >
> > On the CDs, I think the same applies. I've had trouble with CDDB
on
> > compilation CDs, where the "performer/artist" field
_isn't_ at
> > the CD level
> > but the track level...
> >
> > Mark
> >
> >
******************************************************************
> > **********
> > Kingfisher plc
> > Registered Office: North West House, 119 Marylebone Road, London
NW1 5PX
> > Registered in England, Number 1664812
> >
> > This e-mail is only intended for the person(s) to whom it is
addressed
and
> > may contain confidential information.  Unless stated to the
contrary,
any
> > opinions or comments are personal to the writer and do not
represent the
> > official view of the company.  If you have received this e-mail
in
error,
> > please notify us immediately by reply e-mail and then delete this
message
> > from your system.  Please do not copy it or use it for any
purposes, or
> > disclose its contents to any other person.  Thank you for your
> > co-operation.
> >
******************************************************************
> > **********
> >
> >
> > -----Original Message-----
> > From: Stuart Grimshaw [mailto:stuart@xxxxxxx]
> > Sent: 15 March 2001 10:59
> > To: ukha_d@xxxxxxx
> > Subject: [ukha_d] Library Software
> >
> >
> > Does anyone know of any software that will let me catalogue my
> > CD/DVD/Video/MP3/Book collection?
> >
> > I had a cuecat shipped over from the states a while back, so
> > something that
> > can use that would be cool as well.
> >
> > --
> >                                 ,,,
> >                                (o o)
> >
===========================oOO==(_)==OOo==============================
> > Stuart Grimshaw         www.schoolsnet.com          sg@xxxxxxx
> > Special Projects Developer                            t: 07976
625221
> > Schoolsnet LTD             .oooO  Oooo.               f: 0870
7060260
> > ===========================(   )==(  
)===============================
> >                             \ (    ) /
> >                              \_)  (_/
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
_____________________________________________________________________
> > This message has been checked for all known viruses by the
> > MessageLabs Virus Control Centre. For further information visit
> > http://www.messagelabs.com/stats.asp
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>





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