How to perform Batch User Update?

For Google Workspace.

For Microsoft 365.

Question:

How to perform Batch User Update?

Answer:

Batch User Update Procedure is as follows;

Batch User Update Procedure

  1. Log in to the admin page of HENNGE access control service using admin user account
  2. Go to [User list] in the left menus a Click on [Download (TSV)] -> Acquire TSV file of the currently registered users list.

  3. Edit the downloaded TSV file
    Delete the entire line of the user who needs no change, or input [0] in the [Description of the changing action] field on A line.
    In here, please be careful enough NOT to change the settings of the HENNGE admin user.

     Line  Item  Description of the changing action
     A  Action   2 (Update)

     *The followings are the designated numbers for the actions.
     1 (New registration)
     2 (Update)
     3 (Delete)
     Other (No action)
     B  User name  Leave it as it is (No change)
     C  Password 【Change】
     Change to a certain password

    【No change】
     Delete the value and leave it blank
     D  Password forcibly changed 【Change】
     0 (Initial Password not forcibly changed)
     1 (Initial Password forcibly changed)

    【No change】
     Delete the value and leave it blank
     E  Last name 【Change】
     Change to a certain surname

    【No change】
     Leave it as it is (No change)
     F  First name 【Change】
     Change to a certain surname

    【No change】
     Leave it as it is (No change)
     G ■Google Workspace
     Department

    ■Microsoft 365
     Display name
    ■Google Workspace
     Leave it as it is (Make no change and leave it blank)

    ■Microsoft 365
    【Change】
     Change it to a certain name

    【No change】
     Leave it as it is (No change)
     H  State of belonging  Leave it as it is (Make no change and leave it blank)
     I  Access Policy Group 【Change】
     Change to a certain access policy group ID

    【No change】
     Leave it as it is (No change)
     J  Mail address(SAML UID) 【Change】
     Change to a certain mail address

    【No change】
     Leave it as it is (No change)
     K  OTP Notification mail receiving address 【Change】
     Change to a certain mail address

    【No change】
     Delete the value and leave it blank
     L  OTP shared key 【Change】
     Change to a certain OTP shared key

    【No change】
     Delete the value and leave it blank
     M  OTP token for imminence 【Change】
     Change it to a certain OTP token for imminence

    【No change】
     Delete the value and leave it blank
  4. Go to [User list] in the left menus -> Click on [Batch registration/update] -> Upload the TSV file edited in step 3 -> Click [+send] button.
          
Was this article helpful?