I have a file of event registrants that I would like to import but some of them will be in the database and some won't. Is there any way of knowing if IOM found a match in the database during import so I can set the Participant is a Constituent field to Yes or No?
I've tried the following code with no luck:
Public Overrides Sub BeforeConstituentSave(ByVal oRec As Blackbaud.PIA.RE7.BBREAPI.CRecord, _
Cancel as ImportOM.API.iCancel)
'The main constituent record is about to be saved
If oRec.Fields(Blackbaud.PIA.RE7.BBREAPI.ERECORDSFields.RECORDS_fld_ID) = "" Then
import.fields.Getbyexcelname("S").Value = "No"
import.fields.Getbyexcelname("S").Value = "Yes"