Change Country Name?

[zampino]

Yugoslavia is now called Serbia, but to Miva V4 it's still Yugoslavia. Is there a way to edit the name of the country associated with the abbreviation "YU"?

Thanks,
phil zampino

http://www.squidco.com

[Nerd Boy Inc]

Re: Change Country Name?

Dear Phil,

You can use a DBF Editor to change the name.

[Mr.Webby]

Re: Change Country Name?

Why does anyone need to use a DBF editor? That name change has been in effect since October 2006, can't this be rolled into a core-update or something?

[Rick Wilson]

Re: Change Country Name?

It's on our list, I thought we did it in Core 14. I'll make sure this is paid attention to.

[Mr.Webby]

Re: Change Country Name?

Cool, because I just installed core-14 last week. While you are at it, there's also Kosovo, Montenegro, and I'm not sure what else.

Thank you,

[Bruce - PhosphorMedia]

Re: Change Country Name?

actually, if you changing things...might want to allow that list to be edited. (A lot of countries are spelled differently overseas<G>)

[Rick Wilson]

Re: Change Country Name?

That's our plan.

[Gilbert]

Re: Change Country Name?

Rick

Ideally the list should be at store level, it would allow localisation within a mall

EDITED

Having a second thought on that ... One editable list should be Ok as countries name can be written within that list according to their local spelling.

[Pamela Hazelton]

Re: Change Country Name?

That's our plan.

Sounds good, but could you make it so existing countries are BOLDED with a warning on the screen about Country Codes? I can see already people's shipping calcs not working, only to find they messed with the country codes...

[Gilbert]

Re: Change Country Name?

Sounds good, but could you make it so existing countries are BOLDED with a warning on the screen about Country Codes? I can see already people's shipping calcs not working, only to find they messed with the country codes...

To avoid problems the Country Codes could remain non editable.

[sassyronin]

Re: Change Country Name?

I'm running 5.5. I have a customer from Montenegro who's unable to get his payment to process, as his country doesn't exist in our store and Yugoslavia is invalid. We just converted our data to MySQL. If I go in and edit the appropriate entry, will this break anything now or when a core update comes along to fix it? Thanks!

[chucklasker-BANNNED]

Re: Change Country Name?

Here are the codes for the countries that have replaced Yugoslavia:

Serbia (or Republic of Serbia) = RS
Croatia = HR
Bosnia-Herzogovina = BA

From http://www.columbia.edu/kermit/postal.html, here's USPS info:

USPS Name		ISO	Car	City Line Format	City Line Example  
BOSNIA-HERZEGOVINA	BA	BIH	nnnnn town		71000 SARAJEVO  
CROATIA			HR	HR	nnnnn town		10000 ZAGREB  
MACEDONIA		MK	MK	nnnn town		1000 SKOPJE  
MONTENEGRO		ME	??	nnnnn town		81000 PODGORICA  
SERBIA			RS	??	nnnnnn town		106314 BEOGRAD  
SLOVENIA		SI	SLO	SI-nnnn town		SI-1001 LJUBLJANA

In Miva Merchant MM4 DBF, the columns are:

ID, NAME, ALPHA, NUMERIC

So, what would be the ALPHA and NUMERIC for the above if I added them?

[Mr.Webby]

Re: Change Country Name?

I've just installed core-17, this still isn't updated. Will it be in an update any time soon or should I go ahead and edit the table manually?

[Rick Wilson]

Re: Change Country Name?

You should manually edit it.

[ILoveHostasaurus]

Re: Change Country Name?

I just changed a customer's country.dbf to add Serbia and while it's in there, it's not showing up in the admin or customer interfaces. Is there something additional that needs to be edited in a different file?

Edit: pack domain afterward and then it shows up.