Start a new topic

Event participation - check but not add

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

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

    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

Login to post a comment