V3.5 14/08/19
UD0089
Page 357
This Document is uncontrolled unless over stamped "CONTROLLED DOCUMENT"
3.13.10
IMPORT USERS FROM A SPREADSHEET
Import User Spreadsheet
This utility allows user data to be imported from an Excel Spreadsheet into the Traka32 database. The Excel
Spreadsheet must be in a pre-defined format. Blank spreadsheets are available from the root of the Traka32
installation, for example 'C:\Users\Public\Traka\Traka32\Import\Traka32 User Import.xls'.
1.
To enable this option, close any open windows within the software so you have a grey screen.
2.
Click on Tools followed by Import Users from Spreadsheet from the main menu.
3.
Select the path to the spreadsheet that you wish to import. To search for the spreadsheet file simply click on
the ... button.
4.
To preview the data before the data is imported, select the Preview the imported data before copying to
the live tables' checkbox.
5.
To automatically upload the data to the relevant Traka Systems, select the Synchronise the imported user
data with the cabinet(s) checkbox.
6.
Select the appropriate formatting for the Forenames and Surnames.
7.
When you are happy with your selections, simply click on Import Users.
Importing Users into Regions
It is possible to import users from a spreadsheet into specific regions in Traka32. Doing this is beneficial as it will save
time manually inputting users into regions.
1.
First you will need to create your desired regions within Traka32.
2.
Enter the appropriate information along with the desired region into the provided fields in the Traka32 User
Import excel spreadsheet.