[ID3 Dev] Reading Tags into a Database

Peter Bennett pgbennett at comcast.net
Mon Jan 10 17:36:32 PST 2011

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.
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.
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.
The command line program tagupdate follows the same rules and uses the 
same code as the GUI.

On 1/10/2011 12:56 PM, John Slane wrote:
> 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.
> Although I will figure it out eventually, perhaps you can comment -- 
> if you have time:
> 1) Does the program write to the Windows registry?
> 2) mp3Gain writes (if I remember correctly) to APE tags.  Could those 
> be affected/corrupted in any way through use of jampal?
> Once again, thanks for helping me out on this one.
> John
> *From:* Peter Bennett <pgbennett at comcast.net>
> *To:* id3v2 at id3.org; John Slane <jaslane64 at yahoo.com>; Chris Morton 
> <salt.morton at gmail.com>
> *Cc:*
> *Sent:* Saturday, January 8, 2011 1:44:48 PM
> *Subject:* Re: [ID3 Dev] Reading Tags into a Database
> 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.
> Peter
> On 1/4/2011 1:55 PM, John Slane wrote:
>> 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.
>> Again, thanks.
>> 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.
>> *From:* Chris Morton <salt.morton at gmail.com> 
>> <mailto:salt.morton at gmail.com>
>> *To:* id3v2 at id3.org <mailto:id3v2 at id3.org>
>> *Cc:*
>> *Sent:* Tuesday, January 4, 2011 1:03:33 PM
>> *Subject:* Re: [ID3 Dev] Reading Tags into a Database
>> /I don't have an answer, but you might also try the crowds over at:/
>> http://yabb.jriver.com/interact/index.php?PHPSESSID=8392cbc25b0419846a059bcac1e0e5a3&board=5.0
>> http://anythingbutipod.com/forum/forumdisplay.php?f=23
>> /and/
>> http://forums.rockbox.org/index.php?PHPSESSID=bfbcac48f5553c499ecc8e2963cbe8e1&board=33.0
>> /> Chris/
>> On Tue, Jan 4, 2011 at 9:54 AM, John Slane <jaslane64 at yahoo.com 
>> <mailto:jaslane64 at yahoo.com>> wrote:
>>     I hope this is a legitimate question for this mailing list. 
>>     Given the audience, I figured it was worth a shot.
>>     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.
>>     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.
>>     Is there something out there that will just collect the tag and
>>     path info, and arrange it into a searchable/sortable database?
>>     Thanks!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.id3.org/pipermail/id3v2/attachments/20110110/242c3402/attachment.html>

More information about the ID3v2 mailing list