Print albums

[BigBob]

Is there any way to print or extract in a CSV file the entire Mezzmo music library or a part of it

A simple list like Artist - Album - Song

Thank's

[Paul]

Sorry - there's no way to export your entire Mezzmo library.

The only export feature in in the current version of Mezzmo (v2.7.1.0) is the ability to export a list of files as a external playlist file (.M3U, .PLS). To do this, select some files in Mezzmo and click File -> Export Media As External Playlist File.

[BigBob]

I did it.

Although it's not perfect it's enough for me.

How to do it under Windows

1- Install SQLite ODBC Driver. The Win32 is ok, you can find it at : http://www [dot] ch-werner [dot] de/sqliteodbc/
2- Create a text file with this code (you can modify SQL if you want) and replace .output C:/OutputFileName.txt with the path and filename where you want your output

.header on
.output C:/OutputFileName.txt
SELECT MGOFileAlbum.Data AS Album, MGOFileArtist.Data AS Artist, MGOAlbumArtist.Data AS AlbumArtist, MGOFileGenre.Data AS Genre, MGOFile.Title, MGOFile.FileTitle, MGOFile.BitRate, MGOFile.AudioBitrate, MGOFile.Year, MGOFile.Month, MGOFile.File FROM (((MGOFile LEFT JOIN MGOFileAlbum ON MGOFile.AlbumID = MGOFileAlbum.ID) LEFT JOIN MGOAlbumArtist ON MGOFile.AlbumArtistID = MGOAlbumArtist.ID) LEFT JOIN MGOFileGenre ON MGOFile.GenreID = MGOFileGenre.ID) LEFT JOIN MGOFileArtist ON MGOFile.ArtistID = MGOFileArtist.ID;
.output stdout
.header off

3- Open the SQLite Shell and select the Mezzmo.db file
4- Execute your text file with the command

.READ yourtextfile

5- Import in Excel (delimited with |, no quote)

It's probably easy to implement in a future version :)

[Paul]

Well done & thanks for sharing this.