Two little "cleaning projects" for bored or committed contributors

  • 5
  • Idea
  • Updated 2 months ago
Hi, everyone :

While processing the title.trivia.tsv file to get some results, I gathered data of several trivia items that need some additional corrections related to either former (qv)-links or newer [link=]s.

I know this is not a priority, since in many instances there's more an aesthetic issue (hence "cleaning") than a loss of information; e.g. tr0568374 in Pluto and the Armadillo:

However, these bad-formatted links affect the integrity of linked data, make browsing the site more difficult, prevent titles from being displayed according to user's country preferences, and yes, they're just plain ugly, so...

...just in case any fellow contributor wants to help amend these entries (thank you!!), I'll leave the complete listing here. To ease the task, if you click on the trconst, the trivia will show up (to verify if it's still wrong-formatted), and the (edit) next to it will lead you to the trivia update form of the title where such trivia is located (unfortunately, there are no direct URLs to correct specific items within a title).

I've separated the items into two different categories ("projects"):


A) LACKING OR WRONG-FORMATTED NEWER [LINK=]s

The header says it all... e.g. tr4196631 in "Syke" (2014) {Joulumaa (#2.10)}:
As of 20 Sep 2019 there are (at least) 285 items that need to be corrected:

Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

Posted 3 months ago

  • 5
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
B) LACKING TAG IN INTENDED FORMER TITLE (qv)-LINKs

A contributor enclosed some text in underscores (_) to, allegedly, create a former link to another title, but forgot to add the (qv) tag afterwards... e.g. tr1924104 in Daria:
As of 20 Sep 2019 there are (at least) 1,310 items that need to be corrected:
(to be continued...)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
I've already submitted updates for this whole 100-trivia group (tr0564805 to tr0575448)...
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
The block above (tr0575464 to tr0590353) has been processed as well...
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
These ones (tr0590581 to tr0630650) have been cleaned too...
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
The block above (tr0631652 to tr0680173) is done too...
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
I started this block tr0680548 - tr0717793
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
Well, it was not a vacation. Just one item "tr0702992 (edit)" cost me equally to a whole 100 block in time, while being 1 edit for system ;)))
______________________________

I did not link this one tr0700727 (edit) - because it needs a deeper research for which exactly film is mentioned.
______________________________

I also start processing the next following block: tr0721146tr1124551.
(Edited)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
Just one item...
Wow! That really deserves an extra praise... See the differences between before and after your edit:

Thanks!
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
The above block is done.
____________________________________

I take the next block: tr1134291 - tr1636285
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
The above block is done.
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
I'm taking this one (tr1641202 to tr2062581)...
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
...and it's completed!
(Edited)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
Is this really the last unclaimed block? 
I'll plant my flag. tr2063320-tr2421756 
https://getsatisfaction.com/imdb/topics/two-little-cleaning-projects-for-bored-or-committed-contribu...
timestamp 12:46:59

I'll start at the top. If someone else wants to start at the bottom...

Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
I'm taking from tr2329348 onwards...

ETA: ...and it's over!
(Edited)
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
tr2314425 - tr2322949 are done.
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
tr2304213 - tr2322949 are done.
I stop on this. Thank you all.

All the edits made on September 23 are pending. 
No one of 70+ is approved. Oops...
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
Report of project completion was slightly premature.
I had not finished my section (and thank you to those who reduced the block).
Now my 50 (tr2063320-tr2304208) are complete, with this Pending:
tr2076680 (edit) 190923-081305-316000

If anyone wants to beautify this one so it shows as a vertical list, go for it. (I only had to fix a couple of links.)
https://www.imdb.com/title/tt0488907/trivia?item=tr2182054


Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of Nikolay Yeriomin (Mykola Yeromin)

Nikolay Yeriomin (Mykola Yeromin), Champion

  • 3135 Posts
  • 4115 Reply Likes
If this block (tr2436749tr2800504) is still unclaimed I'm doing it in the next hour or two. :) 
Photo of Nikolay Yeriomin (Mykola Yeromin)

Nikolay Yeriomin (Mykola Yeromin), Champion

  • 3135 Posts
  • 4115 Reply Likes
A bit of a progress report: I started from the bottom of this cluster and slowly moving further up. Taking much longer than expected since many titles require a lot of additional editing I discover along the way (usually botched trivia, sometimes also cast and crew). Having a blast moving through that, though, as I've already discovered quite a few things I never knew I wanted to see. :) 
Photo of Nikolay Yeriomin (Mykola Yeromin)

Nikolay Yeriomin (Mykola Yeromin), Champion

  • 3135 Posts
  • 4115 Reply Likes
