Importing a Mixed File
Donors and Donations Together
If your file contains both donors and donations together in one file, then you have what we call a mixed file. In this case you may have a donor specified multiple times - once for each donation (see example below).
Mixed data files follow the same rules as importing donors and donations, except that the donor and the donation are both on the same row.
When you're importing a mixed file you can specify a donor on multiple lines for multiple donations. As long as their attributes (name, address, etc.) are identical for each row, then the system will recognize that it's the same person and will assign all their donations to the right donor.
Example Mixed File
| Donation Id | Donor Id | Name | Amount | Fund | Source | Gift Date |
|---|---|---|---|---|---|---|
| 1 | 1 | Andrew Carnegie | 100.00 | General Fund | Year-End Mailing | 2012-05-03 |
| 2 | 1 | Andrew Carnegie | 125.00 | General Fund | Special Appeal | 2012-05-10 |
| 3 | 2 | John Rockerfeller | 225.00 | General Fund | Special Appeal | 2012-04-26 |
| 4 | 3 | Joseph Rowntree | 500.00 | General Fund | Year-End Appeal | 2012-05-16 |
In the example above, you'll end up with three donors (Andrew Carnegie, John Rockerfeller, and Joseph Rowntree) and four donations.