I have a SugarCRM and OpenERP instance, and need to sync states (which change a lot), customers, organisations and some products.
Some of the above records are created when OpenERP was installed, some have been imported from CSV, and some have been entered by hand through the admin pages. This has left and unholy mash of different and missing external IDs on the records (e.g. the states).
Is there a way to clean up these external IDs? I can't see a way to do it through the admin pages, so is there a way through the APIs? Can I load up state "Alabama" and tell OpenERP "the external ID for this record is now US-AL"?
Similarly, when creating new states through the API (we have a global list that is growing all the time), can the external ID be set at the time it is created?
