I noticed with a lot of the scraper scripts there was still a lot of missing certification information and in some cases, the US rating was being imported even when the UK rating option was selected (imdb+). In most instances, the site being scraped simply does not have the UK rating available.
This small app will allow you to load up your MovingPictures database file and search and convert certificate ratings based on your preferences. It is also possible to search for movies with missing certifications and populate them manually.
![Screenshot2.png Screenshot2.png](https://forum.team-mediaportal.com/download/2013/02/thumb/168048_Screenshot2.png)
To use, simply download the attached zip file, extract the two files to any location and run the DBCertRenamer.exe. All changes are displayed for review before having to commit to the change so you can see what is actually going to be edited (and cancel if the results are not as expected) and a backup of the database is taken before every update.
UK BBFC Certification Logos (including higher res images) can be found here - BBFC Certs
Changelog
1.0.2
- Added option to blanket rename 12 certs to 12A or 12A certs to 12 (UK Cinema ratings are always 12A. 12 Only exists for Home Video - I prefer the cinema ratings)
- Added changes previews so all updates can be reviewed before committing to the update (with the option to cancel the update)
- Fixed the movie counts at the bottom of the preview windows
1.0.1
- Tided up the UI and auto populated the selections to make it quicker to use
- Added an option to retrieve and display all movie entries with no certification and allow them to be edited and saved manually
- Time stamped the backups
1.0.0
- First release
This small app will allow you to load up your MovingPictures database file and search and convert certificate ratings based on your preferences. It is also possible to search for movies with missing certifications and populate them manually.
![Screenshot1.png Screenshot1.png](https://forum.team-mediaportal.com/download/2013/02/thumb/168047_Screenshot1.png)
![Screenshot2.png Screenshot2.png](https://forum.team-mediaportal.com/download/2013/02/thumb/168048_Screenshot2.png)
To use, simply download the attached zip file, extract the two files to any location and run the DBCertRenamer.exe. All changes are displayed for review before having to commit to the change so you can see what is actually going to be edited (and cancel if the results are not as expected) and a backup of the database is taken before every update.
UK BBFC Certification Logos (including higher res images) can be found here - BBFC Certs
Changelog
1.0.2
- Added option to blanket rename 12 certs to 12A or 12A certs to 12 (UK Cinema ratings are always 12A. 12 Only exists for Home Video - I prefer the cinema ratings)
- Added changes previews so all updates can be reviewed before committing to the update (with the option to cancel the update)
- Fixed the movie counts at the bottom of the preview windows
1.0.1
- Tided up the UI and auto populated the selections to make it quicker to use
- Added an option to retrieve and display all movie entries with no certification and allow them to be edited and saved manually
- Time stamped the backups
1.0.0
- First release
Attachments
Last edited: