User import with multiple User Groups
I have just tried an import to update Users. The intention was to replace their existing Role(s) and User Groups with values from the import file. The file had 1 line per user with a semi-colon separated list of Roles and a semi-colon separated list of User Groups headed New Roles and New Groups..
All Users that only had 1 User Group in the file updated – their existing list of Roles was replaced with the list from the file and their existing list of User Groups were replaced with 1 User Group in the file. The update for the users that had more than 1 User Group in the file failed with “not a valid value”
Fortunately only a few users were to be in more than 1 User Group so a manual update was easy.
Can someone give me some more details of how to do this kind of thing?
I think you have figured it out…. only 1 activity per import line so anyone with multiple user groups would need separate import lines for each user group
Note that there are preferences for importing this that allow you to replace or add. Great to hear you have it sorted.