Follow

How to send HRIS data from TriNet via SFTP


Overview

You can save time and effort by configuring your HRIS to automatically extract and send your employee data to Culture Amp via Secure File Transfer Protocol (SFTP). 

You can use the integration to automate updates to the demographics outlined in Step 1 and from time to time upload additional demographics (e.g. diversity & inclusion demographics for understanding engagement results) via 'Import users'.

Setting up an SFTP integration may require assistance from TriNet. To request their help, you can create a support request in the TriNet platform (Support -> Contact TriNet -> Add Request). We've provided detailed technical instructions that you can provide to them during the setup process.

SFTP updates the user data using our Partial Import process. This means that you can update or add data via SFTP and manual uploads if you do not have all your information available in TriNet.

Before you start setting up the integration, ensure that you have access to the following accounts:

  • TriNet account with Workforce Analytics Administrator access
  • Culture Amp account with Account Administrator access

Quick Links

Step 1: Create a custom report in your HRIS
Add your hierarchy

 

Step 1: Create a custom report in your HRIS

Create a report that contains all the employees and demographics you want to import into Culture Amp. TriNet has created a template that already contains mandatory and recommended fields from our Employee Data File Template. To access it, log into your TriNet account and navigate to Reports -> Workforce Analytics -> Community Templates -> Culture Amp Export

A few recommendations:

  • You can edit the template to include or exclude some demographics or change names with which demographics will be sent to Culture Amp.
  • If you have existing data in the Culture Amp platform, it is best to edit the TriNet report to match demographic names already used in Culture Amp. This will allow you to trend results in surveys for demographic groups over time.
  • If you plan to create a hierarchy, or already have a hierarchy enabled, make sure that you have Manager Email demographic included in the report.
  • By default all employees (including terminated) will be included. If you want to exclude some employees, click Manage Filters on the report and add your rules.

Step 2: Connect your SFTP client with Culture Amp

To continue the set up in TriNet, click Schedule report -> Use SFTP. After that, select csv as file format and enable SSH Authentication.

TriNet will require the following information to set a connection. This information can be found in Culture Amp (Account Admin > Data Integrations > Select your HRIS > Set up Integration): 

    • Host/Hostname: Can be found Culture Amp
    • Username: Can be found Culture Amp
  • Port: 22

Make sure the hostname and username you use to set up your SFTP client are copied directly from the setup form in Culture Amp. Both are case-sensitive.

After you fill in that information in TriNet, click Download Key to download the public key. Open the file with a Notepad or a similar application and copy the entire content of the file, including the rss header, to the Public SSH key field on Culture Amp’s integration page you have just opened. 

As the last step, add in Culture Amp the contact person to notify about any integration errors and click Save settings.

If you want to test your SFTP connection after copying the public key from TriNet to Culture Amp, you can click Test on the Schedule Report page in TriNet. 

Step 3: Set report frequency

Now you can Set Frequency for this report on the Schedule Report page in TriNet. Reports will be created and sent to Culture Amp based on this schedule.

Common errors

'Duplicate employee IDs' error when using the TriNet integration

If you have switched to TriNet from a different HRIS and still have data from your previous HRIS in Culture Amp, you may experience a 'duplicate employee IDs' error when uploading data from TriNet. The common root cause is that the same Employee ID may be assigned to two different users in TriNet and your previous HRIS.

To correct the error:

  1. Go to Users page in Culture Amp
  2. Click 'Export Users' and export all users, including inactive users.
  3. In the export of your user file remove values for 'Employee ID' but keep the column header
  4. Save the document and go back to the Users page and do a partial import with that file.

These steps will erase the Employee IDs from your previous HRIS and should stop the 'duplicate employee IDs' error from occurring when you next sync your SFTP. 

Troubleshooting integration issues 

If you are facing issues with syncing your data from TriNet to Culture Amp, you can view troubleshooting information we have included in our Troubleshooting SFTP integration issues guide.

Add your hierarchy

Once your integration has been successfully set up, the process of adding hierarchy to your account is a once off manual task.

The steps to add hierarchy to your account can be located via our Add your hierarchy guide.



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments