Accidently Imported Appeal & package codes twice - how to remove it from account?

Darren Ponce

Hello, I accidently put in an imported csv files of appeals and package ID's twice and would like to have the accounts only show it once. I'm forgetting how to best remove the duplicate row from the Appeal tab. Any word on how to globally change this? Thanks!



Example of import codes I'm currently using: ConsID CAPDate CAPAppealID PackageID CAPImpID

Patti Hommes, bCRE-PRO

There may be a better approach, and if so I look forward to hearing it! I had this happen as well. Using a query of the constituents in question I did a global delete of the appeal, MAKING SURE I CREATED AN OUTPUT QUERY. This removed both of the appeals. Then using the Output Query, I did a global add of the appeal back into those records. 

JoAnn Strommen

Also, my understanding.  Both have to be deleted and then put one back in. 

Darren Ponce

Thank you for the help. I didn't want to do a global delete of both, but its pretty easy to just add it back in the way you described. Thanks again!

Christine Robertson

I don't think that any other solution will be faster than simply deleting both via Global Delete and then re-adding the appeal.  One thing to double check would be that your # of people who were solicited is correct (on the Appeal itself).

Jody Johnson

Always best just to remove what you did and start over.