Author Topic: Missing province in Honduras [SOLVED] (Read 1786 times)

wpost · February 16, 2012, 07:30:04 pm

Upon installing the l10n file, I notice that one of Honduras's 18 provinces is missing: La Paz. How can I add it?

Prior to asking here I attempted to add it myself. I opened the file civicrm_data.es_ES.mysql. Observing how prior editors added missing data, I added at the end of the province list (line 4088):

-- Added missing province for Honduras (NULL, 1097, "LP", "La Paz"),

It didn't work; the province drop-down control is still missing La Paz. What else might I try to get this province to appear?

Donald Lobo · February 17, 2012, 06:36:59 am

You need to add this directly in the DB in the civicrm_state_province table

If you file an issue we'll get this in for the 4.2 release

lobo

wpost · February 17, 2012, 07:49:14 am

Quote from: Donald Lobo on February 17, 2012, 06:36:59 am

You need to add this directly in the DB in the civicrm_state_province table

If you file an issue we'll get this in for the 4.2 release

Fixed on my end and added to the issue tracker. Many thanks!

Upperholme · March 02, 2012, 11:32:53 pm

I've just attempted to add "Isles of Scilly" to the civicrm_state_province table, following the pattern. Presumably the country id determines which provinces appear in the drop down for each country. I've logged out and back in again, but the new entry is not available in the drop-down. Have I missed a step?

Graham

CiviCRM Community Forums (archive)

News:

Author Topic: Missing province in Honduras [SOLVED] (Read 1786 times)

wpost

Missing province in Honduras [SOLVED]

Donald Lobo

Re: Missing province in Honduras

wpost

Re: Missing province in Honduras [SOLVED]

Upperholme

Re: Missing province in Honduras [SOLVED]