WorkTango User Management - SFTP Automated
TABLE OF CONTENTS
The CSV user management integration allows customers to automate the process of syncing user information between the customer’s system of record (HRIS) and WorkTango. Customers are responsible for uploading the HRIS files with complete employee data, either internally or with the help of their HRIS provider.
Our integration reads a CSV file from an SFTP host and uses the data to create, update, and archive users within WorkTango.
Note: The CSV file must be formatted without quotes.
SFTP Information and Automation
Overview
The content of this file will be derived from an export of your existing HRIS provider. To simplify the process, we recommend working with your HRIS provider to automate sending files.
Note: HRIS providers may charge for the creation and transfer of the user data report. It can also take them time to generate this report, as it’s based on their queue. Be sure to check with your HRIS provider to understand the expected cost and timeframe for your organization.
FTP upload process
To share HRIS files, your WorkTango Implementation Manager (IM) will create a folder on a secured file transfer protocol (SFTP) portal. You will be provided with credentials and connection information to input into your FTP site. This will connect your folder to WorkTango’s in order to transfer the HRIS file. Your IM will provide you with the following information:
Host
Username
Password
You’ll also be given a template with the necessary fields to structure employee data. Before making the connection, we suggest sending a completed user file to your IM for review.
Once approved, you will schedule a regular upload of your file to the FTP site. The file name can be anything you’d like - the platform will run any file dropped into the FTP site, regardless of the name.
Note that the WorkTango platform will run the file as soon as it is dropped in the FTP site. The file will be processed, then deleted from the FTP site immediately upon completion. We recommend scheduling this regular upload to happen overnight so that daily data changes are captured at the end of each day and updated prior to start of business the next day.
A Note on Unique Identifiers
Our integration works by building a profile for each user based on a static Unique Identifier, like Employee ID. This Unique Identifier allows the system to update any other data points that might change relative to the user.
While we recommend using Employee ID, we recognize that sometimes our customers don’t have this data point. For those who don’t, we can use an Email address, but it must remain constant or duplicate users could be created in the system.
File Columns
The following are the standard column headers for this integration.
All required columns must be included for your file to process, however columns may be in any order.
Additional Information
Groups
Outside of the standard “Department” and “Location” groupings, WorkTango allows customers to organize users into additional groups. There is no cap on how many groups a customer can bring over, and these generally align with the data fields saved within your HRIS.
You will have a parent group and sub groups. For example, “Division” might be a parent group containing the sub groups “West” and “North”. Work with your WorkTango IM to establish the groupings you would like to bring into your WorkTango platform. Your IM will help establish the groups.
Archiving Employees
To archive inactive employees, you can either use the “Status” column or opt to archive users who are missing from your file.
WorkTango recommends bringing only active employees onto the file and selecting the option to “Archive all users who are not included in an import file.”
Employees whose data isn’t on the file will be automatically archived and will no longer be able to log into the platform. Archived employees maintain both their Giving and Earned Points; these will not be zeroed out or refreshed (quarterly or monthly).
Please note: if you are archiving missing users, the “Status” column is still required in your user file. In this case, the status would always be “active.”
Error Handling
Your platform will log any errors that arise during your SFTP import. Admin users are able to access import histories and error logs for the past 90 days, by navigating to Admin>Company>Integrations>Import History. After 90 days, this information will be purged from the system.
- no-reply@p2motivate.com
- notification@prepaidcardstatus.com
- auto-confirm@prepaidcardstatus.com
- service@prepaidcardstatus.com
The documentation provided above is only applicable to the WorkTango Recognition & Rewards platform and does not apply to our Surveys & Insights solution.