Exporting Split Gifts

Sarah Fitzgerald

Is there any way I can create a gift export that will give me a row with an amount for each split instance instead of all on one row?

Melissa S Graves

Well - technically no but yes. If you export as a .mdb file you will get lots of tables and links and these instances would be separate but I am certain you are not looking for that (unless you plan to do your reporting via access or crystal or the like.)


Depending on what you are planning to do with your data and what other fields you are including - this is when the "do not export from query" rule is sometimes broken.

Sarah Fitzgerald

Oh is there a way to do this with a query? I tried this but wasn't getting good info. Is there a trick?

Melissa S Graves

If you export the split gift amount instead of gift amount you will get 2 rows. But if you also have any other one to many export fields, you may get 4 instead of 2. You really need to understand the database structure and how one to many fields work.

Jen Claudy

I would recommend adding criteria with a couple of Constituent IDs to your Query while you're learning/testing.  Even creating some dummy records.  This way, you can try different things and see what happens, without needing to wait a longer time for the Query to run because it's using a larger data selection.