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).
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
|Andrew Carnegieemail@example.com||100.00||General Fund||Year-End Mailing||2017-02-06|
|Andrew Carnegiefirstname.lastname@example.org||125.00||General Fund||Special Appeal||2017-02-13|
|John Rockerfelleremail@example.com||225.00||General Fund||Special Appeal||2017-01-30|
|Joseph Rowntreefirstname.lastname@example.org||500.00||General Fund||Year-End Appeal||2017-02-19|
In the example above, you'll end up with three donors (Andrew Carnegie, John Rockerfeller, and Joseph Rowntree) and four donations.