CiviCRM Community Forums (archive)

We need a extension to manage the Countries, Provinces and Worldregion from CiviCRM

My idea is do it a form(UI) to manage this three components.

The tables that contain this information are civicrm_worldregion, civicrm_state_province, civicrm_state_province

The idea is that this must work in a not clean installation(with contacts and addresses filled) and don't corrupt the data.

- In the three tables preserve the currents rows civicrm_country.id, civicrm_state_province.id, civicrm_worldregion.id(To avoid corrupt the data). And the posibility to alter the field name from this tables.
- Give the possibility to add rows in the three tables
 Add new World regions: name.
 Add new Country: name, iso_code(validation UNIQUE), region_id(with a select from Worl regions )
 Add new State/Province: name, abbreviation(validation UNIQUE), country_id(with a select from Country )

I'm missing something, or the development need to be in another way?