CiviCRM Community Forums (archive)

This is a good question.

Dropping the database records in the table "civicrm_group_contact" that have "status=Removed" might be all you have to do... but that record doesn't store the date of the Add/Remove, so there must be another record somewhere, and I hesitate to recommend you remove some records, without getting them all.

Someone round here will know better.

Hang tight buddy.

If we can find where the REMOVED date is stored in the DB, then you could control which ones are removed.

Hmm......

And there it is!  Thanks Lobo.

So, create a script that finds the subscription changes in the date range you made the bad import (Added) and when you fixed your mistake (removed), and also remove the group_contact record that is linked with the FK.

Two questions :

Can you access your database via phpMyAdmin, and are comfortable doing that, as well as creating/restoring a backup of the database?

How many mistakes are we talking about?  a few hundred?  a few thousand? more?

If you can't make a script, you could do it manually in phpMyAdmin, depending on how many records we are talking about...

But if you can't dig around in your database, I'm not sure how to help. If it's a big enough deal, hire a programmer to write a custom script to clean up your database for you.

--------------------------------

As a side discussion, this might be a low priority feature request for situations like this?  A mass update (add to group) is made in error, creating records that can't be fully undone by performing the opposite mass update(remove from group).  Is the subscription history the only record that this happens?   (Add to group / Remove from group -- Don't want the history to show the error)