Massive import of State/Provinces of countries. Help us with your country's data

Germany:

DE,Baden-Württemberg,BW,TRUE,0
DE,Bayern,BY,TRUE,0
DE,Berlin,BE,TRUE,0
DE,Brandenburg,BB,TRUE,0
DE,Bremen,HB,TRUE,0
DE,Hamburg,HH,TRUE,0
DE,Hessen,HE,TRUE,0
DE,Mecklenburg-Vorpommern,MV,TRUE,0
DE,Niedersachsen,NI,TRUE,0
DE,Nordrhein-Westfalen,NW,TRUE,0
DE,Rheinland-Pfalz,RP,TRUE,0
DE,Saarland,SL,TRUE,0
DE,Sachsen,SN,TRUE,0
DE,Sachsen-Anhalt,ST,TRUE,0
DE,Schleswig-Holstein,SH,TRUE,0
DE,Thüringen,TH,TRUE,0

Brazil,

BR,Acre,AC,True,0
BR,Alagoas,AL,True,0
BR,Amapá,AP,True,0
BR,Amazonas,AM,True,0
BR,Bahia,BA,True,0
BR,Ceará,CE,True,0
BR,Distrito Federal,DF,True,0
BR,Espírito Santo,ES,True,0
BR,Goiás,GO,True,0
BR,Maranhão,MA,True,0
BR,Mato Grosso,MT,True,0
BR,Mato Grosso do Sul,MS,True,0
BR,Minas Gerais,MG,True,0
BR,Pará,PA,True,0
BR,Paraíba,PB,True,0
BR,Paraná,PR,True,0
BR,Pernambuco,PE,True,0
BR,Piauí,PI,True,0
BR,Rio de Janeiro,RJ,True,0
BR,Rio Grande do Norte,RN,True,0
BR,Rio Grande do Sul,RS,True,0
BR,Rondônia,RO,True,0
BR,Roraima,RR,True,0
BR,Santa Catarina,SC,True,0
BR,São Paulo,SP,True,0
BR,Sergipe,SE,True,0
BR,Tocantins,TO,True,0

Canadian Provinces and Territories

CA,Ontario,,True,0
CA,Quebec,,True,0
CA,Nova Scotia,,True,0
CA,New Brunswick,,True,0
CA,Manitoba,,True,0
CA,British Columbia,,True,0
CA,Prince Edward Island,,True,0
CA,Saskatchewan,,True,0
CA,Alberta,,True,0
CA,Newfoundland and Labrador,,True,0
CA,Northwest Territories,,True,0
CA,Yukon,,True,0
CA,Nunavut,,True,0

Italy

