| Author |
 Topic  |
|
|
MacGyverJC
Starting Member
France
20 Posts |
 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 |
|
|
JDommi
Administrator
Germany
4645 Posts |
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. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
 |
|
|
apd
Junior Member
Greece
378 Posts |
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
Administrator
Germany
4645 Posts |
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* |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
| |
Topic |
|
|
|
Rename cover files after renumerotation tool