I would like to assign multiple roles to event participants through imports. I can upload a csv to assign a user role, but if I import a second data source with a different role, it is set aside as a duplicate and not imported. I would like the second role to be added to the existing record. (not overwrite)

For instance I have a list of auction event particapants who are attendees, donors and/or buyers. My lists have overlapping contacts. I would like to keep these all associated with the event, rather than creating groups or tags. Handling the overlaps manually is not practical.

bumped to the homepage by Community 2 days ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

  • can you import with comma within the one field separating the various role IDs – petednz - fuzion Apr 16 at 20:33
  • That DOES work, which is great BUT it means that all roles need to be established and merged before any importing. I want to be able to import three different data sets and let the roles accumulate, partly because the roles are established at different times. Someone may be a VIP guest BEFORE the event. Afterwards, I want to add the role of "Buyer". Thanks for your suggestion. I feel like it gets me one step closer. – Audrey Apr 16 at 23:59

The value for all Role data is stored in a single field so I think however you tackle this you are at risk of overwriting existing Roles. Here is one process that at least makes existing Role values visible so you won't overwrite them accidentally.

Create a Profile for updating Participants that includes the Import your Contact IDs and add them to a Group

Use Adv Search to find those Contacts but set the search "Display Results As" to be Participants.

Select the records you want to update - under Actions choose Update multiple participants - select the Profile you created above - this should then give you a batch updates screen where each Role is shown as a checkbox

enter image description here

  • Thanks. It looks like I could do a batch update of adding a role, is that the idea? I had hoped there would have been a simpler solution, similar to adding tags to an import, where they just continue to build in the record. I think that reverting to using tags for my roles might end up being the simplest solution, though I'm afraid I'll end up with tag tangles. – Audrey Apr 18 at 18:45
  • Yes my suggestion was using Batch Updating and the only extra work that I see compared to Adding Tags, is the fact that it is a checkbox field and therefore if you have a mix of current roles you won't be able to use the photocopy button at the top. Have you thought about using custom fields instead? One field for each 'role' and then use Batch Updating where you would be able to use the photocopy button. – petednz - fuzion Apr 18 at 19:46
  • Ok, I'll experiment, thanks! – Audrey Apr 19 at 21:20

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.