4

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?

4

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

1
  • 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
2

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...).

1

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.

1

I think this extension will help you for the future record.

https://lab.civicrm.org/extensions/formercommunicationdata

1
  • Yes it will help for all changes to address etc which have not happened yet. ie it only generates info for changes made after installing the extension. for ones that may have already happened and are in you log_ tables, you probably need to try Advanced Report (though it didn't fire up for my first effort) – petednz - fuzion Sep 8 '20 at 7:19
0

Wikimedia use the Advanced Report extension to provide a tab showing address history (rendering a report as a tab is an extended reports feature) (citing https://lab.civicrm.org/dev/core/-/issues/1021#note_18644)

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.