Author Topic: Help clean out "THE"  (Read 4001 times)

Help clean out "THE"
« on: April 09, 2016, 12:41:44 pm »
As many of you know, database entries cannot begin with the word "the."
I've gone through the database and found a boat load of THE games. I need help finding all the matching duplicates. If there is no duplicates, rename the item to follow the style guide.

If you plan on helping I recommend making a claim on a range of entries you plan on completing. This way people don't end up doing work that as already been done, and step on each others toes. Post your claim in this thread. Post your found duplicates in the official duplicate thread. Once you're done with your staked out games edit your post notifying everyone that your section is done.

EDIT: First list is complete. Thanks for your work peoples!
EDIT: Found a few more. See below.
« Last Edit: April 23, 2016, 09:08:18 am by badATchaos »

Re: Cleaning out "THE"
« Reply #1 on: April 09, 2016, 01:02:54 pm »
the bards tale 1   Commodore 64 Cassettes [NA] http://vgcollect.com/item/103194
The Golden Compass   PlayStation 3 [EU] http://vgcollect.com/item/102750
The Gospel    PSP UMD Video [NA] http://vgcollect.com/item/102568
The Incredible Hulk   PlayStation 3 [EU] http://vgcollect.com/item/102753
The Killing Game Show   Mega Drive [JP] http://vgcollect.com/item/102560
the vindicator   Commodore 64 Cassettes [NA] http://vgcollect.com/item/103167

mrfoxhound:
The 39 Steps   PC - Digital Download [NA] http://vgcollect.com/item/73622
The 3rd Birthday   PlayStation Portable [EU] http://vgcollect.com/item/95564
The A-Team   Tiger LCD http://vgcollect.com/item/21029
The A.Typical RPG   PC - Digital Download [NA] http://vgcollect.com/item/76207
The Adventure of Puppet Princess + 1   PlayStation [JP] http://vgcollect.com/item/76711
The Adventure of Puppet Princess: Marl Oukoku no Ningyou Hime   PlayStation [JP] http://vgcollect.com/item/76708
The Adventure of Puppet Princess: Marl Oukoku no Ningyou Hime +1   PlayStation [JP] http://vgcollect.com/item/85987
The Adventure of Puppet Princess: Marl Oukoku no Ningyou Hime PSOne Books release   PlayStation [JP] http://vgcollect.com/item/76710
The Adventures Of Batman And Robin - Tiger Barcodzz   Tiger LCD http://vgcollect.com/item/68607
The Adventures Of Bayou Billy   Nintendo eShop (Wii U) [EU] http://vgcollect.com/item/97981
The Adventures of St. Bernard   ZX Spectrum [EU] http://vgcollect.com/item/75377
The Adventures of Tintin: The Secret of the Unicorn   Wii [NA] http://vgcollect.com/item/98070
The All*Star Fighting Festival   PlayStation 2 [JP] http://vgcollect.com/item/58205
The Amazing Spider-Man   PlayStation Network (Vita) [NA] http://vgcollect.com/item/63382
The Amazing Spider-Man   Nintendo 3DS [NA] http://vgcollect.com/item/70809
The Amazing Spider-Man   Amiga [EU] http://vgcollect.com/item/102133
The ARCHIVE of DRAG-ON DRAGOON   Swag - Print Media (Books, Comics) http://vgcollect.com/item/68595
The Art of Fire Emblem: Awakening   Swag - Print Media (Books, Comics) http://vgcollect.com/item/96654
The Art of Magic   PC [EU] http://vgcollect.com/item/60841
The Art of Performing   CD-i [EU] http://vgcollect.com/item/91113
The Bard's Tale   Xbox [EU] http://vgcollect.com/item/86537
THE BATTLE OF DESTINY   Mega Drive [JP] http://vgcollect.com/item/99199
The Best of Pokemon Adventures: Red   Swag - Print Media (Books, Comics) http://vgcollect.com/item/88311
The Best RPG's Are On Xbox 360   Xbox 360 Demo http://vgcollect.com/item/95826
The Binding of Isaac: Rebirth   PlayStation 4 [EU] http://vgcollect.com/item/95456
The BIT.TRIP   PlayStation Network (Vita) [EU] http://vgcollect.com/item/92774
The BIT.TRIP   PlayStation Network (PS4) [NA] http://vgcollect.com/item/92882
The BIT.TRIP   PlayStation Network (Vita) [NA] http://vgcollect.com/item/92883
The Bob DeCrescenzo Collection   Atari 7800 [NA] http://vgcollect.com/item/71860
The Byte Before Christmas   Atari 2600 (VCS) [NA] http://vgcollect.com/item/74593
The CF Powerpack - Mean Stread & Top Duck   Commodore 64 Cassettes [EU] http://vgcollect.com/item/65638
The CF Powerpack Tape 14   Commodore 64 Cassettes [EU] http://vgcollect.com/item/66610
The CF Powerpack Tape 20   Commodore 64 Cassettes [EU] http://vgcollect.com/item/66608
The CF Powerpack Tape 22   Commodore 64 Cassettes [EU] http://vgcollect.com/item/66607


