Personal Video Database

 Buah I hate you I was trying to avoid the subject of regex's !
 I guess you're right, I should change the regex so that it only suggest changes when it finds the EXACT same filename, and not the "or" in "american splendor" !!!
 
 If you know how to do that, I wouldn't mind you telling me.  Otherwise I will just have to hurt my brain, yet again.

 Thanks!

 What is NMM?

 Yes I am scanning several movies simultaneously, but the scanner scans the whole hard drive.

 I meant the movie, of course...

 Yes Imdb's ratings are dangereous and were able, a while ago, to make me miss good movies.
 I use a combination of ratings and sources.
 The magazine "Sight & Sound" is very good.
 Also the French magazine "Brazil" is a good source.
 One rating system that works surprisingly well for me is the rotten tomatoes one, and that's why I requested a script one that could gather these ratings.
 

 Well... some of these I have watched already and some others are not worth watching and I do not possess them anymore.
 But yes, it's still a lot I agree 

 Just wanted to report that I have now successfully transferred all 5800 movie entries from my previous corrupted database file to a new clean one.
 
 I imported all posters (VERY important step so that I don't loose hours/days of image hunting) using ImgID

 Many many thanks (for their patience and expertise) to all who helped me in this process: Buah, Nostra and Rick

 I am a happy man.

 Thanks All I will test that out when back home and keep you updated on my progress.

 Hi Rick, thanks for your patience.
 Yes I knew the ID's did not match, but this is because the image files are saved with the INTERNAL ID and not the ID's.
 So the image files are like: terminator_Internal ID.jpg
 And ImgID actually works with these for my corrupted database.
 Unfortunately, and I have checked it, the new database does not assign the same Internal ID's to the movies. And I have no way to import the Internal ID's into the new database.

 Anyway I see what you want me to do, and I have done everything right up to the point where I have asked you how to rename my files after you suggested it.
 The ID's are exactly the same from my new and my old database.
 
 So the file I had posted for you to look at are showing the right posters files generated from the old database.
 
 Basically my question can be summarized as this:

 How can I change the name of thousands of files like these:
 movie titles_Internal ID.jpg
 to
 ID.jpg
 when possessing a list of ID's linked to the movies titles?

 The two lists I had posted are the list I would like to use to link up all.

 As you can see, it's not a matter of removing the "movie titles_" part of the image files, as the number displayed is not the ID.

 Thanks again



 

 Yes the two steps are a good suggestion thanks.
 
 

Then export only list of entries with posters, edit it in Excel, and you should find out the name of the column

 I have tried that but no export seem to give me any image path, unless I have to build it with the export manual that Nostra has put together?
 Still, I cannot find any import field (in the configuration menu for the import plugins) that could even resemble an image path...
 
 

 Sounds good thanks Buah.
 This is not going to be simple as some of my movies do not have a poster file, and also the alphabetic order is not perfect...
 
 Also, what is the name of the "image path" in the import plugin? I can't find it in the list available.

 Hi me again sorry for all the posts but problems are piling up...
 
 Before I describe the problem let me describe the method I am following.
 PVD won't import an XLS file for an unknow reason and would give me an error everytime I try.
 So I am using CSV import instead and it works.

 I basically create an xml exportd file from my corrupted database, convert it into a csv file, delete the columns/fields that i do not need to import in the new database.
 Then when I import the csv file in the new database, for some reason the "file path" field gets populated with the field that is just before it in the csv file!

 I even tried to create a csv file that is two columns only, ID and File path.
 When I import (after having modified the csv import to limit it to ID and Path), the File path gets populated with the ID number!!

 I'm going crazy here, the delimiter is fine, the csv import configuration corresponds to the csv file and yet it does not take the path.

 Am I missing something here?
 aaaarh I need some fresh air.