IT,Agrigento,AG,TRUE,1
IT,Alessandria,AL,TRUE,1
IT,Ancona,AN,TRUE,1
IT,Aosta,AO,TRUE,1
IT,Arezzo,AR,TRUE,1
IT,Ascoli Piceno,AP,TRUE,1
IT,Asti,AT,TRUE,1
IT,Avellino,AV,TRUE,1
IT,Bari,BA,TRUE,1
IT,Barletta-Andria-Trani,BT,TRUE,1
IT,Belluno,BL,TRUE,1
IT,Benevento,BN,TRUE,1
IT,Bergamo,BG,TRUE,1
IT,Biella,BI,TRUE,1
IT,Bologna,BO,TRUE,1
IT,Bolzano,BZ,TRUE,1
IT,Brescia,BS,TRUE,1
IT,Brindisi,BR,TRUE,1
IT,Cagliari,CA,TRUE,1
IT,Caltanissetta,CL,TRUE,1
IT,Campobasso,CB,TRUE,1
IT,Carbonia-Iglesias,CI,TRUE,1
IT,Caserta,CE,TRUE,1
IT,Catania,CT,TRUE,1
IT,Catanzaro,CZ,TRUE,1
IT,Chieti,CH,TRUE,1
IT,Como,CO,TRUE,1
IT,Cosenza,CS,TRUE,1
IT,Cremona,CR,TRUE,1
IT,Crotone,KR,TRUE,1
IT,Cuneo,CN,TRUE,1
IT,Enna,EN,TRUE,1
IT,Fermo,FM,TRUE,1
IT,Ferrara,FE,TRUE,1
IT,Firenze,FI,TRUE,1
IT,Foggia,FG,TRUE,1
IT,Forlì-Cesena,FC,TRUE,1
IT,Frosinone,FR,TRUE,1
IT,Genova,GE,TRUE,1
IT,Gorizia,GO,TRUE,1
IT,Grosseto,GR,TRUE,1
IT,Imperia,IM,TRUE,1
IT,Isernia,IS,TRUE,1
IT,La Spezia,SP,TRUE,1
IT,L'Aquila,AQ,TRUE,1
IT,Latina,LT,TRUE,1
IT,Lecce,LE,TRUE,1
IT,Lecco,LC,TRUE,1
IT,Livorno,LI,TRUE,1
IT,Lodi,LO,TRUE,1
IT,Lucca,LU,TRUE,1
IT,Macerata,MC,TRUE,1
IT,Mantova,MN,TRUE,1
IT,Massa-Carrara,MS,TRUE,1
IT,Matera,MT,TRUE,1
IT,Medio Campidano,VS,TRUE,1
IT,Messina,ME,TRUE,1
IT,Milano,MI,TRUE,1
IT,Modena,MO,TRUE,1
IT,Monza e della Brianza,MB,TRUE,1
IT,Napoli,NA,TRUE,1
IT,Novara,NO,TRUE,1
IT,Nuoro,NU,TRUE,1
IT,Ogliastra,OG,TRUE,1
IT,Olbia-Tempio,OT,TRUE,1
IT,Oristano,OR,TRUE,1
IT,Padova,PD,TRUE,1
IT,Palermo,PA,TRUE,1
IT,Parma,PR,TRUE,1
IT,Pavia,PV,TRUE,1
IT,Perugia,PG,TRUE,1
IT,Pesaro e Urbino,PU,TRUE,1
IT,Pescara,PE,TRUE,1
IT,Piacenza,PC,TRUE,1
IT,Pisa,PI,TRUE,1
IT,Pistoia,PT,TRUE,1
IT,Pordenone,PN,TRUE,1
IT,Potenza,PZ,TRUE,1
IT,Prato,PO,TRUE,1
IT,Ragusa,RG,TRUE,1
IT,Ravenna,RA,TRUE,1
IT,Reggio Calabria,RC,TRUE,1
IT,Reggio Emilia,RE,TRUE,1
IT,Rieti,RI,TRUE,1
IT,Rimini,RN,TRUE,1
IT,Roma,RM,TRUE,1
IT,Rovigo,RO,TRUE,1
IT,Salerno,SA,TRUE,1
IT,Sassari,SS,TRUE,1
IT,Savona,SV,TRUE,1
IT,Siena,SI,TRUE,1
IT,Siracusa,SR,TRUE,1
IT,Sondrio,SO,TRUE,1
IT,Taranto,TA,TRUE,1
IT,Teramo,TE,TRUE,1
IT,Terni,TR,TRUE,1
IT,Torino,TO,TRUE,1
IT,Trapani,TP,TRUE,1
IT,Trento,TN,TRUE,1
IT,Treviso,TV,TRUE,1
IT,Trieste,TS,TRUE,1
IT,Udine,UD,TRUE,1
IT,Varese,VA,TRUE,1
IT,Venezia,VE,TRUE,1
IT,Verbano-Cusio-Ossola,VB,TRUE,1
IT,Vercelli,VC,TRUE,1
IT,Verona,VR,TRUE,1
IT,Vibo Valentia,VV,TRUE,1
IT,Vicenza,VI,TRUE,1
IT,Viterbo,VT,TRUE,1

Việt Nam (Vietnam)

VN, Hà Nội, HN, TRUE, 1
VN, Hồ Chí Minh, HCM, TRUE, 2
VN, Đà Nẵng, ĐN, TRUE, 3
VN, Hải Phòng, HP, TRUE, 4
VN, Cần Thơ, CT, TRUE, 5
VN, Hà Giang, HG, TRUE, 6
VN, Cao Bằng, CB, TRUE, 6
VN, Bắc Kạn, BK, TRUE, 6
VN, Tuyên Quang, TQ, TRUE, 6
VN, Lào Cai, LC, TRUE, 6
VN, Điện Biên, ĐB, TRUE, 6
VN, Lai Châu, LC, TRUE, 6
VN, Sơn La, SL, TRUE, 6
VN, Yên Bái, YB, TRUE, 6
VN, Hòa Bình, HB, TRUE, 6
VN, Thái Nguyên, TN, TRUE, 6
VN, Lạng Sơn, LS, TRUE, 6
VN, Quảng Ninh, QN, TRUE, 6
VN, Bắc Giang, BG, TRUE, 6
VN, Phú Thọ, PT, TRUE, 6
VN, Vĩnh Phúc, VP, TRUE, 6
VN, Bắc Ninh, BN, TRUE, 6
VN, Hải Dương, HD, TRUE, 6
VN, Hưng Yên, HY, TRUE, 6
VN, Thái Bình, TB, TRUE, 6
VN, Hà Nam, HN, TRUE, 6
VN, Nam Định, NĐ, TRUE, 6
VN, Ninh Bình, NB, TRUE, 6
VN, Thanh Hóa, TH, TRUE, 6
VN, Nghệ An, NA, TRUE, 6
VN, Hà Tĩnh, HT, TRUE, 6
VN, Quảng Bình, QB, TRUE, 6
VN, Quảng Trị, QT, TRUE, 6
VN, Thừa Thiên Huế, TTH, TRUE, 6
VN, Quảng Nam, QN, TRUE, 6
VN, Quảng Ngãi, QN, TRUE, 6
VN, Bình Định, BĐ, TRUE, 6
VN, Phú Yên, PY, TRUE, 6
VN, Khánh Hòa, KH, TRUE, 6
VN, Ninh Thuận, NT, TRUE, 6
VN, Bình Thuận, BT, TRUE, 6
VN, Kon Tum, KT, TRUE, 6
VN, Gia Lai, GL, TRUE, 6
VN, Đắk Lắk, ĐL, TRUE, 6
VN, Đắk Nông, ĐN, TRUE, 6
VN, Lâm Đồng, LĐ, TRUE, 6
VN, Bình Phước, BP, TRUE, 6
VN, Tây Ninh, TN, TRUE, 6
VN, Bình Dương, BD, TRUE, 6
VN, Đồng Nai, ĐN, TRUE, 6
VN, Bà Rịa - Vũng Tàu, BR, TRUE, 6
VN, Long An, LA, TRUE, 6
VN, Tiền Giang, TG, TRUE, 6
VN, Bến Tre, BT, TRUE, 6
VN, Trà Vinh, TV, TRUE, 6
VN, Vĩnh Long, VL, TRUE, 6
VN, Đồng Tháp, ĐT, TRUE, 6
VN, An Giang, AG, TRUE, 6
VN, Kiên Giang, KG, TRUE, 6
VN, Hậu Giang, HG, TRUE, 6
VN, Sóc Trăng, ST, TRUE, 6
VN, Bạc Liêu, BL, TRUE, 6
VN, Cà Mau, CM, TRUE, 6

