How to update the "Department" field for Google G-Suite (SSO)?

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.

 

  1. Log in to the server hosting GCDS (usually the AD Server)
  2. Launch GCDS
  3. Under General Settings, Ensure User Profiles is checked

    inline-751557806.png
  4. 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
  5. 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

 

  1. Sign into your Admin Console (https://admin.google.com/)
  2. Click on Users tile

    firefox_2020-06-10_15-01-45.png
  3. Select required organizational unit in the menu on the left then click on Download users button

    ApplicationFrameHost_2020-06-10_15-07-18.png​
  4. Select All user info columns and currently selected columns and Comma-separated values (.csv) options, then click on Download button

    firefox_2020-06-10_15-07-57.png​
  5. Click on Download CSV from Google Admin task area
    firefox_2020-06-10_15-08-19.png
  6. Open the CSV file with user information that you just downloaded
  7. 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)

    EXCEL_2020-06-10_15-09-25.png

    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).

  8. Save the CSV file
  9. Go back to Google Admin Console and click on Bulk upload users button

    firefox_2020-06-10_15-09-59.png
  10. Click on ATTACH CSV button and navigate to the updated CSV spreadsheet you saved. Then click on Upload button.

    firefox_2020-06-10_15-10-37.png​
  11. This will merge the spreadsheet as opposed to creating new users.

 

  1. Sign into your Admin Console (https://admin.google.com/)
  2. Click on Users

    firefox_2020-06-10_15-01-45.png
  3. Click on the user you wish to update/modify the department field for
  4. Click on User Information under basic information

    ApplicationFrameHost_2020-06-10_15-40-35.png
  5. 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).

    ApplicationFrameHost_2020-06-10_15-39-06.png


Last edited on