Provincie abbreviate

cirieh · Messaggio da **cirieh** » 21/10/2003, 1:44

Ecco la query sql da importare affinche la provincia venga visualizzata tipo targhe auto e non per esteso(non + Agrigento ma AG)

Codice: Seleziona tutto

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'AG','AG');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'AL','AL');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'AN','AN');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'AO','AO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'AR','AR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'AP','AP');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'AT','AT');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'AV','AV');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BA','BA');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BL','BL');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BN','BN');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BG','BG');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BI','BI');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BO','BO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BZ','BO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BS','BS');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BR','BR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CA','CA');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CL','CL');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CB','CB');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CE','CE');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CT','CT');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CZ','CZ');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CH','CH');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CO','CO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CS','CS');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CR','CR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'KR','KR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'CN','CN');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'EN','EN');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'FE','FE');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'FI','FI');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'FG','FG');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'FO','FO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'FR','FR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'GE','GE');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'GO','GO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'GR','GR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'IM','IM');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'IS','IS');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'AQ','AQ');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'SP','SP');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'LT','LT');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'LE','LE');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'LC','LC');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'LI','LI');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'LO','LO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'LU','LU');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'MC','MC');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'MN','MN');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'MS','MS');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'MT','MT');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'ME','ME');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'MI','MI');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'MO','MO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'NA','NA');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'NO','NO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'NU','NU');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'OR','OR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PD','PD');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PA','PA');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PR','PR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PG','PG');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PV','PV');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PS','PS');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PE','PE');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PC','PC');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PI','PI');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PT','PT');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PN','PN');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PZ','PZ');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'PO','PO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'RG','RG');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'RA','RA');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'RC','RC');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'RE','RE');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'RI','RI');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'RN','RN');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'RM','RM');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'RO','RO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'SA','SA');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'SS','SS');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'SV','SV');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'SI','SI');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'SR','SR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'SO','SO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'TA','TA');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'TE','TE');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'TR','TR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'TO','TO');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'TP','TP');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'TN','TN');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'TV','TV');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'TS','TS');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'UD','UD');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'VA','VA');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'VE','VE');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'VB','VB');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'VC','VC');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'VR','VR');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'VV','VV');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'VI','VI');
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'VT','VT');

BluEdoG · Messaggio da **BluEdoG** » 28/10/2003, 13:51

Per completezza di informazione, le provincie complete le trovate:
http://www.oscommerce.com/community/contributions,18

Bass · Messaggio da **Bass** » 16/08/2004, 23:56

cirieh ha scritto:Ecco la query sql da importare affinche la provincia venga visualizzata tipo targhe auto e non per esteso(non + Agrigento ma AG)
Codice: Seleziona tutto
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES ('',105,'BZ','BO');

Attenzione che c'e' un errore nella tabella, come potete vedere qui sopra per Bolzano il 4° campo va sostituito da BO a BZ

'iao

Sergio

mustafa · Messaggio da **mustafa** » 23/08/2004, 14:21

BluEdoG ha scritto:Per completezza di informazione, le provincie complete le trovate:
http://www.oscommerce.com/community/contributions,18

per completezza, a cosa servono?

Bass · Messaggio da **Bass** » 23/08/2004, 18:47

mustafa ha scritto: per completezza, a cosa servono?

Ad esempio ad inserire la sigla delle provincie nella form di registrazione al sito

'iao

Sergio

mustafa · Messaggio da **mustafa** » 23/08/2004, 18:57

Bass ha scritto:
mustafa ha scritto: per completezza, a cosa servono?
Ad esempio ad inserire la sigla delle provincie nella form di registrazione al sito

'iao

Sergio

il che significa che devo scaricare ed installare le zone di tutti i paesi nei quali voglio vendere, giusto? (nel mio caso specifico, UE).

Bass · Messaggio da **Bass** » 23/08/2004, 19:02

mustafa ha scritto: il che significa che devo scaricare ed installare le zone di tutti i paesi nei quali voglio vendere, giusto? (nel mio caso specifico, UE).

Mi pare che alcune siano gia' inserite comunque qui trovi quello che ti serve

'iao

Sergio

mustafa · Messaggio da **mustafa** » 23/08/2004, 19:06

Bass ha scritto:
mustafa ha scritto: il che significa che devo scaricare ed installare le zone di tutti i paesi nei quali voglio vendere, giusto? (nel mio caso specifico, UE).
Mi pare che alcune siano gia' inserite comunque qui trovi quello che ti serve

'iao

Sergio

grazie.
ma quindi confermi che devo mettere tutte le zone dei paesi in cui voglio vendere, si?

Bass · Messaggio da **Bass** » 23/08/2004, 19:20

mustafa ha scritto: grazie.
ma quindi confermi che devo mettere tutte le zone dei paesi in cui voglio vendere, si?

Credo sia utile, sia per i dati che dovrai utilizzare per inviare la merce che per eventuali differenze nel prezzo della spedizione

'iao

Sergio

mustafa · Messaggio da **mustafa** » 23/08/2004, 20:04

Bass ha scritto:
mustafa ha scritto: grazie.
ma quindi confermi che devo mettere tutte le zone dei paesi in cui voglio vendere, si?
Credo sia utile, sia per i dati che dovrai utilizzare per inviare la merce che per eventuali differenze nel prezzo della spedizione

'iao

Sergio

ok, grazie.

ciao

osCommerceITalia

Provincie abbreviate

Provincie abbreviate

Re: Provincie abbreviate