Start a new topic

Event participation - check but not add


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


1 Comment

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


  Dim oEvent As Blackbaud.PIA.RE7.BBREAPI.CSpecialEvent = New



  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


  Cancel.CancelRow("Event ID should be MDHE")

  End If



  End Sub

Login or Signup to post a comment