Skip to main content

Topic: Is it possible to export the Library dBase to an Excell sheet? (Read 1261 times) previous topic - next topic

0 Members and 1 Guest are viewing this topic.
  • AndreaT
  • [*][*]
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

  • marc2003
  • [*][*][*][*][*]
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


  • AndreaT
  • [*][*]
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

  • fbuser
  • [*][*][*][*][*]
  • Developer
Is it possible to export the Library dBase to an Excell sheet?
Reply #3
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.

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.

  • ojdo
  • [*][*][*][*][*]
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%";...].

  • trout
  • [*][*][*][*]
Is it possible to export the Library dBase to an Excell sheet?
Reply #5
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.
~ Sorry for my bad english.