Prior to doing any work, ensure that a backup has been made:
- If your Raiser's Edge is in Blackbaud Hosting, your Raiser's Edge is backed up.
- If your Raiser's Edge is not in Blackbaud Hosting, create a backup in the Blackbaud Management Console.
This can be done by creating Raiser's Edge queries to group the records. Some things to consider are for these records are:
- When was the last gift given?
- When was the last time the constituent renewed his/her membership?
- Does the constituent have a relationship/affiliation with another donor in the database?
- Are the constituents contacts for an organization?
- Are these records already marked deceased or inactive?
- Are these constituents rated prospects for future cultivation?
Once the records are identified via Query*, there is an optional process to extract/export the information in The Raiser's Edge prior to deletion to save externally to the Raiser's Edge backup. One option to extract this data is to use Import as it will create these files with the needed import IDs should you ever desire to import these records back into The Raiser's Edge.
The process will involve creating import data files using Import. (*Multiple queries may be needed depending on the information desired, such as constituent query and a gift query to pull constituent information and gift information). A base constituent record of name, address, and gifts would involve the following the imports:
- Constituent (*Constituent query)
- Constieunt Address (*Constituent query)
- Gift (*Gift query)
The other option is to use a constituent Export in either CSV, Excel, or even Access format. This can put everything into one file but may be very large depending on the information selected.
After the backup and the secondary extract/export is complete, then proceed with the global deletion of constituents to remove them entirely from your Raiser's Edge.