Understanding the CSV Used by Fond Roster Sync

You are here:
← All Topics

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 NameFormatRequiredWhere UsedHow Used
“Full Name”, “Fullname” or “Preferred Name”“First LastName” (e.g. “John Smith”)YRecognition Form, Social Feed,
User Profile Page, All Admin Exports
Customer Reporting
“Email”, “Emailaddress” or “primaryworkemail”Valid and unique email addressYLogin and/or SSO, Recognition Form, All Admin ExportsPrimary User ID, Customer Reporting
“Birthday”MM/DDNRoster ExportsTrigger Scheduled Birthday Recognitions
“Work Start Date”MM/DD/YYYYNRoster ExportsTrigger Scheduled Work Anniversary Recognition and/or Service Awards
“Job Title”Alphanumeric text (up to 191 characters)NAll Admin ExportsCustomer Reporting
“Employee ID”, “EmployeeID”, or “ID”Unique alphanumeric codeN*All Admin ExportsTo automatically update email address changes for existing employees and to reinstate formerly deleted/deactivated employees, Customer Reporting
“Department”Alphanumeric text (up to 191 characters)NFeed Filter, All Admin ExportsFeed Filtering**, Customer Reporting
“Supervisor Email”Valid email address of the employee’s direct manager/supervisorNFeed Filter, All Admin ExportsAssociate employees with their managers for Team Reporting and Feed Filtering,
Customer Reporting
“Office City”Alphanumeric City Name (up to 191 characters)NFeed Filter, All Admin ExportsFeed Filtering**,
Customer Reporting
“Office State”Alphanumeric State Code (up to 191 characters)NFeed Filter, All Admin ExportsFeed Filtering**, Customer Reporting, Auto set users’ initial locations
“Office Country”Alphanumeric Country Name (up to 191 characters)NFeed Filter, All Admin ExportsFeed Filtering**,
Customer Reporting
GroupsUp to 5 custom values NFeed Filter, All Admin ExportsFeed Filtering**,
Customer Reporting
Country CodeISO-2 or ISO-3 country codeN***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.