Start a new topic

Multiple Gift Import

We are trying to import the donors giving history.  I have each gift, date, amount, fund, in different columns. However, when it creates the import batch, it is only pulling the data from the first column.

I have read where split gifts need to be a two lines.  Do multiple gifts need to be treated the same or have I missed something in configuration to allow this?
1 Comment

Hi Brian,

Multiple gifts typically go one-per-row. Gift splits are multiple-per-row. If you have control over the source of your data I would recommend reformatting it to be one gift per row. If not, you can create multiple profiles, each one set to process a span of columns comprising a single gift set in your file, then process the same file multiple times with the different profiles. If you do not have an exact constituent ID on each row, I would recommend having the first profile output the constituent import ID, so you'd only have to go through the constituent search process on the very first profile.

Jeff
Login or Signup to post a comment