CiviCRM Community Forums (archive)

The database still only has Uttaranchal, India as the state name, and of course, it hasn't been that for a while.  I reported this in January, when I was at the office in Mumbai.

How can I add an alternative name (to civicrm_state） so that both are possible during import (since this seems to be the way that the state government is handling it)?

I was thinking of just putting in another record, with the same ID value, but it depends a lot on how your SQL is written as to whether or not that is feasable.

Thanks