Country select list not displaying the options

Posted by bhuwan on 07-Dec-2015 21:24

Hi all,
The "Country" and "ZipCode" drop down list does not display any countries anymore. Could someone please advise how to fix this problem?

Thank you.

Posted by Santosh Patel on 08-Dec-2015 00:25

Australian Capital Territory|ACT

Christmas Island|CX

Cocos (Keeling) Islands|CC

Coral Sea Islands

Heard Island and McDonald Islands|HM

Jervis Bay Territory|JBT

New South Wales|NSW

Norfolk Island|NF

Queensland|QLD

South Australia|SA

Tasmania|TAS

Victoria|VIC

Western Australia|WA-AU

Alberta|AB

British Columbia|BC

Manitoba|MB

New Brunswick|NB

Newfoundland|NL

Northwest Territories|NT

Nova Scotia|NS

Ontario|ON

Prince Edward Island|PE

Quebec|QC

Saskatchewan|SK

Yukon|YT

Anhui|AH

Beijing|BJ

Chongqing|CQ

Fujian|FJ

Gansu|GS

Guangdong|GD

Guangxi Zhuang|GX

Guizhou|GZ

Hainan|HI-CN

Heilongjiang|HL

Henan|HA

OTHER

Hunan|HN

Jiangsu|JS

Jiangxi|JX

Jilin|JL

Liaoning|LN

Nei Mongol|NM-CN

Ningxia ***|NX

Qinghai|QH

Shandong|SD-CN

Shanxi|SX

Sichuan|SC-CN

Tianjin|TJ

Xinjiang Uygur|XJ

Xizang|XZ

Yunnan|YN

Zhejiang|ZJ

Baden-Wurttemberg|BW

Bavaria|BY

Berlin|BE

Brandenburg|BB

Bremen|HB

Hamburg|HH

Hesse|HE

Mecklenburg-Vorpommern|MV

Lower Saxony|NI

North Rhine-Westphalia|NW

Rhineland-Palatinate|RP

Saarland|SL

Saxony|SN

Saxony-Anhalt|ST

Schleswig-Holstein|SH

Thuringia|TH

Aichi|23

Akita|05

Aomori|02

Chiba|12

Ehime|38

Fukui|18

Fukuoka|40

Fukushima|07

Gifu|21

Gunma|10

Hiroshima|34

Hokkaido|01

Ibaraki|08

Ishikawa|17

Iwate|03

Kagawa|37

Kanagawa|14

Kochi|39

Mie|24

Miyagi|04

Nagano|20

Niigata|15

Okayama|33

Shiga|25

Shimane|32

Shizuoka|22

Tochigi|09

Tokushima|36

Tokyo|13

Coral Sea Islands

Toyama|16

Yamagata|06

Yamaguchi|35

Yamanashi|19

Northern Territory|NT

Seoul|11

Busan|26

Incheon|28

Daegu|27

Gwangju|29

Daejeon|30

Ulsan|31

Gyeonggi|41

Gangwon|42

Chungcheongbuk|43

Chungcheongnam|44

Jeollabuk|45

Jeollanam|46

Gyeongsangbuk|47

Gyeongsangnam|48

Jeju|49

AK|AK

AL|AL

AR|AR

AZ|AZ

CA|CA

CO|CO

CT|CT

DC|DC

DE|DE

FL|FL

GA|GA

HI|HI

IA|IA

ID|ID

IL|IL

IN|IN

KS|KS

KY|KY

LA|LA

MA|MA

MD|MD

Seoul|11

ME|ME

Busan|26

MI|MI

Incheon|28

MN|MN

Daegu|27

MO|MO

Gwangju|29

MS|MS

Daejeon|30

MT|MT

Ulsan|31

NC|NC

Gyeonggi|41

ND|ND

Gangwon|42

NE|NE

Chungcheongbuk|43

NH|NH

Chungcheongnam|44

NJ|NJ

Jeollabuk|45

NM|NM

Jeollanam|46

NV|NV

Gyeongsangbuk|47

NY|NY

OH|OH

OK|OK

OR|OR

OTHER

PA|PA

RI|RI

Bremen|HB

SC|SC

SD|SD

Hesse|HE

TN|TN

TX|TX

UT|UT

VA|VA

VT|VT

WA|WA

Saxony|SN

WI|WI

WV|WV

Schleswig-Holstein|SH

WY|WY

All Replies

Posted by Anoop Premachandran on 07-Dec-2015 21:28

Are you on Public Cloud ?

Posted by Anoop Premachandran on 07-Dec-2015 21:34

Country is a shared picklist. I see that you have Country field in 6 objects. If you have edited and removed entries in any object, it will be reflected in all objects.

Posted by Anoop Premachandran on 07-Dec-2015 21:35

If you create entries again, new ids will generated for the new entries and all old mappings will be lost. Please create a support ticket for us to help you fix this.

Posted by bhuwan on 07-Dec-2015 21:42

Hi Anoop,