And... This cluster of 100 pieces finished. I imagine most people are way faster, but I also think they're not going into a rabbit's hole each time, correcting additionally a ton of stuff on numerous titles. It's totally okay: rabbit's hole is not for everyone. Usually if there's one mistake, you can bet that there's another one somewhere. Correcting one title might ensue in effective hour of trying to piece the situation together. Plus, these 100 randomly happened to have ton of stuff I like so reading was a distraction, as well. 

Anyhow, out of 100 corrections most of them were approved nearly instantly, only one was (oddly enough: will post on that more or less soon) declined and two are still pending. 

If there will be anything left I'd love to try and do another cluster sometime on September 23-29. :)
(Edited)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be continued...)
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
It's D.O.A.
100%
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
Got it, did it.
D.O.A. ('49), The Quotes page confirmed it nicely.
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
Editing of this set of 100 (tr2804065-tr3057909 ) is complete. Pending:
tr2829219 (edit)  190922-125606-940000
tr2854931 (edit) 190922-130234-925000
tr2863468 (edit)  190922-131250-858000
tr2867927 (edit) 190922-132619-376000
tr2883050 (edit) 190922-134057-729000
tr2885196 (edit) 190922-134426-368000
tr2886581 (edit)  190922-134828-693000
tr2886603 (edit) 190922-135041-922000
tr2888597 (edit) 190922-135152-681000
tr2920899 (edit) 190922-141327-364000
tr2921318 (edit) 190922-151447-576000
tr2976922 (edit) 190922-150311-919000
tr2999541 (edit) 190922-163939-197000

Oh, and Nikolay may want to check this one:
tr3000165
(Edited)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
Oh, and Nikolay may want to check this one

Photo of Nikolay Yeriomin (Mykola Yeromin)

Nikolay Yeriomin (Mykola Yeromin), Champion

  • 3135 Posts
  • 4115 Reply Likes
bderoes, at this point I was practically expecting something of mine to pop up in the cluster I was cleaning up but, oh well, got exposure elsewhere. :) 

I dug up the initial submission notification e-mail from three years ago and... Yeah, I messed those up, forgot "(qv)" on more then one instance. I like the new link formatting a lot more for that reason: it's much harder to mess up this one for me. :)
(Edited)
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
So the project is just to correct formatting problems?
Because when I check the first item on the A list, it's not quite correct, even with the formatting fixed.
It says:
Tippi Hedren ... uses the name "Margaret Edgar" in the show, which is her character's name in the Hitchcock film [link-tt0058329]
The tt refers to Marnie, where her character name is Marnie Edgar, not Margaret Edgar.
If I take the time to check each one like this, the task is super-daunting. Then again, I'm not sure I want to link my contributor status with incorrect information. (I could use my secondary account...)
Photo of ljdoncel

ljdoncel, Champion

  • 849 Posts
  • 1804 Reply Likes
Hi, bderoes:

I usually assume that, when I choose "Adding/correcting link(s)" in the explanation box, the data manager just checks that I'm doing so, without re-verifying if the info that was there in the first place was accurate... but you're correct, and perhaps we should have confirmation that there'd be no further penalty if the data ultimately happened to be not true...
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes

(to be concluded...)
(Edited)
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
Edits have been submitted for this entire group of 100: tr3058779 to tr3392527, Pending:
tr3060061 (edit) 190921-195304-436000
tr3060091 (edit) 190921-195425-695000
tr3064311 (edit)  190921-195633-188000
tr3107805 (edit) 190921-201340-758000
tr3107825 (edit) 190921-201430-255000
tr3110034 (edit)  190921-201603-962000
tr3123381 (edit) 190921-201926-944000
tr3138292 (edit) 190921-212217-066000
tr3198785 (edit) 190921-215012-702000
tr3203371 (edit) 190921-215211-562000

BTW, for both my batches, I opened the tr constant link for each item to see if the bad stuff was still visible. (I caught one that I skipped that way.)
(Edited)
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes


Cheers!
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
MAthePA - neither Poehler nor Diaz is in Zootopia.
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
I'm not saying for the initial submitter what is meant under "would later star": a wish, a hypothesis, a prediction based on inner knowledge, or else. For me, Zootopia is the only variant which makes a sense in this situation and context. Should I prepare a scientific thesis on this? :)
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
It does not seem appropriate to change an extant trivia item based on speculation about what it's original author might have intended.

