What is this?
C.A.R.E. Shelter receives donations through multiple platforms (Qgiv, PayPal, Square, ShelterLuv, and manual entries). Each platform exports data with different field names and formats, making it difficult to import all donations into DonorSnap for centralized donor management.
The Problem
Managing donation data from multiple sources is challenging:
- Qgiv uses field names like "First Name", "Last Name", "Email"
- ShelterLuv uses "Person First Name", "Person Last Name", "Person Primary Email"
- Square uses "First Name", "Last Name", "Email Address"
- Facebook PayPal only has "From Email Address" for contact info
- DonorSnap expects its own specific field names like "First", "Last", "EMail"
Without automation, someone has to manually rename columns and reformat data from each source before importing into DonorSnap - a time-consuming and error-prone process.
The Solution
This tool automates the entire process:
- Accept a single Excel file containing sheets from different donation sources
- Map each source's fields to DonorSnap's expected field names automatically
- Combine all donation records into one standardized CSV file
- Simplify the import process into DonorSnap's Excel Import feature
How It Works
- Export donation data from each platform (Qgiv, Square, ShelterLuv, etc.)
- Combine all exports into a single Excel file with separate sheets for each source
- Upload the Excel file to this web application
- Download the standardized CSV file ready for DonorSnap import
Benefits
- Save Time: No more manual field renaming and data reformatting
- Reduce Errors: Automated mapping ensures consistency
- Centralize Data: All donor information in one place for better management
- Transparency: View exactly how fields are mapped on the Mappings page
Supported Platforms
- DonorSnap (existing data)
- Qgiv
- ShelterLuv
- Square
- Facebook PayPal
Result: Instead of manually reformatting data from each platform, you can now upload one consolidated spreadsheet and get back a DonorSnap-ready CSV file with consistent field names for donor information (name, email, address), donation details (amount, date, payment method), and notes.
Privacy & Data Security
Your data is not stored or retained.
This tool processes your files in real-time and immediately discards them:
- Files are uploaded to temporary memory and automatically deleted after processing
- No database exists to store donation data
- The CSV output is streamed directly to your browser
- No logs are kept of file contents or donor information
Open Source: This project is fully open source. You can review the code, verify our privacy claims, and even run the tool on your own computer for complete control.
Technical Implementation
This tool is built with:
- Rust: Fast, secure, and memory-safe programming language
- Axum: Modern web framework for efficient request handling
- Data-Driven Mappings: All field mappings are defined in code and displayed transparently
- Temporary File Handling: Uses
NamedTempFilefor automatic cleanup
Version Information
- Git Commit:
4b62aa5 - Git Branch:
main - Build Date:
2025-10-28 10:37:37 -0500