To automate your employee list file sync, your IT team will have to (1) automatically generate your employee list from your HRIS, payroll system, or Active Directory using one of the employee list templates as a guide and (2) send that file to us on a cadence you choose (daily, weekly, every 5 minutes... it's up to you).

If you automate your file sync, the name of the file must be "members.csv".

We are happy to talk about this with you and your IT group if/when you decide you want to set this up, just contact us at support@blissbook.com.

You can send your file via SFTP or HTTPS.

Set Up

Start on the SYNC tab of your People page (click ORGANIZATION in the main nav).

Next, click the Enable button next to the "Automatically via SFTP or HTTPS" section.

For SFTP, click the button and then click Install. Blissbook will automatically generate a secure username and password for you and your credentials & settings will be shown once you click the Install button. Use those credentials to connect to Blissbook to send us your file. The file is read upon receipt and then immediately deleted for security reasons. You will receive a response from our FTP server to report the success or failure of your sync attempt.

For HTTPS, click HTTPS and then click the Install HTTPS button. You'll then need to generate an API key – just follow the instructions/link provided after you install. Then use the example scripts to create your own to send us your file. The file is read upon receipt and then immediately deleted for security reasons.

Timing

Again, your employee list in Blissbook updates any time you send a file. Most of our customers send it nightly, but you could send it every 5 minutes or once a week if you want to.

More important is the order in which certain events happen. If you are sending automated invitations to new employees through Blissbook, those employees' email addresses must be valid. Blissbook also needs to know about a new employee before they try to sign in to Blissbook. So the ordering should be:

  1. Email address works (so the invitation/login email won't bounce)
  2. You tell Blissbook
  3. Employee then tries to sign in

If you aren't using Blissbook to send invitations, 1 & 2 could be flip-flopped and it would still be OK.

WinSCP Example SFTP Script

If you are using WinSCP, here is an example script to sync your employee list to our SFTP server. The SHA 256 Fingerprint as well as your username and password will be available after you install the SFTP integration. For additional WinSCP scripting and command line options, please refer to the WinSCP documentation.

blissbook-sftp-script.txt

open sftp://<username>:<password>@sftp.blissbook.com:3022/ -hostkey="ssh-rsa 4096 <sha-256-fingerprint>="
put -nopermissions -nopreservetime members.csv
close

Command Line

winscp.exe /ini=nul /script=”blissbook-sftp-script.txt”

Did this answer your question?