English > Support

Just migrated from Movie Collector, how to transfer 1000 covers?

(1/2) > >>

Marc:
Hi,

I've been using Movie Collector for a few years, but they are charging way too much for very little, so I decided to move to something better: PVD. I managed to export my thousand DVD's to TXT, convert that to Excel, and then import the collection to PVD. However, I can't seem to find a way to import the covers? In Movie Collector the covers are stored in a folder, and every movie points to the location of the cover in that folder. I have exported this path along the other movie details I wanted, but it seems PVD doesn't work this way? I managed to get PVD to not only store the image in the database, but also in a folder. Is it possible to put all my covers in that folder and convert my Movie Collector paths to PVD paths?

I hope I don't have to manually add them all. Most of them can't be downloaded from Amazon (I have alot of Asian and Dutch DVD's).

rick.ca:
Welcome, Marc.

The Images by ID utility described here is what you're looking for. You will need to assign ID's using the Reindex movies tool. Hopefully, you've imported the poster location. If you haven't, you will need to do so. Then export ID and poster location to Excel, and use this to create a DOS batch file that will rename all your posters to ID (i.e., rename [full pathname of poster] [ID].jpg).

Before importing, make sure Preferences - Miscellaneous - Save images in database is not set. When using the utility, set the Thumbnails folder to something different than the Image folder (or the images will be overwritten by thumbnails). After successfully importing, I recommend then setting Save images in database.

I tested this undocumented utility for the first time just now and found it a bit tricky, so please practise on a copy of your database until you're sure you've got it right. Good luck!

Marc:
Thank you for the suggestion. I will download the plugin and see if I can sort it out. I'll post back here with the results.

Marc:

--- Quote from: rick.ca on July 28, 2009, 09:02:37 pm ---Then export ID and poster location to Excel, and use this to create a DOS batch file that will rename all your posters to ID (i.e., rename [full pathname of poster] [ID].jpg).

--- End quote ---

I could use a little help with that, never done that before. I have the excel file with all ID's and paths to the posters. I now need to rename the posters to their corresponding ID's, using a DOS batch file which reads the data from the Excel file? How would I do that?

rick.ca:
This message should point you in the right direction. Note that fields are now referred to by name, rather than number.

Navigation

[0] Message Index

[#] Next page