|
|
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.
|
|
| Monday July 09 15:55:47 2018 Re: Episode cleanup |
| One thing which I disagree with, purely for logic reasons, is having dates in quotes. It implies that an episode is literally titled by its air date, which is almost never the case except for a show like 24 with its clock digits. |
| Sam |
| Monday July 09 16:07:26 2018 Re: Episode cleanup |
| Gagster wrote: > Hell of a job if you manage to standardize the whole > thing It's done...whew. > 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. Well, I saw plenty of both, and the contributors had generally used the format that was most appropriate for the series origin, so I decided to leave them as they were. If we decide it's a good idea, I'd be happy to do another pass to standardize on one (presumably the American format), since there aren't that many that would need to be changed either way. > 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. Erm...I didn't. Again, I saw plenty of both. In this case I didn't see any reason to keep two separate conventions, and the parentheses seemed superfluous to me when no episode title was present, so I got rid of them. If the consensus is that I screwed up, there are a ton that would need to be changed back...so maybe it could be done programatically? Assuming that a regex search and replace could be run directly on the Description field in the DB, this would do it: s/^(Episode: )(\d+\.\d+)/$1\($2\)/ Sorry if I created more work with this one. Should be worth it for the other improvements, at least. |
| Raffish |
| Monday July 09 16:21:54 2018 Re: Episode cleanup |
| Sam wrote: > One thing which I disagree with, purely for logic > reasons, is having dates in quotes. It implies that an > episode is literally titled by its air date, which is > almost never the case except for a show like 24 with its clock digits. I agree. There were a bunch that did use the quotes, and since I tended to run into more of those early on, I settled on that for the convention. Didn't really agree with it, though. In this case, there are fewer than 75 entries that would need to be changed, which I can manage by hand...but I'll wait until we decide whether to standardize on a single date format, and tackle both at once. |
| Raffish |
| Monday July 09 17:44:54 2018 Re: Episode cleanup |
| > Erm...I didn't. Realized this might have been unclear, so just in case...I did NOT actually add the words "Season" or "Episode" for these. I kept the #.## convention, but removed the parentheses when this was not preceded by an episode title. |
| Raffish |
| Monday July 09 18:06:11 2018 Re: Episode cleanup |
| Raffish wrote: > > Erm...I didn't. > Realized this might have been unclear, so just in > case...I did NOT actually add the words > "Season" or "Episode" for these. I > kept the #.## convention, but removed the parentheses > when this was not preceded by an episode title. I just took a quick look through the DB and I don't see anything to complain about, so congratulations on some really nice work. If you want some help with the manual changes, you can let me know here or pop me an email. |
| Gagster |
| gagster69@hotmail.com |
| Monday July 09 18:29:15 2018 Re: Episode cleanup |
| Thanks Gagster. Here's a list of the entries that currently have dates in quotes, where it sounds like we're agreed that the quotes should be removed. If you feel like tackling these, go for it, otherwise I'll try to get to it within the next few days. For date ranges, I'd appreciate it if we could leave both dates fully intact instead of writing something like "11-13 October 2004"...easier to process that way. (We should decide at the same time whether we're going to standardize on a single date format.) 3121 "October 9, 1954" 5901 "November 15, 1999" 6106 "April 26, 1999" 7649 "December 31, 1990" 8137 "November 25, 2002" 8969 "August 6, 2003" 9082 "September 10, 2003" 9099 "September 15, 2003" 10387 "May 3, 2004" 11067 "December 21, 2004" 11139 "January 13, 2005" 11706 "November 21, 2005" 11951 "March 20, 2006" 12209 "September 13, 2006" 12250 "October 1, 2006" 12848 "August 3, 2007" 13606 "October 25, 2006" 13794 "November 20, 2008" 13905 "October 27, 2007" 14140 "April 2, 2004" 14176 "March 3, 2009" 14459 "April 28, 1956" 14493 "9 November 2009" 14988 "September 11, 2010" 15103 "October 20, 2010" 15270 "January 5, 2011" 15278 "January 14, 2011" 15409 "March 23, 2011" 15843 "November 3, 1975" 16285 "October 3, 1977" 16944 "August 23, 2013" 16995 "3 September 2013" 17077 "July 24, 2013" 17734 "8 January 2014" 18109 "23 May 2014" 18520 "4 March 2006" 18778 "30 August 2010" 18807 "30 June 2014" 18910 "November 10, 2014" 18911 "August 6, 2013" 19084 "11 October 2014", "13 October 2014" 19247 "March 19, 2012"-"March 21, 2012" 19255 "September 13, 2012"-"September 20, 2012" 19346 "3 March 1995" 19870 "April 20, 2007" (?) 19894 "10 August 2015" 20050 "July 1, 2011" 20060 "13 June 2013" 20137 "16 January 2009" 20157 "4 September 2010" 20349 "20 August 2015"-"21 August 2015" 20365 "30 November 2015" 20371 "16 November 2015"-"17 November 2015" 20584 "January 24, 2016" 20712 "April 20, 2002" 20789 "11 September 2015" 20791 "16 September 2015" 20793 "21 September 2015"-"22 September 2015" 20836 "12 January 2016"-"14 January 2016" 20838 "April 9, 2016" 21030 "June 15, 2016" 21088 "12 February 2016" 21680 "10 October 2016" 21682 "9 February 2016" 21683 "12 February 2016" 21927 "July 13, 2015" (?) 22161 "April 5, 2017" 22247 "20 February 2013" 22292 "July 27, 2010" 22294 "17 April 2017"-"19 April 2017" 22434 "5 December 2016" 23015 "13 December 2017" 23414 "31 May 2018" |
| Raffish |
| Monday July 09 18:52:33 2018 Re: Episode cleanup |
| I'm fine with full instead of combined dates, in the absence of episode titles or numbers. I suggest semicolons as separators, so that the MDY format doesn't look awkward: 1 November 1998; 4 November 1998 November 1, 1998; November 4, 1998 In the case of a show composed of a continuous stream of episodes with no distinguishable season number, I've been using this format for a while: "Episode Title" (episode number) You'll see it a lot in my German and Telemundo entries. |
| Sam |
| Monday July 09 18:55:22 2018 Re: Episode cleanup |
| Oh, and another which irks me: "Pilot" with the quotes. Again, rarely used as a worded episode title, and sort of nonsensical unless the actual storyline is about a pilot(!), or a long-lost Airwolf episode that we never knew about. Therefore: Pilot (1.01) ......would make more sense. |
| Sam |
| Monday July 09 18:57:15 2018 Re: Episode cleanup |
| > "Episode Title" (episode number) Sure...this makes sense for the series in question, but I changed it to "Episode Title" (1.episode number) for consistency. I know it's a bit goofy-looking, but it's technically accurate. (IMDb etc. do this too, because of the requirement that every episode belongs to a season.) |
| Raffish |
| Monday July 09 19:03:30 2018 Re: Episode cleanup |
| Sam wrote: > Oh, and another which irks me: "Pilot" with the > quotes. These I'm not gonna touch, because AFAIK some of these series actually DO use that as a one-word title (or at least that's how it's referred to pretty much everywhere). No objections here if someone wants to change them, though. These are the entries we're talking about: 337 828 912 1456 2583 2847 3718 3887 4018 4092 4823 6058 6542 6778 7232 7894 7895 8060 9016 9029 9029 9738 10819 11165 11165 11286 11594 12198 13260 13461 13681 14283 14541 15018 15020 15348 15580 16439 16805 17069 17119 17254 17779 17785 17817 17899 18185 18338 18497 18618 18950 18950 19114 19172 19356 19553 20187 20246 20263 20741 21025 22188 22419 22547 22829 22865 23016 23509 |
| Raffish |
| Monday July 09 19:21:19 2018 Re: Episode cleanup |
| > These I'm not gonna touch, because AFAIK some of these > series actually DO use that as a one-word title (or at > least that's how it's referred to pretty much > everywhere). Oh, true actually. I've seen DVD and VOD material listing a quotemarked "Pilot" as a title, so scratch that; doesn't need to be touched. |
| Sam |
| Monday July 09 19:32:13 2018 Re: Episode cleanup |
| Sam wrote: > I'm fine with full instead of combined dates, in the > absence of episode titles or numbers. I suggest > semicolons as separators, so that the MDY format doesn't > look awkward: > 1 November 1998; 4 November 1998 > November 1, 1998; November 4, 1998 I should have some free time tomorrow to tackle the dates, but I want to clarify exactly how you want the dates to appear. For a single date m d, y or d m y, depending on whether American or European (if known). For a range of dates, you want a semicolon in between the start and end dates as quoted above? The question for me comes into play on whether we're dealing with an episodic show, where there are, say, 2 episodes shown a week apart. A soap opera can have a scene stretched out for weeks, with large gaps in the DID action. I'm fine with just having the start and end dates with the semicolon, and specifying in the text how the scene played out. I just want to be sure we have a consensus here. As for the name "Pilot" for so many of the 1.01 episodes, that is what is actually used in the US. It may be different in the UK, but if you take a look in the lists at epguides.com, you'll see hundreds of series which used that as a title for their first episode. More importantly, its also what is used in both printed and online programming guides to identify the episode. If Raf is matching the DB against online listings, the title "Pilot" is what he is going to find. |
| Gagster |
| Monday July 09 20:33:28 2018 Re: Episode cleanup |
| > For a range of dates, you want a semicolon in between the start > and end dates as quoted above? The question for me comes into > play on whether we're dealing with an episodic show, where there > are, say, 2 episodes shown a week apart. A soap opera can have a > scene stretched out for weeks, with large gaps in the DID action. Right. For now I followed the same convention with these that we use for episodes specified with #.##: a hyphen specifies a complete range in which all the episodes in between contain DiD stuff (except perhaps as noted in the full description), while a comma specifies two specific non-consecutive dates with perhaps some non-DiD stuff in the middle. Anyway, I don't really care how we handle these, since (a) there are only seven "hyphen" entries and one "comma" entry total at the moment, (b) they're unlikely to match in other databases (or be searched on) anyway. For multi-episode scenes in general, in order to simplify my life, all I'm actually planning to do is to file them under the first episode with a field to indicate that they continue through [last episode here]. > As for the name "Pilot" for so many of the 1.01 episodes, that is > what is actually used in the US. Yeah, I think we agreed that we're fine with the quotes. |
| Raffish |
|
|