(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.

    You're currently viewing posts by Pinsider LaughingOtter.
    Click here to go back to viewing the entire thread.

    #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

    #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.

    #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.

    Promoted items from the Pinside Marketplace
    $ 75.00
    Playfield - Toys/Add-ons
    Whitewater pinball mods
    $ 48.00
    Cabinet - Other
    ModFather Pinball Mods
    $ 49.95
    Playfield - Toys/Add-ons
    pinballmod
    From: $ 42.00
    Cabinet - Shooter Rods
    ModFather Pinball Mods
    From: $ 38.00
    Playfield - Other
    Pin Monk
    $ 109.99
    $ 22.50
    $ 269.00
    Cabinet - Other
    PinGraffix Pinside Shop
    $ 154.00
    Cabinet - Toppers
    Id Rather Play Pinball
    $ 163.00
    Playfield - Toys/Add-ons
    The MOD Couple
    From: $ 22.00
    Playfield - Toys/Add-ons
    ModFather Pinball Mods
    $ 5,800.00
    Pinball Machine
    Great American Pinball
    $ 9,500.00
    Pinball Machine
    Little Shop Of Games
    $ 6.00
    Cabinet - Other
    Siegecraft Electronics
    From: $ 9.99
    Eproms
    Matt's Basement Arcade
    $ 58.00
    Playfield - Toys/Add-ons
    Lermods
    From: $ 99.00
    Lighting - Under Cabinet
    Rock Custom Pinball
    $ 149.99
    Playfield - Toys/Add-ons
    Lighted Pinball Mods
    $ 229.99
    Lighting - Other
    Lighted Pinball Mods
    From: $ 175.00
    Gameroom - Decorations
    Pinball Photos
    From: $ 220.00
    Playfield - Toys/Add-ons
    CzTV Mods
    € 159.00
    Cabinet - Toppers
    FlipperLED
    $ 15.00
    Playfield - Protection
    Professor Pinball
    $ 69.95
    Playfield - Toys/Add-ons
    Hookedonpinball.com

    You're currently viewing posts by Pinsider LaughingOtter.
    Click here to go back to viewing the entire thread.

    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