Italian provinces

[strati]

Hello, I would like to include the codes of the Italian provinces in the official version. Who can I give the MYSQL instruction to?

[burt]

Thank you. Feel free to upload SQL as an addon, or just paste it in this thread for Italian users to find.

We don't want to go down the path of this in Core, as other users in many other countries might want the same, which will mean;

a/ loads of requests to add in country details that I don't want to deal with
b/ when that is done, more code in core that I don't want to look after
c/ bigger download for end users
d/ slower installation for new install

More or less, for the same reason, we have only English language in Core.

[strati]

More or less, for the same reason, we have only English language in Core.

I don't want to argue, but I have to disagree, you don't have ONLY English...
You have: USA, Canada, Germany, Austria, Switzerland, Spain.

Now, that you don't want to add Italy is fine with me and I will do it with an ADDON.
But that you tell me that you only have the English/American ones is not fine with me.

Read from 1301 to 1492
https://github.com/CE-PhoenixCart/Phoen ... hoenix.sql

[strati]

Code: Select all

INSERT INTO zones (zone_country_id, zone_code, zone_name) VALUES (105,'NA','NAPOLI'),
(105,'BA','BARI'),
(105,'BO','BOLOGNA'),
(105,'CA','CAGLIARI'),
(105,'CT','CATANIA'),
(105,'FI','FIRENZE'),
(105,'GE','GENOVA'),
(105,'ME','MESSINA'),
(105,'MI','MILANO'),
(105,'PA','PALERMO'),
(105,'RC','REGGIO CALABRIA'),
(105,'RM','ROMA'),
(105,'TO','TORINO'),
(105,'VE','VENEZIA'),
(105,'AG','Agrigento'),
(105,'AL', 'Alessandria'),
(105,'AN', 'Ancona'),
(105,'AR', 'Arezzo'),
(105,'AP', 'Ascoli Piceno'),
(105,'AT', 'Asti'),
(105,'AV', 'Avellino'),
(105,'BT', 'Barletta-Andria-Trani'),
(105,'BL', 'Belluno'),
(105,'BN', 'Benevento'),
(105,'BG', 'Bergamo'),
(105,'BI', 'Biella'),
(105,'BZ', 'Bolzano'),
(105,'BS', 'Brescia'),
(105,'BR', 'Brindisi'),
(105,'CL', 'Caltanissetta'),
(105,'CB', 'Campobasso'),
(105,'CE', 'Caserta'),
(105,'CZ', 'Catanzaro'),
(105,'CH', 'Chieti'),
(105,'CO', 'Como'),
(105,'CS', 'Cosenza'),
(105,'CR', 'Cremona'),
(105,'KR', 'Crotone'),
(105,'CN', 'Cuneo'),
(105,'EN', 'Enna'),
(105,'FM', 'Fermo'),
(105,'FE', 'Ferrara'),
(105,'FG', 'Foggia'),
(105,'FC', 'Forlì-Cesena'),
(105,'FR', 'Frosinone'),
(105,'GO', 'Gorizia'),
(105,'GR', 'Grosseto'),
(105,'IM', 'Imperia'),
(105,'IS', 'Isernia'),
(105,'AQ', 'L\'Aquila'),
(105,'SP', 'La Spezia'),
(105,'LT', 'Latina'),
(105,'LE', 'Lecce'),
(105,'LC', 'Lecco'),
(105,'LI', 'Livorno'),
(105,'LO', 'Lodi'),
(105,'LU', 'Lucca'),
(105,'MC', 'Macerata'),
(105,'MN', 'Mantova'),
(105,'MS', 'Massa-Carrara'),
(105,'MT', 'Matera'),
(105,'MO', 'Modena'),
(105,'MB', 'Monza e Brianza'),
(105,'NO', 'Novara'),
(105,'NU', 'Nuoro'),
(105,'OR', 'Oristano'),
(105,'PD', 'Padova'),
(105,'PR', 'Parma'),
(105,'PV', 'Pavia'),
(105,'PG', 'Perugia'),
(105,'PU', 'Pesaro e Urbino'),
(105,'PE', 'Pescara'),
(105,'PC', 'Piacenza'),
(105,'PI', 'Pisa'),
(105,'PT', 'Pistoia'),
(105,'PN', 'Pordenone'),
(105,'PZ', 'Potenza'),
(105,'PO', 'Prato'),
(105,'RG', 'Ragusa'),
(105,'RA', 'Ravenna'),
(105,'RE', 'Reggio Emilia'),
(105,'RI', 'Rieti'),
(105,'RN', 'Rimini'),
(105,'RO', 'Rovigo'),
(105,'SA', 'Salerno'),
(105,'SS', 'Sassari'),
(105,'SV', 'Savona'),
(105,'SI', 'Siena'),
(105,'SR', 'Siracusa'),
(105,'SO', 'Sondrio'),
(105,'SU', 'Sud Sardegna'),
(105,'TA', 'Taranto'),
(105,'TE', 'Teramo'),
(105,'TR', 'Terni'),
(105,'TP', 'Trapani'),
(105,'TN', 'Trento'),
(105,'TV', 'Treviso'),
(105,'TS', 'Trieste'),
(105,'UD', 'Udine'),
(105,'VA', 'Varese'),
(105,'VB', 'Verbano-Cusio-Ossola'),
(105,'VC', 'Vercelli'),
(105,'VR', 'Verona'),
(105,'VV', 'Vibo Valentia'),
(105,'VI', 'Vicenza'),
(105,'VT', 'Viterbo');

[ecartz]

More or less, for the same reason, we have only English language in Core.

I don't want to argue, but I have to disagree, you don't have ONLY English...
You have: USA, Canada, Germany, Austria, Switzerland, Spain.

We have provinces for a number of countries for historical reasons. I.e. they were added. We never removed them. We don't want to add to that list.

What burt was saying was that among languages, not provinces, we only have the English language pack in core. We don't have translations for Germany, Spain, Austria, or Italy in core, even though we do have provinces listed for Germany, Austria, Switzerland, and Spain. They still have to install language packs for Deutsch, Austrian, French (for Canada), Italian (for Switzerland, which also speaks French and Deutsch), and Espannol (I don't even have the letter on my keyboard to spell that correctly).

We actually removed Deutsch and Espannol from the core community version, perhaps before I started working on it (I don't remember).

We have neither provinces or language for some countries, e.g. China and India, two of the four languages with the most native speakers.

I apologize if this appears unfair. However, we would be more likely to decrease the provinces in core than to add to them. If there were a problem with the provinces in one of the countries that is currently in core that does not speak English natively, we'd likely remove that country's provinces rather than attempt to fix them. That's basically how Deutsch and Espannol got removed. They fell out of date and were removed rather than fixed.

[Fiber]

Hello, I would like to include the codes of the Italian provinces in the official version. Who can I give the MYSQL instruction to?

I added into the translation files a while ago...

[strati]

Yes, I will too... Now I'm looking for a way to insert taxes without compromising the present ones...