Answers.Body: <p>If there is a contact (y) with that ID already then one option via the UI would be</p>
  
  <ul>
  <li>create a new contact (z). Then merge z and y so that z inherits all the information for contact y</li>
  <li>retrieve y from trash, and go through the same steps of merging y with x (your original contact) such that y inherits all the info from x.</li>
  </ul>
  
  <p>Outcome should be that your original contact will now have the ID of y.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-07T21:23:02.330Z
Answers.Text: Thanks for your help! Unfortunately, no one in our database has the specific ID.
Answers.UserDisplayName: Peter Dodge
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-08T05:20:44.040Z
Answers.Text: because it has been used and contact deleted, or your sequence of numbers hasn't gotten that high? if the former you may be able to do a sql insert
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-07T18:46:43.207Z
Answers.LastActivityDate: 2017-02-07T18:46:43.207Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Assuming the id has already come and gone.</p>
  
  <p>Create a new person of the same type.  Give them the same name so you can find and merge later.  Only give them a name.  Don't give them an address or email or anything else.  Otherwise you'll be creating records in other tables.  </p>
  
  <p>Using sql or phpadmin or some other sql tool update the contact id to the one you want.</p>
  
  <pre><code>update civicrm_contact set id = wantedid where id = id_of_newly_created
  </code></pre>
  
  <p>Now merge the old person into the newly created re-id'd person.</p>
  
  <p>As always with stuff like this test in a development environment first.</p>
  
  <p>Caveats:  You might find that the swapping id's errors with foreign key constraints.  If so, look at the constraint and delete the record from that table that matches the new contact_id.  You may have to do this a few times if there is more than one.  I found that custom fields sets that were set to view inline each had a record.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-11T02:57:27.717Z
Answers.Text: It's funny I was just testing this very thing.  We have a couple of people who have recurring donations that got setup on the individual and they want the donations to be on the household.  Since I don't think you can change the IPN stuff, one solution is to change the id's of the people.
Answers.UserDisplayName: Paul-Tahoe
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-11T03:03:11.013Z
Answers.Text: I did try to just insert a record with the id and the bare minimum and then do the merge to that.  You don't end up with a hash for that person and merging, editing, etc. doesn't seem to create one.
Answers.UserDisplayName: Paul-Tahoe
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-11T02:53:58.633Z
Answers.LastActivityDate: 2017-02-11T02:53:58.633Z
Answers.UserDisplayName: Paul-Tahoe
Body: <p>Is there a way to manually override someone's CiviCRM ID?</p>
  
  <p>A long time member of ours got his original ID number from our previous database. When we switched to Civi, it changed his ID. He would like his old ID number back.</p>
  
  <p>Thanks!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-07T18:47:11.517Z
Comments.Text: perhaps explain if the ID the contact 'wants' already exists, etc.
Comments.UserDisplayName: petednz - fuzion
Tags: <contacts>
Title: Manually Change CiviCRM ID?
ThreadText: # Manually Change CiviCRM ID?
  
  (Asked by: username_0 on 2017-02-07)
  
  Is there a way to manually override someone's CiviCRM ID?
  
  A long time member of ours got his original ID number from our previous database. When we switched to Civi, it changed his ID. He would like his old ID number back.
  
  Thanks!
  
  **Tags:** contacts
  
  > **Comments:**
  > **username_1**: perhaps explain if the ID the contact 'wants' already exists, etc.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-02-07. Score: 2
  
  If there is a contact (y) with that ID already then one option via the UI would be
  
  * create a new contact (z). Then merge z and y so that z inherits all the information for contact y
  * retrieve y from trash, and go through the same steps of merging y with x (your original contact) such that y inherits all the info from x.
  
  Outcome should be that your original contact will now have the ID of y.
  
  > **Comments:**
  > **username_0**: Thanks for your help! Unfortunately, no one in our database has the specific ID.  
  > **username_1**: because it has been used and contact deleted, or your sequence of numbers hasn't gotten that high? if the former you may be able to do a sql insert  
  
  ---
  
  ### Answer by username_2 on 2017-02-11. Score: 0
  
  Assuming the id has already come and gone.
  Create a new person of the same type.  Give them the same name so you can find and merge later.  Only give them a name.  Don't give them an address or email or anything else.  Otherwise you'll be creating records in other tables.  
  Using sql or phpadmin or some other sql tool update the contact id to the one you want.
  update civicrm_contact set id = wantedid where id = id_of_newly_created
  
  Now merge the old person into the newly created re-id'd person.
  As always with stuff like this test in a development environment first.
  Caveats:  You might find that the swapping id's errors with foreign key constraints.  If so, look at the constraint and delete the record from that table that matches the new contact_id.  You may have to do this a few times if there is more than one.  I found that custom fields sets that were set to view inline each had a record.
  
  > **Comments:**
  > **username_2**: It's funny I was just testing this very thing.  We have a couple of people who have recurring donations that got setup on the individual and they want the donations to be on the household.  Since I don't think you can change the IPN stuff, one solution is to change the id's of the people.  
  > **username_2**: I did try to just insert a record with the id and the bare minimum and then do the merge to that.  You don't end up with a hash for that person and merging, editing, etc. doesn't seem to create one.  
  
  ---
  
  