davifus:
The Club   PC [EU] http://vgcollect.com/item/69572
The Count   Commodore VIC-20 Cartridges [NA] http://vgcollect.com/item/81561
The Cranberries Doors and Windows   CD-i [NA] http://vgcollect.com/item/58289
The Crew - Limited Edition   PlayStation 4 [NA] http://vgcollect.com/item/73342
The Croods: Prehistoric Party!   Nintendo 3DS [NA] http://vgcollect.com/item/72948
The Crow: City of Angels   Sega Saturn [EU] http://vgcollect.com/item/88885
The Cube Connector   GameCube Accessory http://vgcollect.com/item/57108
The Devil Inside   PC [EU] http://vgcollect.com/item/67172
The Dishwasher: Vampire Smile   Xbox Games Store (X360) [EU] http://vgcollect.com/item/95429
The Dukes of Hazzard   PC [EU] http://vgcollect.com/item/79639
The Elder Scrolls: V:Skyrim & Bioshock Infinite Bundle   PlayStation 3 [NA] http://vgcollect.com/item/94141
The Electric Tale of Pikachu Volume 2: Pikachu Shocks Back   Swag - Print Media (Books, Comics) http://vgcollect.com/item/71559
The Electric Tale of Pikachu Volume 3: Electric Pikachu Boogaloo   Swag - Print Media (Books, Comics) http://vgcollect.com/item/71560
The Electric Tale of Pikachu Volume 4: Surf's Up, Pikachu   Swag - Print Media (Books, Comics) http://vgcollect.com/item/71561
The Entente   PC [EU] http://vgcollect.com/item/78756
The Evil Within   PlayStation 4 [AU] http://vgcollect.com/item/90885
The Evil Within   PlayStation Network (PS3) [NA] http://vgcollect.com/item/78789
the Evil Within   Xbox 360 [NA] http://vgcollect.com/item/95460
The Eyes of Bayonetta: Art Book & DVD   Swag - Print Media (Books, Comics) http://vgcollect.com/item/68003
The Fidgetts   Game Boy [EU] http://vgcollect.com/item/75614
The Fifth Element   PC [EU] http://vgcollect.com/item/67182
The Flinstones   Mega Drive [EU] http://vgcollect.com/item/75809
The Flintstones: Bedrock Bowling   PC [NA] http://vgcollect.com/item/100061
The Four Kings Casino and Slots   PlayStation Network (PS4) [NA] http://vgcollect.com/item/93482
The G.G. Shinobi   Nintendo eShop (3DS) [EU] http://vgcollect.com/item/66077
The Game of Life EX II   PlayStation 2 [JP] http://vgcollect.com/item/74931
The Gamer's Edge Car Power   Other http://vgcollect.com/item/57109
The Getaway   PlayStation 2 [AU] http://vgcollect.com/item/68454
The Getaway: Black Monday   PlayStation 2 [AU] http://vgcollect.com/item/68470
The Glove - Video Game Control   Nintendo 64 Accessory http://vgcollect.com/item/66739
The Glove Controller     PlayStation Accessory http://vgcollect.com/item/44406
The Greatest NES Games Ever!   Swag - Promo Videos/ Movies http://vgcollect.com/item/63445
The Heavy Rain & BEYOND: Two Souls Collection   PlayStation 4 [EU] http://vgcollect.com/item/98875
The Heroic Legend of Arslan   Mega-CD [JP] http://vgcollect.com/item/75395
The Hive Wars   PlayStation [JP] http://vgcollect.com/item/67300
The Home Banker   Commodore 64 Floppy Disks [NA] http://vgcollect.com/item/94982
The Horde   PC [NA] http://vgcollect.com/item/64103
The Hustle: Detroit Streets   PlayStation Portable [EU] http://vgcollect.com/item/80401
The Hustle: Detroit Streets   PlayStation Portable [NA] http://vgcollect.com/item/64146
The Idolm@ster 2   PlayStation 3 [JP] http://vgcollect.com/item/78266


