export data

chegroth · Post by **chegroth** » Tue Sep 20, 2005 2:40 am

Can I export data of the database to excel?
My favorite listing would be something like this:
in the first excel-row the artist,
the second excel-row the album

or maybe something similar

pah68 · Post by **pah68** » Wed Sep 21, 2005 12:47 am

Select the track list you want to export.
File > Create Reports > Selected Tracks (Excel)

You'll get the following column headers.

Artist
Album
Title
Length
Year
Genre
Bitrate
Media

If you know your way around excel you can transpose the results (provided your list {rows} isn't greater than the number of columns).

The script can be modified in C:\Program Files\MediaMonkey\Scripts\Export.vbs

chegroth · Post by **chegroth** » Thu Sep 22, 2005 2:14 am

When I do it this way, I have a large excel-file because the data of every single track is written.
What I want i only the data artist/album.
Any idea?

pah68 · Post by **pah68** » Thu Sep 22, 2005 3:34 am

You'll have to write or modify a script. Or delete everyting you don't want from the resulting spreadsheet and manipulate the data within Excel