Plex Documentation → Your Media
→ Naming & Organizing Your TV Show Files
→ Naming & Organizing Your Movie Files
Can’t help with db queries.
However, for House of Cards, add the TMDB or TVDB ID to the show folder. The ID tells Plex exactly which show to match. For movies, use the TMDB or IMDB ID.
After renaming, Plex Dance the series (or movie). Follow all of the steps. This removes previous, incorrect matching information from the Plex database.
/TV Shows <-- folder added to TV Show library
.../House of Cards (1990) {tmdb-21720} <-- Show_Name (year) {tmdb/tvdb id}
....../Season 01
........./House of Cards (1990) s01e01.ext <-- ext=mkv/mp4/etc.
There are tools to assist with the process:
Many people use Filebot.
The free version of Tiny Media Manager works for basic renaming.
TMM Renamer Patterns:
- Show Name:
${showTitle} (${showYear})
- Season:
Season ${seasonNr2}
- Episode Name:
${showTitle} (${showYear}) s${seasonNr2}e${episodeNr2} ${episode.title}
- Movie Name:
${title} (${year}) {imdb-${imdb}}
PowerRenamer in Microsoft Power Tools is helpful for simple renaming with pattern matches or regular expressions. It makes quick work of tasks such as adding a year to file names, removing undesirable text from multiple files, etc