Skip to main content ↑ ↓

Notice

Please note that most of the software linked on this forum is likely to be safe to use. If you are unsure, feel free to ask in the relevant topics, or send a private message to an administrator or moderator. To help curb the problems of false positives, or in the event that you do find actual malware, you can contribute through the article linked here.
Topic: Media Library (Read 2158 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Media Library

Over the years I've used MS Access to compile a dbase of my music collection . . . LP, CD, tape . . . . .  In the digital domain, I've also used Feurio for ripping of my CD's to HDD; and using Feurio's auto freedb search mechanism to record the particulars of each recording . . . saving these in it's own dbase.

Of late I've been trying to figure out a way to combine the two i.e. have one piece of software that maintains a dbase of my record collection, whether physical copy or e-copy.

And this brings me to foobar.  I use it for playback of my HDD based files.  Can anyone think of a means of using foobar as a component or solely for the maintenance of this single dbase that I'm considering?

Far fetched . . . I recognize that . . . but worth the query.

thanks

PS  Also open to any/all suggestions of a means of maintaining this w/o extraordinary input at my end (ex. I'd love to know enough about Access to figure how to have it query my CD drive or HDD, access freedb and put the info into tables . . . ha! ).

Media Library

Reply #1 –
Well i've never used MS access nor Feurio. You said that feurio stores metadata in it's own DB, this would be rather unfavorable since all metadata would be lost in case there is a problem with this one DB file.

Foobar also is cabable of accessing freedb (and other, more accurate DBs like doscogs or musicbrainz) and saving the metadata to the music files themself.
Also, maintaining a music library is actually one of foobars key features, and where it shines most. Though i'm not sure if this is the kind of DB you are looking for.
 

Media Library

Reply #2 –
You can use Text Tools for outputing media library to CSV for example:

  • Text Tools from foobar2000.org download page:
    Select your media library files, context menu > text tools > advanced, and than add your track pattern, i.e.:
    %artist%; %album%; %filename%; ...etc
    Then you can copy result in clipboard
     
  • Text tools from foo_utils component from foosion's page:
    Preferences > Tools > Text tools, then add the body pattern like above
    In this case you can save data directly to file, without putting huge amount of data in clipboard

This is one way run. You can not update CSV file or something like that

If you are in databases maybe you can work something out from foo_customdb, which can store custom data to sqlite database "customdb_sqlite.db" in your profile folder

If Access is the only way for you, then you can use COM automation, but reading your PS that's probably not good suggestion for you