Poland

PL,Dolnośląskie,,True,0
PL,Kujawsko-pomorskie,,True,0
PL,Lubelskie,,True,0
PL,Lubuskie,,True,0
PL,Łódzkie,,True,0
PL,Małopolskie,,True,0
PL,Mazowieckie,,True,0
PL,Opolskie,,True,0
PL,Podkarpackie,,True,0
PL,Podlaskie,,True,0
PL,Pomorskie,,True,0
PL,Śląskie,,True,0
PL,Świętokrzyskie,,True,0
PL,Warmińsko-mazurskie,,True,0
PL,Wielkopolskie,,True,0
PL,Zachodniopomorskie,,True,0

Australia

AU, Australian Capital Territory,,True,0
AU, New South Wales,,True,0
AU, Northern Territory,,True,0
AU, Queensland,,True,0
AU, South Australia,,True,0
AU, Tasmania,,True,0
AU, Victoria,,True,0
AU, Western Australia,,True,0

Croatia (Hrvatska)


HR,Grad Zagreb,GZG,True,0
HR,Bjelovarsko-bilogorska,BBŽ,True,1
HR,Brodsko-posavska,BPŽ,True,1
HR,Dubrovačko-neretvanska,DNŽ,True,1
HR,Istarska,IŽ,True,1
HR,Karlovačka,KŽ,True,1
HR,Koprivničko-križevačka,KKŽ,True,1
HR,Krapinsko-zagorska,KZŽ,True,1
HR,Ličko-senjska,LSŽ,True,1
HR,Međimurska,MŽ,True,1
HR,Osječko-baranjska,OBŽ,True,1
HR,Požeško-slavonska,PSŽ,True,1
HR,Primorsko-goranska,PGŽ,True,1
HR,Sisačko-moslavačka,SMŽ,True,1
HR,Splitsko-dalmatinska,SDŽ,True,1
HR,Šibensko-kninska,ŠKŽ,True,1
HR,Varaždinska,VŽ,True,1
HR,Virovitičko-podravska,VPŽ,True,1
HR,Vukovarsko-srijemska,VSŽ,True,1
HR,Zadarska,ZDŽ,True,1
HR,Zagrebačka,ZGŽ,True,1

Hi

I've been experiencing this problem with the province list. Basically PayPal Pro (with the PayPal Direct plugin) will refuse the payment if the province/state is missing for some countries, for instance Spain.

I've found this post (https://go.developer.ebay.com/developers/paypal/forums/paypal-sample-code/province-drop-down) that has, what it seems to be, a list of provinces/states supported by paypal that I think is relevant here.

Spanish provinces, for instance, don't have an standard code. If you include the codes provided by paypal, payments from spain will work. But a better solution, for scalability, would be to map this provinces from the paypal direct plugin (somehow).

Hi,

I have implemented the changes in the changeset pointed to by Andrei and seem to have the ability to bulk import states/provinces (certainly the two new buttons for "Import states from CSV" and "Export states to CSV" are there). I am in the process of putting together the CSV file (thanks to all suppliers in this and other posts) ready to try an import. My question is that some of the posts here do not include the state/province two letter abbreviation/code, does that mean that it doesn't matter if there is no two letter code, both for the import facility and also for PayPal? (PayPal rejecting addresses with no state/province being why I am doing this).