Import Profiles from CSV
You can make it easy for your Job Seekers to transition to your new platform by bringing their information over from your old system.
Building your CSV file
The CSV should be setup with the following columns:
| Column Name | Description | Type |
|---|---|---|
| Email Address | ||
| fname | First Name | Text |
| lname | Last Name | Text |
| location | Location | Text |
| phone | Phone | Text |
| label | Headline Title | Text |
| summary | Candidate Summary | Text |
| website | Job Seekers Personal Website | Text |
| Twitter Profile | Text | |
| LinkedIn Profile Address | Text | |
| hidden | Should the profile be hidden from searches? | True or False |
| confidential | Should the profile be confidential? | True or False |
| skills | A comma separated list of skills | Text |
| resume | A path to where the resume is stored. This must be an online source - for example http://jobboard.io/resume.pdf | Text |
| image | A path to where the candidates profile image is stored. This must be an online source - for example http://jobboard.io/resume.jpg | Text |
Click here to see an example CSV file with a selection of header fields
Importing to JobBoard.io
Once your file is ready, you'll be able to import in just a few clicks.
- Navigate to the Profiles section of your admin panel.
- Open the More dropdown, and select Import Job Profiles.
- Under Import Profiles, click the Choose File button. Locate and select your file from your computer's directory.
- If you're using this import to add or updated information on existing profiles, click the Update existing records? checkbox.
- Click Import Profiles.
That's it! You'll receive an e-mail confirmation when your import is completed.
Troubleshooting Imports
Field can't Be Blank
This error indicates that the importer was not able to detect a required field for one or more rows. The error in the e-mail will specify the field name. You'll want to check a few things to resolve this error.
- Be sure the listed column was included in your file. If you find it was missed, go ahead and add the information.
- Check the column header. Be sure you've matched our formatting and spelling as listed above. Avoid extra spaces, punctuation, etc.
- Be sure that the listed rows have this value populated. Add anything that's missing.
If everything in the file looks correct, there may be an issue with the way that the file was encoded. Please follow the UTF-8 steps below to resolve.
Invalid byte sequence in UTF-8
There are a variety of encoding processes that various applications will use when saving your CSV file. Unfortunately, not all of these will be compatible with our importer. The most consistent method we've found for generating a compatible CSV file is using Google Sheets. You will need a Gmail account to use sheets. If you don't already have one, be sure to Sign Up.
- Create a new Sheet.
- Copy the information from your existing CSV, and paste it into your Google Sheet. Alternatively, you can import the file via File -> Import.
- Check the file for accuracy to be sure the data transferred successfully.
- At the top of the page you'll see the text Untitled spreadsheet. Click this text, and set a name for the file. Be sure to set a name that will be easy to differentiate from your original file.
- Open the File menu.
- Choose Download -> Comma-separated values (.csv, current sheet).
That's all it takes! You can now go back and import the newly generated file into JobBoard.io.
Updated over 4 years ago