IPB

Welcome Guest ( Log In | Register )

> foobar2000 General Forum Rules

This is NOT a tech support forum.
Tech support questions go to foobar2000 Tech Support forum instead.

See also: Hydrogenaudio Terms of Service.

 
Reply to this topicStart new topic
Is it possible to export the Library dBase to an Excell sheet?, Library view export to .xls or .xml [edit: or open w/ another program]
AndreaT
post Feb 16 2013, 08:06
Post #1





Group: Members
Posts: 84
Joined: 15-May 12
From: Italy
Member No.: 99856



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
Go to the top of the page
+Quote Post
marc2003
post Feb 16 2013, 10:29
Post #2





Group: Members
Posts: 4439
Joined: 27-January 05
From: England
Member No.: 19379



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

Go to the top of the page
+Quote Post
AndreaT
post Feb 16 2013, 21:53
Post #3





Group: Members
Posts: 84
Joined: 15-May 12
From: Italy
Member No.: 99856



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
Go to the top of the page
+Quote Post
fbuser
post Feb 16 2013, 22:42
Post #4





Group: Developer
Posts: 675
Joined: 26-September 07
Member No.: 47369



QUOTE (AndreaT @ Feb 16 2013, 21:53) *
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 (AndreaT @ Feb 16 2013, 21:53) *
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.
Go to the top of the page
+Quote Post
ojdo
post Feb 17 2013, 06:54
Post #5





Group: Members
Posts: 894
Joined: 18-June 06
From: Germany
Member No.: 31980



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
%ARTIST%;%TITLE%;%ALBUM%;%DATE%;%GENRE%;%LENGTH_SECONDS%;%ALBUM ARTIST%;%TRACKNUMBER%;%TOTALTRACKS%;%DISCNUMBER%;%TOTALDISCS%;%PLAY_COUNT%;%FIRST_PLAYED%;%LAST_PLAYED%

Group header:
CODE
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%";...].


--------------------
http://freemusi.cc/
Go to the top of the page
+Quote Post
trout
post Feb 17 2013, 15:23
Post #6





Group: Members
Posts: 421
Joined: 26-March 09
Member No.: 68400



QUOTE (ojdo) *
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.
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 28th July 2014 - 13:38