Quickly Add Large Groups of Users to an Existing Assignment Group In OpenAir

If you have an existing assignment group and you are trying to load a large number of users to that assignment group, you can do so using OpenAir Integration Manager (OAIM), using the “Project Group” mapping.

The mapping file should contain the “Internal ID” of the assignment group and the “Assigned Users” which is a comma-separated list of the user internal IDs that need to be added to the assignment group. If you have the list of internal IDs of those users where each user is listed as a separate row in the .csv file, you can write a concatenation formula to take those rows and put them all in one cell in a comma-separated format.

Note: If you need help for turning a list of data into a comma-separated format just google “how to convert an excel column to comma-separated list”.