Date printed: 07-12-2020   Last updated: 03-28-2007

To view our complete support knowledge base and most current version of this article visit

Applies to versions: 1.3, 1.4, 1.5, 1.6

Importing Employee, Department or Site Information

TimeIPS can import Employee, Department, and Site information and can also update records using the TimeIPS Import/Update Feature. The TimeIPS Employee Import and Export optional module is required.

Security Level Required: Employee Administrator or Payroll Administrator

Using the left pane Main Menu, click on: Administration » Employee Management » Import/Export

The Import/Export Page

  1. Click on the Browse button and navigate to the CSV file to be imported.
  2. If importing employee data, select No in the Import/Update Blank Employee Fields if you do NOT want to clear employee's data in TimeIPS if the data is blank in the import file.
    NOTE: TimeIPS will overwrite employee data with blank information ONLY if 1) the column exists in the CSV file with the correct column header, 2) the employee's data for the column is blank, and 3) Yes is selected in the "Import/Update Blank Employee Fields". This option does not apply to the Departments Import/Update.
  3. Select the data to be imported in the Import/Update field.
  4. Click on the Import/Update button.

The following file requirements must be met to import data into TimeIPS:

NOTE: By default, the import identifies employees by using the employee's last, first, and middle name. The names must match exactly during an update or a new employee will be created. To make changes to an employee's name, or in cases where multiple employees have the same name, you must specify a "key" other than name. On the import page, select the employee import with an alternate key, such as SSN. When using iapi, add a key=ssn or key=badge to the parameters list to use an alternate key.

NOTE: Some fields, such as Pay Rate and Security Levels, include audit records when adjusted. The Import/Update Feature may not add audit records indicating the field was adjusted.

See Also:
Exporting Employee, Department or Site Information (1.3, 1.4, 1.5, 1.6)
Adding New Employees Individually (1.3, 1.4)

©2004-2019 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
"Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.