G Suite: Importing users from G Suite

Although there is an option to enable the automatic creation of accounts on first login to Room Booking, some schools prefer to import their users. Reasons for this include being able to make bookings on behalf of a user before they log in, or having a little more control over who can and can't login.

Getting a list of users from G Suite

G Suite allows you to download a full (or filtered) list of users, which can then be modified and imported to Room Booking, as follows:

1. Log into G Suite as an administrator.
2. Go to the Users menu.
3. (Optional) If you wish to output a custom list of users, select the users you wish to output in the export by clicking their icon.

4. Click the options button at the top right then select Download Users.

   

5. Select one of the options, depending on what you want to output to the downloaded list.

   

The list of users will then be downloaded. 

Preparing the exported list of users for import

You should now have a file that looks similar to the following:

While this contains most of the information needed, it's not quite in the right format and you need to take the following steps:

1. Delete columns D to G - these are not required for import.
2. Copy column A and "Insert" it to make a new column - both consisting of email addresses. Rename the newly pasted column so that the heading is "Username":
3. Follow the 'Importing Users' section of this guidance to import the file: https://support.roombookingsystem.co.uk/article/110-how-do-i-set-up-my-users
   
   Please note that users may be sent a password reset link when this happens, however these can simply be ignored
   Note: If users in the export already exist on Room Booking, they will not be updated. You may have noted that there is a  User Import section on the admin home page, we do not recommend using it in this circumstance as it will send out a password reset email to all users imported. However, we can import the users without that email being sent.