Movie Database Summary in Excel

[marlon1925 4]

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.?

 

[Ragnarok 198]

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

[polargeek 44]

You are probably better off asking that over at the Kodi forums. 

[marlon1925 4]

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 July 21, 2016 by marlon1925
update

[Ragnarok 198]

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.

[marlon1925 4]

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.

[Ragnarok 198]

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.