|
|
Welcome to the Database Correction page. This page is for letting me or the other editors know of corrections that need to be made. Please read the posting instructions carefully.
|
|
| Sunday July 08 20:04:10 2018 Episode cleanup |
| I'm a few hours away from finishing up a thorough run through the database to standardize the formatting for TV episode names and numbers. With a few weird exceptions, once I'm finished, all of the entries will now match one of the following familiar patterns: "Name"[, Part(s) x] "Name"[, Part(s) x] (Season.Number[-Season.Number]) Season.Number[-Season.Number] "Number" "Month Day, Year"[-"Month Day, Year"] "Day Month Year"[-"Day Month Year"] Unknown When extra information was provided that didn't fit into one of these patterns, I generally tried to preserve it in the body of the entry. (There are a few exceptions, like original air dates for non-daily series where standard episode numbers were already included: that information is almost always available in other databases for anyone who really needs it, but mostly it's just clutter). The immediate motivation for this is to improve episode matching for a bunch of automated processing that I'm doing, for DVR alerts and also for the Drive replacement I'm working on, without having to write convoluted code to handle a ton of random formats. I'll probably repeat this process every few months, but if you run into examples in the meantime that don't fit one of these patterns, I'll certainly appreciate your efforts in cleaning them up. |
| Raffish |
| Sunday July 08 22:14:59 2018 Re: Episode cleanup |
| Raffish wrote: > I'm a few hours away from finishing up a thorough run > through the database to standardize the formatting for TV > episode names and numbers. With a few weird exceptions, > once I'm finished, all of the entries will now match one > of the following familiar patterns: Hell of a job if you manage to standardize the whole thing. I have a question about how you're going to standardize the dates, specifically: > "Month Day, Year"[-"Month Day, Year"] > "Day Month Year"[-"Day Month Year"] If you're going to use both, how are you going to differentiate between European and American formats? Not that original broadcast dates are particularly important (as you say, they're available elsewhere) but if they're here, they should be clear. Also, I'm not really sure about how you're planning on putting in "Season.Number". I think I'm just getting confused due to the way that you typed up your message, but I'm hoping you're just going to keep maintaining the (#.##) format that most entries are using now. |
| Gagster |
|
|