{"id":1242323,"date":"2017-02-20T11:11:02","date_gmt":"2017-02-20T19:11:02","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/"},"modified":"2017-02-21T08:23:09","modified_gmt":"2017-02-21T16:23:09","slug":"filter-bar-location-has-duplicate-autocomplete-entries","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/","title":{"rendered":"Filter Bar Location has Duplicate Autocomplete Entries"},"content":{"rendered":"<p>Greetings!<\/p>\n<p>A couple months back we had issues with states&#8217; full names and their abbreviations competing with each other to claim certain events: https:\/\/theeventscalendar.com\/support\/forums\/topic\/states-listed-in-multiple-formats-based-on-import-but-not-on-database\/<\/p>\n<p>Meaning, FL and Florida were completely separate when running a search, even though, ideally, both would be acceptable and mean the same thing to the system, regardless of what was input. Weirdly, it was hard to find any traces of the abbreviations in the Venue information in the database. There were some events where on the single event detail page, yes, it used the abbreviation, presumably from being entered that way in an import. But it also looked like, after the import, the plug-in did the conversion. It just hasn&#8217;t appeared to honor that in practice in search.<\/p>\n<p>Now we&#8217;re back to something similar, though I imagine this might be simpler or down to user error. In the Filter Bar, we&#8217;re having duplicates with the City filter, where there is both an ORLANDO, for example, and an Orlando. Is there a way for it to mix these together? To ignore case sensitivity, but also to just never show extra versions in the first place?<\/p>\n<p>If not, is there a suggestion as far as how to reform the database to get them to match?<\/p>\n<p>Cheers,<br \/>\nVincent J.<\/p>\n","protected":false},"template":"","class_list":["post-1242323","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Filter Bar Location has Duplicate Autocomplete Entries -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Filter Bar Location has Duplicate Autocomplete Entries -\" \/>\n<meta property=\"og:description\" content=\"Greetings! A couple months back we had issues with states&#8217; full names and their abbreviations competing with each other to claim certain events: https:\/\/theeventscalendar.com\/support\/forums\/topic\/states-listed-in-multiple-formats-based-on-import-but-not-on-database\/ Meaning, FL and Florida were completely separate when running a search, even though, ideally, both would be acceptable and mean the same thing to the system, regardless of what was input. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-21T16:23:09+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/\",\"name\":\"Filter Bar Location has Duplicate Autocomplete Entries -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-02-20T19:11:02+00:00\",\"dateModified\":\"2017-02-21T16:23:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Filter Bar\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/filter-bar\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Filter Bar Location has Duplicate Autocomplete Entries\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Filter Bar Location has Duplicate Autocomplete Entries -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/","og_locale":"en_US","og_type":"article","og_title":"Filter Bar Location has Duplicate Autocomplete Entries -","og_description":"Greetings! A couple months back we had issues with states&#8217; full names and their abbreviations competing with each other to claim certain events: https:\/\/theeventscalendar.com\/support\/forums\/topic\/states-listed-in-multiple-formats-based-on-import-but-not-on-database\/ Meaning, FL and Florida were completely separate when running a search, even though, ideally, both would be acceptable and mean the same thing to the system, regardless of what was input. [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/","article_modified_time":"2017-02-21T16:23:09+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/","name":"Filter Bar Location has Duplicate Autocomplete Entries -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-02-20T19:11:02+00:00","dateModified":"2017-02-21T16:23:09+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/filter-bar-location-has-duplicate-autocomplete-entries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Filter Bar","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/filter-bar\/"},{"@type":"ListItem","position":5,"name":"Filter Bar Location has Duplicate Autocomplete Entries"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1242323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1242323\/revisions"}],"predecessor-version":[{"id":1242985,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1242323\/revisions\/1242985"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1242323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}