mrfoxhound:
The Improv Presents: Don't Quit Your Day Job   PC [NA] http://vgcollect.com/item/98972
The Incredible Crash Dummies    Tiger LCD http://vgcollect.com/item/81194
The Italian Job   PC [EU] http://vgcollect.com/item/88286
The Italian Job   PlayStation [EU] http://vgcollect.com/item/100604
The Jackbox Party Pack   PlayStation Network (PS3) [NA] http://vgcollect.com/item/83780
The King of Fighters '95   Game Boy [JP] http://vgcollect.com/item/89564
The King of Fighters '96   Wii Shop [NA] http://vgcollect.com/item/74485
The King of Fighters '96 + '95   Sega Saturn [JP] http://vgcollect.com/item/75236
The King of Fighters '97   Wii Shop [NA] http://vgcollect.com/item/74486
The King of Fighters '98   Wii Shop [NA] http://vgcollect.com/item/74487
The King of Fighters '99   Wii Shop [NA] http://vgcollect.com/item/74488
The King of Fighters XII   Xbox 360 [EU] http://vgcollect.com/item/71390
The Labyrinth of Grasaia   PlayStation Vita [JP] http://vgcollect.com/item/79371
The Last Blade 2 (NeoCD Rip)   Sega Dreamcast [NA] http://vgcollect.com/item/96471
The Last Federation   Steam http://vgcollect.com/item/97248
the last ninja trilogy   PC [NA] http://vgcollect.com/item/93303
The Last of Us   PlayStation 3 [NA] http://vgcollect.com/item/99492
The Last Remnant   Xbox 360 [JP] http://vgcollect.com/item/91746
The Last Story   Wii [EU] http://vgcollect.com/item/62285
The Legaia   PlayStation [JP] http://vgcollect.com/item/64018
The Legend of Dark Witch   Steam  http://vgcollect.com/item/94754
The Legend of Korra    PlayStation Network (PS3) [NA] http://vgcollect.com/item/96164
The Legend of Kyrandia, Book 3: Malcom's Revenge   PC [NA] http://vgcollect.com/item/80462
The Legend of Zelda - Classics   Nintendo Entertainment System [EU] http://vgcollect.com/item/99106
The Legend of Zelda Melodies of Time   Swag - Soundtrack http://vgcollect.com/item/63436
THE LEGEND OF ZELDA: HYRULE HISTORIA   Nintendo eShop (Wii U) [NA] http://vgcollect.com/item/75833
The Legendary Starfy balloons     Swag - Toys/Novelties http://vgcollect.com/item/56366
The Mahjong Touhaiden   Super Famicom [JP] http://vgcollect.com/item/68933
The Matrix   PSP UMD Video [EU] http://vgcollect.com/item/77694
The Matrix Reloaded   PSP UMD Video [EU] http://vgcollect.com/item/77695
The Matrix Revolutions   PSP UMD Video [EU] http://vgcollect.com/item/77696
The Matrix: Path of Neo   PlayStation 2 [AU] http://vgcollect.com/item/68413
The Matrix: Path of Neo   Xbox [NA] http://vgcollect.com/item/100723
The Matrix: Path of Neo   PC [EU] http://vgcollect.com/item/70816
The Mix'n Match Collection   PC [NA] http://vgcollect.com/item/79343
The Mummy   PlayStation [EU] http://vgcollect.com/item/66483
The Neverending Story: Auryn Quest   PC [NA] http://vgcollect.com/item/90347
THE NINJA   Sega Master System [EU] http://vgcollect.com/item/99230
The Paradise of Grasaia   PlayStation Vita [JP] http://vgcollect.com/item/79372
The Pit   Arcade (Dedicated) http://vgcollect.com/item/96296
The Premiere Collection Encore - Andrew Lloyd Webber   CD-i [EU] http://vgcollect.com/item/85742
The Pro Mahjong Menkyo Kaiden   PlayStation [JP] http://vgcollect.com/item/85946
The Pro Yakyuu: Pennant Race    Sega Master System [JP] http://vgcollect.com/item/72282
The Punisher Demo Disc   PlayStation 2 Demo http://vgcollect.com/item/77555
The Punisher: No Mercy   PlayStation Network (PS3) [EU] http://vgcollect.com/item/84618
The Ratchet & Clank Trilogy   PlayStation Network (Vita) [EU] http://vgcollect.com/item/66719
THE REN AND STIMPY SHOW   Mega Drive [EU] http://vgcollect.com/item/99194
The Rumble Fish   PlayStation 2 [JP] http://vgcollect.com/item/93090
The S Factor: Sonia and Silver    Sega Genesis [NA] http://vgcollect.com/item/93090
the sacred amulet   PC [NA] http://vgcollect.com/item/57630
The Secret World   PC [EU] http://vgcollect.com/item/63404
The Settlers   PC [EU] http://vgcollect.com/item/67178
The Settlers II Veni, Vidi, Vici   PC [EU] http://vgcollect.com/item/67179
The Settlers: Heritage Of Kings   PC [EU] http://vgcollect.com/item/65443
The Shinri Game 2: Magical Trip   Super Famicom [JP] http://vgcollect.com/item/69809
The Simpsons: Cartoon Studio   PC [NA] http://vgcollect.com/item/75856
The Simpsons: Virtual Springfield   PC [NA] http://vgcollect.com/item/75857


Deso:
The Sims   GameCube [EU] http://vgcollect.com/item/86796
The Sims 2   Game Boy Advance [EU] http://vgcollect.com/item/74997
The Sims 3: World Adventures   PC [NA] http://vgcollect.com/item/72633
The Smurfs   Nintendo Entertainment System [EU] http://vgcollect.com/item/92284
The Spongebob Squarepants Movie   Xbox [EU] http://vgcollect.com/item/85418
The Sports Pack   ZX Spectrum [EU] http://vgcollect.com/item/75511
The Sum Of All Fears   PC [EU] http://vgcollect.com/item/76357
The Summoning   PC [NA] http://vgcollect.com/item/68372
The swapper   Nintendo eShop (Wii U) [NA] http://vgcollect.com/item/94007
The Terminator: Future Shock   PC [NA] http://vgcollect.com/item/82488



