There are three ways we recommend to update the Department field for Google G-Suite. They are outlined below.
NB: You only need to choose one method.
- Log in to the server hosting GCDS (usually the AD Server)
- Launch GCDS
- Under General Settings, Ensure User Profiles is checked
- Go to User Profiles and ensure to map department > Department. The below two articles may assist if you wish to sync other attributes:
https://support.google.com/a/answer/6162412?hl=en#userprofile
https://support.google.com/a/answer/6258071#user_profile - Ensure Active Directory has a common value populated in the Department field (i.e. Staff for staff members or the year group such as Year 7, Year 8 for students)
If you use Google Cloud Directory Sync (GCDS), any synchronization with Active Directory will override changes made in G-Suite
- Sign into your Admin Console (https://admin.google.com/)
- Click on Users tile
- Select required organizational unit in the menu on the left then click on Download users button
- Select All user info columns and currently selected columns and Comma-separated values (.csv) options, then click on Download button
- Click on Download CSV from Google Admin task area
- Open the CSV file with user information that you just downloaded
- Under the Department column, enter appropriate values (i.e. Staff for staff members or the year group such as Year 7, Year 8 for students)
Important things to remember:
- Any information in columns you can edit replaces existing information in the Admin console when you upload the file.
- For columns you don't want to change, you can either delete them (if the column isn't required), leave their information in the file, or delete their information.
- If you delete all information from a column that's not required, but leave the column in the spreadsheet, the existing information is not removed from the user's account when you upload the file.
- If you don't want to change a user's password, make sure the Password column contains the symbols **** (4 asterisks). - Save the CSV file
- Go back to Google Admin Console and click on Bulk upload users button
- Click on ATTACH CSV button and navigate to the updated CSV spreadsheet you saved. Then click on Upload button.
- This will merge the spreadsheet as opposed to creating new users.
- Sign into your Admin Console (https://admin.google.com/)
- Click on Users
- Click on the user you wish to update/modify the department field for
- Click on User Information under basic information
- Scroll down until you see Department. Click on the attribute and enter appropriate values (i.e. Staff for staff members or the year group such as Year 7, Year 8 for students).