<html><body><div style="color:#000; background-color:#fff, font-family:arial, helvetica, sans-serif;font-size:10pt"><span><span>Hey, thanks, Mike. Yes, the command-line approach is just fine with me, if it gets me where I want to go. I'll have to explore this approach, too, this weekend. I have a feeling I'll learn a lot more about id3 tags and mp3 files in the process. And, yes, I just might have to check out MuzikBrowzer, too. Looks like a nice product.<br><br>Appreciatively,<br>John<br class="yui-cursor"></span></span><div style="font-family: inherit; font-size: 10pt;"><br><div style="font-family: inherit; font-size: 12pt;"><font face="Arial" size="2"><div style="border: 1px solid rgb(204, 204, 204); line-height: 0pt; font-size: 0pt; margin: 5px 0px; padding: 0pt;" readonly="true" class="hr" contenteditable="false"></div><b><span style="font-weight: bold;">From:</span></b> Michael Makuch
<mike@muzikbrowzer.com><br><b><span style="font-weight: bold;">To:</span></b> id3v2@id3.org<br><b><span style="font-weight: bold;">Cc:</span></b> <br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, January 11, 2011 10:45:14 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [ID3 Dev] Reading Tags into a Database<br></font><br>
<div id="yiv1830033195">
If you prefer command line & scripting to GUIs I have 2 command
line utilities I use; id3 and mbtag.exe<br>
<br>
id3 is based on the prog that's in the id3lib source, modified to my
liking. mbtag.exe (win only) is also based similarly on id3lib, but
it also does read/writing of .ogg, .wma, and .flac.<br>
<br>
id3 src: http://www.muzikbrowzer.com/dl/id3.zip (requires id3lib)<br>
mbtag.exe http://www.muzikbrowzer.com/dl/mbtag.zip (no installer,
just a command line exe)<br>
<br>
mbtag.exe also comes along with Muzikbrowzer when you install it
http://www.muzikbrowzer.com/<br>
<br>
Below are the usage of both utils.<br>
<br>
Cheers<br>
Mike<br>
<br>
<br>
$ id3<br>
id3 [options] <file> # w/out options display tag info.
options:<br>
-v <value> # id3 version (1 or 2)<br>
-dt # delete tag (version 1 or 2 if specified else
both<br>
-df <value> # delete tag field<br>
-ds # delete some fields<br>
-getart <value> # getart, writes to <file><br>
-TCON <value> # genre<br>
-TPE1 <value> # artist<br>
-TALB <value> # album<br>
-TIT2 <value> # title<br>
-TRCK <value> # track<br>
-TLEN <value> # length<br>
-TYER <value> # year<br>
-TPOS <value> # part in set<br>
-TPUB <value> # publisher<br>
-UFID <value> # ufid<br>
-TMED <value> # dig...<br>
-COMM <value> # comment<br>
-APIC <value> # art file, reads from <file><br>
<br>
$ ./mbtag.exe -help<br>
mbtag from Muzikbrowzer <a rel="nofollow" class="yiv1830033195moz-txt-link-abbreviated" target="_blank" href="http://www.muzikbrowzer.com">www.muzikbrowzer.com</a><br>
Standalone command line tag editor/viewer. Feel free<br>
to distribute mbtag.exe.<br>
<br>
usage:<br>
mbtag [options] <file> # w/out options display tag info.
options:<br>
-k <value> # key, use with -v<br>
-v <value> # val, use with -k to set key/val<br>
-dt # delete tag<br>
-df <value> # delete tag field<br>
-c # display comments only (COMM, COMMENTS,
DESCRIPTION<br>
-getart <value> # gets art from tag, writes to
<file> (mp3/ogg)<br>
-setart <value> # read from <file>, add to tag
(mp3/ogg)<br>
-help # full help<br>
<br>
Examples:<br>
<br>
Set Genre:<br>
mbtag -k TCON -v "Texas Rock" Fandango.mp3<br>
mbtag -k GENRE -v RockAndRollBaby ElvisLives.flac<br>
Set Artist:<br>
mbtag -k WM/AlbumArtist -v RockAndRollBaby ElvisLives.wma<br>
mbtag -k ARTIST -v "The King" ElvisLives.ogg<br>
mbtag -k TPE1 -v "XYZZY" TwistyLittleMaze.mp3<br>
<br>
id3 keys converted to appropriate corresponding key when used on<br>
ogg, flac, wma files. Example:<br>
mbtag -k TCON -v "Classical" BethovensFifth.ogg<br>
is converted to<br>
mbtag -k GENRE -v "Classical" BethovensFifth.ogg<br>
<br>
id3 keys supported: TCON,TPE1,TALB,TIT2,TRCK,TYER,COMM<br>
ogg, flac, wma: anything goes<br>
For wma's only type STRING fields are supported.<br>
<br>
<br>
<br>
<br>
<br>
<br>
On 1/11/2011 7:00 AM, John Slane wrote:
<blockquote type="cite">
<div style="color: rgb(0, 0, 0); font-size: 10pt;"><span><span>Beautiful.
That is very useful info.<br>
<br>
I very much look forward to trying this out during the
coming weekend. It looks like it may give me much more
flexibility in organizing my library than can be achieved
with the popular library/player packages.<br>
<br>
Thanks very much for taking time to help me.<br class="yiv1830033195yui-cursor">
</span></span>
<div style="font-family: inherit; font-size: 10pt;"><br>
<div style="font-family: inherit; font-size: 12pt;"><font face="Arial" size="2"><b><span style="font-weight: bold;">From:</span></b>
Peter Bennett <a rel="nofollow" class="yiv1830033195moz-txt-link-rfc2396E" ymailto="mailto:pgbennett@comcast.net" target="_blank" href="mailto:pgbennett@comcast.net"><pgbennett@comcast.net></a><br>
<b><span style="font-weight: bold;">To:</span></b> John
Slane <a rel="nofollow" class="yiv1830033195moz-txt-link-rfc2396E" ymailto="mailto:jaslane64@yahoo.com" target="_blank" href="mailto:jaslane64@yahoo.com"><jaslane64@yahoo.com></a><br>
<b><span style="font-weight: bold;">Cc:</span></b>
<a rel="nofollow" class="yiv1830033195moz-txt-link-rfc2396E" ymailto="mailto:id3v2@id3.org" target="_blank" href="mailto:id3v2@id3.org">"id3v2@id3.org"</a> <a rel="nofollow" class="yiv1830033195moz-txt-link-rfc2396E" ymailto="mailto:id3v2@id3.org" target="_blank" href="mailto:id3v2@id3.org"><id3v2@id3.org></a><br>
<b><span style="font-weight: bold;">Sent:</span></b>
Monday, January 10, 2011 8:36:32 PM<br>
<b><span style="font-weight: bold;">Subject:</span></b>
Re: [ID3 Dev] Reading Tags into a Database<br>
</font><br>
<div id="yiv1830033195yiv1932039420">
<title></title>
Jampal writes to the windows registry using the java
preferences API.
It only uses the registry for the most recently used list
for the
"File" "Open" menu. It uses a key of
"HKEY_CURRENT_USER\Software\JavaSoft\Prefs\pgbennett\jampal".
If you
are running on Linux or Unix it uses a file in your home
directory for
this purpose instead.<br>
All other options are either written to the library file
itself or to
jampal-initial.properties in a .jampal directory that is
created in
your home directory in windows or Unix.<br>
If there are any frames that Jampal does not support or
understand, it
leaves them untouched. You can use jampal to delete
unsupported frames
but not to add or update them.<br>
The command line program tagupdate follows the same rules
and uses the
same code as the GUI.<br>
Peter<br>
<br>
<br>
<br>
On 1/10/2011 12:56 PM, John Slane wrote:
<blockquote type="cite">
<div style="color: rgb(0, 0, 0); font-size: 10pt;"><span><span>Thank
you
very much for the head-up on your program. I have
cruised through
SourceForge and other favorite resources, looking
for something like
this. I don't know how I missed it. I look
forward to giving this a
go during the coming weekend.<br>
<br>
Although I will figure it out eventually, perhaps
you can comment -- if
you have time:<br>
<br>
1) Does the program write to the Windows registry?<br>
<br>
2) mp3Gain writes (if I remember correctly) to APE
tags. Could those
be affected/corrupted in any way through use of
jampal?<br>
<br>
Once again, thanks for helping me out on this one.<br>
<br>
John<br class="yiv1830033195yiv1932039420yui-cursor">
</span></span>
<div style="font-family: inherit; font-size: 10pt;"><br>
<div style="font-family: inherit; font-size: 12pt;"><font face="Arial" size="2"><b><span style="font-weight: bold;">From:</span></b>
Peter
Bennett <a rel="nofollow" class="yiv1830033195yiv1932039420moz-txt-link-rfc2396E" ymailto="mailto:pgbennett@comcast.net" target="_blank" href="mailto:pgbennett@comcast.net"><pgbennett@comcast.net></a><br>
<b><span style="font-weight: bold;">To:</span></b>
<a rel="nofollow" class="yiv1830033195yiv1932039420moz-txt-link-abbreviated" ymailto="mailto:id3v2@id3.org" target="_blank" href="mailto:id3v2@id3.org">id3v2@id3.org</a>;
John Slane <a rel="nofollow" class="yiv1830033195yiv1932039420moz-txt-link-rfc2396E" ymailto="mailto:jaslane64@yahoo.com" target="_blank" href="mailto:jaslane64@yahoo.com"><jaslane64@yahoo.com></a>;
Chris Morton
<a rel="nofollow" class="yiv1830033195yiv1932039420moz-txt-link-rfc2396E" ymailto="mailto:salt.morton@gmail.com" target="_blank" href="mailto:salt.morton@gmail.com"><salt.morton@gmail.com></a><br>
<b><span style="font-weight: bold;">Cc:</span></b>
<br>
<b><span style="font-weight: bold;">Sent:</span></b>
Saturday,
January 8, 2011 1:44:48 PM<br>
<b><span style="font-weight: bold;">Subject:</span></b>
Re: [ID3 Dev]
Reading Tags into a Database<br>
</font><br>
<div id="yiv1830033195yiv1932039420yiv761764691">
<title></title>
You can download my program Jampal (
http://jampal.sf.net ). This
creates a library from your mp3 files. The
library can be customized to
contain any combination of mp3 frames you
specify. The libraray is a
file with extension jmp and is a csv (comma
separated text file)
encoded with UTF-8. If you can read a comma
separated file this can do
what you want. Also there is a command line
program included with
Jampal, TagUpdate, which can print the full
contents of tags, also can
update them. The print output would have to be
parsed to be usable for
importing to SQL.<br>
<br>
Peter<br>
<br>
<br>
On 1/4/2011 1:55 PM, John Slane wrote:
<blockquote type="cite">
<div style="color: rgb(0, 0, 0); font-size: 10pt;">Thanks, Chris.
Boy, those are some great sites! I haven't
yet found my answer to my
original question, but I've found lots of
other really interesting
stuff. I'll do some better digging in those
sites tonight.<br>
<br>
Again, thanks.<br>
<br>
ps. I have learned that Mp3tag can export
CSV, and that TkSQLite can
import CSV. So maybe there is a combo of
these that will create my ID3
database.<br class="yiv1830033195yiv1932039420yiv761764691yui-cursor">
<span><span></span></span>
<div style="font-family: inherit; font-size: 10pt;"><br>
<div style="font-family: inherit; font-size: 12pt;"><font face="Arial" size="2"><b><span style="font-weight: bold;">From:</span></b>
Chris
Morton <a rel="nofollow" class="yiv1830033195yiv1932039420yiv761764691moz-txt-link-rfc2396E" ymailto="mailto:salt.morton@gmail.com" target="_blank" href="mailto:salt.morton@gmail.com"><salt.morton@gmail.com></a><br>
<b><span style="font-weight: bold;">To:</span></b>
<a rel="nofollow" class="yiv1830033195yiv1932039420yiv761764691moz-txt-link-abbreviated" ymailto="mailto:id3v2@id3.org" target="_blank" href="mailto:id3v2@id3.org">id3v2@id3.org</a><br>
<b><span style="font-weight: bold;">Cc:</span></b>
<br>
<b><span style="font-weight: bold;">Sent:</span></b>
Tuesday,
January
4, 2011 1:03:33 PM<br>
<b><span style="font-weight: bold;">Subject:</span></b>
Re: [ID3
Dev]
Reading Tags into a Database<br>
</font><br>
<div id="yiv1830033195yiv1932039420yiv761764691yiv708539087">
<div><i>I don't have an answer, but
you might also try the crowds
over at:</i></div>
<div> </div>
<div>http://yabb.jriver.com/interact/index.php?PHPSESSID=8392cbc25b0419846a059bcac1e0e5a3&board=5.0</div>
<div> </div>
<div>http://anythingbutipod.com/forum/forumdisplay.php?f=23</div>
<div> </div>
<div><i>and</i></div>
<div> </div>
<div>http://forums.rockbox.org/index.php?PHPSESSID=bfbcac48f5553c499ecc8e2963cbe8e1&board=33.0</div>
<div> </div>
<div><i>> Chris</i></div>
<div> </div>
<div><br>
<br>
</div>
<div class="yiv1830033195yiv1932039420yiv761764691yiv708539087gmail_quote">On
Tue, Jan 4,
2011 at 9:54 AM,
John Slane <span dir="ltr"><<a rel="nofollow" ymailto="mailto:jaslane64@yahoo.com" target="_blank" href="mailto:jaslane64@yahoo.com">jaslane64@yahoo.com</a>></span>
wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;" class="yiv1830033195yiv1932039420yiv761764691yiv708539087gmail_quote">
<div>
<div style="color: rgb(0, 0, 0); font-size: 10pt;">I hope this
is
a
legitimate question for this
mailing list. Given the
audience, I
figured it was worth a shot.<br>
<br>
Does anyone know of a software
program (preferably free) that
will read
the ID3 tags from a Windows
folder full of mp3 files and
pump them into
something like an SQLite
database? It would be
important to also
capture the path to each file
file location.<br>
<br>
I can do this using popular
software like MediaMonkey,
since its
"Library" is an SQLite
database that contains the ID3
info and path
info for each file selected.
Songbird also creates an
SQLite DB. But
these are big programs
containing players and other
baggage. <br>
<br>
Is there something out there
that will just collect the tag
and path
info, and arrange it into a
searchable/sortable database?<br>
<br>
Thanks!<br>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<br>
</div>
</div>
</div>
<br>
</blockquote>
<br>
</div>
<br>
<br>
</div>
</div>
</div>
<br>
</blockquote>
<br>
</div>
<br>
<br>
</div>
</div>
</div>
<br>
</blockquote>
<br>
</div><br><br></div></div></div><br>
</body></html>