[User 77203]

I cant seem to find a decent way of finding my missing movies. I have a folder called movies which contain 840 movies, each in a seperate folder containing artwork, nfo's etc but when importing them into the library i only see 821.

While at work and being cheeky, i sometimes try things on xbmc before i do it at home. I've got some sample movies which ive loaded into the library and exported it as a seperate file.

I've just wrote a little .net app which reads the xml file and builds a csv file of all the movie paths.

videodb.csv

Code:

C:\Documents and Settings\ash.jones\My Documents\My Videos\Die Hard (1988)\
C:\Documents and Settings\ash.jones\My Documents\My Videos\Die Hard 2\
C:\Documents and Settings\ash.jones\My Documents\My Videos\Die Hard 3\
C:\Documents and Settings\ash.jones\My Documents\My Videos\Die Hard 4\

using a command prompt in windows i.e. good old dos.

I've went into the movies folder and ran

Code:

C:\Documents and Settings\ash.jones\My Documents\My Videos>dir *. > dir.csv

Now dir.csv looks like

Code:

Volume in drive C has no label.
Volume Serial Number is 313E-80E4

Directory of C:\Documents and Settings\ash.jones\My Documents\My Videos

07/04/2011  13:12    <DIR>          .
07/04/2011  13:12    <DIR>          ..
04/04/2011  10:55    <DIR>          Die Hard (1988)
04/04/2011  10:42    <DIR>          Die Hard 2
04/04/2011  10:42    <DIR>          Die Hard 3
04/04/2011  10:42    <DIR>          Die Hard 4
               0 File(s)              0 bytes
               6 Dir(s)  169,967,099,904 bytes free

This should make it easier for me to find whats missing, well i hope. Wont find out until i get home tonight and try it

[phear]

http://forum.xbmc.org/showthread.php?tid=90258

[User 77203]

http://forum.xbmc.org/showthread.php?tid=90258

tried it, it dont work for me

[User 77203]

kinda made it more user friendly now i.e. less work for me to do

[phear]

well fingers crossed it work for you now

[tcman47]

did you look under the bed, most of missing stuff like socks and dog toys end up under the bed, I would look there first.

[User 77203]

ha ha, found my 20 odd missing movies and now they have been added.

[chimpsinties]

Have you tried adding the movies manually? I know it's not ideal but once you know which ones they are at least then you'll have them available in your library.

I find the best way to find them if your scraper won't pick them up is to go into the Movie Information, then do a refresh and make sure the name is correct i.e. delete the .avi etc. Then add the year the film was made. This almost always finds them and adds them to your library.

[User 77203]

yes its not ideal. i got 840 odd movies and growing

Most of the errors (95%) has been naming convensions. i.e.

Hot Shots 1 (dont exist but did it for easy of file browsing)
Hot Shots 2

Gladiator (200) (not enough oo's, lol)

Forest Gump (1994) (oh rrrrr, lol)

"I Was Monty's Double" does not exist on TMDb but does on IMDb

also some martial arts movies on IMDB only picks on the original chinese title on IMDb

But once they are in i export them as seperate files so no more future errors :p

[fnc1]

try:
dir /B > mymovies.csv
this will give you bare format... no more having to edit away all the junk, when you dump it in a spreadsheet...


Now to get a list out of what you have in your database...

download sqlitespy and install it

then if your database isnt local copy it to where you installed sqllitespy
on linux it is located in: /home/xbmc/.xbmc/userdata/Database
for movies it is something like MyVideos44.db or something similar.

start SQLiteSpy
go to file > open database...
(chose the database you just copied)
in the top box you can type:
select c00 from movieview
then Execute > Execute SQL

you will have a list of all your movies...

Select (highlight all your movies)
go to Edit> Copy

open a word or xls file and paste it...

now you can combine this and the dos listing and you will have something you can compare quite quickly.