Jump to content

Welcome, Guest!

Be a part of CinemaVision today! Once registered and logged in, you will have access to public chat and your own private messenger, you can view and contribute guides, collaborate on the forums, review downloads, give reputation to your fellow members, contribute content and so much more. Registering is quick and completely free, so what are you waiting for?
   Sign In    Sign Up

Become a RedCarpet Club Member Today!

Lorem ipsum dolor sit amet, sea eu causae aperiri periculis, iusto affert soleat an sea, soluta petentium inciderint nec no. Dolorum reprimique ullamcorper sed ad. Ei quo malorum singulis, tota mundi feugait ut pro. Choro utamur inimicus ex sea. Tota dicit te usu. Sea ad erant possim reformidans. An modus detraxit postulant vel. Per no habeo ludus qualisque. Vix legere singulis legendos et, an cum eius soluta accumsan. Facer discere no nec.
   Join Now

Download the Kodi Add-on Today!

Lorem ipsum dolor sit amet, sea eu causae aperiri periculis, iusto affert soleat an sea, soluta petentium inciderint nec no. Dolorum reprimique ullamcorper sed ad. Ei quo malorum singulis, tota mundi feugait ut pro. Choro utamur inimicus ex sea. Tota dicit te usu. Sea ad erant possim reformidans. An modus detraxit postulant vel. Per no habeo ludus qualisque. Vix legere singulis legendos et, an cum eius soluta accumsan. Facer discere no nec.
  • 0
marlon1925

Movie Database Summary in Excel

Question

is there a way that I could get a summary of the movies I have in my kodi database in excel together with all the details? i.e. year, rating, file size, audio format, resolution, etc.?

 

Share this post


Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0
8 hours ago, marlon1925 said:

is there a way that I could get a summary of the movies I have in my kodi database in excel together with all the details? i.e. year, rating, file size, audio format, resolution, etc.?

 

So first, there are much prettier ways to get the data. There are applications that build full-on webpages will your library information. If you're just looking for Excel, here's how:

  1. Export your Kodi Library to XML by following the steps outlined here.
  2. Browse to %APPDATA%\Kodi\\userdata and copy the videodb.xml file to a new location
  3. Download the attached convert.xsl file to the same directory you copied the videodb.xml file to.
  4. Download this command line utility from Microsoft to the same directory you copied the videodb.xml file to. 
  5. Run a command prompt as Administrator.
  6. Browse to the location of the three files above in the command window.
  7. Run the following command:
    • msxsl.exe videodb.xml convert.xsl > KodiLibrary.csv
  8. Open KodiLibrary.csv in Excel.

convert.xsl

Share this post


Link to post
Share on other sites
  • 0
4 hours ago, Ragnarok said:

So first, there are much prettier ways to get the data. There are applications that build full-on webpages will your library information. If you're just looking for Excel, here's how:

  1. Browse to %APPDATA%\Kodi\\userdata and copy the videodb.xml file to a new location
  2. Download the attached convert.xsl file to the same directory you copied the videodb.xml file to.
  3. Download this command line utility from Microsoft to the same directory you copied the videodb.xml file to. 
  4. Run a command prompt as Administrator.
  5. Browse to the location of the three files above in the command window.
  6. Run the following command:
    • msxsl.exe videodb.xml convert.xsl > KodiLibrary.csv
  7. Open KodiLibrary.csv in Excel.

convert.xsl

i can only find RssFeeds.xml here: C:\Program Files\Kodi\userdata

 

I am using NAS to store my movies, does it have something to do why I couldn't find it there?

 

i also tried here: C:\Users\Omar\AppData\Roaming\Kodi\userdata

but I can only find mediasource.xml, sources.xml, etc. No videodb.xml :(

 

 

 

Edited by marlon1925
update

Share this post


Link to post
Share on other sites
  • 0
3 hours ago, marlon1925 said:

i can only find RssFeeds.xml here: C:\Program Files\Kodi\userdata

I am using NAS to store my movies, does it have something to do why I couldn't find it there?

i also tried here: C:\Users\Omar\AppData\Roaming\Kodi\userdata

but I can only find mediasource.xml, sources.xml, etc. No videodb.xml :(

I forgot to include the first step, export your Kodi Library. I updated the instructions above. :)

Share this post


Link to post
Share on other sites
  • 0
On 7/21/2016 at 2:52 PM, Ragnarok said:

So first, there are much prettier ways to get the data. There are applications that build full-on webpages will your library information. If you're just looking for Excel, here's how:

  1. Export your Kodi Library to XML by following the steps outlined here.
  2. Browse to %APPDATA%\Kodi\\userdata and copy the videodb.xml file to a new location
  3. Download the attached convert.xsl file to the same directory you copied the videodb.xml file to.
  4. Download this command line utility from Microsoft to the same directory you copied the videodb.xml file to. 
  5. Run a command prompt as Administrator.
  6. Browse to the location of the three files above in the command window.
  7. Run the following command:
    • msxsl.exe videodb.xml convert.xsl > KodiLibrary.csv
  8. Open KodiLibrary.csv in Excel.

convert.xsl

Sorry, but I couldn't find how to export to XML :(

Please bear with me.

Share this post


Link to post
Share on other sites
  • 0
9 hours ago, marlon1925 said:

Sorry, but I couldn't find how to export to XML :(

Please bear with me.

No worries. Using this link, follow the instructions laid out by team Kodi. You'll want to browse to the appropriate Videos Settings, which are referenced in the wiki article. From there it looks like you need to change your settings level to Advanced or Expert, then choose the Export video library option. If you have trouble with the export process, the folks on the Kodi forum would probably be a better resource than we will. We're stumbling through this like you are, but they wrote the software. :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

About Us

CinemaVision began in 2014 as a collaboration to create content for use with your home theater, offering movie trivia slides and video bumpers. It has since grown to be THE PREMIER WAY to create and customize your preshow experience. Download the CinemaVision add-on for Kodi today from the official Kodi repository, and easily create a sequence of trivia, videos, trailers, home automation triggers and more that will bring the experience of a movie theater straight to your screen!

×

Important Information

By using this site, you agree to our Guidelines and Terms of Use.