My research suggests the item is false. Not even joint appearances on SNL were remotely close to 2016, so "Pettopia" with them wasn't even a sketch on that show.
I'm inclined to request deletion of the item.
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
My initial reply is only for what "Pettopia" could possibly mean. I think you don't need an advice what to do next, but if you need my opinion: this trivia item deserves to be deleted for more than one reason. At least, the trivia sounds as a rumor.
(Edited)
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
The 110 items I claimed from
https://getsatisfaction.com/imdb/topics/two-little-cleaning-projects-for-bored-or-committed-contribu...
with timestamp 12:53:34
are now edited. Most are completed, with these few exceptions:
tr3640840 (edit) / no action (Testing Movie)
tr3433546 (edit) / pending 190921-015828-466000
tr3497948 (edit) / pending 190921-104916-232000
tr3524814 (edit) / pending deletion 190921-155052-058000
tr3568060 (edit) / pending 190921-113037-222000
tr3589525 (edit) / pending 190921-123028-459000
tr3657292 (edit) / pending 190921-134807-937000
tr3663646 (edit) / pending 190921-150250-984000
tr3888739 (edit) / pending 190921-151827-216000

Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
Till this moment, I've done 100+ items from section 'A', except these ones:
tr1047320 (edit)
tr2824266 (edit)
tr3006839 (edit), tr3006876 (edit)
tr3157257 (edit)
some of them are good to improve the search algorithm.
Photo of ljdoncel

ljdoncel, Champion

  • 849 Posts
  • 1804 Reply Likes
some of them are good to improve the search algorithm
You're correct... a few false-positive results of my regex query (worth its price... ). Thanks for collaborating, MAthePA!
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
Section 'A' is done; 15 pending.
Photo of Nikolay Yeriomin (Mykola Yeromin)

Nikolay Yeriomin (Mykola Yeromin), Champion

  • 3135 Posts
  • 4115 Reply Likes
If there will be anything left I'll try my best to correct some of those, as well. I routinely add links to trivia items where there are none (I enocounter those on a regular basis) and some which are wrong, but this is whole another level! Also, link problems occur in movie connections. A lot... 
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
Thank you very much, Nikolay. Any help is absolutely welcome...
(Edited)
Photo of Phil G

Phil G

  • 154 Posts
  • 341 Reply Likes
Unfortunately, I won't be helping out this time (I'm fighting with other issues at the moment), but I couldn't ignore the brilliant efforts here. Really useful work, especially dealing with it like this, instead of one at a time if and when we notice these bad links by accident.

Thanks ljdoncel for setting this up and thanks everyone for working through it.
Photo of ljdoncel

ljdoncel, Champion

  • 850 Posts
  • 1805 Reply Likes
Now that all the corrections have been submitted (I'll check the tsv file again in a few days to see if some have been rejected), there's something I'd want to say... (I wish I could do it in Spanish because I'd express myself better...)

A VERY BIG, ENORMOUS THANKS to all of you, MAthePA, bdreoes and Nikolay! Fantastic work! And also thank you very much to Phil G, gromit, Ed and Marco for your support.

Yes, we have our flaws, but you've shown everybody what it is to be an contributor. We're able to put a lot of time and effort into a collaborative project just for the reward of keeping the database as much accurate and good-looking as possible. Results are impressive in quantitative terms (over 1,500 updates in less than 3 days), however many people unfortunately don't understand the (much more important) qualitative value of this unpaid work...


You do know it...

I'm really proud of being part of this community... Thank you very much again.
(Edited)
Photo of Marco

Marco

  • 1234 Posts
  • 1544 Reply Likes
Kudos to the four of you for fixing this so swiftly! And kudos especially to you, ljdoncel, for creating such lists in the first place!
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
I had two declined, and I sent a Contact Us message.
190922-132619-376000 Earth, Wind and... Wait for It 
For both, the reason was
Other, Your contribution has been declined. We did not capture a specific reason during processing.

The only one still pending is from the last batch, although it's several hours old:
190923-081305-316000 The Hobbit (1977)
Looks like there was a space between the link and the period at the end of the sentence. Wonder if that's why.

Well, I'm not a big fan of Trivia, and this didn't elevate it in my mind. But broken links drive me nuts.

Are there other sources of links that you didn't mine in this batch? I shudder to think of the Name pages. How about other types of Title data?

Not that I'm eager for more.
Photo of bderoes

bderoes, Champion

  • 1580 Posts
  • 2575 Reply Likes
I had two declined, and I sent a Contact Us message.
190922-132619-376000 Earth, Wind and... Wait for It 
This is now resolved.
The only one still pending is from the last batch, although it's several hours old:
190923-081305-316000 The Hobbit (1977)
This is still pending.
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
Photo of MAthePA

MAthePA

  • 2063 Posts
  • 3494 Reply Likes
Photo of Nikolay Yeriomin (Mykola Yeromin)

Nikolay Yeriomin (Mykola Yeromin), Champion

  • 3135 Posts
  • 4115 Reply Likes