Agylia enables you to perform automated user imports, which you can use to schedule user imports on a regular cycle. This guide explains what you need to do to use the automated user import feature.
First, you need a file that contains the user information you would like to add to your Agylia LMS. Ideally this file is in a compatible format with the CSV file used within your Agylia administration portal.
Note: You can download a template CSV file to specify the users to be imported. To do this, in the Administration Portal, on the the Users | Import users page, click download the template file. You can also test your import file manually using the Import users option. Further information on manually bulk importing users is available here.
After you are happy that you have a correctly formatted file, you need to upload the file to an FTP server.
Agylia provides an FTP server, secured using either SFTP or FTPS, which you can use to upload your file:
Region can be either
us, for example,
Note: Only the EU site is available at this time.
You should get in contact with Agylia support so we can create you an FTP user for your LMS. The user name for your FTP account will be the first part of your Agylia Administration Portal hostname, for example, if your hostname is example.portal-agylia.com your user name will be example. The password for your FTP account is your API Key. You can find your API Key from your Admin portal (Settings | General | API Key).
The following example shows how to connect to the EU Agylia FTP site, with the user name example and the password 9c52047e63db436bf0b990e6910d71aedf32656ef23, by using the lftp command line tool:
$ lftp ftp-eu.portal-agylia.com lftp ftp-eu.portal-agylia.com:~> login example 9c52047e63db436bf0b990e6910d71aedf32656ef23 lftp email@example.com:~> ls drwxr-xr-x 2 0 0 4096 Aug 22 16:51 log drwxr-xr-x 2 1000 1000 4096 Aug 22 15:39 reports drwxr-xr-x 2 0 0 4096 Aug 23 08:49 tmp drwxr-xr-x 2 1000 1000 4096 Aug 22 17:07 uploads lftp firstname.lastname@example.org:/>
You must upload your user import CSV file into the
/uploads folder. The file must be called
user-import.csv. You should overwrite this file each time you want to perform a user upload.
The job that processes the upload runs once a day at midnight UTC by default. However, please let us know if you would like to change this scheduling. The import job only processes uploads that have not been processed before, so don't worry about leaving the file on the FTP server.
Note: The import job creates a SHA1 hash of the upload file and places the hash in your
/tmp folder; this is how the import job knows if it has processed that version of the
user-import.csv file before. Therefore, if you want retry an import, simply remove all the SHA1 hash files in the folder.
The import job writes to the
/log/user-import.log as it processes your import file, so you can look at this file to see if everything worked as expected with the upload.
Note: The log file does not contain detailed information about the processing of the user records within the file. This information is sent by email after Agylia has processed all the users.
The import process runs in the context of a nominated administrator account. We recommend creating a global admin user for this specific purpose, for example, a user called FTP User. The email address associated with this user will receive the email notifications from Agylia, including a status report, on completion of the bulk processing. The status report contains a record by record indication of success for each user update. The import job needs to know the identity (but not the password) for your selected administrator account. Please let us know which account you’d like to use and we will update the import job for you.
In summary, to successfully set-up user imports you need to:
- Let us know you'd like use the user import feature (so we can provision you an FTP User)
- Let us know which global administrator account to act as (so you can receive email updates)
- Copy a
user-import.csvfile to the
/uploadsfolder (so we process your users)
If you need any help or have any questions please contact Agylia support, we're happy to help.