Skip to main content
Sync a user CSV via SFTP

This page describes the requirements of Spencer to facilitate user sync via SFTP with a predefined CSV.

Tom Segers avatar
Written by Tom Segers
Updated over a month ago

General understanding

Spencer's SFTP service is available at sftp.spencer.co (port 22).

Access credentials can be requested via [email protected].

You'll receive access to a customer specific root directory that contains following sub-folders:

  • /users/in - Directory that is used by the customer to upload the user CSV(with name spencer_user.csv)

  • /users/in/processed - Directory that is used by Spencer in order to archive files that have been processed (note that processed files are purged on regular basis).

Security

There are 2 possible ways to securely connect to the service:

  • via username + password

  • via username + SSH key

Username/password is the default method. If you prefer connecting via SSH key, please provide us with your public key.

IP ranges and server fingerprints can be delivered on request if needed by your network & security teams' outgoing security policy allowlisting.

Rules

  • The user CSV must have a fixed name: spencer_user.csv

  • Each nightly sync will process the file in /users/in and move it to /users/in/processed after successful sync.

  • We do not support multiple files in the /users/in folder. The same file needs to be overwritten every time you upload an updated CSV.

  • When no file is found or an error occurs during processing, the sync process will automatically send an error mail indicating the issues found.

Input needed from customer

  • Let us know if you want to connect via password or SSH key.

    • [Optionally] send us your public SSH key

  • Provide us with a (preferably shared) email address that can be used for email notifications in case the user sync fails.

Did this answer your question?