{"id":23346,"date":"2024-09-01T10:39:38","date_gmt":"2024-09-01T10:39:38","guid":{"rendered":"http:\/\/www.intellicti.com\/help\/?p=23346"},"modified":"2025-05-28T10:59:54","modified_gmt":"2025-05-28T10:59:54","slug":"infor-crm-changes-country-data","status":"publish","type":"post","link":"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/","title":{"rendered":"Infor CRM Changes to Country Data"},"content":{"rendered":"<p><!-- Article Header --><\/p>\n<div class=\"qgkb-articleheader\">\n<table summary=\"Article Summary\">\n<tbody>\n<tr class=\"qgkb-articleheader-table-header\">\n<td style=\"border-top-width: 5px;\" valign=\"top\" width=\"22%\"><b>Summary:<\/b><\/td>\n<td valign=\"top\" width=\"78%\">Information on Infor CRM changes to country data and the impact of these changes for intelli-CTi&#x2122; users.<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td valign=\"top\"><b>Article Type:<\/b><\/td>\n<td valign=\"top\">\u00a0Troubleshooting<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td valign=\"top\"><b>Related Product(s):<\/b><\/td>\n<td valign=\"top\">This article relates to the following products:<\/p>\n<ul>\n<li>Infor CRM SLX (formerly Saleslogix)<\/li>\n<li>intelli-CTi&#x2122; for Infor CRM SLX (Saleslogix)<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"border-bottom: 3px solid;\" valign=\"top\"><b>Related Articles:<\/b><\/td>\n<td style=\"border-bottom: 1px solid;\" valign=\"top\">\n<ul>\n<li>None<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><!-- Article Header End--><\/p>\n<p><!-- Article Content --><\/p>\n<h2>Overview<\/h2>\n<p>Updates to the Country Pick List included as part of the 8.0 to 8.1 upgrade bundle introduced some discrepancies which would lead to inconsistent address data.<\/p>\n<h2>Cause<\/h2>\n<p>Upon further investigation we found there were various issues, some pre-existing and some introduced by the update, Amongst the issues found there were multiple options (e.g. USA, United States), Multiple iterations (e.g. Bolivia, Bolivia, Plurinational State of, Moldova, Moldova, Republic of) Spelling mistakes (e.g. Norfold Island, Pictcairn) and entries which do not constitute a country and so on.<\/p>\n<p>Having reviewed the Country Pick List and found all of these issues, this had to be updated and thus an investigation into updating the appropriate values was started.<\/p>\n<h2>Resolution<\/h2>\n<p>The initial thoughts were to use ISO, however, the ISO country list is a standard for ISO codes. The country names are defined, provided, and updated by the United Nations Statistics Divisions, as an address there are multiple examples that are not appropriate for everyday use and some imply that they will change in time.<\/p>\n<p>We also considered data provider(s) as where you get the majority of countries from is important, as this will dictate what will most frequently be entered into a system from \u2013 therefore minimizing the user having to change the country on data entry \u2013 which they will not. In the examples we looked at the data providers were not returning ISO country names.<\/p>\n<p>There are an abundance of country address lists available, however, in comparison there were always differences between them, so what to use?<\/p>\n<p>We decided the only option was to use a combination of sources, perhaps not ideal moving forward as there is no one source to reference back to in the future, however for our requirements this was the most appropriate solution, One which is unlikely suitable for everyone but fulfilled our requirements.<\/p>\n<p>The sources used were a combination of:<\/p>\n<ul>\n<li><strong>Google Maps<\/strong><\/li>\n<li><strong>ISO<\/strong>\n<ul>\n<li><a href=\"https:\/\/www.iso.org\/obp\/ui\/#search\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.iso.org\/obp\/ui\/#search<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>List of countries of the world<\/strong>\n<ul>\n<li><a href=\"http:\/\/www.listofcountriesoftheworld.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/www.listofcountriesoftheworld.com\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>We used Google Maps as the master for the majority of entries but still found some idiosyncrasies (e.g. DRC \u2013 Congo, The Democratic Republic of the) and gaps, These were amended and or plugged from the other two sources.<\/p>\n<h2>Impact for intelli-CTi&#x2122; Users<\/h2>\n<p>The addition, duplication and removal of multiple items in the County&#8217;s Pick List can potentially cause a\u00a0problem\u00a0for\u00a0existing intelli-CTi&#x2122; users, as these changes are not automatically reflected in our intelli-TNS (Telephone Number Support) Country records. \u00a0Without a correct mapping (e.g. for any new\/duplicate Countries), any telephone numbers processed will likely fall-back to the &#8220;Default&#8221; Country Code&#8217;s rule.<\/p>\n<h3>Resolution for intelli-CTi Users<\/h3>\n<p>The short-term solution for affected intelli-CTi&#x2122; users could be to identify the Countries that\u00a0are new\/renamed and compare those with existing TNS Country records and update accordingly (e.g. re-select the new Country Pick List name for an existing TNS Country record). \u00a0However, this will not solve the issue of new\/duplicated Country Pick List items.<\/p>\n<p>The long-term solution, and one that we believe to be the best way forward, is for us to update the intelli-CTi&#x2122; for Infor CRM product to allow more flexible associations of Infor Country Pick List items to TNS Country records. \u00a0Our plan is to include support this functionality in the next release of intelli-CTi for Infor CRM.<\/p>\n<p>Either way, if you are an intelli-CTi&#x2122; user and\u00a0would like assistance with this scenario, please <a href=\"https:\/\/www.intellicti.com\/contact-us\/\">contact QWARE <\/a>for more information.<\/p>\n<p><!-- Article Content End--><\/p>\n<p><!----------------------------- Article Footer Start - DO NOT REMOVE ------------------------------><\/p>\n<table style=\"border-bottom: none;\" summary=\"Article Summary\">\n<tbody>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"width: 25%; border-top-color: currentColor; border-top-width: 3px; border-top-style: solid;\" valign=\"top\"><strong>\u00a0Related Resources:<\/strong><\/td>\n<td style=\"width: 75%; border-top-color: currentColor; border-top-width: 1px; border-top-style: solid;\" valign=\"top\">\n<ul>\n<li>None<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"vertical-align: top; border-top: 1px solid #e6e6e6;\"><strong><span style=\"color: #444444;\"><span style=\"line-height: 14px; font-size: 14px;\">Further Information:<\/span><\/span><\/strong><\/td>\n<td style=\"vertical-align: top; border-top: 1px solid #e6e6e6;\">\n<ul>\n<li><a href=\"\/help\/\">intelli-CTi Help Center<\/a><\/li>\n<li><a href=\"\/help\/faqs\/\">intelli-CTi\u00a0FAQs<\/a><\/li>\n<li><a href=\"\/help\/troubleshooting\/\">intelli-CTi\u00a0\u00a0Troubleshooting<\/a><\/li>\n<li><a href=\"\/help\/how-to-guides\/\">intelli-CTi\u00a0How-To Guides<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/technical-articles\/\">intelli-CTi\u00a0Technical Articles<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/documents\/\">intelli-CTi\u00a0Document Library<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-------------------------------------- Article Footer End ---------------------------------------><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-23346\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-23346\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/\" target=\"_blank\" title=\"Click to print\"><span>Print<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Summary: Information on Infor CRM changes to country data and the impact of these changes for intelli-CTi&#x2122; users. Article Type: \u00a0Troubleshooting Related Product(s): This article relates to the following products: Infor CRM SLX (formerly Saleslogix) intelli-CTi&#x2122; for Infor CRM SLX (Saleslogix) Related Articles: None Overview Updates to the Country Pick List included as part of &hellip; <a href=\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Infor CRM Changes to Country Data<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-23346\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-23346\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/\" target=\"_blank\" title=\"Click to print\"><span>Print<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":21,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[134,15,355],"tags":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.1.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"A help Center article covering information on Infor CRM changes to country data and the impact of these changes for intelli-CTi users.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:title\" content=\"Infor CRM Changes to Country Data - The intelli-CTi Help Center\" \/>\n<meta name=\"twitter:description\" content=\"A help Center article covering information on Infor CRM changes to country data and the impact of these changes for intelli-CTi users.\" \/>\n<meta name=\"twitter:creator\" content=\"@intelliCTi\" \/>\n<meta name=\"twitter:site\" content=\"@intelliCTi\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.intellicti.com\/help\/#website\",\"url\":\"https:\/\/www.intellicti.com\/help\/\",\"name\":\"The intelli-CTi Help Center\",\"description\":\"Customer Self Help, intelli-CTi product news and blog articles\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.intellicti.com\/help\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/#webpage\",\"url\":\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/\",\"name\":\"Infor CRM Changes to Country Data - The intelli-CTi Help Center\",\"isPartOf\":{\"@id\":\"https:\/\/www.intellicti.com\/help\/#website\"},\"datePublished\":\"2024-09-01T10:39:38+00:00\",\"dateModified\":\"2025-05-28T10:59:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.intellicti.com\/help\/#\/schema\/person\/553240b39260b41170ae563fc6640ef7\"},\"description\":\"A help Center article covering information on Infor CRM changes to country data and the impact of these changes for intelli-CTi users.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.intellicti.com\/help\/infor-crm-changes-country-data\/\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.intellicti.com\/help\/#\/schema\/person\/553240b39260b41170ae563fc6640ef7\",\"name\":\"intelli-CTi Team\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.intellicti.com\/help\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/00c6cd7408c3531da38599fd6bccaa5c?s=96&d=mm&r=g\",\"caption\":\"intelli-CTi Team\"},\"sameAs\":[\"http:\/\/www.intellicti.com\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8OqwE-64y","_links":{"self":[{"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/posts\/23346"}],"collection":[{"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/comments?post=23346"}],"version-history":[{"count":4,"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/posts\/23346\/revisions"}],"predecessor-version":[{"id":26032,"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/posts\/23346\/revisions\/26032"}],"wp:attachment":[{"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/media?parent=23346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/categories?post=23346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.intellicti.com\/help\/wp-json\/wp\/v2\/tags?post=23346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}