I have got this far...
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
MyBase.BeforeConstituentSave(oRec,Cancel)
Dim oEvent As Blackbaud.PIA.RE7.BBREAPI.CSpecialEvent = New
Blackbaud.PIA.RE7.BBREAPI.CSpecialEvent()
oEventInit(ImportSessionContext)
oEvent.LoadByField(bbEventUniqueFields.uf_Event_EventID,"MDWA1905") 'This will eventually be looking at a column of data in my spreadsheet, but wanted to test against one event first
For Each p As CParticpant In oEvent.Participants
If p.Fields(EParticipantsFields.Participants_import.Fields.GetByExcelName("C").Value <>
oRec.Fields(ERECORDSFields.RECORDS_fld_FIRST_NAME) _
AndAlso p.Fields(EParticipantsFields.Participants_import.Fields.GetByExcelName("D").Value <>
oRec.Fields(ERECORDSFields.RECORDS_fld_LAST_NAME) _
AndAlso p.Fields(EParticipantsFields.Participants_import.Fields.GetByExcelName("K").Value <>
oRec.Fields(ERECORDSFields.RECORDS_fld_Email) Then
oEvent.CloseDown()
Cancel.CancelRow("Event ID should be MDHE")
End If
p=Nothing
Next
End Sub
Gemma Pearce
Hi!
We have an import which is adding an attribute to events. The events in the file can be a mixture of different events. How can I ask IOM to check to see if they are already a participant on this event and push them into an exception file if they aren't already added please? I don't have a Participant Import ID in my file, so can't exclude based on this.
Any help would be appreciated!
Many thanks
Gemma