Attendee Email Match to ID

Created by Kevin Schmidt - HCPro, Modified on Thu, 9 Oct at 3:11 AM by Kevin Schmidt - HCPro


Match on email address to return the Aptify Person ID.

Import the spreadsheet into the Aptify database and name it Temp.

Match the email address to Person.Email and insert Person.ID to the table.


If you do not find a match on Person you can also try to match email to WebUser.UserID and insert WebUser.LinkID (which = PersonID). 

There is a good chance you will get duplicate email matches. 
If those records can be flagged then Judith can look in Maritz and locate the correct registration record to retain. Judith my Maritz login info is in Secret Server. 



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article