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.
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
Are you on Public Cloud ?
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.
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.
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?
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
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.
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
Hi Santosh,
This does the trick. However, how about the state/province? Have you got the list of them as well?
Cheers.
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
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.