Exporting List of titles

Printable View

06-19-2017, 11:23 AM
joe33067

Exporting List of titles

Is it possible to create a CSV file from a view (or playlist) ?
06-19-2017, 11:28 AM
Peter

You can export files to a playlist from the file menu http://www.mezzmo.com/wiki/doku.php?id=export_playlist&s[]=export
06-19-2017, 04:20 PM
joe33067

Hey Peter - I actually tried that, to see what it would look like. It actually crashed Mezzmo.

I didn't actually want to export a playlist, per se', I wanted to generate a list of all titles in a format that I could use to import into Excel, like a CSV format.
06-19-2017, 04:37 PM
Peter

The Mezzmo database is sqlite so possibly you could try an excel to sqlite bridge such as https://github.com/govert/SQLiteForExcel, have not tried this so I'm not sure if it will work. You can also use an sqlite program like sqliteSpy to browse the table and export data.
06-20-2017, 12:05 AM
joe33067

Thx Peter. I'll investigate those options.
06-20-2017, 10:09 AM
ftanner

Quote:

Originally Posted by joe33067

Hey Peter - I actually tried that, to see what it would look like. It actually crashed Mezzmo.

I didn't actually want to export a playlist, per se', I wanted to generate a list of all titles in a format that I could use to import into Excel, like a CSV format.

I will second this Peter. Exporting the playlists now crashes Mezzmo consistently (every time).
06-20-2017, 10:35 AM
Peter

I tried it here and could not reproduce the crash, can you please send the crash report to support [at] conceiva [dot] com so we can investigate?
06-21-2017, 12:33 PM
ftanner

Quote:

Originally Posted by Peter

I tried it here and could not reproduce the crash, can you please send the crash report to support [at] conceiva [dot] com so we can investigate?

E-mail sent to support.
06-21-2017, 01:34 PM
Peter

Thanks, the crash report shows that the crash is occurring when loading the title of one of the files. Can you please try exporting the playlist of just one file to see if the crash occurs then if this does not crash try exporting more files until you find which file is causing the crash.
06-22-2017, 10:18 AM
ftanner

Quote:

Originally Posted by Peter

Thanks, the crash report shows that the crash is occurring when loading the title of one of the files. Can you please try exporting the playlist of just one file to see if the crash occurs then if this does not crash try exporting more files until you find which file is causing the crash.

It does this with two different playlists with two different sets of criteria. One of the playlists is for movies that are less than 720p (standard def) and one that is 720p or larger, but less than 1080p (720p high def). These two playlists do not share files.
06-22-2017, 12:11 PM
Peter

There may be corruption in the database that is causing the crash when reading the title of one of the files in each playlist, can you try just exporting one file from each playlist?
06-23-2017, 02:17 AM
ftanner

Quote:

Originally Posted by Peter

There may be corruption in the database that is causing the crash when reading the title of one of the files in each playlist, can you try just exporting one file from each playlist?

It still crashes when I do one item from one of the playlists, but not with the other one.
06-23-2017, 10:04 AM
Peter

It is probably best we get your database so we can try to reproduce it here, please go to options in Mezzmo to find the database folder then open it in Windows explorer and stop your Mezzmo media server and exit Mezzmo then add the Mezzmo.db file to a zip and send it to us via dropbox or google drive.