mrfoxhound:
The Transporter   PSP UMD Video [EU] http://vgcollect.com/item/80224
The Travels of the Dung Beetle   PC - Digital Download [NA] http://vgcollect.com/item/95948
The Treasure of USAS   MSX2 [JP] http://vgcollect.com/item/76477
The Trials of Topoq   PlayStation Network (PS3) [EU] http://vgcollect.com/item/86643
The Troma Project   Steam http://vgcollect.com/item/94756
The Ultimate 2D Shoot-Em-Up Collection   PC [EU] http://vgcollect.com/item/100719
The Ultimate Doom - Thy Flesh Consumed   PC [EU] http://vgcollect.com/item/88720
The Ultimate Guide to Next-gen Video Games - PlayStation 4   Magazine http://vgcollect.com/item/91664
The Ultimate Trivia Quiz   PlayStation 2 [EU] http://vgcollect.com/item/78579
The Undead Syndrome   Xbox Games Store (X360) [NA] http://vgcollect.com/item/59000
The Urbz   Game Boy Advance [EU] http://vgcollect.com/item/81644
The Vanishing of Ethan Carter   GOG.com http://vgcollect.com/item/79168
The Vindicator   ZX Spectrum [EU] http://vgcollect.com/item/75238
The Warriors   PlayStation Portable [EU] http://vgcollect.com/item/76739
The Witcher   PC [EU] http://vgcollect.com/item/73554
The Witcher: Adventure Game     GOG.com http://vgcollect.com/item/83542
« Last Edit: April 23, 2016, 09:25:06 am by badATchaos »

desocietas

Re: Cleaning out "THE"
« Reply #2 on: April 09, 2016, 06:44:36 pm »
The nice thing about being an admin is that we can modify each other's posts ;)

I marked off my section on the list. I'll work on this now and will strikethrough when done.
Currently playing:
FFXIV (PC), The Witcher (PC), Monster Hunter World: Iceborne (PS4)
twitch.tv/desocietas

davifus

Re: Cleaning out "THE"
« Reply #3 on: April 09, 2016, 06:58:55 pm »
I got nothing better to do at work, I call dibs on these. I'll try to get them done by sometime tonight.

PS.I'll be making little edits into my list so I can check mark & link dup here which I'll put in dub listing when I get home.

