CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Snapshots of historic data
Pages: [1]

Author Topic: Snapshots of historic data  (Read 1712 times)

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Snapshots of historic data
April 04, 2013, 01:40:47 pm
A client has requested the ability to access a snapshot of their previous year's data, as this is a functionality of their existing (Access + MSSQL2005) DB.

IMO CiviCRM does a pretty good job of not "throwing away" data - eg their existing DB deletes contacts, but CiviCRM would retain these contacts and flag them deceased, do not contact, etc. In some areas, CiviCRM wouldn't offer this (eg editing an email address or historic membership record would overwrite the data).

To me a snapshot feels like the wrong approach, but I'm thinking about it from a perspective of an admin who might need to restore DB data in event of emergency, not as an office staff member who wants to review historic information.

Have you done something similar for a client? I'd be interested to hear of approaches and thoughts. It seems straightforward to copy the DB to a new install at snapshot-2009.example.org ...

@xurizaemon ● www.fuzion.co.nz

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Snapshots of historic data
April 04, 2013, 02:57:14 pm
Yes, keeping a daily snapshot of the full DB is one simple way to do this.

I do have a client (using old versions of Drupal and CiviCRM) who wanted to be able to take snapshots at will so I made him a custom module that stores the data for that client as HTML (IIRC) in the DB somewhere. That worked for him. :)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Snapshots of historic data

This forum was archived on 2017-11-26.