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
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
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.
Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
Twitter: https://twitter.com/conceiva_mezzmo
Web: http://www.mezzmo.com
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
Last edited by BigBob; 12-30-2012 at 03:52 PM.
Well done & thanks for sharing this.
Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
Twitter: https://twitter.com/conceiva_mezzmo
Web: http://www.mezzmo.com
Bookmarks