Is there a way to grab a nice list of all my media?

General Discussion
#1

I was wondering if there is a good way via OSMC or Kodi (or Linux) to grab a list of all the media-files in my library.

I know how to just list them to a text-file but that gives a list with subfolders etc. and is really hard to read.

Perfect scenario would be just the basic list like you can see in the movie/browsing with “list” chosen, then you get the right name for the movies and only 1-line per movie.

#2

what info would you like to have in that one line, if you can chose from kodi libary?

#3

The title from the scraper and not the actual filename.

So this is to be used for multiple purposes, one is to easy search titles offline, another is like a backup incase a diskcrash so i know what content to remake.

#4

I’m unsure but I think sqlite3 is installed by default, else you have to install it.

Run this commands and you get a list(only valid in kodi 18.x):

sqlite3 ./.kodi/userdata/Database/MyVideos116.db "select c00, c14, c16 from movie_view where 1;" > movielist.txt

This will give you a list, with LocalMovieName, Genre, OriginalTitle

If you want to decode the c00 or other magic in you libary here is a referens page:
KodiDB and here is for the movie_view

3 Likes
#5

This could also be done with the texture cache maintenance utility, which is also useful for broader purposes. The use case in question is outlined in the following thread…

https://forum.kodi.tv/showthread.php?tid=166316

Do note that this was posted with an earlier version of Kodi and I assume the script so you may have to slightly tweak. His first example cuts off a couple character’s (that is the only one I tested) so you will have to edit the command but it works.

osmc@kodicave:~$ ./texturecache.py j movies | grep '"title":' | cut -d: -f2- | awk '{print substr($0,3,length($0)-3)}'
*batteries not included
\u00a1Three Amigos!
2 Lava 2 Lantula!
10,000 Saints
12 Years a Slave
28 Days Later
28 Weeks Later
45 Years
1922
A Beautiful Day in the Neighborhood
A Boy and His Dog

This list continued for the rest of my movies. The oddity above is the only one I noticed on quick glance. This is probably minor as movie titles with an upside down exclamation are not common.

#6

This works pretty good, the only downside is that they end up not in alphabetical order. But a copy paste into excel makes it easy to sort alphabetically. Thanks.

#7

This commans says I dont have the “texturecache.py”.

#8

sqlite3 ./.kodi/userdata/Database/MyVideos116.db "select c00, c14, c16 from movie_view where 1 order by c00;" > movielist.txt

#9

Nice, which command should I use for tv-shows, I see there are more then 1 to choose from.

#10

You need to install it

wget https://raw.github.com/MilhouseVH/texturecache.py/master/texturecache.py chmod +x ./texturecache.py

1 Like
#11

sqlite3 ./.kodi/userdata/Database/MyVideos116.db "select c00, c14, c16 from tvshow_view where 1 order by c00;"

#12

Thanks alot.

You know what, I am more than happy with how these lists turned out, it will serve the purpuse well and is very easy to update.

I used to just do it directly from the harddrives but got all the subfolders etc. and also have to do it on so many drives so this is a real step up.

Again thanks!!

1 Like