Understanding the CSV Used by Fond Roster Sync
Fond allows customers to create and manage employees in the platform via a CSV file (typically a custom report generated from their HRIS system). The CSV automatically updates the Fond database nightly.
In an effort to be as accommodating as possible to the limitations of customers’ HRIS export tools, Fond sanitizes CSV file headers before processing them. As such, capitalization is not important, and underscores are accepted instead of spaces. For example, “Full Name” or “full name” are both accepted and “Full Name” and “Full_Name” are considered the same. Additionally, headers can be provided in any order.
How the CSV Data Is Used
To maximize the value of the data you provide to Fond, it’s important to understand how and where each data element is used.
|Header Name||Format||Required||Where Used||How Used|
|“Full Name”, “Fullname” or “Preferred Name”||“First LastName” (e.g. “John Smith”)||Y||Recognition Form, Social Feed,|
User Profile Page, All Admin Exports
|“Email”, “Emailaddress” or “primaryworkemail”||Valid and unique email address||Y||Login and/or SSO, Recognition Form, All Admin Exports||Primary User ID, Customer Reporting|
|“Birthday”||MM/DD||N||Roster Exports||Trigger Scheduled Birthday Recognitions|
|“Work Start Date”||MM/DD/YYYY||N||Roster Exports||Trigger Scheduled Work Anniversary Recognition and/or Service Awards|
|“Job Title”||Alphanumeric text (up to 191 characters)||N||All Admin Exports||Customer Reporting|
|“Employee ID”, “EmployeeID”, or “ID”||Unique alphanumeric code||N*||All Admin Exports||To automatically update email address changes for existing employees and to reinstate formerly deleted/deactivated employees, Customer Reporting|
|“Department”||Alphanumeric text (up to 191 characters)||N||Feed Filter, All Admin Exports||Feed Filtering**, Customer Reporting|
|“Supervisor Email”||Valid email address of the employee’s direct manager/supervisor||N||Feed Filter, All Admin Exports||Associate employees with their managers for Team Reporting and Feed Filtering,|
|“Office City”||Alphanumeric City Name (up to 191 characters)||N||Feed Filter, All Admin Exports||Feed Filtering**,|
|“Office State”||Alphanumeric State Code (up to 191 characters)||N||Feed Filter, All Admin Exports||Feed Filtering**, Customer Reporting, Auto set users’ initial locations|
|“Office Country”||Alphanumeric Country Name (up to 191 characters)||N||Feed Filter, All Admin Exports||Feed Filtering**,|
|Groups||Up to 5 custom values||N||Feed Filter, All Admin Exports||Feed Filtering**,|
|Country Code||ISO-2 or ISO-3 country code||N***||Auto set users’ initial locations, ***Cost of Living Adjustments|
*Employee ID is required to automatically update email address changes for existing employees and to reinstate formerly deleted/deactivated employees
**The efficacy of the feed filters is directly correlated to the quality and consistency of this data.
***Country Code is required for Rewards customers using cost of living adjustments.