Relationship between metadata guid and database

– I posted this originally in the general forum, but then found the developers forum, which is much better suited for this question –



Hi all,



Probably will need a dev to assist on this one, but hopefully someone can point me in the right direction.

I’d like to be able to fix up a couple of covers by hand for TV shows and movies that are blatantly wrong (some very obscure shows like the BBC Documentary “Folk America” get covers that are wrong despite being matched correctly).



I have been every table in the database but I can’t find a mapping that connects a TV show or a movie to its directory in ~/Library/Application Support/Plex Media Server/Metadata/



Plex 0.8 used a crc32 checksum of the lowercase path to the video file, but obviously these guids in 0.9 aren’t crc32 checksums.



I have looked in the plex source in git, but am not finding anything.



Can anyone please please please point me in the direction to map the .bundle dir/files to their specific movies and tv shows?



Thanks.







Here is some more info for anyone interested:



While waiting for the ability to fix via the UI I would like to be able to replace a file like:

Movies/5/5d3ae354036d021569a8adc4957311593f66629.bundle/Contents/com.plexapp.agents.imdb/posters/f5f21c391ebba4655c0e9a37025a47c1dc446822

with the “correct” cover.



These are definitely the covers as I can view them as long as I treat them like jpegs:

$ file 5/5d3ae354036d021569a8adc4957311593f66629.bundle/Contents/com.plexapp.agents.imdb/posters/f5f21c391ebba4655c0e9a37025a47c1dc446822

5/5d3ae354036d021569a8adc4957311593f66629.bundle/Contents/com.plexapp.agents.imdb/posters/f5f21c391ebba4655c0e9a37025a47c1dc446822: JPEG image data, JFIF standard 1.01





Once I can get them mapping then I could also write some scripts that would tell me which movies are missing covers, or have low-res jpegs, etc.

That is a SHA1 hash generated from the GUID of the metadata item (metadata_items.guid).



Hope that helps :slight_smile:

That was a huge help. Thanks very much for the info.



That gave me enough to grep on within the Application Support to start to dig into the code and see how it all ties together.

You’re welcome! Let me know if you have any more questions :slight_smile:

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.