(Topic ID: 108952)

I have more than 300 dup/triple/quad Locator entries tracked.


By LaughingOtter

5 years ago



Topic Stats

  • 8 posts
  • 6 Pinsiders participating
  • Latest reply 5 years ago by robin
  • No one calls this topic a favorite

You

Linked Games

No games have been linked to this topic.

    #1 5 years ago

    Hello again!
    You have quite a lot of repetitive entries in your Locator. This has happened before.
    I have a big list of duplicate, triplicate, and quadruplicate entries currently active in your Locator database.
    My usual system is to retain the entry with the most recent Updated date/time and toss the rest.
    Before I give you guys a big list of location slugs to delete, I want to know if this would be an acceptable way to sort them all out.
    Steve

    #2 5 years ago
    Quoted from LaughingOtter:

    Hello again!
    You have quite a lot of repetitive entries in your Locator. This has happened before.
    I have a big list of duplicate, triplicate, and quadruplicate entries currently active in your Locator database.
    My usual system is to retain the entry with the most recent Updated date/time and toss the rest.
    Before I give you guys a big list of location slugs to delete, I want to know if this would be an acceptable way to sort them all out.
    Steve

    Umm, que?

    #3 5 years ago

    I've written programs in perl to read all the entries in your Pinball Locator database. It takes about three hours to run, but it gets all the location and games data for every entry.
    I read through the results afterwards and sort out that you've got lots of repeaters. Here's a couple of freebies!

    The Garage (Eau Claire) canada the-garage-eau-claire-1-calgary-ab-canada canada/the-garage-eau-claire-1-calgary-ab-canada 200 Barclay Parade Southwest #195, Calgary, AB T2P 4R3, Canada Calgary, AB, Canada Added August 4th 51.0527019 -114.069913 Kryzsky 8/4/2014 8:44 Kryzsky 8/4/2014 8:44 No description was given, please enter a description here after you visited the location! http://www.the-garage.ca/ 1 game creature-from-the-black-lagoon|Creature from the Black Lagoon
    The Garage (Eau Claire) canada the-garage-eau-claire-1-calgary-ab-canada-copy canada/the-garage-eau-claire-1-calgary-ab-canada-copy 200 Barclay Parade Southwest #195, Calgary, AB T2P 4R3, Canada Calgary, AB, Canada Added August 4th 51.0527019 -114.069913 Kryzsky 8/4/2014 8:44 Kryzsky 8/4/2014 8:44 No description was given, please enter a description here after you visited the location! http://www.the-garage.ca/ 1 game creature-from-the-black-lagoon|Creature from the Black Lagoon
    The Garage (Eau Claire) canada the-garage-eau-claire-1-calgary-ab-canada-copy-copy canada/the-garage-eau-claire-1-calgary-ab-canada-copy-copy 200 Barclay Parade Southwest #195, Calgary, AB T2P 4R3, Canada Calgary, AB, Canada Added September 3rd 51.0527019 -114.069913 Kryzsky 9/3/2014 8:00 Kryzsky 9/3/2014 8:00 No description was given, please enter a description here after you visited the location! http://the-garage.ca 1 game creature-from-the-black-lagoon|Creature from the Black Lagoon

    Tiger Lounge, The united-states tiger-lounge-the-406-seattle-wa-united-states united-states/tiger-lounge-the-406-seattle-wa-united-states 412 South Orcas Street, Seattle, WA 98108, USA Seattle, WA, United States Added May 4th 47.552118 -122.328814 LaughingOtter 5/4/2011 17:07 JerryDanzig 1/26/2013 18:05 No description was given, please enter a description here after you visited the location! http://www.tigerloungeagogo.com/ 2 games hokus-pokus|Hokus Pokus^space-mission|Space Mission
    The Blu Grouse united-states the-blu-grouse-1-seattle-wa-united-states Seattle, WA, United States Added December 1st 1 game hang-glider|Hang Glider

    In the first case, the third entry has the latest entry/updated date so would probably have the most recent list. The other two are duplicates.
    In the second case, the Tiger Lounge closed and the Blu Grouse opened. Same location, different names. I've got more of those too.

    #4 5 years ago

    stud

    #5 5 years ago

    I would think you and Robin could work on this? And start a sticky on pinsiders please update locations.

    #6 5 years ago

    Well, good for you!

    Maybe send a message to contact a moderator. Attn. Robin.

    #7 5 years ago

    I didn't know Robin was still running things. OK, I'll do that.
    Good for me? Not really. Tons of corrections and all that. Good for Pinside? Definitely.

    #8 5 years ago

    Thanks for all your efforts, LaughingOtter! Your help with the map his much appreciated.

    FYI, I hooked LaughingOtter up with a map editor account, allowing him to implement his changes directly into the Pinside locations database.

    Promoted items from the Pinside Marketplace
    $ 89.99
    $ 7,499.00
    Pinball Machine
    Nitro Pinball Shop
    From: $ 5,799.00
    Pinball Machine
    Great American Pinball
    $ 199.99
    Lighting - Led
    PinballBulbs
    $ 27.99
    Eproms
    Matt's Basement Arcade
    $ 218.00
    From: $ 5,999.00
    Pinball Machine
    Monster Bash Remake Out of stock
    Flip N Out Pinball
    $ 7.49
    Electronics
    Yorktown Parts and Equip
    $ 37.00
    Playfield - Toys/Add-ons
    The MOD Couple
    $ 44.95
    Playfield - Toys/Add-ons
    PinBoss Mods
    $ 58.00
    Playfield - Toys/Add-ons
    Lermods
    $ 6.00
    Cabinet - Other
    Siegecraft Electronics
    $ 95.95
    Cabinet - Shooter Rods
    Super Skill Shot Shop
    $ 9.99
    Eproms
    Matt's Basement Arcade
    $ 234.99
    $ 36.99
    Eproms
    Matt's Basement Arcade
    $ 18.99
    $ 9.99
    $ 199.99
    Lighting - Other
    Lighted Pinball Mods
    From: $ 220.00
    From: $ 140.00
    $ 10.95
    $ 7,500.00
    Pinball Machine
    Great American Pinball
    € 222.00
    Cabinet - Decals
    Buthamburg

    Hey there! Got a moment?

    Great to see you're enjoying Pinside! Did you know Pinside is able to run thanks to donations from our visitors? Please donate to Pinside, support the site and get anext to your username to show for it! Donate to Pinside