Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country

Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country (/showthread.php?tid=367887)

Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country - tinkster - 2022-04-16

Hi,

I wasn't sure about which of the subforums to ask this in, apologies if this is the wrong place; please point me at the right spot if this doesn't work.

The country I live in isn't listed in the list of countries that certifications are available for. It defaulted to US, but those don't align well with what I need.
I changed it to DE - how do I make the database pull in the certifications for the changed country for all titles?

Thanks!
Tink

RE: Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country - Karellen - 2022-04-16

(2022-04-16, 03:01)tinkster Wrote: I changed it to DE - how do I make the database pull in the certifications for the changed country for all titles?

You need to rescrape the movies again. There is no option to partially scrape.

Here are some other methods:

1. Install the Metadata Editor addon from the repo, and you can edit each rating individually...
Settings>Add-ons>Install from repository>Program add-ons>Metadata Editor
https://forum.kodi.tv/showthread.php?tid=349035

2. Use NFO Files and edit the following tag <mpaa></mpaa>
Looks like this when edited correctly... <mpaa>Australia:M</mpaa>

3. Directly edit the database if you are comfortable with SQL

RE: Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country - tinkster - 2022-04-16

(2022-04-16, 03:05)Karellen Wrote:
(2022-04-16, 03:01)tinkster Wrote: I changed it to DE - how do I make the database pull in the certifications for the changed country for all titles?
You need to rescrape the movies again. There is no option to partially scrape.

Here are some other methods:

1. Install the Metadata Editor addon from the repo, and you can edit each rating individually...
Settings>Add-ons>Install from repository>Program add-ons>Metadata Editor
https://forum.kodi.tv/showthread.php?tid=349035

2. Use NFO Files and edit the following tag <mpaa></mpaa>
Looks like this when edited correctly... <mpaa>Australia:M</mpaa>

3. Directly edit the database if you are comfortable with SQL

Thanks for the response - I was afraid that there might not be an easy solution Smile

If I understood the table layout in the sqlite database well enough I might be able to clobber together a little python program to do my bidding, but as it stands I think the "easiest" option will be to delete the database, re-scrape and manually fix the few movies it gets wrong. I have no stomach for manually updating 500+ titles Smile

Cheers!

RE: Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country - Karellen - 2022-04-16

(2022-04-16, 03:25)tinkster Wrote: f I understood the table layout in the sqlite database well enough I might be able to clobber together a little python program

Well if you can write python, you won't have problems with SQL, just like filling in a spreadsheet... https://kodi.wiki/view/Databases/MyVideos
But before you go to all that work, ratings are skin dependent to a large degree. Kodi stores the rating, but the skin displays it. So for which ever skin you are using, find out what format the skin expects the rating to be in, and whether it even has flags for your country. Most skins only display certification flags for about half a dozen countries.

But whatever you are comfortable with Smile

RE: Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country - tinkster - 2022-04-16

Thanks for that extra bit of info - I would never have guessed. I manually went and updated info on a couple of films, and it would appear that estuary doesn't know Germany Smile

I'll just leave it sitting on US and grin and bear it. And have robust discussions with the lad if he wants to watch a film I deem not suitable for him Big Grin

RE: Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country - tinkster - 2022-04-16

P.S.: I love several of the movies in your screenshot Wink

RE: Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country - Karellen - 2022-04-16

(2022-04-16, 03:46)tinkster Wrote: and it would appear that estuary doesn't know Germany

Estuary does not display a rating flag. It just shows a text based rating on the information page. (that is correct isn't it @jjd-uk?)

If you switch to another skin it is more likely to show the icons. Here is the code for Aeon Nox:Silvo as an example... https://github.com/mikesilvo164/Aeon-Nox-SiLVO/blob/master/16x9/Variables.xml#L1039
You can see what the skin searches for, and how the rating should be named, which is why the scrapers allow you to add a "prefix" to the certification.

In Estuary, you could create a series of Smart playlists (wiki) or Nodes that can sort the movies into lists of the same rating. This is an example using Nodes. Even though the flags are not displayed, the information is still there, and it can be used to populate these lists.

(2022-04-16, 03:55)tinkster Wrote: P.S.: I love several of the movies in your screenshot

Thanks

RE: Kodi, 2:18.6 on Ubuntu 20.04, The Movie Database 5.2.6 - change country - Karellen - 2022-04-16

And using a compatible skin that displays certification flags, it would look like this...