UCA Server WebConsole Graphical User Interface 9 - 25
Device User Import File Format
Use this option to load data in bulk instead of creating users and phone extensions one at a time via the UCA
server's Web Console. Bulk loading of phone extensions and CA50 users into the UCA database is enabled.
To create and import phone extensions, see
.
The CA50 user import feature uses a comma separated value (CSV) format that must include a header line as
follows:
locExtID,ExtUsrID,firstName,lastName,userName,PIN,RoleToken,userStatus,Selectable Group
List,Permanent Group List
Sample Import Line
A sample import line is as follows:
0002,2000, Joe,Smith,Joe Smith, 5555,Sales,A,"Lumber,Electrical,Bath",NewHire
Sample import line notes:
•
If the location ID string has leading zeros in the database, leading zeros must be included in the import file. If
the file is edited using Microsoft Excel, the field must be manually formatted to text within Excel.
•
Between items, a space is optional. (The sample above shows items with and without spaces.)
•
The Selectable and Permanent Group Lists must be enclosed in quotes since the groups in the lists are
comma separated.
•
The group token is used in the group lists.
•
The user status is typically 'A' (active). Other options are 'D' (disabled) and 'S' (suspended).
•
It is recommended to start with the sample import file found in the Development Toolkit folder.
NOTE
For information on how to import phone extensions into the UCA database, see
.
Summary of Contents for CA50
Page 1: ...CA50 UCA Client Server Developer User Guide ...
Page 2: ......
Page 3: ...CA50 UCA Client Server Developer User Guide 72E 93914 02 Revision A November 2009 ...
Page 18: ...xvi CA50 UCA Client Server Developer User Guide ...
Page 24: ...xxii CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 30: ...1 6 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 34: ...2 4 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 48: ...3 14 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 106: ...4 58 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 109: ...UCA Client Application on the CA50 5 3 Page intentionally blank ...
Page 110: ...5 4 CA50 UCA Client Server Developer User Guide ...
Page 135: ...UCA Server 6 25 Figure 6 30 Installing Prerequisites Figure 6 31 SQL Server Setup ...
Page 200: ...7 32 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 284: ...9 56 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 302: ...10 18 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 350: ...11 48 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 358: ...12 8 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 418: ...A 6 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 436: ...B 18 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 478: ...E 12 CA50 UCA Client Server Developer User Guide 6 7 8 9 10 11 ...
Page 488: ...F 4 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 492: ...G 4 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 510: ...I 14 CA50 UCA Client Server Developer User Guide Page intentionally blank ...
Page 538: ...Index 12 CA50 UCA Client Server Developer User Guide ...
Page 540: ......
Page 541: ......