I have a spreadsheet of data from an event we recently held that was hosted on an Aventri website. Have been banging my head on importing this into CiviCRM for a week. I finally figured out how to match people to organizations by doing two separate imports; now I'm trying to figure out how to match custom data from registration questions in the participant import.
I have a column for whether they only registered or actually attended (which I guess maps to Participant Status?), one for newsletter signup, one for donor interest, and a fourth for career status (custom text field). I've created these four fields in a profile and attached it to the event; they show up fine in the list of match fields.
But I don't see how to match the participant data to the contacts; I have last name as an option but that fails for contacts with duplicate last names. (I had to revert my database on that one, first try.) Why isn't there an email match? The only thing I can think of—which I haven't done because this can't be the right way—is to export the contacts from CiviCRM and manually put their IDs into the spreadsheet?
What am I missing here? I know I can find the tagged imported contacts and bulk register them for the event; I don't know if this is a step I take before importing the custom data.