Import employees

We are thrilled to announce a newrelease. Data for employees can be easily imported into the Brainy HR system now.

Import supports the following operations:

Add/Update
Delete

The maximum size of the import file is 1MB.

Special characters can cause problems during data transfer.

When importing employees' data, new data is added to existing data entries in the database. All existing employee's data will be replaced with the imported new data. All existing data will be completely cleared and all references in the system will be lost.

1. Prepare the Data

On theleftsidebar, go toTools>Import Employees.

ClickDownload Sample File.

Open Download Sample File.

The sample file includes column headings with dummy data.

Check the structure of the sample file and use it to prepare your CSV import file, making sure that the column headings are the same.

first_name - your employee first name (required)

last_name - your employee last name (required)

email - employee's e-mail. Make sure to use real emails. It will be used to reset the password, sent an invite, etc. (required)

birth_day - 2000-10-03 format (required)

alternative_email - additional email (optional)

phone - office phone number (optional)

ext - external number (optional)

mobile_phone - mobile phone (optional)

gender - f/m (f=Female, m=Male) (required)

marital_status - single/married (required)

hire_day - 2000-10-03 format (required)

position - position - data option from your system settings (optional)

office - office - data option from your system settings (optional)

department - department - data option from your system settings (optional)

employment_status - employment status - data option from your system settings (optional)

manager - add an employee's direct manager's email (optional). Note: if you add an e-mail, this manager's account should already be in the system. Or skip it for now. You can update this field in the customer's account later.

send_invite - leave it empty if you don't want to send an invite to the Brainy HR system. Add 0 or 1 if you want to send the employee a welcome (registration) email to the (optional)

Make sure your file isn't more than 1M.

2. Choose Import Behavior

SetImport Behaviorto one of the following:

Add/Update (New employee data is added to the existing employee data for the existing entries in the database.)
Delete (Any entities in the import data that already exist in the database are deleted from the system. The email data is enough for deleting behavior)

Accept the value of a comma (,) for the Field separator. (The comma is the default separator in a CSV file)