I've imported our membership list with existing membership numbers into CiviCRM.
The old membership numbers are currently under external ID. I'd like an autoincrementing membership number.
The best solution I have found from digging around various threads and forums is to do the following in order to use the contact id as the membership:
- Modify the database schema constraints to allow updating the contact id and to propagate those changes to all tables
- execute a script that would update the contact id to be the same as the member external id
I might be able to figure out the second part given enough time, but the first bit for sure is a bit beyond my SQL skills. Is anybody able to assist? Or there a better solution available to what I imagine is a common requirement?