Cisco Systems OL-5385-01 manual Tips for Creating a Text-Based CSV File, Example

Page 7

Chapter 4 Working with Users

Adding Users

Note For BAT inserts, you cannot use CSV files for users that are saved anywhere but C:\BATFiles\Users\Insert Users\ on the server that is running the publisher database for Cisco CallManager.

Tips for Creating a Text-Based CSV File

The following example format shows the field length and string types followed by an example of a CSV file for users.

First Name(Mandatory, 1 to 50 characters),Last Name(Mandatory, 1 to 50 characters),User ID(Mandatory, up to 30 characters),Password(Optional, up to

20characters),Manager(Optional, up to 30 characters),Department(Optional, up to 50 characters),PIN(Optional, up to 20 numerals),User Device Profile(Optional, up to 50 characters),User Locale(Optional, up to 50 characters),Controlled Device MAC Address1(optional, 12 characters),Directory Number (Optional, (Optional, up to 24 numerals and special characters)),Controlled Device MAC Address2(Optional, 12 characters)

Tip You must specify PIN and Password values, either on the CSV file or during file insertion in BAT. If you want to apply individual PINs or passwords for each user or groups of users, specify the PIN and password information in the CSV file. If you want to use a default PIN and password that all users can use, do not specify PIN or password values in the CSV and instead provide this information when you insert the CSV file in BAT.

Note You cannot enter values for MAC Address2 without entering values for MAC Address1.

Example

John,Smith,johns,abc123de,karend,0012055,9989,johns profile,English

United States,1231123245AB,1231123245AB,9725557154,0010EB001234

You must specify delimiters even if a field is blank. Refer to the following examples and sample CSV records when you are creating CSV files.

 

 

Bulk Administration Tool User Guide

 

 

 

 

 

 

OL-5385-01

 

 

4-7

 

 

 

Image 7
Contents Adding Users Working with UsersRelated Topics Creating the CSV File for UsersProcedure Creating a CSV File for Users Using BAT.xltWorking with Users Adding Users Creating a Text-Based CSV File for Users Procedure Example Tips for Creating a Text-Based CSV FileBefore You Begin Adding Users to Cisco CallManagerChoose Configure Users Working with Users Adding Users Click Insert Creating the CSV File for Updating Users Updating UsersCreating a CSV File for Updating Users Using BAT.xlt Userid,#,department,,,123456789012 Creating a Text-Based CSV File for Updating Users Tips for Creating a Text-Based CSV File Retaining Stored Values Updating Users to Cisco CallManager Working with Users Updating Users Deleting Users Deleting Users from Cisco CallManager Related Topics