I’m working on an import profile to apply online gifts (from Artez) to as Other Donations to event participants when there's a specific event ID in the import file. I’ve mapped the Participant Import ID from the Artez Solicitor ID to link the gift to the participant.
The import file includes both event proceeds and proceeds from other events, which are not being applied to event records in RE, but they have a value in them (usually “0”, but there are some stray values from other events). This causes an exception when importing the gift. I’ve worked around it by deleting the value out of the Solicitor ID field when the Artez Event ID is different.
Is it possible to make the import dynamic enough to only reference the solicitor ID field if there’s a specific Artez Event ID field on the file? I’m hoping not to have to modify the file prior to import or do multiple passes.