| T O P I C R E V I E W |
| MacGyverJC |
Posted - 29 Jan 2012 : 19:25:28
Hi,
Sorry for my poor english ;-)
After the use of the tool ReNumerotation without hole, covers aren't renamed.
You could use something like this:
SELECT Movies.MovieID, Movies.Title, Movies.Cover, InStr(1,[Cover],CStr([MovieId]),False) AS FileChanged, [MovieId] & "-" & [Title] & ".jpg" AS GoodFile, "ren """ & [cover] & """ """ & [goodfile] & """" AS RenameFiles
FROM Movies
WHERE (((Movies.Cover)<>"") AND ((InStr(1,[Cover],CStr([MovieId]),False))=0));
I've pasted all the values from RenameFiles and execute a batch file.
and
UPDATE Movies SET Movies.Cover = [MovieId] & "-" & [Title] & ".jpg"
WHERE (((Movies.Cover)<>"") AND ((InStr(1,[Cover],CStr([MovieId]),False))=0));
You could perhaps do better ;-)
Bye |
| 3 L A T E S T R E P L I E S (Newest First) |
| JDommi |
Posted - 29 Jan 2012 : 23:22:30
Well, I'm Old School. I watch only a few movies on PC. That's all...
The only luxury I have is a MediaHD that's for 99% used by my wife and the children *lol* |
| apd |
Posted - 29 Jan 2012 : 23:11:00
Hey could you consider this idea for an upgrade? It would be valuable for anyone using a WDTV. This device has a mode to show covers instead of titles. To do so, it needs the image file to be in the exact same name as the video file with ext .jpg. I guess everyone has their own naming conventions, so what I think would work for most is the ability to export one image file per movie, according to fields/rules, like [Director] - [Title] - [Year].jpg (Auto resizing to the proper dimensions would be a great extra). Exported jpgs should be placed as copies in a user defined folder to be moved to the proper external HDDs. |
| JDommi |
Posted - 29 Jan 2012 : 20:11:21
Thanks for this workaround!
You can also use the CoverManager plugin (not the internal one of XMM) to adjust the picture names to the new movie id. |
|
|
