Exporting scanned records from Raiser's Edge NXT
A resumable, read-only tool that copied 63,200 scanned files out of a CRM with no bulk export, each one checksummed
The charity needed a complete offline copy of the scanned attachments held against its supporter records in Raiser's Edge NXT, mainly Gift Aid declaration scans dated 2009 to 2017. The product has no bulk export for them, and they could only be opened one record at a time.
- •No bulk export exists for attachments in the product
- •Tens of thousands of supporter records had to be checked, not just a sample
- •The Blackbaud API rate-limits requests, and download links expire after 30 minutes
We wrote a Python 3.11 tool that works through every supporter record using read-only requests to the Blackbaud SKY API, downloads each attachment straight after listing it, and records a SHA-256 checksum and a manifest entry for every file. It can be stopped and restarted without repeating work.
- •Use read-only GET requests only, so nothing is written to Raiser's Edge
- •Throttle requests, and honour the API's Retry-After header whenever it returns a 429
- •Keep a done-list of finished supporter records, so a crash restarts where it stopped
Project Overview
A UK children’s charity kept scanned records, mainly Gift Aid declaration scans dated 2009 to 2017, as attachments on its supporter records in Blackbaud Raiser’s Edge NXT. It wanted its own complete copy outside the CRM. There is no bulk export for attachments, so we wrote a tool to do it.
The client is anonymous at its request.
The Strategic Challenge
Scanned declarations matter because they are the evidence behind Gift Aid claims. The charity needed to know the copy was complete, and needed it without any risk to the live database. That ruled out anything that wrote to the CRM, and it meant checking every supporter record rather than a sample.
How We Built It
Read-only and polite
The tool uses only GET requests to the Blackbaud SKY API. Requests are throttled, and when the API returns a 429 the tool waits for the time given in Retry-After before carrying on.
Resumable
Each finished supporter record goes on a done-list. When a Blackbaud 502 stopped the full run part-way through, restarting the tool picked up where it had stopped.
Each file checked
Download links expire after 30 minutes, so each file is fetched straight after it is listed. A SHA-256 digest and a manifest row are recorded for every file, and items that are links only, have no file or fail to download are listed separately. We started with a pilot on a small set of records before the full run.
Results and Impact
On 28 October 2026 the tool checked 60,236 supporter records. 23,567 of them had attachments, giving 63,200 files totalling 15.9 GB, exported in 6 hours 43 minutes. We delivered the files to the charity by SFTP, it confirmed receipt the next day, and we then permanently deleted our working copy so that we held no more of its data than necessary.
Technology
Python 3.11 run with uv, httpx for the API and downloads, DuckDB for summarising the manifest, and the Blackbaud SKY API as the source.
Need data out of a system that has no export? See Raiser’s Edge NXT integration and software development, or read about a related Raiser’s Edge NXT integration. Talk to us.
Key Features
Read-only by design
The tool makes only GET requests to the Blackbaud API. Nothing in the charity's live CRM is created, changed or deleted.
- No risk to live supporter data
- Safe to run alongside normal use of the CRM
Polite and resilient
Requests are throttled and 429 responses are honoured using Retry-After. A done-list means a stopped run resumes where it left off.
- Stays within the API's limits
- One Blackbaud 502 crash was resumed without repeating work
Integrity recorded for every file
A SHA-256 digest is stored for each exported file, alongside a manifest and a separate list of exceptions.
- The copy can be re-checked at any time
- Anything unusual is listed rather than hidden
Related Projects
CFP Lottery & Raffles
We built Insyte for CFP Lottery & Raffles: a Django platform that reads scanned donation forms with Document AI, runs QA and reconciles banking for charities.
CFP Lottery & Raffles
We built the CFP Raffle platform: a Django back office for running charity raffles end to end, from tickets and OCR to banking reconciliation and exports.
UK children's charity
We connected a UK children's charity's iRaiser donation platform to Blackbaud Raiser's Edge NXT, so online gifts and Gift Aid declarations are recorded automatically, without duplicates.
Ready to Transform Your Business?
Let's discuss how we can help you achieve similar results