12. Is it possible to add posters with this utility regarding my situation at all?
I believe so, but it's been a long time since I've used it, so I'm going to assume you can figure out the details...
13. Is it possible to add more than one poster for a single entry with this utility?
...like this one, for example. I doubt it. I'll also assume the utility requires the ID be used to identify the movie.
But more importantly, I don't know if it still works after the recent change to the structure of the ID.9. Imported from where to where? How?
Originally, I meant import the image pathnames into a custom field so you could use them later for an image import. But you can do both steps now. I don't know how you've named your image files, but I assume you have some way of matching them up to what's in the database (e.g.,
Title and
Year).
0. Backup!!! Database and external images.
1. Export a movie list to Excel, including ID and whatever you need to match the image filenames.
2. Create a list of image pathnames and import those into Excel.
3. Re-index your ID's, and export again.
4. Combine all three lists in Excel, so for each movie you have the new sequential ID, the old ID, and the image pathname. Combine these to create the command
rename <image pathname> <path>\<ID>.jpg. Copy this column to a text file, rename the file with a .BAT and run it.
5. Use the utility to import the images.
6. Import your Excel file to replace the re-indexed ID's with the old ones.
7. [Optional] Use the Excel worksheet to create another batch file that will rename the image to <movie pathname>.jpg. Even though they're in the database, I like having posters "beside" the movie files so I can see them in the file system as well.
There are, of course, variations that will also work. If your nervous about messing up your existing ID's, for example, you could do a similar process on just those—without changing the ID's. And then deal with the other 138 separately. Or even better, export only those, assign unique ID's and re-import.
