Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

RO Zones
 
quark
Member
 
Total Posts:  60
Joined:  2007-12-15
Romania
 

Attached you can find Romaian zones / counties, with county_code and county_name.
Please include these zones in the database.
Regards,

Ioan

File Attachments
RO_zones_UTF8_2.sql  (File Size: 10KB - Downloads: 359)
 
Magento Community Magento Community
Magento Community
Magento Community
 
pgpdesign
Member
 
Total Posts:  41
Joined:  2008-04-15
 

Mreci!

 
Magento Community Magento Community
Magento Community
Magento Community
 
pgpdesign
Member
 
Total Posts:  41
Joined:  2008-04-15
 

Ca si ne-programator - le-am introdus in baza de date. Imi apar in meniu dar nu se salveaza in adrese.........

Intru intr-un cerc vicios cand incerc sa editez o comanda: imi cere sa selectez judetul si pierde optiunea de transport. Selectez modalitatea de transport si dispare judetul....

In “Contul meu” pot edita adresa dar la re-editare judetul nu mai este selectat.

Ma poate ajuta cineva ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
pgpdesign
Member
 
Total Posts:  41
Joined:  2008-04-15
 

se pare ca ,ai trebuie updatat un tabel, si anume directory_country_region_name

am incercat

INSERT INTO `directory_country_region_nameVALUES(`RO`, 182'Alba');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 183'Arad');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 184'ArgeÅŸ');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 185'Bacău');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 186'Bihor');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 187'BistriÅ£a-Năsăud');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 188'BotoÅŸani');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 189'BraÅŸov');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 190'Brăila');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 191'BucureÅŸti');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 192'Buzău');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 193'CaraÅŸ-Severin');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 194'CălăraÅŸi');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 195'Cluj');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 196'ConstanÅ£a');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 197'Covasna');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 198'DâmboviÅ£a');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 199'Dolj');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 200'GalaÅ£i');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 201'Giurgiu');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 202'Gorj');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 203'Harghita');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 204'Hunedoara');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 205'IalomiÅ£a');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 206'IaÅŸi');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 207'Ilfov');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 208'MaramureÅŸ');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 209'MehedinÅ£i');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 210'MureÅŸ');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 211'NeamÅ£');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 212'Olt');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 213'Prahova');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 214'Satu-Mare');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 215'Sălaj');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 216'Sibiu');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 217'Suceava');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 218'Teleorman');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 219'TimiÅŸ');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 220'Tulcea');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 221'Vaslui');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 222'Vâlcea');
INSERT INTO `directory_country_region_nameVALUES(`RO`, 223'Vrancea');

dar nu merge

si-mi da

Error

SQL query
:

INSERT INTO `directory_country_region_name`
VALUES (
`
RO` , 182'Alba'
);

MySQL saidDocumentation
#1054 - Unknown column 'RO' in 'field list'

am incercat si cu ro_RO - acelasi lucru

Ma poate lumina cineva?

 
Magento Community Magento Community
Magento Community
Magento Community
 
pgpdesign
Member
 
Total Posts:  41
Joined:  2008-04-15
 

se pare ca imediat ce pun intrebarea gasesc singur raspunsul:

