INTERACT FORUM

More => Old Versions => Media Jukebox => Topic started by: bobrock on October 06, 2002, 08:23:15 am

Title: Exporting Media Library data in CSV format
Post by: bobrock on October 06, 2002, 08:23:15 am

Hi to all, sorry if this Q have been discussed before.

Is there a way to export Media Library info in CSV text format ?

I didn't find the way to do it. I would like to import Media Library data to my PDA.

Thanks in advance for advice

Title: Re: Exporting Media Library data in CSV format
Post by: Matt on October 06, 2002, 09:02:35 am

Select all the files and do a Ctrl+C (copy)

It puts the data on the clipboard in a bunch of formats.

Also, exporting to a MPL playlist (File menu -> Export) makes a tidy XML file.

Finally, you could write a custom plugin using VB or C++ to do the work.

Hopefully one of those will do the trick...

Title: Re: Exporting Media Library data in CSV format
Post by: bobrock on October 06, 2002, 10:03:11 am

Exporting Playlist works form me... Thanks!

Title: Re: Exporting Media Library data in CSV format
Post by: bobrock on November 16, 2002, 04:50:30 am

Well it seems that your suggestion doesn't solve my problem.

I'll try one again.

1. I have created a separate library which contains information about CD's (imported from CDDB) database

In addition to this I have modified Custom 1 field (in my collection this is the number of CD)

2. What i am trying to achive is export of information about all CD's in my collection.

The output of this export should have 3 fields

Custom1, Artist, Album

So the example CSV output file will looks like

1, ArtistNo.1, AlbumOfArtistNo1
.
.
.
453, ArtistNo453,AlbumOfArtistNo453

Is there a way to acomplish this with MJ 8 ?!?

Title: Re: Exporting Media Library data in CSV format
Post by: Deivit on November 16, 2002, 08:02:16 am

I'm new to MJ too and perhaps there are easiest ways, but I would try the following:

1.- Create a playlist with all your tracks
2.- Right-clicking on any of the title tabs will open the field list. Check those 3 fields you are interested in and uncheck the rest of them.
3.- Export the playlist to .hml format, checking the "export only the visible fields" option.
4.- Open the html file just created with Excel or other spreadsheet. I don't know if your PDA software can handle Excel files, if so... you're probably done. If not, you may save the excel file as .csv and export it to your PDA.

Hope this helps.