Start a new topic

Event Participant importing question

Hi everyone,


I'm hoping someone can help me with a question we had on importing multiple event participants.


Specifically where Event Participant records are set to allow multiples on a record, so the supporter could do ‘Generic Fundraising Event’ on 01/01/2017, and then again do a different ‘Generic Fundraising Event’ on 02/02/2017, how does ImportOMatic process these in imports?  I believe that if the EventID matches that it will always update the existing Event Participant record, meaning that any time someone did multiple different fundraising events during a year of the same type, where we would ideally use the same EventID, ImportOMatic would automatically update the existing record.  Is there any way to force it to add new ones where it matches the EventID but other information doesn’t match, such as the Event Date? 


Additionally, for Challenge Events, we would only want to allow one Participant record, as someone should only be taking part in events like London Marathon 2017 once.  But for Community Events, where a supporter could do their own fundraising throughout the year, we tend to use a single EventID (‘Now is Good Community Fundraising’) but a distinct event participant record for each separate bit of fundraising they do.  We have a number of supporters who may do multiple bake sales or smaller fundraising events in a year, where we would want to steward them for each of these, and I think that ImportOMatic wouldn’t support this...?


Please let me know if any of this is unclear as I appreciate it's quite a long-winded post...


Many thanks,


Hi Ben,

We would like this same functionality to be able to make the decision to allow more than one participant record per event per constituent. Have you voted on the idea for this yet? If not, please vote!! Hopefully, we can push to have this updated in IOM. Thank you!!

URL to the uservoice idea:


Hi Ben, not sure if this is still an open issue but have you tried adding the RSVP date to the Event ID matching logic? That should allow you to separate them within a single event record. I use that kind of logic on some Assigned Appeals that occur throughout the year for multiple years.

Login or Signup to post a comment