Siemens SiPass Entro - Create an import file in Excel

Using the system
67
Building Technologies 052_SiPass_Entro_6_5_A24205-A335-B318_e_en
Fire Safety & Security Products 10.03.2010
24.8.6 Create an import file in Excel
1. Create one empty spreadsheet. E g Remove any Sheet 2, Sheet 3 etc.
2. Be sure that actual cells are in Text format before you enter any information
and store it in a file. (E g Excel can not manage leading zeroes in numerical
fields.)
3. The file should be of the format below for each person (row).
4. Choose Save as on the File menu.
5. In the File format list box, select the desired delimiter, e.g. semicolon.
6. Type a name for the file in the File name field and click OK.
Column Field Comments
A Name (e g Surname)
B Name (e g first name)
Text
1)
Note! Field A and B together maximum 32
characters.
C Free field Text (maximum 40 characters).
E g E-mail address.
D Card number Text value
3)
(00000000-99999999)
If Entro standard card parameters are used,
padding zeroes will be imported to get eight digits.
E PIN Text value
3)
(0001-9999)
F Valid Text
Alt 1 YY-MM-DD
Alt 2 YY-MM-DD - YY-MM-DD
G Group 1 Text
2)
(16 characters) – or empty
H Group 2 Text
2)
(16 characters) – or empty
I Group 3 Text
2)
(16 characters) – or empty
J Group 4 Text
2)
(16 characters) – or empty
K Group 5 Text
2)
(16 characters) – or empty
L Group 6 Text
2)
(16 characters) – or empty
M Priority person Not imported – Leave empty
N Counter Text value (00-99)
O Member group no Text value (0-999999)
P Card inactive Text Yes/No
Q Free field 2 Text (maximum 40 characters).
1) If name is imported from SiPass Entro Lite, the name truncated to the 32 first
characters
2) The name for a group must be identical regarding spelling and case. Otherwise
a new group without any permission at all will be imported. For other software than
Excel be sure that a delimiter character (e g semi-colon) is included for every
access group not used.