Data Import Guide (Specification)

Using the Data Import facility, you can import data you already have into the system.

Elements in this guide marked with an ‘*’ require the entry of system generated codes before uploading. These are Locations, Departments and Job Titles and must be set up on the system prior to upload. If you are doing initial preparations on the sheet, just enter the actual names in the relevant fields. When you come to upload the sheet you will need to replace these with the relevant codes.

The Fields that can be uploaded are as below, with corresponding columns:

Field Column
User ID A
First name B
Middle Name C
Surname D
Email address (work) E
Start date F
DOB G
Address line 1 H
Address line 2 I
Address line 3 J
Address line 4 K
Postcode L
Line manager M
* Job title N
Employee number O
NI number P
Gender Q
Title R
Full time pay S
Date of pay deal T
* Location V
* Department W
Telephone 1 (Work) X
Extension No. Y
Telephone 2 (Home) Z
Mobile (Work) AA
Mobile (Private) AB

 

Please note that the mandatory fields are: First name, Surname, and Start date. You are not required to add information to the other fields if you prefer not to.

    • Cut and paste your data into the spreadsheet. You can leave columns empty, which is fine, but you cannot add or delete columns or change the headings.Please do not add any data to the column A (User ID)

  • * Enter the values for your employees job titles in column ‘N’.
  • Enter the following letter (M or F) for the gender (in column ‘Q’) of your employees:
Male M
Female F
  • Please enter the following values for the titles (in column ‘R’) of your employees:
Mr: 3
Mrs: 4
Ms: 5
Sir: 6
Madam: 7
Rev: 8
Dr: 9
Miss: 10
  • Please enter the following values for the marital status (in column S) of your employees:
Single: 0
Married: 1
Widowed: 2
Divorced: 3
Unknown: 4
  • Input the employees’ full time pay in column ‘T’. For part time workers please enter their full-time equivalent pay. Please enter the date of the pay deal in column ‘U’ (in the format dd/mm/yyyy).
  • * Please enter the values for your employees’ locations in column ‘V’
  • * Please enter the values for your employees’ departments in column ‘W’
  • Make sure all dates are in the format dd/mm/yyyy. You must use exactly this format, with slashes, and all ‘years’ must have four digits (so don’t put ’15/01/09′, it needs to say ’15/01/2009′)
  • Save the spreadsheet in ‘CSV’ format. To do this, when you save the document you need to select ‘save as’ and then use the ‘save as type’ pull-down selector to choose CSV. It might also say ‘comma delimited’
  • Having saved the spreadsheet on your computer, click on the ‘Browse’ button to select the spreadsheet and then click on ‘Upload employee file’ and follow the instructions.