(Topic ID: 108952)

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

By LaughingOtter

9 years ago



Topic Stats

  • 8 posts
  • 6 Pinsiders participating
  • Latest reply 9 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 9 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 9 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 9 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.

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

    Reply

    Wanna join the discussion? Please sign in to reply to this topic.

    Hey there! Welcome to Pinside!

    Donate to Pinside

    Great to see you're enjoying Pinside! Did you know Pinside is able to run without any 3rd-party banners or ads, thanks to the support from our visitors? Please consider a donation to Pinside and get anext to your username to show for it! Or better yet, subscribe to Pinside+!


    This page was printed from https://pinside.com/pinball/forum/topic/i-have-more-than-300-duptriplequad-locator-entries-tracked?tu=LaughingOtter and we tried optimising it for printing. Some page elements may have been deliberately hidden.

    Scan the QR code on the left to jump to the URL this document was printed from.