Home

User import with multiple User Groups

Answered

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?

Agile User Asked on February 9, 2017 in Agile PLM (v9),   Product Collaboration.
Add Comment
Cancel
2 Answer(s)
Best answer

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

Cancel
Agile Angel Answered on February 9, 2017.

Paul Marfell

But it replaces all existing user groups with the value in the cell. Or, if it is in a single import, does it replace with the first then add with any subsequent ones? And to be on the safe side the file would be sorted by UserID.

on February 9, 2017.
Cancel

Paul Marfell

Bingo! I have just tested with 2 lines for 1 user with a different group on each line. The user finished up in each User Group. Their old user groups were removed.

on February 9, 2017.
Cancel
Add Comment
Cancel

Note that there are preferences for importing this that allow you to replace or add.  Great to hear you have it sorted.

Cancel
Agile Angel Answered on February 9, 2017.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.