<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    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: <a class="moz-txt-link-freetext" href="http://www.muzikbrowzer.com/dl/id3.zip">http://www.muzikbrowzer.com/dl/id3.zip</a> (requires id3lib)<br>
    mbtag.exe <a class="moz-txt-link-freetext" href="http://www.muzikbrowzer.com/dl/mbtag.zip">http://www.muzikbrowzer.com/dl/mbtag.zip</a> (no installer,
    just a command line exe)<br>
    <br>
    mbtag.exe also comes along with Muzikbrowzer when you install it
    <a class="moz-txt-link-freetext" href="http://www.muzikbrowzer.com/">http://www.muzikbrowzer.com/</a><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 class="moz-txt-link-abbreviated" 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 cite="mid:307442.46697.qm@web31602.mail.mud.yahoo.com"
      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="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"><b><span style="font-weight: bold;">From:</span></b>
              Peter Bennett <a class="moz-txt-link-rfc2396E" href="mailto:pgbennett@comcast.net"><pgbennett@comcast.net></a><br>
              <b><span style="font-weight: bold;">To:</span></b> John
              Slane <a class="moz-txt-link-rfc2396E" href="mailto:jaslane64@yahoo.com"><jaslane64@yahoo.com></a><br>
              <b><span style="font-weight: bold;">Cc:</span></b>
              <a class="moz-txt-link-rfc2396E" href="mailto:id3v2@id3.org">"id3v2@id3.org"</a> <a class="moz-txt-link-rfc2396E" 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="yiv1932039420">
              <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="yiv1932039420yui-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 moz-do-not-send="true"
                          rel="nofollow"
                          class="yiv1932039420moz-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 moz-do-not-send="true" rel="nofollow"
                          class="yiv1932039420moz-txt-link-abbreviated"
                          ymailto="mailto:id3v2@id3.org" target="_blank"
                          href="mailto:id3v2@id3.org">id3v2@id3.org</a>;
                        John Slane <a moz-do-not-send="true"
                          rel="nofollow"
                          class="yiv1932039420moz-txt-link-rfc2396E"
                          ymailto="mailto:jaslane64@yahoo.com"
                          target="_blank"
                          href="mailto:jaslane64@yahoo.com"><jaslane64@yahoo.com></a>;
                        Chris Morton
                        <a moz-do-not-send="true" rel="nofollow"
                          class="yiv1932039420moz-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="yiv1932039420yiv761764691">
                        <title></title>
                        You can download my program Jampal (
                        <a class="moz-txt-link-freetext" href="http://jampal.sf.net">http://jampal.sf.net</a> ). 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="yiv1932039420yiv761764691yui-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 moz-do-not-send="true"
                                    rel="nofollow"
                                    class="yiv1932039420yiv761764691moz-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 moz-do-not-send="true"
                                    rel="nofollow"
                                    class="yiv1932039420yiv761764691moz-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="yiv1932039420yiv761764691yiv708539087">
                                  <div><i>I don't have an answer, but
                                      you might also try the crowds
                                      over at:</i></div>
                                  <div> </div>
                                  <div><a class="moz-txt-link-freetext" href="http://yabb.jriver.com/interact/index.php?PHPSESSID=8392cbc25b0419846a059bcac1e0e5a3&board=5.0">http://yabb.jriver.com/interact/index.php?PHPSESSID=8392cbc25b0419846a059bcac1e0e5a3&board=5.0</a></div>
                                  <div> </div>
                                  <div><a class="moz-txt-link-freetext" href="http://anythingbutipod.com/forum/forumdisplay.php?f=23">http://anythingbutipod.com/forum/forumdisplay.php?f=23</a></div>
                                  <div> </div>
                                  <div><i>and</i></div>
                                  <div> </div>
                                  <div><a class="moz-txt-link-freetext" href="http://forums.rockbox.org/index.php?PHPSESSID=bfbcac48f5553c499ecc8e2963cbe8e1&board=33.0">http://forums.rockbox.org/index.php?PHPSESSID=bfbcac48f5553c499ecc8e2963cbe8e1&board=33.0</a></div>
                                  <div> </div>
                                  <div><i>> Chris</i></div>
                                  <div> </div>
                                  <div><br>
                                    <br>
                                     </div>
                                  <div
                                    class="yiv1932039420yiv761764691yiv708539087gmail_quote">On
                                    Tue, Jan 4,
                                    2011 at 9:54 AM,
                                    John Slane <span dir="ltr"><<a
                                        moz-do-not-send="true"
                                        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="yiv1932039420yiv761764691yiv708539087gmail_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>
  </body>
</html>