|
<< Click to Display Table of Contents >> StaffSafe - Import StaffSafe Employees |
  
|
|
<< Click to Display Table of Contents >> StaffSafe - Import StaffSafe Employees |
|
Overview
Import employee details into AT&T GSMS from an external CSV file.
|
Click the 'StaffSafe' tab at the top of the interface to open the StaffSafe drop-down menu.
Click 'Import Employee' to open the 'Employee Import' screen and begin importing employee details.
|
Description
|
Before you can import employees, you must create a .csv file in Excel which contains all the required information.
There must be no more than one value per cell. Each row represents one employee; each column represents a field in a new employee record in AT&T GSMS.
Include all mandatory information, and any optional information.
Any of these values can be included as a column in your .csv file.
General Information
First Name
|
First, or given, name.
|
Last Name
|
Surname, or family name.
|
Phone
|
A mobile or landline phone number. This is a secondary or alternative number which is stored but not used by AT&T GSMS.
|
Fax
|
Optional fax machine number.
|
Mobile
|
Primary mobile number in international format.
|
Driver's License
|
Optional driver's license number.
|
Alias
|
A nickname or alternate name (e.g. if name is Edward Wood Jr, nickname might be 'Ed').
|
|
Primary email address.
|
Timezone
|
Select from the drop-down menu. Timezone should match the recipient's location.
|
Currency
|
Select the correct denomination. This is the currency the employee is paid in.
|
Number Plate
|
Optional vehicle license plate number
|
Mailing Address
Street/Suburb
|
The physical street address for correspondence (e.g. 100 Walker Street, North Sydney).
|
City
|
The city or town of residence (e.g. Sydney, New York, London)
|
Country
|
Country of residence (e.g. Australia, United States, Singapore)
|
Zip/Postal Code
|
Mailing zone number or code for the state (e.g. 2060, CA)
|
Description Information
Description |
A free-form field for any other useful information about the employee.
|
Employee Details
Employee Number
|
User's unique employee identification number
|
Title
|
Employee's job title.
|
Cost Center Label
|
Label used to identify an employee's cost center (if applicable).
|
Cost Center ID
|
Identifier for employee's related cost center (if applicable).
|
Once you have typed/pasted all the employee information you want to import, save the spreadsheet as a '.csv' file type.
Upload CSV File
|
Locate and select the saved .csv file on your local or network drive.
|
Navigate to find a file on your computer or network.
|
Source File Encoding
|
Default is 'US-ASCII', which supports all English characters. Select an alternative if you need to support international/foreign characters.
|
First Line is Header Line
|
Tick this box to ignore the first line of your .csv file when uploading (e.g. if first line contains column headings and not actual employee information).
|
Once all required fields are complete:
|
Begin importing data.
|
|
Discard all changes and exit.
|
Map Employee Details
Map the required information from your CSV file to the matching fields. Some fields contain drop-downs which cannot be mapped. Choose the required pre-existing option from these fields.
Once all required fields are complete:
|
Remove all existing data and replace with the imported file.
|
|
Keep the existing data and add only new data from the imported file.
|
