Print

Previous Topic

Next Topic

CSV Fields

 

Note: Organization Administrators and User Administrators cannot be created using the CSV Import process.

The following fields (in no specific order) should be included in the CSV file prior to importing users into Cisco WebEx. Some fields are mandatory, you must enter information into them, and some are optional.

 

Note: If you do not want to enter information into a field, you can enter the character "-" and it is imported into the database as an empty field. You can only do this for optional fields. If you input "-" in a mandatory field, an error is reported on import. Do not use the value N/A.

 

Field Name

Description

employeeID

Mandatory (only SSO enabled). Enter the user's ID.

displayName

Optional. Enter the user's display name.

firstName

Mandatory. Enter the user's first name.

lastName

Mandatory. Enter the user's last name.

email

Mandatory. Enter the user's email address.

userName

Mandatory. Enter the user's username in the user@email.com format.

jobTitle

Optional. Enter the user's job title or designation.

address1

Optional. Enter the first line of the user's address. The Organization Administrator can configure this field so that it is mandatory for users.

address2

Optional. Enter the second line of the user's address. The Organization Administrator can configure this field so that it is mandatory for users.

city

Optional. Enter the city in which the user lives. The Organization Administrator can configure this field so that it is mandatory for users.

state

Optional. Enter the state in which the user lives. The Organization Administrator can configure this field so that it is mandatory for users.

zipCode

Optional. Enter the user's ZIP code. The Organization Administrator can configure this field so that it is mandatory for users.

ISOcountry

Optional. Enter the two letter country code, for example IN, US, CN, in which the user lives. For more information see http://www.iso.org/iso/country_codes/iso_3166_code_lists/country_names_and_code_elements.htm. The Organization Administrator can configure this field so that it is mandatory for users.

phoneBusinessISOCountry

Optional. Enter the country code, for example IN, US, CN, for the user's business phone number. The Organization Administrator can configure this field so that it is mandatory for users.

phoneBusinessNumber

Optional. Enter the user's business phone number. The Organization Administrator can configure this field so that it is mandatory for users.

phoneMobileISOCountry

Optional. Enter the country code, for example IN, US, CN, for the user's mobile phone number. The Organization Administrator can configure this field so that it is mandatory for users.

phoneMobileNumber

Optional. Enter the user's mobile phone number. The Organization Administrator can configure this field so that it is mandatory for users.

fax

Optional. Enter the user's fax number.

policyGroupName

Optional. Enter the default policy group to which the user belongs.

userProfilePhotoURL

Optional. Enter the URL where the user's profile picture can be accessed.

activeConnect

Optional. Indicate whether the user's status is active in Cisco WebEx. Enter Yes to indicate an active status and No to indicate an inactive status.

center

Optional. Used to assign (Yes) or remove (No) the center account for the Connect user. Only one center can be specified.

storageAllocated

Optional. Enter the storage allocated to the user in Megabytes.

Note: This must be a numerical value

CUCMClusterName

Optional. Enter the name of the Cisco Unified Communications Manager cluster that the user belongs to.

businessUnit

Optional. Enter the business unit or department of the user. The Organization Administrator can configure this field so that it is mandatory for users.

IMLoggingEnable

Optional. Indicate if IM logging is enabled for this user. Enter True to indicate an enabled status and False to indicate a disabled status.

endpointName

Optional. Enter the endpoint name configured for logging IMs.

autoUpgradeSiteName

Optional. Enter the upgrade site name.

 

 

Notes::

  • You can use tab, or comma-separated CSV files.
  • Ensure that your CSV file is encoded in either UTF-8 or UTF16-LE formats.
  • The following steps describe the procedure to select UTF-8 as the encoding format:
    • In Microsoft Excel. select File > Save As.
    • In the Save As dialog box, select Tools and Web Options.
    • In the Web Options dialog box, select the Encoding tab.
    • From the Save this document as list, select UTF-8.
    • Select OK to return to the Save As dialog box.
    • From the Save as type list, select CSV (Comma delimited) (*.csv).
    • In the File Name field, type a name for the CSV file and select Save.

      Open in Notepad++ and change the encoding to UTF-8 and try the import again.

 

Workaround to resolve a potential import issue

In some cases, you might encounter an error when importing users via a CSV file. This is caused when the Organization Administrator has set the Country field as mandatory. To work around this issue, follow one of these solutions.

Solution 1:

  1. Select the Configuration tab to open the Organization Information screen as the default view.
  2. Under System Settings, click User Provisioning to open the User Provisioning screen.
  3. Under Set Mandatory Fields for User Profile, clear the Country field.
  4. Run the CSV import process again.

Solution 2:

  1. Open the CSV file and locate the field titled ISOCountry.
  2. Enter the ISO Country Code for each user as appropriate. For the complete list of ISO Country Codes, see ISO Country Codes.
  3. Save the CSV file.
  4. Run the CSV import process again.

Solution 3:

  1. Open the CSV file and locate the field titled ISOCountry.
  2. Delete the ISOCountry field if your organization does not use it.
  3. Save the CSV file.
  4. Run the CSV import process again.
Top of Page   Print