Thank you so much for your response. Just to clarify your comments, so if I remove the country from the design page under any objects within the application then it will remove it for all of them?

I am currently using the evaluation version, so I guess I don't have any option to raise a support ticket?

Posted by Anoop Premachandran on 07-Dec-2015 22:02

Yes There are 2 types of picklist - shared and not shared.

Country is a shared picklist type.

We mention this text in bold above Values edit section

"This Picklist is shared between objects. Changes in the list of values will affect other objects which use this Picklist."

You can populate countries again but you will have to fix values in all existing records of the 6 objects manually.

If you were under support we would have helped in this process.

Also I suggest you take backup of your system on a regular basis. So you can restore to a previous backup or fix data by looking at backup data.

Setup -> Administration Setup -> Backup

You can schedule a batch job as well to do backups

Posted by bhuwan on 07-Dec-2015 23:25

Hi Anoop,

Thank you again for your response. I still can not populate the countries. I created a new object and added the country picklist but still no luck.

Will take backup in future.

Posted by Santosh Patel on 08-Dec-2015 00:07

Bhuwan,

You have already modified a shared picklist and there is no way to recover original values once modified.

You could edit the country picklist and put in these values. Note that this could reset data in your records (wherever country is being used) based on what values you already modified.

Afghanistan|AF

Albania|AL

Algeria|DZ

American Samoa|AS

Andorra|AD

Angola|AO

Anguilla|AI

Antarctica|AQ

Antigua|AG

Argentina|AR

Armenia|AM

Aruba|AW

Australia|AU

Austria|AT

Azerbaijan|AZ

Bahamas|BS

Bahrain|BH

Bangladesh|BD

Barbados|BB

Belarus|BY

Belgium|BE

Belize|BZ

Benin|BJ

Bermuda|BM

Bhutan|BT

Bolivia|BO

Bosnia|BA

Botswana|BW

Brazil|BR

Brunei Darussalam|BN

Bulgaria|BG

Burkina Faso|BF

Burundi|BI

Cambodia|KH

Cameroon|CM

Canada|CA

Cayman Islands|KY

Chad|TD

Chile|CL

China|CN

Colombia|CO

Comoros|KM

Congo|CG

Costa Rica|CR

Croatia|HR

Cuba|CU

Cyprus|CY

Czech Republic|CZ

Denmark|DK

Dominican Republic|DO

Ecuador|EC

Egypt|EG

El Salvador|SV

Equatorial Guinea|GQ

Eritrea|ER

Estonia|EE

Ethiopia|ET

Fiji|FJ

Finland|FI

France|FR

Gabon|GA

Gambia|GM

Georgia|GE

Germany|DE

Ghana|GH

Greece|GR

Greenland|GL

Grenada|GD

Guadeloupe|GP

Guam|GU

Guatemala|GT

Guinea|GN

Guyana|GY

Haiti|HT

Honduras|HN

Hong Kong|HK

Hungary|HU

Iceland|IS

India|IN

Indonesia|ID

Iran|IR

Iraq|IQ

Ireland|IE

Israel|IL

Italy|IT

Jamaica|JM

Japan|JP

Jordan|JO

Kazakhstan|KZ

Korea, North|KP

Korea, South|KR

Kuwait|KW

Kyrgyzstan|KG

Lao Democratic Republic|LA

Latvia|LV

Lebanon|LB

Liberia|LR

Libya|LY

Liechtenstein|LI

Lithuania|LT

Luxembourg|LU

Macedonia|MK

Madagascar|MG

Malawi|MW

Malaysia|MY

Maldives|MV

Malta|ML

Mexico|MX

Micronesia|MO

Micronesia|MO

Moldova|MD

Monaco|MC

Mongolia|MN

Morocco|MA

Mozambique|MZ

Myanmar|MM

Namibia|NA

Nepal|NP

Netherlands|NL

New Zealand|NZ

Nicaragua|NI

Niger|NE

Nigeria|NG

Norway|NO

Oman|OM

Pakistan|PK

Palau|PW

Palestine|PS

Panama|PA

Papua New Guinea|PG

Paraguay|PY

Peru|PE

Philippines|PH

Poland|PL

Portugal|PT

Puerto Rico|PR

Qatar|QA

Romania|RO

Russian Federation|RU

Rwanda|RW

Saint Lucia|LC

Saint Vincent Grenadines|VC

Samoa|WS

San Marino|SM

Sao Tome and Principe|ST

Saudi Arabia|SA

Senegal|SN

Serbia|CS

Sierra Leone|SL

Singapore|SG

Slovakia|SK

Slovenia|SI

Somalia|SO

South Africa|ZA

Spain|ES

Sri Lanka|LK

Sudan|SD

Suriname|SR

Sweden|SE

Switzerland|CH

Syria|SY

Taiwan|TW

Tajikistan|TJ

Tanzania|TZ

Thailand|TH

Togo|TG

Trinidad and Tobago|TT

