I have set up all my movies in XBMC and wanted to clean the library from movies which I’ll likely never watch. My idea is to export the library to plain text CSV format, read the file with Excel, filter for crappy IMDB ratings and remove the movies files. Here is how:
- Export your library to a single file from XBMC. The file likely ends up in
C:\Documents and Settings\Administrator\Application Data\XBMC\userdataand is calledvideodb.xml. - Convert the XML file to something Excel can read.
- Download the XSL file which sets the conversion format.
- Convert the file with a command line utility from Microsoft. Open a command window and use
msxsl.exe videodb.xml convert.xsl > movies.csv
- Read
movies.csvwith Excel and analyze to taste. - You’re done.
This is great — almost exactly what I’ve been looking to do for a long time! Thanks!
How would I go about extracting information like ‘video codec’ or ‘audio codec’ or ‘aspect’? (I guess I have to take a look at the XSL syntax on a Microsoft site someplace, but if you had any quick-and-dirty information I could add to ‘convert.xsl,’ I’d appreciate it.)
+1 one on this too, it be great to know the resolution of the video. Thanks for this info though.
If you still need help figuring that out. Please note that if you have movies like i,Robot you might want to open the file in notepad then past the contents into Excel then do Text-to-Columns (“;”). As if you have commas in the titles it will do interesting things when directly opening the CSV in excel.
Just save this into the Convert.xsl I used Notepad++ to make the edits as it is a good editor and it is free. Hope this helps you. It will let you know all the audio formats and video if you have more then one in the video file.
Don’t worry about the code not being tabbed for easier reading as that is purely to allow people to read it easier the computer could care less.
#—————————————————————————————————–
# Copy the Below Text
Title;Year;IMDB Rating;Genre;Path and Filename;Codec;aspect;width;height;codec;channels
;
;
;
;
;
;
;
;
;
;
;
It didn’t like the code so here is a link to the file:
https://onedrive.live.com/redir?resid=B003924390CA1206%212017
I just wanted to chime in and thank you for this also! I needed both this exact thing and the same for TV shows. The xsl file was clean and easy to edit for my needs to give me one file for my movies and one for my tvshows, thank you again!