Export HTML List of Movies/TV shows

Hi, i'm trying to export an HTML list of movies and music from the XBMC Library
similar to how winamp exports all my music to an HTML File.

I have approximately 500 DVD movies and 500 Blu Ray movies and about 1000 TV Episodes

I would like to make an in depth list of every movie with like the DVD Covers and all the metadata for each and every movie.. I understand that for 1,000 movies that it will be very very very long list, but that is what i want.


I also have about 70,000 songs that i would make to make a list of

Winamp only allows me to export a list of my music through the playlist editor and the playlist editor only has

Artist - Song - Length

Whereas in the Winamp Media Player i have all the ID3 Information for every single one of my 70,000 songs

I would like to make an HTML list with ALL OF THE ID3 Information such as

Artist - Album - Track Number - Track - Length - Bitrate - Genre

Is there anyway to do this through XBMC? I am very new to XBMC and have hardly ever used it, but i do have all of my movies and all of their metadata listed within XBMC.

Is there some sort of add-on i can download to export a list, preferably an HTML list?

Thank you

Bump...

There's no way to export a list of files through xbmc? really know one has the answer to this?

I'm not aware of any add-on that will allow you to do this but you could write some sql queries and query the databases directly and get the info you want. The default database is sqlite and you can use razorsql or similar to build some queries. I use a mysql database so can't give you any experience in using this tool.

Its also the done thing to wait 24 hours before bumping your own post

Yes well i'm not exacting trying to "write sql queries" to gain the information i want.

I am looking for a way that's already been acheieved through either an add-on or built into the program

If there is no way to do this through the program (which i find hard to believe considering the dozens of add-ons which are much more complicated and advanced in nature)

Does anyone know of any seperate programs that create HTML or even a Text file listing all my movies?

Try this program:

Eric's Movie Database
http://www.emdb.tk/

It'll export your movie list to text, html, or csv files. Best of all it's free.

(2011-09-15 16:07)Pulazki Wrote:  Yes well i'm not exacting trying to "write sql queries" to gain the information i want.

I am looking for a way that's already been acheieved through either an add-on or built into the program

If there is no way to do this through the program (which i find hard to believe considering the dozens of add-ons which are much more complicated and advanced in nature)

Does anyone know of any seperate programs that create HTML or even a Text file listing all my movies?

Well I use Powershell and xsl to output all the info to a xhtml page....
Works for me.

The Skipman

It's quite easy to export your XBMC movie database in CSV format, then just open in Excel and Save As HTML format.

To do this:

• FTP to your XBMC machine (Google it if you don't know how)
• navigate to XBMCs database folder (in my case on XBMCLive that is /home/myname/.xbmc/userdata/Database)
• Download a copy of your movie database file (in my case MyVideos34.db).
• This file stores all the good stuff about your movies & TV shows. It's a SQLite database file - a very simple, lightweight database with tables, views & records. Make a backup copy of this file, and work on the copy just in case you muck it up (even if you did destroy the downloaded *.db file, you can always FTP a fresh copy over from your XBMC box and start again).
• Install the Firefox SQLite Manager plugin for Firefox browser. This is a cross-platform SQLite database editor, which you can use to export your movie information. It's super-fast. It ran my queries in < 1 second and exported > 8,000 records to CSV files in ~2 seconds.
• Open the SQLite Manager using Firexfox. I have Mac OSX and it's under the Tools menu.
• From SQLite Manager open your XBMC database file. From the Database menu choose "Connect Database" and navigate to your *.db file. You'll need to change the "Format" drop-down list to "All formats" (because it expects a *.sqlite file, not a *.db file). When the XBMC *.db SQLite database file is open you will see the tables and views listed on the left panel.
• On the right panel click the "Execute SQL" tab and type in the following 2 queries to grab movie and tv show information (table columns) that you'd typically be interested in. Feel free to customise the queries. You may find that your database column names are slightly different if you have a different version of XBMC. I'm running XBMC version 10.
  

SQL to get Movies:
select movie.c00 as "Movie Name", movie.c07 as Year, movie.c14 as Genre, movie.c21 as Country, movie.c01 as "Plot", movie.c02 as "Short Plot", movie.c03 as Byline, movie.c05 as Rating, movie.c04 as "No. Votes", movie.c15 as "Director(s)", movie.c06 as "Producer(s)", movie.c12 as "MPAA Rating", movie.c09 as "IMDB ID", files.playCount as "Play Count" from movie join files on files.idFile=movie.idFile order by "Movie Name" limit 10000

SQL to get TV Shows
select tvshow.c00 as "TV Show", episode.c12 as "Season No.", episode.c13 as "Episode No.", episode.c00 as "Episode Title", episode.c03 as "Episode Rating", episode.c01 as "Episode Plot", files.playCount as "Play Count", tvshow.c01 as "Show Synopsis", tvshow.c04 as "Show Rating", tvshow.c08 as Genre, tvshow.c14 as Network, tvshow.c13 as Channel, episode.c05 as "First Shown", episode.c04 as "Director(s)"
from episode join files on files.idFile=episode.idFile join tvshowlinkepisode on episode.idepisode=tvshowlinkepisode.idEpisode join tvshow on tvshow.idShow=tvshowlinkepisode.idShow
order by tvshow.c00 asc, episode.c12 asc limit 10000

I've limited the results to 10000 rows max. Increase that if you have more records/movies.

Then, once each query runs, simply export the results to CSV file by clicking the "Actions" drop-down list, then choose "Save Result (CSV) to File". Open the exported file in Excel, then save to HTML format.

WHAMMY! You're done

Enjoy.

If all this seems a bit too complicated, EMM (Ember Media Manager, should be a link in these forums) will output to HTML with most of the metadata and cover. I don't think it will do anything for your TV shows or music though.

Add-on:XWMM can export the library to HTML as well.

(2012-09-29 13:27)jason.elliott Wrote:  It's quite easy to export your XBMC movie database in CSV format, then just open in Excel and Save As HTML format.
...

easy as pie!
thats what i'm looked for!
thx!