The only issue I've run into has been write conflicts trying to update
records in the Album table. The DiscId field gets set to the empty string
via the submission process. Access (or the ODBC driver, I'm not sure which)
interprets this as a NULL value, although mysql treats them differently. I
have to manually reset the DiscId fields to NULL using mysql before I can
edit using Access.
* Eradicator *
Once you learn a bar chord, the musical world is your oyster.
-----Original Message-----
From: Showalter, Frank [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 01, 1999 12:12 PM
To: '[EMAIL PROTECTED]'
Subject: RE: couple o' questions
Okay, I've gotten the ODBC connection working through Access.. any gotcha's
I should be aware of?
-F
-----Original Message-----
From: Derek Westcott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 01, 1999 2:33 PM
To: '[EMAIL PROTECTED]'
Subject: RE: couple o' questions
The Submit function in ObsIO does the actual submission. The last parameter
is a structure that contains the Title, Album, Artist, etc. You should be
able to write a perl script that generates this structure from whatever
source you want. Check out SubmitTrack.pl to get started. It alternatively
pulls the data from ID3 or from the command-line.
* Eradicator *
Once you learn a bar chord, the musical world is your oyster.
-----Original Message-----
From: Showalter, Frank [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 01, 1999 11:07 AM
To: '[EMAIL PROTECTED]'
Subject: RE: couple o' questions
You hit it on the head. The only problem for that solution is that the id3
tags are never big enough to hold the artist-songname format.. i can see
your point about autocheckin, but if you have a universal naming convention
that you stick to I can't see it being a problem (for instance mine are all
"artist - track number - song.mp3" where the directory they fall in is the
album name) i should think that a perl script could be written to accomplish
this but i'm not sure if there is more involved then simply adding titles to
the database. Do they need to be registered with the daemon? or is does it
simply pull from the database?
-F
-----Original Message-----
From: Derek Westcott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 01, 1999 2:00 PM
To: '[EMAIL PROTECTED]'
Subject: RE: couple o' questions
I'm fairly sure you can just tweak the Url field in the Track table to point
at whatever file you want.
I'm not sure I understand your soundtrack problem, but I can make a guess.
I have some mix cds with each track by a separate artist. The tactic I've
taken to prevent the tracks from being scattered across multiple albums is
to tag them all with the same album name and artist name (I use the DJ as
the artist), and then tag the song name with the individual track artist, in
the form "artist - song title". This is the approach that CDDB uses for
some albums, but I have to patch the database after the fact for those that
it doesn't.
The only gotcha I can think of with filenames is that they're not
consistent, so automatic cataloging becomes difficult, if not impossible.
Would be nice to update to using id3v2 tags so long names don't get clipped,
though.
You can browse the DB using mysql directly. You just need a few basic SQL
statements to find albums, artists, and matching tracks. Still, graphical
editing is easier. I'm using the mysql ODBC driver so I can connect a Win98
machine running Access. There are also several graphical client programs
available for X, although I haven't tried any of them out. Find all of this
over at http://www.mysql.com
* Eradicator *
Once you learn a bar chord, the musical world is your oyster.
-----Original Message-----
From: Showalter, Frank [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 01, 1999 10:22 AM
To: '[EMAIL PROTECTED]'
Subject: couple o' questions
okay, i must admit i love the program.. however there are a couple of
changes i'd like to make and was wondering if anyone had already tried this
and/or if anyone knows why it would/wouldn't work:
i really don't like the renaming scheme it enforces. what i'm hoping is i
that this is only stored in the sql tables and not hard-coded so in theory i
could just change the tables to point to filenames formatted the way i like
and all will be okay?
secondly, as it stands it really doesn't handle soundtracks very well
(thinks they're upteen diffrenet albums of the same name for each artist) so
again i'd like to just manually edit the sql table to correct this. this one
i'm relatively sure will work.
finally, does anyone know why the choice was made to use id3 tags instead of
file names for indexing purposes? is there somekind of gotcha with filenames
i don't know about? id3 tags are annoyingly small and i'd much rather have
it read the info from a filename for indexing purposes...
oh and also, does anyone know an easy way to get in and actually modify the
data in the tables (preferably a gui option) i suppose i could just
dump-edit-and import but i would think there would be an easier way to get
in and browse around and edit the entries i need to...
any comments/advice/guidence would be appreciated.
-frank
