XBMC Duplicate Files

[Dolby]

My movies are (supposed) to be listed in my directory like this :

C:\ants\ant.mkv
C:\toy story\toy story.mkv
C:\lethal weapon\lethal weapon.mkv

I point XBMC to the directory and it sees 3 movies and downloads coverart etc for them. However, sometimes I have two formats of movie files (by mistake) in the folders, like this :

C:\ants\ant.mkv
C:\ants\ant.mov
C:\toy story\toy story.mkv
C:\lethal weapon\lethal weapon.mkv
C:\lethal weapon\lethal weapon.avi

So if I point to XBMC now, it registers 5 movies instead of the 3 - and when browsing title on XBMC I'll see duplicates.

Anyway to see which directory has the same name, but different format, movies so that I can delete?

 

[Bull1012]

There may be an easier way, but this the way that I normally do it.

I use the cmd command: dir /s/b > test.txt
Export the entire directory to a .txt file
From there I open this in Excel
Once in excel its easy to manipulate the information

Insert a column, add the number 1
Insert a pivot, and you can see any folder that has 2 entries has two movies

 

[Dolby]

Ah nice!

I'll try that when home, thanks!

 

[grok]

I sometimes interact directly with the XBMC db using SQLiteSpy, usually to fix taglines or incomplete scraped data, but executing this query will give you the names and count of duplicate movie names in XBMC.

select c00, count(*) from movie
group by c00 having count(*) > 1

c00 is the movie name column, you can also use c09 which is the IMDB tag or c22 which is the folder name column according to your needs.

 

[Dolby]

I wouldn't even know how to start :/

 

[AstroTurf]

I just put xbmc on the one side and explorer on the other then hunt the duplicates down and kill them (my drive is indexed though so quick and easy to do).

 

[ponder]

http://www.techsupportalert.com/best-free-duplicate-file-remover.htm

Or boot from a ubuntu livecd, install fslint and run it.

 

[backstreetboy]

Plex will show your duplicates with a little number like so from there you just use explorer to go kill it. My music collection on the other hand is a mess will need to look at www.nirsoft.net Something like http://www.nirsoft.net/articles/find_duplicate_files.html

 

[Dolby]

There may be an easier way, but this the way that I normally do it.

I use the cmd command: dir /s/b > test.txt
Export the entire directory to a .txt file
From there I open this in Excel
Once in excel its easy to manipulate the information

Insert a column, add the number 1
Insert a pivot, and you can see any folder that has 2 entries has two movies

How do I do this on a network drive ?

 

[HAL 9000]

Try moving all your individual movie folders off the root directory of your drive (C:\) to a common folder, e.g. C:\Movies and see if the issue is resolved.

I never store large amounts of data folders in the root, but put them into a sub-folder instead.

 

[Pho3nix]

Plex will show your duplicates with a little number like so View attachment 146962 from there you just use explorer to go kill it. My music collection on the other hand is a mess will need to look at www.nirsoft.net Something like http://www.nirsoft.net/articles/find_duplicate_files.html

Aren't the numbers to show the number of episodes you haven't watched?