Imports - Contacts Import Information

Field

Value

Type/Size

Required for create new

Required for Update

Update Allowed

First Name

Create New - First/last name combo can’t already exist

Update- Must find existing first/last name

  •  
  •  
  •  

Last Name

Create New - First/last name combo can’t already exist

Update- Must find existing first/last name

  •  
  •  
  •  

Prefix

  •  
  •  
  •  

Email

Create New- must be an employee number that doesn’t exist in the facility selecting

Update - must find existing employee number in that facility

int(10)

  •  
  •  
  •  

Phone Number

char(10)

  •  
  •  
  •  

Job Title

char(35)

  •  
  •  
  •  

Department

Must be an existing department

char(10)

  •  
  •  
  •  

Division

Y = Mechanic

D = Driver

M = Manager

A = Asst. Manager 

C = Clerical

I = Inactive

N = Other

char(1)

  •  
  •  
  •  

Language

decimal(4,2)

  •  
  •  
  •  

Search