I want to edit all the collection tags in my movies.

Third Party Development
1

Hello friends.
Any have any tool to remove all collection( tags) in the plex database.
I don’t know why I have a collection tag for each movie, because I don’t create them.

I need any tool for edit the database. I can’t find the app plexeditor from eagle…

any help??

2

Its pretty rediculous that movies that have no associatation to collections get their own collection…

I.e. Every movie has a collection with just itself as a member…

Genius… makes things much easier… sacrasm noted’

3

@calibra3 said:
Hello friends.
Any have any tool to remove all collection( tags) in the plex database.
I don’t know why I have a collection tag for each movie, because I don’t create them.

I need any tool for edit the database. I can’t find the app plexeditor from eagle…

any help??

You have collection tags because whatever agents you are using downloads them from TMDb. You can bulk edit any piece of metadata by clicking on the icon that looks like a check mark in a box on the left column in PMS and then selecting all the items you want to edit.

4

These, if auto created, come from an agent. I inadvertently turned on “Use collection info from The Movie Database” in the Movie Database agent settings. This created a bunch of collections I didn’t want on many of my 2700 movies.

I found I could delete all the collections association in the taggings table but then I would have to rebuild all the collection i previously had. I settled on deleting any collection than had less then 3 members with this SQL code:

use SQLite or DbVisualizer or the like.

delete
from taggings
where id in
(
select tg1.id from taggings tg1
left outer join tags tgs1 on tgs1.id = tg1.tag_id
where tgs1.id in
(select tgs.id from taggings tg
left outer join tags tgs on tgs.id = tg.tag_id
where tgs.tag_type = 2
group by tgs.tag
having count(tg.id) < 3
order by tgs.tag
)
);

The tags are in the table tags, you can correct any spelling issues there as well. The association to a movie/media is in taggings table. The above removes the association of a tag to a movie but does not delete the tag itself. This worked well for me and I hope it helps somebody else too.

Cheers

3 Likes
5

ok, what the… I don’t have that box checked “use collection info from movie database” and i manually removed the per movie collection info i had and replaced with my own. Today all that information is back again how / why?

additionally it would be useful if while editing multiple movies i could simply clear that field for all of them.

6

@pterobyte used your sqlite code to remove all the dumb collection tags i got from media scanners.
worked great

7

@pterobyte do you have any insight into

  1. Where the ´genre´ tags are stored in the database
    and
  2. How i can copy that from one database to another database on another server with the same content (but different paths)?

I have a library of video produced by me on my home server, i entered all the genre tags manually. Now I have put all of that media on a different server and can´t type it all in manually again so I´m looking for a way to pull it from the original server and get it into the new server.

I tried a simple database backup and restore but the server would not start with the wrong database file.

8

Genres are in the Tags table also but of type 1.
The related to the to the media in the Taggings table.

Hope that helps.

j

9

@pterobyte said:
Genres are in the Tags table also but of type 1.
The related to the to the media in the Taggings table.

Hope that helps.

j

yeah that helps a little, thanks, bit of a daunting task ahead of me here :-/