Navigation:  Setting up TOOLMINDER > Import External Data >

Import Personnel

Previous pageReturn to chapter overviewNext page

The Worksheet name in the Excel spreadsheet must be called Personnel.

 

Mandatory

 

Column Name

Description

Example

YES

Employee No

Employee number to uniquely identify the person

001

 

Title

Title of the person

Mr

 

First Name

First name of the person

John

 

Last Name

Last name of the person

Smith

 

Job Title

Their official Job Title

Sales Manager

 

Department Level 1

Department structure supports 4 levels in the tree

Sales

 

Department Level 2

 

North West

 

Department Level 3

 

Greater Manchester

 

Department Level 4

 

 

 

HAV EAV

HAV monitoring points before their EAV is exceeded

100

 

HAV ELV

HAV monitoring points before their ELV  is exceeded

400

 

HAVmeter only allows up to 16 characters for Employee No.