INSERT INTO `directory_country_region_name` (`locale` ,`region_id` ,`name`) VALUES 
('en_US'182'Alba'),
(
'en_US'183'Arad'),
(
'en_US'184'ArgeÅŸ'),
(
'en_US'185'Bacău'),
(
'en_US'186'Bihor'),
(
'en_US'187'Bistriţa-Năsăud'),
(
'en_US'188'BotoÅŸani'),
(
'en_US'189'BraÅŸov'),
(
'en_US'190'Brăila'),
(
'en_US'191'BucureÅŸti'),
(
'en_US'192'Buzău'),
(
'en_US'193'CaraÅŸ-Severin'),
(
'en_US'194'Călăraşi'),
(
'en_US'195'Cluj'),
(
'en_US'196'Constanţa'),
(
'en_US'197'Covasna'),
(
'en_US'198'Dâmboviţa'),
(
'en_US'199'Dolj'),
(
'en_US'200'Galaţi'),
(
'en_US'201'Giurgiu'),
(
'en_US'202'Gorj'),
(
'en_US'203'Harghita'),
(
'en_US'204'Hunedoara'),
(
'en_US'205'Ialomiţa'),
(
'en_US'206'IaÅŸi'),
(
'en_US'207'Ilfov'),
(
'en_US'208'MaramureÅŸ'),
(
'en_US'209'Mehedinţi'),
(
'en_US'210'MureÅŸ'),
(
'en_US'211'Neamţ'),
(
'en_US'212'Olt'),
(
'en_US'213'Prahova'),
(
'en_US'214'Satu-Mare'),
(
'en_US'215'Sălaj'),
(
'en_US'216'Sibiu'),
(
'en_US'217'Suceava'),
(
'en_US'218'Teleorman'),
(
'en_US'219'TimiÅŸ'),
(
'en_US'220'Tulcea'),
(
'en_US'221'Vaslui'),
(
'en_US'222'Vâlcea'),
(
'en_US'223'Vrancea');
 
Magento Community Magento Community
Magento Community
Magento Community
 
quark
Member
 
Total Posts:  60
Joined:  2007-12-15
Romania
 

Nu stiu de ce tie nu ti-a mers importul zonelor din fisier. Azi am reinstalat Magento ver. 1.0.19870.1 si importul a mers struna.
Uite si rezultatul importului:

Import has been successfully finished42 queries executed.
Comanda SQLINSERT INTO `directory_country_region` (`region_id`, `country_id`, `code`, `default_name`) VALUES (182'RO''AB''Alba');# Linii afectate: 1
INSERT INTO `directory_country_region` (`region_id`, `country_id`, `code`, `default_name`) VALUES (183'RO''AR''Arad');# Linii afectate: 1
INSERT INTO `directory_country_region` (`region_id`, `country_id`, `code`, `default_name`) VALUES (184'RO''AG''ArgeÅŸ');# Linii afectate: 1
...
INSERT INTO `directory_country_region` (`region_id`, `country_id`, `code`, `default_name`) VALUES (223'RO''VN''Vrancea');# Linii afectate: 1
 
Magento Community Magento Community
Magento Community
Magento Community
 
quark
Member
 
Total Posts:  60
Joined:  2007-12-15
Romania
 

Varianta cu diacritice valabila pentru versiunea 1.2.1 (ultima valoare a campului region_id din tabelele directory_country_region si directory_country_region_name are valoarea 277).
Importati fisierul SQL in baza de date folosind phpMyAdmin sau orice alta metoda.

File Attachments
RO_zones_UTF8_3.sql  (File Size: 11KB - Downloads: 321)
 
Magento Community Magento Community
Magento Community
Magento Community
 
MariusG
Jr. Member
 
Total Posts:  7
Joined:  2008-03-18
Romania
 

A functionat impecabil. Mersi, quark. smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
pgpdesign
Member
 
Total Posts:  41
Joined:  2008-04-15
 

ok....

cateva observatii

1) ca sa nu mai patesc ca alta data cand - dupa un update de magento - mi s-au busit judetele, am inceput de la ID-ul 99182
2) acum am modul de plata ePayment. Ca sa transmit la ei corect si judetul a trebuit sa renunt la diacritice
3) tot din cauza ePayment Bucuresti a devenit ‘Bucuresti - Sector 1’ urmat de sectoarele 2.... 6, dupa care mai departe

Paul

 
Magento Community Magento Community
Magento Community
Magento Community
 
ardelean
Jr. Member
 
Total Posts:  2
Joined:  2009-03-10
 

vreu sa pun un anunt....

caut un programator php4 php5 si care sa se descurce si cu magento.

cine ii interesat sa ma contacteze pe:  dna_dan83@yahoo.it

salariu in euro…

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top