You can automate your user imports with our SFTP feature. This allows you to keep your user data up to date at a cadence which suits your business, while making use of all the functionality of a user import via the admin dashboard, including:
- Creating users
- Updating existing users
- Managing group membership
- Automatically activating or suspending users
By automating user imports with SFTP, you can combine data stored in systems other than your main user directory to enrich your users’ profiles.
The diagram below gives an overview of how user synchronisation with SFTP works.
To set it up:
- Export the user data from your HRMS (e.g. Active Directory, SAP)
- Transform the user file according to Beekeeper’s requirements (the format is identical to a CSV user import, as described here)
- (Optional) Encrypt the file with PGP for additional security. Download our PGP public key here
- Send the file to Beekeeper’s servers using an FTP client (popular clients include Filezilla, WinSCP and CoreFTP)
FTP client configuration
Your FTP client should be configured according to the settings below:
ftp-sync.beekeeper.io (or ftp-sync.ch.beekeeper.io for customers in Switzerland)
|Protocol||SFTP (SSH File Transfer Protocol)|
Your Beekeeper domain, e.g. your-company.beekeeper.io (or if you are in a different region, use your-company.dc.beekeeper.io, where 'dc' is your datacenter)
|Password||the access key of a Bot Account with admin privileges|
|(Optional) RSA key fingerprint||86:cc:3a:95:7a:40:4a:ec:06:b2:5d:d5:b9:6b:21:cc|
|(Optional) PGP public key||download|
Imports do not appear in the dashboard: Check your file structure. It should follow the requirements outlined in this article.
Some profile fields did not map during the import: Check your placeholders. You can find these in the admin dashboard under Settings > Profile fields.
What format should be used for the CSV file? UTF-8, comma or semicolon separated. Do not use tabs as the delimiter. ASCII quotes (") around fields are not required.
Are there any constraints regarding the length of fields? This depends on the profile field type, e.g. usernames are limited to 32 characters but user IDs can be any length.
Will users who are not listed in the import file be deleted? No, users that are not listed will not be changed.
How can I suspend users? Include a column titled 'suspended' in your file, and use the values '0' for active and '1' for suspended users.
Do users created via SFTP automatically get sent login instructions? No, but you can still send them login instructions through the admin dashboard, under Engagement > Login Instructions. (See this article for more information on how to send login instructions.)
My configuration is correct, but I can't connect to the Beekeeper FTP server: Verify that the Beekeeper domain (beekeeper.io) is whitelisted in your firewall.
I'm getting an SSH error: Bad packet length: Check your connection configuration. This is usually happens when you are connecting over FTP instead of SFTP, and the server tries to decrypt the first block of data being sent through, only to find that it is in the incorrect format.
My FTP client is returning errors after syncing. Is there anything I can do? Your FTP client may be trying to set permissions or timestamps, which our server does not support. This is the default setting for WinSCP and some other clients. In WinSCP in particular you can change the settings by going to: Preferences > Transfer > Default Preset > Edit... > Common Options and uncheck "Preserve Timestamp".