I get the impression that you're at least somewhat technically competant so I'm gonna just throw this out there and it may or may not help.
http://code.google.com/p/metavideoeditor/ is a great windows app for fetching metadata for movies and tv shows. However, it doesnt add that metadata directly to the files themselves - instead it downloads an xml file with all that fun data in it.
http://www.sno.phy.queensu.ca/~phil/exiftool/ is another cool little tool which allows reading and writing of metadata.
My thought (100% untested) is to fetch all the data with the first tool - then create a batch file of some kind to read the metadata from the xml file and write it to the media files using the 2nd tool.
Like I said, this may not work at all.... but I wish you all the luck in the world with it
Getting metadata isn't really the problem, but you're on the right track with the EXIFTool solution. I want to write directly to the metadata atoms Apple uses for its files, however, so iTunes can display things like parental control ratings and long/short description fields both in iTunes and to the AppleTV 2 v2. AtomicParseley can do that, but with 500+ files, even writing a batch script for it would take the better part of a month of my free time.
I'm still searching on my end, but haven't had any luck for Windows applications; either the applications don't work, or they grab the wrong metadata, or they don't write it properly. I kind of wish I could just tag the episode in iTunes it matches and Apple would fill in the blanks, but Apple is really protective of their metadata, unfortunately.
One of my other thoughts would be to use the Zune app to grab the metadata from the Zune store, since Microsoft is all gung ho about sharing metadata from all regions with all regions (iTunes -still- doesn't get metadata for my Japanese and German CD rips, since I'm a US Store user), just as a starting point, then finding a way to write the rest of the data later. In the end though, that's far from ideal and equally time consuming.
Anyone else have a recommendation for getting Apple's metadata atoms into my home-encoded files? Seeing large blank spaces on my Apple TV is really starting to grind against my OCD.
Unfortunately deejay96, no, I have not. Apple seems to really want to keep detailed metadata locked in their ecosystem, and make editing iTunes metadata atoms as difficult as possible, to the point that they even use codes for certain ratings and information, rather than text; it's heavily obfuscated, if largely deciphered by the community at this point. Any solution that did add metadata effectively is now either Mac only, or hasn't been updated in years. Even AtomicParsely hasn't seen an update since 2006, to give you an idea how badly a solution is needed.
I'm hoping that Apple opens their metadata up to users in an easier to use format, but considering it's been almost a decade since the iTunes Store launched (it turns 10 on April 28, 2013), I doubt they'll open the gates as it were, not without some strong push from the community and/or content owners. It's a shame, really, since Zune let me get all of that meta data and more with just a simple search - it accounted for international releases too, something iTunes still doesn't do. It's sad that Zune had the superior software, but Apple won out with iTunes despite its bloat, lack of polish, and interface unchanged since 2001.
Ultimately, I really doubt we'll see any ground breaking features in iTunes without a complete rewrite of the software. If Apple were to shoe-horn a metadata atom editor or search engine now, it'd likely be buried in settings menus or overly-complicated because of the clunky interface. Users really just need a simple, easy way of matching a piece of media they currently own to a version available in any iTunes store, domestic and international. I should be able to type in "Archer s03e07", iTunes loads Season 3 of Archer, highlights episode seven, and let me overwrite all (or some) atoms of my personal files with iTunes metadata, ratings and all. It's something you think we'd have when TV Shows took off from the store, but I've found iTunes is like the filthy bathroom of the otherwise-impeccible Apple Mansion, the one real area they need significant improvement in to bring in-line with their other devices.
Did you find a solution yet? Fortunatly, I suffer from OCD too. Are all your files in .mp4 format? If so, visit videoscripts.wordpress.com. This guy wrote a bunch of software in his free time to help weirdo's with compulsive disorders. I use his software on a daily basis. I think what you'll be looking for is METADATABATCHER.
Try it, and buy him a coffee if you like it. Hope this helps. If this doesn't solve your issue, let me know. I've got a lovely iTunes library because of this guy, album art, meta data, artist information, the works!
Correction, I got it working (it didn't like how I used dashes ( - ) instead of periods ( . ) for the seperation of data in the filename. My only gripe is that it doesn't let me input data I know, like TV Rating or Network, for shows that it lacks said information for. I also dislike how it insists on completely overwriting data entirely, even if there's already data there.
Anyone have another solution?
Ok, granted the solution is a bit buggy. But believe me, I have looked far and wide for an application for my use too.
I forgot the mention, I pair the Metadeta Batcher program to run after I sort the TV Shows using TV Rename. Its a free software, if you search on Google, you'll find it. What TV Rename does, it detects that garbled up name in shows and replaces that with SHOW.SXXEXX.Episode Name. Then it sorts it in your pointed location with Show Folder > Season X > Video file. Now, this enables Metadata Batcher to quickly look and search for all the information in bulk.
Unfortunately, there is no control on the granularity in metadata writing with Metadata Batcher. Fortunately, I am also a Mac user. There are two programs I use called iVI & iDentify2 which immediately recognizes the show, adds necessary show information, ratings, info and renames extention to .m4v all in seconds without having to do any of it manually. It also is automated and runs as soon as it detects new downloads. Sadly, this can only be done on my laptop. I use this laptop for work as well, which makes the Server I created at home redundant.
That's all I've got, if you or anyone can find a solution that can mimic all the features of iVI or iDentify2 on Windows, that would be awesome.