Exporting a text document
#1
Hi guys,

I really need to export a list of my Movie Library from XBMC into a text document. My film library is over 15tb and spans many hard drives. I'm not looking for anything flashy and I'm not looking to export it the list to the internet, or upload it to any apps, I literally just want a text document with every film in my library listed in order. I dont need anything else. I'm also on a Mac, in case that makes any difference.

Thanks a lot guys!
Reply
#2
download some sqlite browser, i'm gonna assume you use the vanilla 'sqlite3' app.

open $appdata/xbmc/Database/MyVideos<number>.db
sqlite3 MyVideos##.db

execute
.output movielist.txt
select movie.c00 from movie order by movie.c00;
.quit;

you will now have your movies sorted by title in movielist.txt

you can also use
.mode csv
.output movielist.csv
select movie.c00 from movie order by movie.c00;
.quit;

to get a csv file. if you want to import into a spreadsheet or such.
Reply
#3
Hey Ironic Monkey,

Thanks for getting back to me! I hate to say it, but i understood very little of this, are you able to offer some clarification?

What is Vanilla 'Sqlite3' and where could i get it? I assume the rest of your guide will make sense once i've got this. I did google 'Download vanilla sqlite3 in hopes of finding this mysterious software and solving the problem myself but I honestly didnt stumble across any real answers, just more questions.

Hope you're happy to help still!

Many thanks
Reply
#4
replace vanilla with 'standard' then Smile

http://www.sqlite.org/cli.html
Reply

Logout Mark Read Team Forum Stats Members Help
Exporting a text document0