All Collections
Integrations
People Integration
People Integration: CSV over SFTP
People Integration: CSV over SFTP
Learn how to load your employee data as CSV over SFTP
Chris Ramlow avatar
Written by Chris Ramlow
Updated over a week ago

Problem

You want to load your employee data into the PlusPlus learning platform, and People Integration: Direct API is not a viable option.

Solution

Use our CSV over SFTP for people integration. This option allows you/your team to set up a daily job to export your people data in the CSV format (described below) and securely upload it to PlusPlus over SFTP.

This approach requires several steps:

  1. Contact your Customer Success Manager to request the CSV over SFTP option, as this is currently not offered as a self-serve admin action.

  2. Unless you are doing this yourself, introduce your Customer Success Manager to the team/person configuring this on your end.

  3. Your Customer Success Manager will securely provide you/your team with the connection information and access credentials to our SFTP repository. Note, we support username/password as well as key-based authentication methods, so we will need to know your preference.

  4. You/your team will create a daily automated job that will export your employee details from your HRIS system into a single CSV file. This job will then upload this file to our SFTP repository with the supplied credentials, while using the following naming convention: uploads/hr_reports/people_report_YYYY-MM-DD.csv
    (e.g.: uploads/hr_reports/people_report_2020-02-08.csv). Please note that this file path is case-sensitive and that the date format must match YYYY-MM-DD.

  5. Our team will ensure that we pick up this file on daily basis and load the employee data into our platform.

CSV File Format

The CSV file format MUST satisfy the following requirements:

  • The file MUST include a header row with the following case-sensitive column names:

    • Full Name

    • Email

    • Employee ID

    • Department

    • Title

    • Hire Date

    • Manager’s email

    • Picture URL

    • Location

    • Termination Date

  • Only "Full Name" and "Email" fields are required to contain valid values. Other fields are optional and MAY be left empty (though this will limit certain features on the platform).

  • Additional columns MAY be added to the right of the required ones. The data in these columns will not be stored in the user profile but could be used as input to any rules you define for automated rules, such as group assignments, track assignments, and event enrollments.

  • All values SHOULD be quoted using the double quotes (") character.

  • All columns MUST be separated using the comma (",") character.

  • Where necessary, data MUST be escaped using the backslash ("\") character.

  • All rows MUST be separated using the carriage-return followed by the line-feed characters ("\r\n").

  • The entire file SHOULD be encoded as UTF-8. If it's not, please let us know what is the file encoding you would like to use, so that we can validate that we can support it (e.g. ISO-8859-1).

  • You can grab the template here: https://2pl.us/people-integration-csv

See Also

Did this answer your question?