Bulk edit Parental Rating

[Finios]

With release 10.9.0 the parental rating contry code where removed. I found the csv files on github, where the entries where remove in february 2023. 
I used the parental rating entries with contry code if there where no official rating from the rating system organisations (like videos from YouTube) and locked the depending episode or movie so a scan would not overrite it.
I also have checked the metadata savers setting Nfo in every of my libraries, so I can't edit all entries by manipulating the sqlite database, because the old rating is safed in nfo files and won't be overriten. If I add the movies or episodes to a new server it will scan the nfo file and will use the there safed entry.

My questions are:

• Can I add a custom csv file to my existing server, so I can still chose the rating entries with contry code in the dropdown menues? 
  
• Or does anyone have a script or know how to bulk edit every parental rating entry with contry code in database and nfo files?
  

[TheDreadPirate]

You could edit the NFOs. If you are on linux you can use a loop and the sed command to bulk edit files.

Otherwise, we don't recommend editing the database. Thats a recipe for disaster. And I can't find any CSVs that you could edit in a compiled jellyfin-web.

[Finios]

Thank you.
With the following code I now have replaced every contry code in every nfo file in the current folder and all subfolders.

Code:

find . -type f -name "*.nfo" -print0 | xargs -0 sed -i --expression='s_<mpaa>DE-\(.*\)</mpaa>_<mpaa>FSK \1</mpaa>_g'

[taylorcurran]

you can try this  xargs -0 sed -i --expression='s_<mpaa>DE-\(.*\)</mpaa>_<mpaa>FSK \1</mpaa>_g' to the code iq test online

[Duvel]

Everything related to parental control in Jellyfin is a nightmare, at least for my case : non-US user having >50% of non-US stuff.

My children complain non stop that they can't see OBVIOUS CHILDREN stuff on their account and I have to edit the custom parental rating so they can get it. But I fully understand that the root cause of this isnt Jellyfin, but the myriad of different ratings per country and metadata sites being incorrect.

Indeed a bulk edit system would be a lot more simple to manage
Another solution might work for some people: defining a rating on a whole library and have all stuff inside inheriting it.

Additionally this is also the work of Radarr/Sonarr teams to put parental rate rewriting rules in place, as well as Bulk edit facilities, but they dont want to.