Import employee data with a CSV

Admins can upload profile information for people in their company quickly with CSV imports. You can use a CSV to update any Custom Field information in Pingboard, along with Teams and Locations.

Self Serve Imports (for Org Charts)

If you want to use CSV to import or make changes to your Org Chart, use the Self Serve Import option on the Sync & Import page. Org Chart Imports are 100% self-service and allow you to import new information or update existing data for:

  • First Names
  • Last Names
  • Email Addresses
  • Job Titles
  • Managers (Direct Reporting Relationships)

For all other information (like Birthdays and Start Dates), use our Full-Serve Import method.

Screen_Shot_2018-02-05_at_9.42.39_AM.png

  1. On the import screen, match each column from your CSV to a field in Pingboard
  2. If you need to overwrite relationships on your existing Org Chart with your new CSV, choose "Replace existing data" as your Import Preference

 

Full-Serve Imports (Standard & Pro Only)

If you want to update more than just your Org Chart, use the Full-serve import option on the Sync & Import page. Fill out the template provided, or use an Everything Report from our Reports page as a custom template, then submit it to our system for review.

These larger imports can take up to a business day to complete while they go through our systematic QA process to make sure there are no data or formatting errors before the import is completed.

By default, CSV imports only populate data to empty fields and will not overwrite existing data in Pingboard. To overwrite data with information in a CSV import, include the word "overwrite" in the column header for that field (for example, to overwrite Job Titles, your column header in the CSV should read "Job Title Overwrite").

Note Teams and Locations will automatically be created in Pingboard based on Teams and Locations listed in your CSV import, but keep in mind that Custom Fields will need to exist in Pingboard before they can be updated with a CSV. For instance, if you're trying to add data for your Employees' "Favorite Candy", you'll need to create that Custom Field in Pingboard before you can include data for a "Favorite Candy" field in a CSV import. 

Still need help? Let us know.

Was this article helpful?

0 out of 0 found this helpful