I understand now. I thought you were referring to the user score on Metacritic and not IMDb. Merging the two fields automatically would indeed require a custom version of the plugin that you would need to modify the code and rebuild with Xcode.
What is slightly easier is to periodically merge the Metacritic score into the user rating score when that one is empty. You would use the SQL backend for this and it would be with a program called Terminal in /Application/Utilities.
1. Quit DVDpedia
2. Make a copy of your database file as a backup, it's located in ~/Library/Application Support/DVDpedia/Database.dvdpd.
3. Open the program named Terminal in /Application/Utilities
4. Copy paste the four following commands (update custom1 to match the number of the custom field that you renamed to "Metacritic"):
- Code: Select all
sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
UPDATE zentry SET zcustom1 = zaverageRating WHERE zcustom1 = NULL || zcustom1 = '';
.exit
That code copies the contents of average rating to custom one were custom one is empty. Running this code after a large import of movies will merge the user score into the Metacritic score when not set. Letting use only the meta critic column.
I updated DVDpedia beta to be able to receive a reload command, which means you can put the above into an Automator Service script and have it as a menu command from DVDpedia.
Read this post on how to do that, you can use these service and open it up and replace the SQL command in the service with the
UPDATE command.above