Import Employees From CSV Dialog Box

Use the Import Employees From CSV dialog box to map the fields in your .CSV file to the corresponding fields in Deltek CRM and to run the process to import employee information from the .CSV file.

Location

To display the Import Employees From CSV dialog box, complete the following steps:
  1. In the Configuration workspace, click either or on the left edge of the Deltek CRM page to go to the Users area or Integrations and Imports area.
  2. If you are in the Users area, click Import From CSV. If you are in the Integrations & Imports area, click Import Employees From CSV.

Contents

The Import Employees From CSV dialog box first prompts you to select your .CSV file.

Field Description
BROWSE Click BROWSE, navigate to and select the .CSV file, and click Open.
Next Click Next to go to the next step in preparing for the import process.

After you select the .CSV file and click Next, the Import Employees From CSV dialog box displays a different set of controls so you can map the fields in the .CSV file to Deltek CRM fields and start the import process.

Field Description
Do not import duplicate records If you do not want the import process to import any information for an employee that already exists in Deltek CRM, select this option.
Update duplicate records If you want the import process to update fields in Deltek CRM for an employee that already exists, select this option. If a field in the existing employee record is blank or contains information that is different from information in the mapped field in the .CSV file, the field in the existing record is updated with the information from the .CSV file.
SOURCE FILE FIELD This column contains the field names from your .CSV file.

Deltek CRM assumes that the first row of the .CSV file is a header row and that the values in that row are the field names.

DELTEK CRM FIELD Use the fields in this column to select the Deltek CRM employee field that corresponds to each of the .CSV file fields that you want to import. If the .CSV file contains fields that you do not want to import, select Do not import for those fields. (The Do not import option is located at the end of the drop-down list.)

When this dialog box displays, it attempts to provide default field mappings based on the field names in your .CSV file and the field names in Deltek CRM. Review those default mappings and change any that are incorrect.

SAMPLE VALUE This column displays the value for each field from the first data row in your .CSV file.
Employees to be imported This field displays the number of employee records that your .CSV file contains.
Import To start the import process, click this button.
The import process does the following:
  • It adds records for employees that do not exist in Deltek CRM.
  • If you selected Update duplicate records, it updates mapped fields in Deltek CRM based on the information in the .CSV file for any employees that already exist in Deltek CRM.
Cancel To close the dialog box without running the import process, click this button. If you mapped fields, you will have to do the mapping again if you decide to run the import at a later time.