Migration Services

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

Client
UK children's charity
Duration
Pilot, then a single full run in October 2026
Launched
Oct 2026
Client confidential
Key result
60,236
Supporter records checked
The Challenge

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
Our Solution

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
Results Achieved
Supporter records checked60,236
Files exported63,200 files (15.9 GB)
Run time6 hours 43 minutes
Complete offline copyThe charity received the full set by SFTP and confirmed receipt the next day
Data minimisationZorinto's working copy of the export was permanently deleted after the charity confirmed it had the files

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
Charity TechnologyData ExportBlackbaudPythonDuckDBGift Aid Records

Related Projects

Ready to Transform Your Business?

Let's discuss how we can help you achieve similar results