Globally Deleting Records with Gifts

Options
Hello,


We have encountered a little probelm within our database. We have reached the number of allotted records per Blackbaud. I know the easiest solution would be to just pony up the money in order to be bumped to the next tier. Well being a state ran institution that money was not budgeted into this fiscal year, so I will have to wait until the next fiscal year. Anyway, I know it is frowned upon within development communities, but I have exhausted all other options. I have to look at archiving historical donors. I have queried last gift date with anything less than  or equal to 12/31/1999 and have close to 5000 records. The biggest question I have for the community is when/if I delete these records and the giving history, will this negatively affect the fund the money was previously held? Btw we aren't linked to FE.  
Tagged:

Comments

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    My opinion, If you're looking at an annual fund from 18 years ago probably not.  Books/records/auditing would have been completed years ago.  If there are gifts to a fund that you are still running reports for cumulative amount say like endowment it would have an effect on the dollar figure the report pulls.  Sort of depends on what kind of reports you anticipate running/needing to me.


    I'm assuming that if you do that type of clean up that you would be exporting the records and giving data to Excel or another format to maintain for historical purposes.
  • Brandon Atkison:

    Hello,


    We have encountered a little probelm within our database. We have reached the number of allotted records per Blackbaud. I know the easiest solution would be to just pony up the money in order to be bumped to the next tier. Well being a state ran institution that money was not budgeted into this fiscal year, so I will have to wait until the next fiscal year. Anyway, I know it is frowned upon within development communities, but I have exhausted all other options. I have to look at archiving historical donors. I have queried last gift date with anything less than  or equal to 12/31/1999 and have close to 5000 records. The biggest question I have for the community is when/if I delete these records and the giving history, will this negatively affect the fund the money was previously held? Btw we aren't linked to FE.  

    If you remove/delete records with a history you  break the integrity of your data.  This is not just about being linked up with FE, that is not the issue.  You lose your ability to do any analytical work with your constituents/donors AND if they do give now, you will not know that they have a history. 

    Please read this: 

    http://www.billconnors.com/media/Raisers Edge NXT Pricing - To Delete or Not Delete Constituents.pdf
  •  Excellent advice. Creating a record to store the summary of the deleted gifts makes good sense.

  • Elaine, that's a brilliant solution! I mean, as with all of these solutions it should only be used in cases of extreme durress, but this makes so much more sense than either simply deleting and forgetting the info or exporting out to excel/access and trying to maintain two separate databases. I'm going to keep this idea in my back pocket.
  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    Elaine, Kudos!  The summary record is a great idea when this type of record cleansing is necessary!
  • Ryan Hyde:

    I agree with JoAnn's assessment entirely. It depends on your org, but unless you're doing reporting still from that long ago, it shouldn't really have any impact on your day to day operations.


    However, I need to ask, do you typically set up both spouses in a household as separate constituents? If you do, I may have a novel solution for you. Last year I flattened out more than 20k of these types of records in my own database without actually losing any information. It's a bit involved, but I'd be happy to talk you through it some time. 

     

    We do not. We only set them up as separate constituents for prospect reasons or if they give a gift on separate occasions.

  • Blast. Well then I vote for Elaine's strategy, but only after you talk to Blackbaud as Jen suggested.
  • This could take some time, but here is another idea that could work if you are just trying to eliminate Constituent records:


    1) Export all constituent records that you are archiving for possible future importing if you increase funding. Do a seperate export for all the gifts.

    2) Create an individual and organization record for historical gifts.

    3) Import the gifts back into those two constituent records. Add gift attributes for the original constiuent record ID and name.

    4) Run some reports to check that all the gifts are in there before deleting the constituent records.

    (5) If you ever import all the records back into the system, the historical gift constituent records could be deleted.
  • I second all the great ideas already suggested, but just wanted to double check that you have thoroughly searched for duplicate records in your database.  My database has a ton of these because prior data entry folks thought that there had to be a separate whole record for the tribute gifts and didn't know that they could just put them all under the tribute tab in the main record.  If you have this kind of double entry in your RE database, what about buying the tribute module instead and merging your "duplicates?"  I wonder if that could fit into your current budget?

  • Just as an FYI ...

    I had recently received a back-up of my database, since we were undergoing a clean-up in our transition to NXT. We were going to delete/merge fields, but wanted to keep a back-up, in case historical information become important down the road.

    Apparently, you can't open a database back-up when you're hosted ... and a local copy of RE is not available once you transition to NXT.

    Support has been fabulous and is working with me, but didn't want others to get caught in this situation!


  • Support has been fabulous and is working with me, but didn't want others to get caught in this situation!

    Wow, I didn't know this! Thanks for the heads up!

Categories