Jellyfin Forum
Bulk edit Parental Rating - Printable Version

+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Support (https://forum.jellyfin.org/f-support)
+--- Forum: General Questions (https://forum.jellyfin.org/f-general-questions)
+--- Thread: Bulk edit Parental Rating (/t-bulk-edit-parental-rating)



Bulk edit Parental Rating - Finios - 2024-05-19

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?



RE: Bulk edit Parental Rating - TheDreadPirate - 2024-05-19

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.


RE: Bulk edit Parental Rating - Finios - 2024-05-20

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'



RE: Bulk edit Parental Rating - taylorcurran - 2024-05-20

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