Readable segment values for browser, os and country segments (#13929)

* Use readable segment value for browser and os segments instead of short codes

* readds original segments using short codes

* Adds additional segment country name to segment by (english) country name

* compare browser and os names case sensitive for segments

* use correct segments for reports

* update tests

6 files changed, 544 insertions, 0 deletions

diff --git a/plugins/API/tests/System/expected/test_AutoSuggestAPITest_browserName__API.getSuggestedValuesForSegment.xml b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_browserName__API.getSuggestedValuesForSegment.xml
new file mode 100644
index 0000000000..da945617ea
--- /dev/null
+++ b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_browserName__API.getSuggestedValuesForSegment.xml
@@ -0,0 +1,171 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>360 Phone Browser</row>
+	<row>360 Browser</row>
+	<row>Avant Browser</row>
+	<row>ABrowse</row>
+	<row>ANT Fresco</row>
+	<row>ANTGalio</row>
+	<row>Aloha Browser</row>
+	<row>Amaya</row>
+	<row>Amigo</row>
+	<row>Android Browser</row>
+	<row>AOL Shield</row>
+	<row>Arora</row>
+	<row>Amiga Voyager</row>
+	<row>Amiga Aweb</row>
+	<row>Atomic Web Browser</row>
+	<row>Avast Secure Browser</row>
+	<row>Beaker Browser</row>
+	<row>BlackBerry Browser</row>
+	<row>Baidu Browser</row>
+	<row>Baidu Spark</row>
+	<row>Beonex</row>
+	<row>Bunjalloo</row>
+	<row>B-Line</row>
+	<row>Brave</row>
+	<row>BriskBard</row>
+	<row>BrowseX</row>
+	<row>Camino</row>
+	<row>Coc Coc</row>
+	<row>Comodo Dragon</row>
+	<row>Coast</row>
+	<row>Charon</row>
+	<row>Chrome Frame</row>
+	<row>Headless Chrome</row>
+	<row>Chrome</row>
+	<row>Chrome Mobile iOS</row>
+	<row>Conkeror</row>
+	<row>Chrome Mobile</row>
+	<row>CoolNovo</row>
+	<row>CometBird</row>
+	<row>ChromePlus</row>
+	<row>Chromium</row>
+	<row>Cyberfox</row>
+	<row>Cheshire</row>
+	<row>Cunaguaro</row>
+	<row>dbrowser</row>
+	<row>Deepnet Explorer</row>
+	<row>Dolphin</row>
+	<row>Dorado</row>
+	<row>Dooble</row>
+	<row>Dillo</row>
+	<row>Epic</row>
+	<row>Elinks</row>
+	<row>Element Browser</row>
+	<row>GNOME Web</row>
+	<row>Espial TV Browser</row>
+	<row>Firebird</row>
+	<row>Fluid</row>
+	<row>Fennec</row>
+	<row>Firefox</row>
+	<row>Firefox Focus</row>
+	<row>Flock</row>
+	<row>Firefox Mobile</row>
+	<row>Fireweb</row>
+	<row>Fireweb Navigator</row>
+	<row>Galeon</row>
+	<row>Google Earth</row>
+	<row>HotJava</row>
+	<row>Iceape</row>
+	<row>IBrowse</row>
+	<row>iCab</row>
+	<row>iCab Mobile</row>
+	<row>Iridium</row>
+	<row>IceDragon</row>
+	<row>Isivioo</row>
+	<row>Iceweasel</row>
+	<row>Internet Explorer</row>
+	<row>IE Mobile</row>
+	<row>Iron</row>
+	<row>Jasmine</row>
+	<row>Jig Browser</row>
+	<row>Kindle Browser</row>
+	<row>K-meleon</row>
+	<row>Konqueror</row>
+	<row>Kapiko</row>
+	<row>Kylo</row>
+	<row>Kazehakase</row>
+	<row>Liebao</row>
+	<row>LG Browser</row>
+	<row>Links</row>
+	<row>LuaKit</row>
+	<row>Lunascape</row>
+	<row>Lynx</row>
+	<row>MicroB</row>
+	<row>NCSA Mosaic</row>
+	<row>Mercury</row>
+	<row>Mobile Safari</row>
+	<row>Midori</row>
+	<row>MIUI Browser</row>
+	<row>Mobile Silk</row>
+	<row>Maxthon</row>
+	<row>Nokia Browser</row>
+	<row>Nokia OSS Browser</row>
+	<row>Nokia Ovi Browser</row>
+	<row>NetSurf</row>
+	<row>NetFront</row>
+	<row>NetFront Life</row>
+	<row>NetPositive</row>
+	<row>Netscape</row>
+	<row>NTENT Browser</row>
+	<row>Obigo</row>
+	<row>Odyssey Web Browser</row>
+	<row>Off By One</row>
+	<row>ONE Browser</row>
+	<row>Opera Mini</row>
+	<row>Opera Mobile</row>
+	<row>Opera</row>
+	<row>Opera Next</row>
+	<row>Opera Touch</row>
+	<row>Oregano</row>
+	<row>Openwave Mobile Browser</row>
+	<row>OmniWeb</row>
+	<row>Otter Browser</row>
+	<row>Palm Blazer</row>
+	<row>Pale Moon</row>
+	<row>Oppo Browser</row>
+	<row>Palm Pre</row>
+	<row>Puffin</row>
+	<row>Palm WebPro</row>
+	<row>Palmscape</row>
+	<row>Phoenix</row>
+	<row>Polaris</row>
+	<row>Polarity</row>
+	<row>Microsoft Edge</row>
+	<row>QQ Browser</row>
+	<row>Qutebrowser</row>
+	<row>QupZilla</row>
+	<row>Qwant Mobile</row>
+	<row>Rekonq</row>
+	<row>RockMelt</row>
+	<row>Samsung Browser</row>
+	<row>Sailfish Browser</row>
+	<row>SEMC-Browser</row>
+	<row>Sogou Explorer</row>
+	<row>Safari</row>
+	<row>Shiira</row>
+	<row>Skyfire</row>
+	<row>Seraphic Sraf</row>
+	<row>Sleipnir</row>
+	<row>SeaMonkey</row>
+	<row>Snowshoe</row>
+	<row>Sunrise</row>
+	<row>SuperBird</row>
+	<row>Streamy</row>
+	<row>Swiftfox</row>
+	<row>TenFourFox</row>
+	<row>Tenta Browser</row>
+	<row>Tizen Browser</row>
+	<row>TweakStyle</row>
+	<row>UC Browser</row>
+	<row>Vivaldi</row>
+	<row>Vision Mobile Browser</row>
+	<row>WebPositive</row>
+	<row>Waterfox</row>
+	<row>wOSBrowser</row>
+	<row>WeTab Browser</row>
+	<row>Yandex Browser</row>
+	<row>Xiino</row>
+	<row>Unknown</row>
+</result>
\ No newline at end of file
diff --git a/plugins/API/tests/System/expected/test_AutoSuggestAPITest_browserName__VisitsSummary.get_range.xml b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_browserName__VisitsSummary.get_range.xml
new file mode 100644
index 0000000000..d8bcdace18
--- /dev/null
+++ b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_browserName__VisitsSummary.get_range.xml
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<nb_visits>0</nb_visits>
+	<nb_actions>0</nb_actions>
+	<nb_visits_converted>0</nb_visits_converted>
+	<bounce_count>0</bounce_count>
+	<sum_visit_length>0</sum_visit_length>
+	<max_actions>0</max_actions>
+	<bounce_rate>0%</bounce_rate>
+	<nb_actions_per_visit>0</nb_actions_per_visit>
+	<avg_time_on_site>0</avg_time_on_site>
+</result>
\ No newline at end of file
diff --git a/plugins/API/tests/System/expected/test_AutoSuggestAPITest_countryName__API.getSuggestedValuesForSegment.xml b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_countryName__API.getSuggestedValuesForSegment.xml
new file mode 100644
index 0000000000..da4e9c8b1e
--- /dev/null
+++ b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_countryName__API.getSuggestedValuesForSegment.xml
@@ -0,0 +1,253 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>Andorra</row>
+	<row>United Arab Emirates</row>
+	<row>Afghanistan</row>
+	<row>Antigua &amp; Barbuda</row>
+	<row>Anguilla</row>
+	<row>Albania</row>
+	<row>Armenia</row>
+	<row>Angola</row>
+	<row>Antarctica</row>
+	<row>Argentina</row>
+	<row>American Samoa</row>
+	<row>Austria</row>
+	<row>Australia</row>
+	<row>Aruba</row>
+	<row>Åland Islands</row>
+	<row>Azerbaijan</row>
+	<row>Bosnia &amp; Herzegovina</row>
+	<row>Barbados</row>
+	<row>Bangladesh</row>
+	<row>Belgium</row>
+	<row>Burkina Faso</row>
+	<row>Bulgaria</row>
+	<row>Bahrain</row>
+	<row>Burundi</row>
+	<row>Benin</row>
+	<row>St. Barthélemy</row>
+	<row>Bermuda</row>
+	<row>Brunei</row>
+	<row>Bolivia</row>
+	<row>Caribbean Netherlands</row>
+	<row>Brazil</row>
+	<row>Bahamas</row>
+	<row>Bhutan</row>
+	<row>Bouvet Island</row>
+	<row>Botswana</row>
+	<row>Belarus</row>
+	<row>Belize</row>
+	<row>Canada</row>
+	<row>Cocos (Keeling) Islands</row>
+	<row>Congo - Kinshasa</row>
+	<row>Central African Republic</row>
+	<row>Congo - Brazzaville</row>
+	<row>Switzerland</row>
+	<row>Côte d’Ivoire</row>
+	<row>Cook Islands</row>
+	<row>Chile</row>
+	<row>Cameroon</row>
+	<row>China</row>
+	<row>Colombia</row>
+	<row>Costa Rica</row>
+	<row>Cuba</row>
+	<row>Cape Verde</row>
+	<row>Curaçao</row>
+	<row>Christmas Island</row>
+	<row>Cyprus</row>
+	<row>Czechia</row>
+	<row>Germany</row>
+	<row>Djibouti</row>
+	<row>Denmark</row>
+	<row>Dominica</row>
+	<row>Dominican Republic</row>
+	<row>Algeria</row>
+	<row>Ecuador</row>
+	<row>Estonia</row>
+	<row>Egypt</row>
+	<row>Western Sahara</row>
+	<row>Eritrea</row>
+	<row>Spain</row>
+	<row>Ethiopia</row>
+	<row>Finland</row>
+	<row>Fiji</row>
+	<row>Falkland Islands</row>
+	<row>Micronesia</row>
+	<row>Faroe Islands</row>
+	<row>France</row>
+	<row>Gabon</row>
+	<row>United Kingdom</row>
+	<row>Grenada</row>
+	<row>Georgia</row>
+	<row>French Guiana</row>
+	<row>Guernsey</row>
+	<row>Ghana</row>
+	<row>Gibraltar</row>
+	<row>Greenland</row>
+	<row>Gambia</row>
+	<row>Guinea</row>
+	<row>Guadeloupe</row>
+	<row>Equatorial Guinea</row>
+	<row>Greece</row>
+	<row>South Georgia &amp; South Sandwich Islands</row>
+	<row>Guatemala</row>
+	<row>Guam</row>
+	<row>Guinea-Bissau</row>
+	<row>Guyana</row>
+	<row>Hong Kong SAR China</row>
+	<row>Heard &amp; McDonald Islands</row>
+	<row>Honduras</row>
+	<row>Croatia</row>
+	<row>Haiti</row>
+	<row>Hungary</row>
+	<row>Indonesia</row>
+	<row>Ireland</row>
+	<row>Israel</row>
+	<row>Isle of Man</row>
+	<row>India</row>
+	<row>British Indian Ocean Territory</row>
+	<row>Iraq</row>
+	<row>Iran</row>
+	<row>Iceland</row>
+	<row>Italy</row>
+	<row>Jersey</row>
+	<row>Jamaica</row>
+	<row>Jordan</row>
+	<row>Japan</row>
+	<row>Kenya</row>
+	<row>Kyrgyzstan</row>
+	<row>Cambodia</row>
+	<row>Kiribati</row>
+	<row>Comoros</row>
+	<row>St. Kitts &amp; Nevis</row>
+	<row>North Korea</row>
+	<row>South Korea</row>
+	<row>Kuwait</row>
+	<row>Cayman Islands</row>
+	<row>Kazakhstan</row>
+	<row>Laos</row>
+	<row>Lebanon</row>
+	<row>St. Lucia</row>
+	<row>Liechtenstein</row>
+	<row>Sri Lanka</row>
+	<row>Liberia</row>
+	<row>Lesotho</row>
+	<row>Lithuania</row>
+	<row>Luxembourg</row>
+	<row>Latvia</row>
+	<row>Libya</row>
+	<row>Morocco</row>
+	<row>Monaco</row>
+	<row>Moldova</row>
+	<row>Montenegro</row>
+	<row>St. Martin</row>
+	<row>Madagascar</row>
+	<row>Marshall Islands</row>
+	<row>Macedonia</row>
+	<row>Mali</row>
+	<row>Myanmar (Burma)</row>
+	<row>Mongolia</row>
+	<row>Macau SAR China</row>
+	<row>Northern Mariana Islands</row>
+	<row>Martinique</row>
+	<row>Mauritania</row>
+	<row>Montserrat</row>
+	<row>Malta</row>
+	<row>Mauritius</row>
+	<row>Maldives</row>
+	<row>Malawi</row>
+	<row>Mexico</row>
+	<row>Malaysia</row>
+	<row>Mozambique</row>
+	<row>Namibia</row>
+	<row>New Caledonia</row>
+	<row>Niger</row>
+	<row>Norfolk Island</row>
+	<row>Nigeria</row>
+	<row>Nicaragua</row>
+	<row>Netherlands</row>
+	<row>Norway</row>
+	<row>Nepal</row>
+	<row>Nauru</row>
+	<row>Niue</row>
+	<row>New Zealand</row>
+	<row>Oman</row>
+	<row>Panama</row>
+	<row>Peru</row>
+	<row>French Polynesia</row>
+	<row>Papua New Guinea</row>
+	<row>Philippines</row>
+	<row>Pakistan</row>
+	<row>Poland</row>
+	<row>St. Pierre &amp; Miquelon</row>
+	<row>Pitcairn Islands</row>
+	<row>Puerto Rico</row>
+	<row>Palestinian Territories</row>
+	<row>Portugal</row>
+	<row>Palau</row>
+	<row>Paraguay</row>
+	<row>Qatar</row>
+	<row>Réunion</row>
+	<row>Romania</row>
+	<row>Serbia</row>
+	<row>Russia</row>
+	<row>Rwanda</row>
+	<row>Saudi Arabia</row>
+	<row>Solomon Islands</row>
+	<row>Seychelles</row>
+	<row>Sudan</row>
+	<row>Sweden</row>
+	<row>Singapore</row>
+	<row>St. Helena</row>
+	<row>Slovenia</row>
+	<row>Svalbard &amp; Jan Mayen</row>
+	<row>Slovakia</row>
+	<row>Sierra Leone</row>
+	<row>San Marino</row>
+	<row>Senegal</row>
+	<row>Somalia</row>
+	<row>Suriname</row>
+	<row>South Sudan</row>
+	<row>São Tomé &amp; Príncipe</row>
+	<row>El Salvador</row>
+	<row>Sint Maarten</row>
+	<row>Syria</row>
+	<row>Swaziland</row>
+	<row>Turks &amp; Caicos Islands</row>
+	<row>Chad</row>
+	<row>French Southern Territories</row>
+	<row>Togo</row>
+	<row>Thailand</row>
+	<row>Tajikistan</row>
+	<row>Tokelau</row>
+	<row>Timor-Leste</row>
+	<row>Turkmenistan</row>
+	<row>Tunisia</row>
+	<row>Tonga</row>
+	<row>Turkey</row>
+	<row>Trinidad &amp; Tobago</row>
+	<row>Tuvalu</row>
+	<row>Taiwan</row>
+	<row>Tanzania</row>
+	<row>Ukraine</row>
+	<row>Uganda</row>
+	<row>U.S. Outlying Islands</row>
+	<row>United States</row>
+	<row>Uruguay</row>
+	<row>Uzbekistan</row>
+	<row>Vatican City</row>
+	<row>St. Vincent &amp; Grenadines</row>
+	<row>Venezuela</row>
+	<row>British Virgin Islands</row>
+	<row>U.S. Virgin Islands</row>
+	<row>Vietnam</row>
+	<row>Vanuatu</row>
+	<row>Wallis &amp; Futuna</row>
+	<row>Samoa</row>
+	<row>Yemen</row>
+	<row>Mayotte</row>
+	<row>South Africa</row>
+	<row>Zambia</row>
+	<row>Zimbabwe</row>
+	<row>Unknown</row>
+</result>
\ No newline at end of file
diff --git a/plugins/API/tests/System/expected/test_AutoSuggestAPITest_countryName__VisitsSummary.get_range.xml b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_countryName__VisitsSummary.get_range.xml
new file mode 100644
index 0000000000..d8bcdace18
--- /dev/null
+++ b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_countryName__VisitsSummary.get_range.xml
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<nb_visits>0</nb_visits>
+	<nb_actions>0</nb_actions>
+	<nb_visits_converted>0</nb_visits_converted>
+	<bounce_count>0</bounce_count>
+	<sum_visit_length>0</sum_visit_length>
+	<max_actions>0</max_actions>
+	<bounce_rate>0%</bounce_rate>
+	<nb_actions_per_visit>0</nb_actions_per_visit>
+	<avg_time_on_site>0</avg_time_on_site>
+</result>
\ No newline at end of file
diff --git a/plugins/API/tests/System/expected/test_AutoSuggestAPITest_operatingSystemName__API.getSuggestedValuesForSegment.xml b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_operatingSystemName__API.getSuggestedValuesForSegment.xml
new file mode 100644
index 0000000000..cda5b1843b
--- /dev/null
+++ b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_operatingSystemName__API.getSuggestedValuesForSegment.xml
@@ -0,0 +1,84 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>AIX</row>
+	<row>Android</row>
+	<row>AmigaOS</row>
+	<row>Apple TV</row>
+	<row>Arch Linux</row>
+	<row>BackTrack</row>
+	<row>Bada</row>
+	<row>BeOS</row>
+	<row>BlackBerry OS</row>
+	<row>BlackBerry Tablet OS</row>
+	<row>Brew</row>
+	<row>CentOS</row>
+	<row>Chrome OS</row>
+	<row>CyanogenMod</row>
+	<row>Debian</row>
+	<row>DragonFly</row>
+	<row>Fedora</row>
+	<row>Firefox OS</row>
+	<row>Fire OS</row>
+	<row>FreeBSD</row>
+	<row>Gentoo</row>
+	<row>Google TV</row>
+	<row>HP-UX</row>
+	<row>Haiku OS</row>
+	<row>IRIX</row>
+	<row>Inferno</row>
+	<row>KaiOS</row>
+	<row>Knoppix</row>
+	<row>Kubuntu</row>
+	<row>GNU/Linux</row>
+	<row>Lubuntu</row>
+	<row>VectorLinux</row>
+	<row>Mac</row>
+	<row>Maemo</row>
+	<row>Mandriva</row>
+	<row>MeeGo</row>
+	<row>MocorDroid</row>
+	<row>Mint</row>
+	<row>MildWild</row>
+	<row>MorphOS</row>
+	<row>NetBSD</row>
+	<row>MTK / Nucleus</row>
+	<row>Nintendo</row>
+	<row>Nintendo Mobile</row>
+	<row>OS/2</row>
+	<row>OSF1</row>
+	<row>OpenBSD</row>
+	<row>PlayStation Portable</row>
+	<row>PlayStation</row>
+	<row>Red Hat</row>
+	<row>RISC OS</row>
+	<row>Remix OS</row>
+	<row>RazoDroiD</row>
+	<row>Sabayon</row>
+	<row>SUSE</row>
+	<row>Sailfish OS</row>
+	<row>Slackware</row>
+	<row>Solaris</row>
+	<row>Syllable</row>
+	<row>Symbian</row>
+	<row>Symbian OS</row>
+	<row>Symbian OS Series 40</row>
+	<row>Symbian OS Series 60</row>
+	<row>Symbian^3</row>
+	<row>ThreadX</row>
+	<row>Tizen</row>
+	<row>Ubuntu</row>
+	<row>WebTV</row>
+	<row>Windows</row>
+	<row>Windows CE</row>
+	<row>Windows IoT</row>
+	<row>Windows Mobile</row>
+	<row>Windows Phone</row>
+	<row>Windows RT</row>
+	<row>Xbox</row>
+	<row>Xubuntu</row>
+	<row>YunOs</row>
+	<row>iOS</row>
+	<row>palmOS</row>
+	<row>webOS</row>
+	<row>Unknown</row>
+</result>
\ No newline at end of file
diff --git a/plugins/API/tests/System/expected/test_AutoSuggestAPITest_operatingSystemName__VisitsSummary.get_range.xml b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_operatingSystemName__VisitsSummary.get_range.xml
new file mode 100644
index 0000000000..d8bcdace18
--- /dev/null
+++ b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_operatingSystemName__VisitsSummary.get_range.xml
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<nb_visits>0</nb_visits>
+	<nb_actions>0</nb_actions>
+	<nb_visits_converted>0</nb_visits_converted>
+	<bounce_count>0</bounce_count>
+	<sum_visit_length>0</sum_visit_length>
+	<max_actions>0</max_actions>
+	<bounce_rate>0%</bounce_rate>
+	<nb_actions_per_visit>0</nb_actions_per_visit>
+	<avg_time_on_site>0</avg_time_on_site>
+</result>
\ No newline at end of file