Tunisia|TN

Turkey|TR

Turkmenistan|TM

Tuvalu|TV

Uganda|UG

Ukraine|UA

United Arab Emirates|AE

United Kingdom|GB

{D}United States|US

Uruguay|UY

Uzbekistan|UZ

Vatican|VU

Venezuela|VE

Vietnam|VN

Yemen|YE

Zambia|ZM

Zimbabwe|ZW

Posted by bhuwan on 08-Dec-2015 00:16

Hi Santosh,

This does the trick. However, how about the state/province? Have you got the list of them as well?

Cheers.

Posted by Santosh Patel on 08-Dec-2015 00:25

Australian Capital Territory|ACT

Christmas Island|CX

Cocos (Keeling) Islands|CC

Coral Sea Islands

Heard Island and McDonald Islands|HM

Jervis Bay Territory|JBT

New South Wales|NSW

Norfolk Island|NF

Queensland|QLD

South Australia|SA

Tasmania|TAS

Victoria|VIC

Western Australia|WA-AU

Alberta|AB

British Columbia|BC

Manitoba|MB

New Brunswick|NB

Newfoundland|NL

Northwest Territories|NT

Nova Scotia|NS

Ontario|ON

Prince Edward Island|PE

Quebec|QC

Saskatchewan|SK

Yukon|YT

Anhui|AH

Beijing|BJ

Chongqing|CQ

Fujian|FJ

Gansu|GS

Guangdong|GD

Guangxi Zhuang|GX

Guizhou|GZ

Hainan|HI-CN

Heilongjiang|HL

Henan|HA

OTHER

Hunan|HN

Jiangsu|JS

Jiangxi|JX

Jilin|JL

Liaoning|LN

Nei Mongol|NM-CN

Ningxia ***|NX

Qinghai|QH

Shandong|SD-CN

Shanxi|SX

Sichuan|SC-CN

Tianjin|TJ

Xinjiang Uygur|XJ

Xizang|XZ

Yunnan|YN

Zhejiang|ZJ

Baden-Wurttemberg|BW

Bavaria|BY

Berlin|BE

Brandenburg|BB

Bremen|HB

Hamburg|HH

Hesse|HE

Mecklenburg-Vorpommern|MV

Lower Saxony|NI

North Rhine-Westphalia|NW

Rhineland-Palatinate|RP

Saarland|SL

Saxony|SN

Saxony-Anhalt|ST

Schleswig-Holstein|SH

Thuringia|TH

Aichi|23

Akita|05

Aomori|02

Chiba|12

Ehime|38

Fukui|18

Fukuoka|40

Fukushima|07

Gifu|21

Gunma|10

Hiroshima|34

Hokkaido|01

Ibaraki|08

Ishikawa|17

Iwate|03

Kagawa|37

Kanagawa|14

Kochi|39

Mie|24

Miyagi|04

Nagano|20

Niigata|15

Okayama|33

Shiga|25

Shimane|32

Shizuoka|22

Tochigi|09

Tokushima|36

Tokyo|13

Coral Sea Islands

Toyama|16

Yamagata|06

Yamaguchi|35

Yamanashi|19

Northern Territory|NT

Seoul|11

Busan|26

Incheon|28

Daegu|27

Gwangju|29

Daejeon|30

Ulsan|31

Gyeonggi|41

Gangwon|42

Chungcheongbuk|43

Chungcheongnam|44

Jeollabuk|45

Jeollanam|46

Gyeongsangbuk|47

Gyeongsangnam|48

Jeju|49

AK|AK

AL|AL

AR|AR

AZ|AZ

CA|CA

CO|CO

CT|CT

DC|DC

DE|DE

FL|FL

GA|GA

HI|HI

IA|IA

ID|ID

IL|IL

IN|IN

KS|KS

KY|KY

LA|LA

MA|MA

MD|MD

Seoul|11

ME|ME

Busan|26

MI|MI

Incheon|28

MN|MN

Daegu|27

MO|MO

Gwangju|29

MS|MS

Daejeon|30

MT|MT

Ulsan|31

NC|NC

Gyeonggi|41

ND|ND

Gangwon|42

NE|NE

Chungcheongbuk|43

NH|NH

Chungcheongnam|44

NJ|NJ

Jeollabuk|45

NM|NM

Jeollanam|46

NV|NV

Gyeongsangbuk|47

NY|NY

OH|OH

OK|OK

OR|OR

OTHER

PA|PA

RI|RI

Bremen|HB

SC|SC

SD|SD

Hesse|HE

TN|TN

TX|TX

UT|UT

VA|VA

VT|VT

WA|WA

Saxony|SN

WI|WI

WV|WV

Schleswig-Holstein|SH

WY|WY

Posted by bhuwan on 08-Dec-2015 17:28

Hi guys/Anoop,

Could you also please restore the State/Province at the application level? Country seems to be working now, however state/province won't work until I add them to each object as a picklist.

Cheers.

This thread is closed