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: Is it possible to export the Library dBase to an Excell sheet? (Read 2277 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Is it possible to export the Library dBase to an Excell sheet?

Hello Friends,

I am happily using Foobar since a year so far, and I have now a quite large library that I would like to carry along with me (on a USB disk) and view/access and print as I will need.

My first idea is to export the actual Library View (by Folder Structure) to an Excel or to an XML document.


Anybody know how to do that?

Have you better suggestions for me to accomplish what I would do? (Alway be able to access/view my actual library from a doc/dBase on a portable USB disk withtout having Foobar running)

Thanks and regards,
Andrea

Is it possible to export the Library dBase to an Excell sheet?

Reply #1 –
you can create your own text files using foo_utils. you'd have to add all music to playlist and then use the context menu for it to export data about the selected tracks.

http://foosion.foobar2000.org/components/?id=utils

 

Is it possible to export the Library dBase to an Excell sheet?

Reply #2 –
Hello Marc,
thanks for your tip, however, I suppose it doesn't do what I want (Excel sheet or XML structured file).
A simple text file could not be structured and easy to use as I would.

So, I place here another question: how to open/read the native foobar database.dat?

Thanks again
Regards, Andrea

Is it possible to export the Library dBase to an Excell sheet?

Reply #3 –
Quote from: AndreaT on
thanks for your tip, however, I suppose it doesn't do what I want (Excel sheet or XML structured file).
A simple text file could not be structured and easy to use as I would.
But you could create a CSV file, which can be imported to Excel. And actually you can also create a XML file with foo_utils. It's only up to you to export the correct structure.

Quote from: AndreaT on
So, I place here another question: how to open/read the native foobar database.dat?
The foobar2000 SDK provides means to access the media library, which means you need to write a plugin, if you can't achieve what you want with foo_utils. If you don't want to write a plugin you can utilize WSH Panel Mod and write a JScript or VBScript program for your purpose.

Is it possible to export the Library dBase to an Excell sheet?

Reply #4 –
Just a pointer for usage of foo_utils, as I regularily create large CSV exports of my library with it. If you need field captions, you are limited to a single preset, accessible via the "Advanced..." context menu entry. There you can enter someting like this:

Track pattern:
Code: [Select]
%ARTIST%;%TITLE%;%ALBUM%;%DATE%;%GENRE%;%LENGTH_SECONDS%;%ALBUM ARTIST%;%TRACKNUMBER%;%TOTALTRACKS%;%DISCNUMBER%;%TOTALDISCS%;%PLAY_COUNT%;%FIRST_PLAYED%;%LAST_PLAYED%

Group header:
Code: [Select]
Artist;Title;Album;Date;Genre;Length;Album artist;Track;Total tracks;Disc;Total discs;Play count;First played;Last played

Multi-value tags are splitable if you don't have commas (,) in tag values. However, semicolons (;) must be - depending on the subsequent parser - escaped [$replace(%tag%,;,\;)] or wrapped in quotes [....;"%tag%";...].

Is it possible to export the Library dBase to an Excell sheet?

Reply #5 –
Quote from: ojdo on
accessible via the "Advanced..." context menu entry

Actually this is referring to "Text Tools" (foo_texttools), a component with nearly identical function to the "Text tools" feature of the multifunctional foo_utils. Either component is capable of the purpose at hand.