Home » discuss » Public forums » iMIS Community

Recover deleted Customer record

Posted July 10th, 2011 by faithw
|

Hello iMIS community users,

A colleague of mine had accidentally deleted a customer record (Name, Susbcriptions, Events, Activities, CE etc) from our live database - not the smartest move. The Delete button was put on active as I, as the DBA, was doing maintenance work on empty records being created.

Fortunately, I have a test database copied from the live database from last month. Has any one had any experience in exporting a full record from another database to import it into a live version of iMIS?

Would greatly appreciate any assistance / guidance on this one.

Thanks in advance,

Faith

‹ Moving iParts on an existing pagecollecting e-check payments with a custom payment gateway provider ›
login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

What happens to deleted records?

On November 7th, 2011 ak says:

Do you know what happens to iMIS member records (and all associated data) once deleted from the desktop? I know there’s no “undo” capability but is the info moved somewhere else in the DB for audit reasons?

Looking at something related, the purge script (Utilities > System Reports and Queries > Purge > Membership Purge for MS SQL) moves data to Purge_Ctrl_* tables but I could be misinterpreting this. And who’s to say the “delete” button would do the same thing?

Thanks,
Annie
login or register to post comments

I believe the Delete button

On November 7th, 2011 faithw says:

I believe the Delete button erases the member record, but details from tables like Trans, Activity still exist - provided that you know the Trans.BT_ID or Activity.ID fields.

Once you have located either of those ID's, it's a matter of creating a new record, manually with that ID; and the existing information will populate that member record. Of course, you'll need to manually input details such as address, contacts, subs, etc.

Not too sure about the Purge!

 

Cheers,

Faith

login or register to post comments