The Club   PC [EU] http://vgcollect.com/item/69572 [No dup/Edit Name] ✓
The Count   Commodore VIC-20 Cartridges[NA]http://vgcollect.com/item/81561
[Dup/ http://vgcollect.com/item/52889] ✓
The Cranberries Doors and Windows CD-i [NA] http://vgcollect.com/item/58289 [No dup/Edit Name/Add Pic] ✓
The Crew - Limited Edition   PlayStation 4 [NA] http://vgcollect.com/item/73342  [No dup/Edit Name] ✓
The Croods: Prehistoric Party!   Nintendo 3DS [NA] http://vgcollect.com/item/72948 [No dup/Edit Name] ✓
The Crow: City of Angels   Sega Saturn [EU] http://vgcollect.com/item/88885 [Dup/ http://vgcollect.com/item/73740]
The Cube Connector   GameCube Accessory http://vgcollect.com/item/57108 [No dup/Edit Name] ✓
The Devil Inside   PC [EU] http://vgcollect.com/item/67172 [No dup/Edit Name] ✓
The Dishwasher: Vampire Smile   Xbox Games Store (X360) [EU] http://vgcollect.com/item/95429 [No dup/Edit Name] ✓
The Dukes of Hazzard   PC [EU] http://vgcollect.com/item/79639 [No dup/Edit Name] ✓
The Elder Scrolls: V:Skyrim & Bioshock Infinite Bundle   PlayStation 3 [NA]  http://vgcollect.com/item/94141 [No dup/Edit Name] ✓
The Electric Tale of Pikachu Volume 2: Pikachu Shocks Back   Swag - Print Media (Books, Comics) http://vgcollect.com/item/71559 [No dup/Edit Name] ✓
The Electric Tale of Pikachu Volume 3: Electric Pikachu Boogaloo   Swag - Print Media (Books, Comics) http://vgcollect.com/item/71560 [No dup/Edit Name] ✓
The Electric Tale of Pikachu Volume 4: Surf's Up, Pikachu   Swag - Print Media (Books, Comics) http://vgcollect.com/item/71561 [No dup/Edit Name] ✓
The Entente   PC [EU] http://vgcollect.com/item/78756 [No dup/Edit Name] ✓
The Evil Within   PlayStation 4 [AU] http://vgcollect.com/item/90885 [No dup/Edit Name] ✓
The Evil Within   PlayStation Network (PS3) [NA] http://vgcollect.com/item/78789 [No dup/Edit Name] ✓
the Evil Within   Xbox 360 [NA] http://vgcollect.com/item/95460 [Dup/ http://vgcollect.com/item/95460]]
The Eyes of Bayonetta: Art Book & DVD   Swag - Print Media (Books, Comics) http://vgcollect.com/item/68003 [No dup/Edit Name] ✓
The Fidgetts   Game Boy [EU] http://vgcollect.com/item/75614 [No dup/Edit Name] ✓
The Fifth Element   PC [EU] http://vgcollect.com/item/67182 [No dup/Edit Name] ✓
The Flinstones   Mega Drive [EU] http://vgcollect.com/item/75809 [Dup/ http://vgcollect.com/item/41798]
The Flintstones: Bedrock Bowling   PC [NA] http://vgcollect.com/item/100061 [No dup/Edit Name] ✓
The Four Kings Casino and Slots   PlayStation Network (PS4) [NA] http://vgcollect.com/item/93482  [No dup/Edit Name] ✓
The G.G. Shinobi   Nintendo eShop (3DS) [EU] http://vgcollect.com/item/66077 [No dup/Edit Name] ✓
The Game of Life EX II   PlayStation 2 [JP] http://vgcollect.com/item/74931  [No dup/Edit Name] ✓
The Gamer's Edge Car Power   Other http://vgcollect.com/item/57109  [No dup/Edit Name/ ???] ✓
The Getaway   PlayStation 2 [AU] http://vgcollect.com/item/68454 [No dup/Edit Name] ✓
The Getaway: Black Monday   PlayStation 2 [AU] http://vgcollect.com/item/68470 [No dup/Edit Name] ✓
The Glove - Video Game Control   Nintendo 64 Accessory http://vgcollect.com/item/66739 [No dup/Edit Name] ✓
The Glove Controller     PlayStation Accessory http://vgcollect.com/item/44406 [No dup/Edit Name] ✓
The Greatest NES Games Ever!   Swag - Promo Videos/ Movies http://vgcollect.com/item/63445 [No dup/Edit Name] ✓
The Heavy Rain & BEYOND: Two Souls Collection   PlayStation 4 [EU] http://vgcollect.com/item/98875 [No dup/Edit Name] ✓
The Heroic Legend of Arslan   Mega-CD [JP] http://vgcollect.com/item/75395
The Hive Wars   PlayStation [JP] http://vgcollect.com/item/67300 [Dup/ http://vgcollect.com/item/67310]
The Home Banker   Commodore 64 Floppy Disks [NA] http://vgcollect.com/item/94982 [No dup/Edit Name] ✓
The Horde   PC [NA] http://vgcollect.com/item/64103 [No dup/Edit Name] ✓
The Hustle: Detroit Streets   PlayStation Portable [EU] http://vgcollect.com/item/80401 [No dup/Edit Name] ✓
The Hustle: Detroit Streets   PlayStation Portable [NA] http://vgcollect.com/item/64146 [Dup/ http://vgcollect.com/item/37353]
The Idolm@ster 2   PlayStation 3 [JP] http://vgcollect.com/item/78266 [Dup/ http://vgcollect.com/item/95202]


DONE
« Last Edit: April 15, 2016, 05:15:49 pm by davifus »
"Hard work betrays none, but dreams betray many." ( Hachiman Hikigaya)
"People say nothing's impossible, but I do nothing everyday." (Winnie The Pooh)


davifus

Re: Cleaning out "THE"
« Reply #4 on: April 09, 2016, 07:41:14 pm »
Double Post but what the heck do I do with this?

The cube connector? [ http://vgcollect.com/item/57108] GBA to Cube? AV? Power?

I went through the creator's list. I found another one that I dont know what to do with.

"Ac adaptor" [ http://vgcollect.com/item/56939] is this too general?
"Hard work betrays none, but dreams betray many." ( Hachiman Hikigaya)
"People say nothing's impossible, but I do nothing everyday." (Winnie The Pooh)


Re: Cleaning out "THE"
« Reply #5 on: April 09, 2016, 10:03:30 pm »
That listing is for the AC Adapter to the Atari Lynx. I'm pretty sure that system had one given the absolute crappy battery life it had. haha
It would help if it had an image or something, because the title alone does sound a bit vague.

davifus

Re: Cleaning out "THE"
« Reply #6 on: April 09, 2016, 11:27:23 pm »
That listing is for the AC Adapter to the Atari Lynx. I'm pretty sure that system had one given the absolute crappy battery life it had. haha
It would help if it had an image or something, because the title alone does sound a bit vague.

What about the cube connector?
"Hard work betrays none, but dreams betray many." ( Hachiman Hikigaya)
"People say nothing's impossible, but I do nothing everyday." (Winnie The Pooh)


tripredacus

Re: Cleaning out "THE"
« Reply #7 on: April 11, 2016, 01:10:39 pm »
Double Post but what the heck do I do with this?

The cube connector? [ http://vgcollect.com/item/57108] GBA to Cube? AV? Power?

I went through the creator's list. I found another one that I dont know what to do with.

"Ac adaptor" [ http://vgcollect.com/item/56939] is this too general?

I fixed Cube Connector (former mystery item). FINALLY, someone put one of these up for sale. Mystery solved.
Also put in picture for the Lynx AC Adaptor.

Re: Cleaning out "THE"
« Reply #8 on: April 11, 2016, 02:22:44 pm »
woulndn't it be quite easy to code a verification when entering new objects so that if an object beginning with "The " or "the " is automatically forbidden? Otherwise just cleaning up the mess will not really stop the problem from occuring

tripredacus

Re: Cleaning out "THE"
« Reply #9 on: April 11, 2016, 02:26:30 pm »
woulndn't it be quite easy to code a verification when entering new objects so that if an object beginning with "The " or "the " is automatically forbidden? Otherwise just cleaning up the mess will not really stop the problem from occuring

Yes, the input could be sanitized. Same thing could be used for barcode entries to reject entries over x digits, and to remove spaces. I think tho, that the edit and item submit process would need to add a verify step, which isn't currently in place. Something in between submit and when the record is sent to the queue.

Re: Cleaning out "THE"
« Reply #10 on: April 16, 2016, 10:39:43 am »
Nice work so far folks. We still got a ways to go yet!

mrfoxhound

PRO Supporter

Re: Help clean out "THE"
« Reply #11 on: April 20, 2016, 01:38:37 am »
I'll grab a handful soon and get to it. I agree, Asmodean, if nothing is put in place to stop it, we're going to be forced to keep manually fixing it.

EDIT: You'll notice in my early entries I changed name and posted duplicate instead of just posting duplicate and not changing name, I stopped doing this a couple entries in as I realized I didn't have to edit name if duplicate was found. Just waiting for the changes to be accepted -

The 39 Steps   PC - Digital Download [NA] http://vgcollect.com/item/73622
[Edited name, duplicate found: http://vgcollect.com/item/42536]

The 3rd Birthday   PlayStation Portable [EU] http://vgcollect.com/item/95564
[Edited name, no duplicate found - only [EU] PSP twisted edition]

The A-Team   Tiger LCD http://vgcollect.com/item/21029
[Edited name, no duplicate found.]

The A.Typical RPG   PC - Digital Download [NA] http://vgcollect.com/item/76207
[Edited name, duplicate found: http://vgcollect.com/item/47555]

The Adventure of Puppet Princess + 1   PlayStation [JP] http://vgcollect.com/item/76711
[Edited name, no duplicate found.]

The Adventure of Puppet Princess: Marl Oukoku no Ningyou Hime   PlayStation [JP] http://vgcollect.com/item/76708
[Edited name, no duplicate found.]

The Adventure of Puppet Princess: Marl Oukoku no Ningyou Hime +1   PlayStation [JP] http://vgcollect.com/item/85987
[Edited name, no duplicate found.]

The Adventure of Puppet Princess: Marl Oukoku no Ningyou Hime PSOne Books release   PlayStation [JP] http://vgcollect.com/item/76710
[Edited name, no duplicate found.]

The Adventures Of Batman And Robin - Tiger Barcodzz   Tiger LCD http://vgcollect.com/item/68607
[Edited name, no duplicate found.]

The Adventures Of Bayou Billy   Nintendo eShop (Wii U) [EU] http://vgcollect.com/item/97981
[Edited name, no duplicate found - only EU and NA NES entries.]

The Adventures of St. Bernard   ZX Spectrum [EU] http://vgcollect.com/item/75377
[Edited name, duplicate found: http://vgcollect.com/item/87062]

The Adventures of Tintin: The Secret of the Unicorn   Wii [NA] http://vgcollect.com/item/98070
[Edited name, no duplicate found.]

The All*Star Fighting Festival   PlayStation 2 [JP] http://vgcollect.com/item/58205
[Edited name, no duplicate found.]

The Amazing Spider-Man   PlayStation Network (Vita) [NA] http://vgcollect.com/item/63382
[Edited name, no duplicate found - only Vita version, not PSN Vita version]

The Amazing Spider-Man   Amiga [EU] http://vgcollect.com/item/102133
[Edited name, no duplicate found.]

The ARCHIVE of DRAG-ON DRAGOON   Swag - Print Media (Books, Comics) http://vgcollect.com/item/68595
[Edited name, no duplicate found]

The Art of Fire Emblem: Awakening   Swag - Print Media (Books, Comics) http://vgcollect.com/item/96654
[Edited name, no duplicate found]

The Art of Magic   PC [EU] http://vgcollect.com/item/60841
[Edited name, no duplicate found]

The Art of Performing   CD-i [EU] http://vgcollect.com/item/91113
[Edited name, no duplicate found.]

The Bard's Tale   Xbox [EU] http://vgcollect.com/item/86537
[Duplicate found: http://vgcollect.com/item/85797]

THE BATTLE OF DESTINY   Mega Drive [JP] http://vgcollect.com/item/99199
[Edited name, no duplicate found.]

The Best of Pokemon Adventures: Red   Swag - Print Media (Books, Comics) http://vgcollect.com/item/88311
[Edited name, no duplicate found.]

The Best RPG's Are On Xbox 360   Xbox 360 Demo http://vgcollect.com/item/95826
[Edited name, no duplicate found.]

The Binding of Isaac: Rebirth   PlayStation 4 [EU] http://vgcollect.com/item/95456
[Duplicate found, game is not physical release only digital via PSN: http://vgcollect.com/item/73746]

The BIT.TRIP   PlayStation Network (Vita) [EU] http://vgcollect.com/item/92774
[Edited name, no duplicate found.]

The BIT.TRIP   PlayStation Network (PS4) [NA] http://vgcollect.com/item/92882
[Edited name, no duplicate found.]

The BIT.TRIP   PlayStation Network (Vita) [NA] http://vgcollect.com/item/92883
[Edited name, no duplicate found.]

The Bob DeCrescenzo Collection   Atari 7800 [NA] http://vgcollect.com/item/71860
[Edited name, no duplicate found.]

The Byte Before Christmas   Atari 2600 (VCS) [NA] http://vgcollect.com/item/74593
[Edited name, no duplicate found.]

The CF Powerpack - Mean Stread & Top Duck   Commodore 64 Cassettes [EU] http://vgcollect.com/item/65638
[Edited name, no duplicate found.]

The CF Powerpack Tape 14   Commodore 64 Cassettes [EU] http://vgcollect.com/item/66610
[Edited name, no duplicate found.]

The CF Powerpack Tape 20   Commodore 64 Cassettes [EU] http://vgcollect.com/item/66608
[Edited name, no duplicate found.]

The CF Powerpack Tape 22   Commodore 64 Cassettes [EU] http://vgcollect.com/item/66607
[Edited name, no duplicate found.]

_______

The Improv Presents: Don't Quit Your Day Job   PC [NA] http://vgcollect.com/item/98972
[Edited name, no duplicate found.]

The Incredible Crash Dummies    Tiger LCD http://vgcollect.com/item/81194
[Edited name, no duplicate found.]

The Italian Job   PC [EU] http://vgcollect.com/item/88286
[Edited name, no duplicate found.]

The Italian Job   PlayStation [EU] http://vgcollect.com/item/100604
[Edited name, no duplicate found - PS [EU] found was a Platinum version]

The Jackbox Party Pack   PlayStation Network (PS3) [NA] http://vgcollect.com/item/83780
[Edited name, no duplicate found.]

The King of Fighters '95   Game Boy [JP] http://vgcollect.com/item/89564
[Edited name, no duplicate found.]

The King of Fighters '96   Wii Shop [NA] http://vgcollect.com/item/74485
[Edited name, no duplicate found.]

The King of Fighters '96 + '95   Sega Saturn [JP] http://vgcollect.com/item/75236
[Edited name, no duplicate found.]

The King of Fighters '97   Wii Shop [NA] http://vgcollect.com/item/74486
[Edited name, no duplicate found.]

The King of Fighters '98   Wii Shop [NA] http://vgcollect.com/item/74487
[Edited name, no duplicate found.]

The King of Fighters '99   Wii Shop [NA] http://vgcollect.com/item/74488
[Edited name, no duplicate found.]

The King of Fighters XII   Xbox 360 [EU] http://vgcollect.com/item/71390
[Edited name, no duplicate found.]

The Labyrinth of Grasaia   PlayStation Vita [JP] http://vgcollect.com/item/79371
[Edited name, no duplicate found.]

The Last Blade 2 (NeoCD Rip)   Sega Dreamcast [NA] http://vgcollect.com/item/96471
[Edited name, no duplicate found.]

The Last Federation   Steam http://vgcollect.com/item/97248
[Edited name, possible duplicate: http://vgcollect.com/item/66468]

the last ninja trilogy   PC [NA] http://vgcollect.com/item/93303
[Edited name, no duplicate found.]

The Last of Us   PlayStation 3 [NA] http://vgcollect.com/item/99492
[Duplicate found: http://vgcollect.com/item/20520]

The Last Remnant   Xbox 360 [JP] http://vgcollect.com/item/91746
[Edited name, no duplicate found.]

The Last Story   Wii [EU] http://vgcollect.com/item/62285
[Duplicate found: http://vgcollect.com/item/40235]

The Legaia   PlayStation [JP] http://vgcollect.com/item/64018
[Edited name, no duplicate found.]

The Legend of Dark Witch   Steam  http://vgcollect.com/item/94754
[Edited name, no duplicate found.]

The Legend of Korra    PlayStation Network (PS3) [NA] http://vgcollect.com/item/96164
[Edited name, no duplicate found.]

The Legend of Kyrandia, Book 3: Malcom's Revenge   PC [NA] http://vgcollect.com/item/80462
[Edited name, possible duplicate found: http://vgcollect.com/item/56729]

The Legend of Zelda - Classics   Nintendo Entertainment System [EU] http://vgcollect.com/item/99106
[Edited name, no duplicate found.]

The Legend of Zelda Melodies of Time   Swag - Soundtrack http://vgcollect.com/item/63436
[Edited name, no duplicate found.]

THE LEGEND OF ZELDA: HYRULE HISTORIA   Nintendo eShop (Wii U) [NA] http://vgcollect.com/item/75833
[Edited name, no duplicate found.]

The Legendary Starfy balloons     Swag - Toys/Novelties http://vgcollect.com/item/56366
[Edited name, no duplicate found.]

The Mahjong Touhaiden   Super Famicom [JP] http://vgcollect.com/item/68933
[Edited name, no duplicate found.]

The Matrix   PSP UMD Video [EU] http://vgcollect.com/item/77694
[Edited name, no duplicate found.]

The Matrix Reloaded   PSP UMD Video [EU] http://vgcollect.com/item/77695
[Edited name, no duplicate found.]

The Matrix Revolutions   PSP UMD Video [EU] http://vgcollect.com/item/77696
[Edited name, no duplicate found.]

The Matrix: Path of Neo   PlayStation 2 [AU] http://vgcollect.com/item/68413
[Edited name, no duplicate found.]

The Matrix: Path of Neo   Xbox [NA] http://vgcollect.com/item/100723
[Duplicate found: http://vgcollect.com/item/218]

The Matrix: Path of Neo   PC [EU] http://vgcollect.com/item/70816
[Edited name, no duplicate found.]

The Mix'n Match Collection   PC [NA] http://vgcollect.com/item/79343
[Edited name, no duplicate found.]

The Mummy   PlayStation [EU] http://vgcollect.com/item/66483
[Duplicate found: http://vgcollect.com/item/97169]

The Neverending Story: Auryn Quest   PC [NA] http://vgcollect.com/item/90347
[Edited name, no duplicate found.]

THE NINJA   Sega Master System [EU] http://vgcollect.com/item/99230
[Duplicate found: http://vgcollect.com/item/18781]

The Paradise of Grasaia   PlayStation Vita [JP] http://vgcollect.com/item/79372
[Edited name, no duplicate found.]

The Pit   Arcade (Dedicated) http://vgcollect.com/item/96296
[Edited name, no duplicate found.]

The Premiere Collection Encore - Andrew Lloyd Webber   CD-i [EU] http://vgcollect.com/item/85742
[Edited name, no duplicate found.]

The Pro Mahjong Menkyo Kaiden   PlayStation [JP] http://vgcollect.com/item/85946
[Edited name, no duplicate found.]

The Pro Yakyuu: Pennant Race    Sega Master System [JP] http://vgcollect.com/item/72282
[Edited name, no duplicate found.]

The Punisher Demo Disc   PlayStation 2 Demo http://vgcollect.com/item/77555
[Edited name, no duplicate found]

The Punisher: No Mercy   PlayStation Network (PS3) [EU] http://vgcollect.com/item/84618
[Edited name, no duplicate found.]

The Ratchet & Clank Trilogy   PlayStation Network (Vita) [EU] http://vgcollect.com/item/66719
[Edited name, no duplicate found.]

THE REN AND STIMPY SHOW   Mega Drive [EU] http://vgcollect.com/item/99194
[Edited name, no duplicate found.]

The Rumble Fish   PlayStation 2 [JP] http://vgcollect.com/item/90200
[Edited name, no duplicate found.]

The S Factor: Sonia and Silver    Sega Genesis [NA] http://vgcollect.com/item/93090
[Edited name, no duplicate found.]

the sacred amulet   PC [NA] http://vgcollect.com/item/57630
[Edited name, no duplicate found.]

The Secret World   PC [EU] http://vgcollect.com/item/63404
[Duplicate found: http://vgcollect.com/item/44357]

The Settlers   PC [EU] http://vgcollect.com/item/67178
[Edited name, possible duplicate: http://vgcollect.com/item/83172]

The Settlers II Veni, Vidi, Vici   PC [EU] http://vgcollect.com/item/67179
[Edited name, possible duplicate: http://vgcollect.com/item/35400]

The Settlers: Heritage Of Kings   PC [EU] http://vgcollect.com/item/65443
[Edited name, no duplicate found.]

The Shinri Game 2: Magical Trip   Super Famicom [JP] http://vgcollect.com/item/69809
[Edited name, no duplicate found.]

The Simpsons: Cartoon Studio   PC [NA] http://vgcollect.com/item/75856
[Edited name, no duplicate found.]

The Simpsons: Virtual Springfield   PC [NA] http://vgcollect.com/item/75857
[Edited name, no duplicate found.]

_______

The Transporter   PSP UMD Video [EU] http://vgcollect.com/item/80224
[Edited name, possible duplicate: http://vgcollect.com/item/90397]

The Travels of the Dung Beetle   PC - Digital Download [NA] http://vgcollect.com/item/95948
[Edited name, no duplicate found.]

The Treasure of USAS   MSX2 [JP] http://vgcollect.com/item/76477
[Edited name, no duplicate found.]

The Trials of Topoq   PlayStation Network (PS3) [EU] http://vgcollect.com/item/86643
[Edited name, no duplicate found.]

The Troma Project   Steam http://vgcollect.com/item/94756
[Edited name, no duplicate found.]

The Ultimate 2D Shoot-Em-Up Collection   PC [EU] http://vgcollect.com/item/100719
[Finished before I got to it]

The Ultimate Doom - Thy Flesh Consumed   PC [EU] http://vgcollect.com/item/88720
[Edited name, no duplicate found.]

The Ultimate Guide to Next-gen Video Games - PlayStation 4   Magazine http://vgcollect.com/item/91664
[Edited name, no duplicate found.]

The Ultimate Trivia Quiz   PlayStation 2 [EU] http://vgcollect.com/item/78579
[Edited name, no duplicate found.]

The Undead Syndrome   Xbox Games Store (X360) [NA] http://vgcollect.com/item/59000
[Edited name, no duplicate found.]

The Urbz   Game Boy Advance [EU] http://vgcollect.com/item/81644
[Edited name, no duplicate found.]

The Vanishing of Ethan Carter   GOG.com http://vgcollect.com/item/79168
[Edited name, no duplicate found.]

The Vindicator   ZX Spectrum [EU] http://vgcollect.com/item/75238
[Edited name, no duplicate found.]

The Warriors   PlayStation Portable [EU] http://vgcollect.com/item/76739
[Edited name, no duplicate found.]

The Witcher   PC [EU] http://vgcollect.com/item/73554
[Edited name, no duplicate found.]

The Witcher: Adventure Game     GOG.com http://vgcollect.com/item/83542
[Edited name, no duplicate found.]

COMPLETE
[Skipped over items that weren't duplicates.]
« Last Edit: April 22, 2016, 05:02:29 pm by badATchaos »

Badges

mrfoxhound

PRO Supporter

Re: Help clean out "THE"
« Reply #12 on: April 20, 2016, 07:40:05 pm »
Double post - all entries posted here should be finished now.

Badges

desocietas

Re: Help clean out "THE"
« Reply #13 on: April 20, 2016, 08:25:58 pm »
Double post - all entries posted here should be finished now.

Awesome! Thanks for your help!
Currently playing:
FFXIV (PC), The Witcher (PC), Monster Hunter World: Iceborne (PS4)
twitch.tv/desocietas

mrfoxhound

PRO Supporter

Re: Help clean out "THE"
« Reply #14 on: April 21, 2016, 02:29:25 pm »
No problem. Just working my way up to that infinite edit badge to cash it in for rep. Don't know any other badge that's as respectable. :P

Badges