I inadvertently changed an address on a contact and need to change it back to it's previous address. How do I find historical address information?


This is only possible if you have "detailed logging" enabled. If not, you'll need to restore a backup copy of your database (to a test server!) and do a comparison.

You can check to see if you have detailed logging enabled at Administer menu » System Settings » Misc, under Logging (see screenshot). If you do NOT have this enabled, please read the logging documentation before enabling it. If you have shared hosting, you may not be allowed to turn this on; if you run CiviCRM on your own server or VPS, then you should have no problem. enter image description here

If you DO have detailed logging enabled:

  • Go to the contact record with the changed address.
  • Click the Change Log tab.
  • Find the change that corresponds to the date that the address was changed and click Update next to it.
  • You should see before-and-after results.

enter image description here enter image description here

| improve this answer | |
  • 1
    I agree with Jon, but be careful as enabling detail logging can significantly increase the size of your database over time. You'll want to ensure you have enough storage. – pkeogan - BackOffice Thinking Sep 26 '17 at 17:37

We sometimes use a custom location type "Old address", so when we add a new address we set the previous as "Old address" and the new one as the "Home" + primary. Administer > Customize Data and Screens > Dropdown Options > Location Types (Home, Work...).

| improve this answer | |

Might also want to consider using the "Future address changes" extension, https://github.com/CiviCooP/org.civicoop.futureaddress

Future address changes This extensions adds functionality to change an address in the future, the old address is archived as an activity in civicrm.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.