CSV File Format for Cisco Webex User Accounts

Before you import user account data in a CSV file, create a backup file of your existing user accounts by exporting the data. You only need to import data for the accounts that you're adding or updating.

  • All exports (report, user, contacts) are exported in Unicode tab-delimited text (UTF-16LE) format. All imports support CSV (for English data only) and Unicode tab-delimited text (for non-English data and mixed language data).

  • A CSV file must include column headings at the top of the file. When creating a CSV file using a spreadsheet program, such as Microsoft Excel, ensure that the column headings are in the first row of a spreadsheet. Column headings must appear exactly as specified in the Account-Information Fields section.

  • Some user account information is required, as specified in the Account-Information Fields section. Include all column headings for required fields.

  • We strongly recommend that you create a CSV file template. The template helps to ensure that your CSV file contains all required column headings, in their proper format.

  • The account-information fields in a CSV file aren't case-sensitive. Thus, you can type values in either uppercase or lowercase letters, or a combination of both. The values that appear in the user’s profile on your site appear as you enter them in the CSV file. To sign in to their accounts, users must type their default passwords exactly as you specify them in the CSV file.

  • See the Account-Information Fields section for information about how to format the user account information.

  • After you finish specifying the user account information, save the spreadsheet as a CSV file.

  • If you specify information for a user account incorrectly, Webex Site Administration can't create that account. Webex Site Administration generates a list of records for the accounts that it was unable to create, including the cause for each error. You can download a file containing these records to your computer, for reference or to correct the errors directly in that file.

Create a CSV File Template

When you export the CSV file, you get a baseline or template that you can use to add new users. Alternately, you can use the file to batch-edit multiple user accounts.

1

Sign in to Webex Site Administration and go to User Management > Import/Export Users.

2

On the Batch Import/Export Users page, select Export.

A message appears to confirm receipt of your request. You receive an email message when the export process is complete.

3

Click the link in the email message and open the exported file in a spreadsheet program, such as Microsoft Excel.

4

If you want to only add new user accounts, delete any account data that the exported file contains.

Deleting this data does not affect any existing accounts when you upload the CSV file to Webex Site Administration.

Open a CSV File in Microsoft Excel and Keep the Leading Zeros

1

Open a new, blank Excel workbook, and click the Data tab.

2

In the Get External Data category, select From text.

3

Browse to the location of the CSV file, select the file, and then click Import.

4

Under Original data type, select Delimited, and then click Next.

5

Under Delimiters, check Tab, and then click Next.

6

Under Column data format, choose Text.

7

Under Data Preview, select all of the columns.


 

Select the first column, hold Shift, and then click the last column.

8

Click Finish.

9

In the Import Data window, choose where to place the data, and then click OK.

Save a CSV File in Microsoft Excel and Keep the Leading Zeros

1

With the CSV file open in Excel, select the cell or range of cells that you want to format.

2

Select the Home tab.

3

In the Number group, click the Number Format (Format Cells: Number image) icon.

4

In the Format Cells window, select the Number tab, and select Custom from the category list.

5

In the Type box, enter the number format, such as 000-000-0000 for a phone number.

6

Click OK.

7

Select the File tab, choose Save As, select the location to save the CSV file, and in the Save As window, click Save.

Account-Information Fields

Field

Description

AccessAnywhere

(Optional) Applies only to accounts for which you have specified PRO in the My Webex field. Specifies whether the user can set up and access remote computers, using Access Anywhere. This field can contain one of the following values:

  • Y: Specifies that My Computers is available in the user's My Webex area, allowing the user to set up remote computers on your site.

  • N: Specifies that My Computers is available in the user's My Webex area, preventing the user from setting up remote computers on your site.

    If the field is left empty, it defaults to Y.

Active

(Required) Specifies whether a user account is active or inactive. For a user to host Webex meetings, training sessions, support sessions, or events, their account must be active. This field can contain one of the following values:

  • Y: The user account is active.

  • N: The user account in inactive.

    If the field is left empty, the default value is Y.

AdditionalComputers

(Optional) Applies only to accounts for which you have specified PRO in the My Webex field and Y for the AccessAnywhere field. Specifies the number of extra computers that you want to allow the user to set up for Access Anywhere on your site. Type only numbers in this field. If you do not want to allocate more computers to a user account, you can leave this field blank.


 
  • Your meeting service contract determines the total number of extra computers. To determine the number of remaining computers available for allocating to user accounts, see the Add User or Edit User page in Webex Site Administration.

If you exceed the total number of extra computers for your site, Webex Site Administration may not be able to create or update all accounts for which you allocated extra computers. This depends on your site configuration.

If the field is left empty, it defaults to 0.

AdditionalRecordingStorage

(Optional) Specifies the number of megabytes (MB) of extra storage space to allocate to the user for storing network-based recording files. Type only numbers in this field. If you do not want to allocate extra storage space to a user account, you can leave this field blank.

If you leave this field empty, the default value is 0.

AdditionalStorage

(Optional) Applies only to accounts for which you have specified PRO in the My Webex field and Y for the MyFolders field. Specifies the number of megabytes (MB) of extra storage space that you want to allocate to the user for storing files on your site. Type only numbers in this field. If you do not want to allocate extra storage space to a user account, you can leave this field blank.


 
  • Your meeting service contract determines the total amount of extra storage space. To determine the amount of remaining storage space available for allocating to user accounts, see the Add User or Edit User page in Webex Site Administration.

  • If you exceed the total amount of extra storage space for your site, Webex Site Administration may not be able to create or update all accounts for which you allocated extra storage. This depends on your site configuration.

    If the field is left empty, it defaults to 0.

Address1

(Optional) Specifies the user's mailing address.

If the field is left empty, the value is left blank.

Address2

(Optional) Specifies additional information about the user's mailing address, if necessary.

If the field is left empty, the value is left blank.

AP1Callback, AP2Callback

(Optional) Specifies the user's pager number at which the user wants to be called.

If the field is left empty, it defaults to N.

AP1Callin, AP2Callin

(Optional) Specifies the pager number the user must use to call in.

If the field is left empty, it defaults to N.

AP1Cntry, AP2Cntry

(Optional) Specifies the number that you dial to call a pager user who resides in another country. Enter numbers and underscores (_) only; do not include punctuation, such as dashes or periods.

If the field is left empty, it defaults to 1.

AP1Local, AP2Local

(Optional) Specifies the user's pager number. This field must contain only numbers. Do not include punctuation, such as dashes or periods.

If the field is left empty, the value is left blank.

CellCallback

(Optional) Specifies the extension of the user's mobile phone number. This field must contain only numbers.

If the field is left empty, it defaults to N.

CellCallin

(Optional) Specifies the user’s mobile phone number at which the user wants to be called.

If the field is left empty, it defaults to N.

CellCntry

(Optional) Specifies the number that you dial to call a mobile phone user who resides in another country. Enter numbers and underscores (_) only; do not include punctuation, such as dashes or periods.

If the field is left empty, it defaults to 1.

CellLocal

(Optional) Specifies the user's mobile phone number the user must use to call in.

If the field is left empty, the value is left blank.

City

(Optional) Specifies the city in which the user resides.

If the field is left empty, the value is left blank.

Country/Region

(Optional) Specifies the country or region in which the user resides.

If the field is left empty, the value is left blank.

Custom1-10

(Optional) If Tracking Codes are enabled on your site, fields can be renamed as desired to track information. By default, the first four fields are named Group, Department, Project, and Other. The first tracking code is used for billing and invoicing.

If the field is left empty, the value is left blank.

DefaultTPSessionType

(Optional) Specifies the default TelePresence session type, as set in the user Preferences page.

If the field is left empty, the value is the session type which supports TelePresence with the minimum meeting type ID.

DefaultVideoDeviceIndex

(Optional) Specifies the index number (from 1 to 5) of the user's default video device.

If you leave this field empty, the value is left blank.

EditorPrivilege

No longer supported. Leave this field empty, and ignore it in the export file.

Email

(Required) Specifies the user's email address. A user's email address must be unique.

If the field is left empty, it prompts for an email address.

EnableLiveStreaming

Toggles the Live Streaming feature.

  • 0: Disable Live Streaming (Default setting)

  • 1: Enable Live Streaming

EventDocument

(Optional) For Enterprise Edition sites with Cisco Webex Events. Specifies whether the user can store recorded events on your site. This field can contain one of the following values:

  • Y: Specifies that the Recorded Events page appears in the user's My Webex area, allowing the user to store recorded events on your site.

  • N: Specifies that the Recorded Events page does not appear in the user's My Webex area, preventing the user from storing recorded events on your site.

    If the field is left empty, it defaults to Y.

FirstName

(Required) Specifies the first name of the user to whom this account belongs.

If the field is left empty, it prompts for a first name.

ForceChangePassword

(Optional) Specifies that the user must change their password the next time that they sign in. The default value for this field, in the exported CSV file is N, regardless of the value stored in the database. If the value in the database is Y and you set the value to Y in the CSV file, Webex Site Administration generates another change password email for the user. This occurs even if they have already changed their password. To prevent redundant emails being sent to users, specify the Y value for this field only if one of the following is true:

  • You want to force a user to change their password.

  • You are adding a new user.


 

This field is not applicable for CI-integrated sites, or for sites that use SSO. For these sites, leave the field blank, or enter N.

GeneralPriv

(Optional) Specifies the general privileges that the user has on your Cisco Webex site. This field can contain the following value:

BADM: Specifies that the user is a billing administrator. The user can access the billing reports from their My Webex page. Applicable only to Cisco Webex sites that have the Billing Administrator option.

If the field is left empty, the value is left blank.

HostPrivilege

(Optional) Specifies the type of account that the user has. This field can contain the following account types:

  • HOST: Specifies that the user has a host account. The user can sign in to the Webex site to host meetings.

  • ADMN: Specifies that the user has a site administrator account. The user can sign in to the Webex site to host meetings and can also sign into Webex Site Administration.


     

    Important A site administrator can manage user accounts, handle registration requests, and specify preferences for your Webex site and services. Therefore, Cisco recommends that your organization have only one or two site administrator accounts.

  • ADMV: Specifies that the user has a view-only site administrator account. The user can sign in to the Webex site to host meetings. They can also use Webex Site Administration to view user account information, registration requests, Webex site configuration and preferences, and meeting usage reports. However, a site administrator with view-only privileges cannot change user account information or Webex site settings.

  • ATTND: Specifies that the user has an attendee account. The user can sign in to your Webex site. They can view a list of meetings to which they are invited and attend meetings that require an account on your site. They can also maintain a user profile. However, they cannot host meetings on your site.

    Note: The following information in the CSV file applies to attendee accounts. If you provide any other information in the CSV file, Webex Site Administration ignores it.

  • Whether the user account is active or inactive

  • First name

  • Last name

  • Password

  • Email address

    If the field is left empty, it defaults to HOST.

LabAdmin

(Optional) Applies only to Webex Training. Specifies Webex Training privilege as an administrator for Hands-on Lab.

If the field is left empty, it defaults to N.

Language

(Optional) Specifies the language that is selected by default on the user's Preferences page. This option determines the language in which text appears to the user on your meeting service website. Depending on which languages your site supports, this field contains one of the following short name values. In the following list, the short name appears next to the corresponding language.

If the field is left empty, it defaults to the default language for the site.

Language - ID

English: en-us

Simplified Chinese: zh-cn

Traditional Chinese: zh-tw

Japanese: jp

Korean: ko

French: fr

German: de

Italian: it

Castilian Spanish: es-me

Latin American Spanish: es-sp

Swedish: sw

Dutch: nl

Portuguese: pt-br

Russian: ru

LastName

(Required) Specifies the last name of the user to whom this account belongs.

If the field is left empty, it prompts for a last name.

DisplayName

(Optional) Displays the user's preferred name in the Meeting Participants List.

If the field is left empty, FirstName + LastName will display in the Meeting Participants List.

MeetingAssist

(Optional) Specifies whether Meeting Assist services are available for your users.

If the field is left empty, the value is 0.

MeetingPrivilege

(Optional) Specifies which types of meetings the user can host. This field can contain one or more codes, with up three digits, that indicate the meeting types a user can host.

Note

  • To obtain a valid code for this field, see the index values under Index for the session types that appear on your Webex Site Administration home page. However, if your site includes the Access Anywhere meeting type, do not type its code in this field.

  • If any codes contain leading zeros, you need not type them. For example, if your meeting type code is 004, type only the digit 4 in this field.

  • You can specify multiple meeting types for any user account, if your organization has the appropriate licenses. To specify multiple service types, separate them with commas, but without spaces—For example:

    15,120

  • If you have any questions about the meeting types that your organization has purchased, please contact your Webex account manager.

    If the field is left empty, the value is left blank.

MyContacts

(Optional) If your site includes the My Webex option, specifies whether the user can access and maintain an address book from the user’s My Webex area on your site. The address book contains your company address book (if you maintain one) and allows the user to maintain a contacts list. This field can contain one of the following values:

  • Y: Specifies that My Contactsis available in the user's My Webex area, allowing the user to access and maintain a personal address book.

  • N: Specifies that My Contacts is not available in the user's My Webex area. However, the user can still access their personal address book, using the options on the Schedule a Meeting page.

    If the field is left empty, it defaults to Y.

MyFolders

(Optional) If your site includes the My Webex option, specifies whether the user can store files in personal folders on your site. This field can contain one of the following values:

  • Y: Specifies that the My Folders button appears in the user's My Webex area, allowing the user to store files on your site.

  • N: Specifies that the My Folders button does not appear in the user's My Webex area, preventing the user from storing files on your site.

    If the field is left empty, it defaults to Y.

MyMeetings

(Optional) If your site includes the My Webex option, specifies whether the user can use their My Webex area on your site to access and maintain a list of meetings that they scheduled. This field can contain one of the following values:

  • Y: Specifies that My Meetings is available in the user's My Webex area, allowing the user to access and maintain a list of scheduled meetings.

  • N: Specifies that My Meetings is not available in the user's My Webex area. However, the user can still access and maintain a list of scheduled meetings, by selecting the My Meetings link on the navigation bar.

    If the field is left empty, it defaults to Y.

MyPMR


 

This option is no longer available. Use SupportPR to determine Personal Room settings for your users.

MyProfile

(Optional) If your site includes the My Webex option, specifies whether the user can access their user profile from their My Webex area on your site. This field can contain one of the following values:

  • Y: Specifies that My Profile is available in the user’s My Webex area, allowing the user to access and maintain their user profile.

  • N: Specifies that My Profile is not available in the user’s My Webex area. However, the user can still access their profile, by selecting the My Profile link on the navigation bar.

    If the field is left empty, it defaults to Y.

MyRecordings

(Optional) Applies only to accounts on a Cisco Webex Training site and for which you have specified PRO in the My Webex field. Specifies whether the user can publish recorded training sessions on your site. This field can contain one of the following values:

  • Y: Specifies that My Recordings or My Training Recordings (for Enterprise Edition) is available in the user’s My Webex area. If so, the user can publish recordings on your site.

  • N: Specifies that My Recordings or My Training Recordings (for Enterprise Edition) is not available in the user’s My Webex area. If so, the user cannot publish recordings on your site.

    If the field is left empty, it defaults to Y.

MyReports

(Optional) Applies only to accounts on a Cisco Webex Training site and for which you have specified PRO in the My Webex field. Specifies whether the user can generate reports containing information about training sessions that the user hosted and computers that the user accessed remotely using Access Anywhere. This field can contain one of the following values:

  • Y: Specifies that My Reports is available in the user's My Webex area, allowing the user to generate reports on your site.

  • N: Specifies that My Reports is not available in the user's My Webex area, preventing the user from generating reports on your site.

    If the field is left empty, it defaults to Y.

MyWebex

(Optional) If your site includes the My Webex option, specify the type of My Webex privilege assigned to the account. This field can contain one of the following values:

  • STD: Specifies that the user account receives the My Webex Standard privilege.

  • PRO: Specifies that the user account receives the My Webex Pro privilege.

  • N: If your site does not include the My Webex option, specify this value for each user account.


 
  • The number of accounts for which you can specify the PRO value depends on the number of My Webex Pro licenses available for your site. To determine the number of My Webex Pro licenses available for assigning to user accounts, see the Add User or Edit User page in Site Administration.

  • If, you exceed the number of licenses for your site, Webex Site Administration cannot create or update all accounts for which PRO is specified. For example, if your site has 10 My Webex Pro licenses, and you specify PRO for 20 accounts, Webex Site Administration imports account information only for the first 10 accounts for which you specified PRO.

  • If your site includes the My Webex option, ensure that you specify either STD or PRO for each account.

    If the field is left empty, it defaults to PRO.

MyWorkspaces

(Optional) Specifies the use of My Workspace in My Webex.

If the field is left empty, it defaults to Y.

OneClickSetup

(Optional) Specifies if the user can use One-Click.

If the field is left empty, it defaults to N.

Password

(Required) Specifies the password for the account. Passwords:

  • Must contain at least four characters

  • Can consist of a maximum of 32 characters

  • Are case-sensitive—Users must type their passwords exactly as you specify them in this field

  • Can be "****", which indicates to the Site Administrator not to change the password for an existing account.

  • Create a new, random password for a new account. In this case, if you are using the option "Require Strict Password...", then the new password does not meet the password criteria, and the user is required to change the password the first time the user logs in.


     

    If, on the Site Settings for Common page, you selected the Require strict password for new user accounts option, specify a default password for each account that complies with the strict password criteria you specified.

    Imported passwords in a CSV file can be changed, if proper password criteria is set in Site Security options.

    If the field is left empty, a temporary password is generated automatically.

PCNAcc1AutoGeneratePCNAcc3AutoGenerate

(Optional) Specifies whether you automatically generate an access code.

This field can contain one of the following values:

  • Y: Specifies that the access code is automatically generated.

  • N: Specifies that the access code is not automatically generated.

    If the field is left empty, it defaults to Available. If PCN is not enabled, the value is left blank.

PCNAcc1ILNumPCNAcc3ILNum

(Optional) Specifies that PCN account supports international call-in.

If the field is left empty, it defaults to Available. If PCN is not enabled, the value is left blank.

PCNAcc1TollCallinNumPCNAcc3TollCallinNum

(Optional) Specifies the backup toll call number.

If the field is left empty, it defaults to Available. If PCN is not enabled, the value is left blank.

PCNAcc1TollFreeCallinNumPCNAcc3TollFreeCallinNum

(Optional) Specifies the toll-free call in number.

If the field is left empty, it defaults to Available. If PCN is not enabled, the value is left blank.

PhoneCallback

(Optional) Specifies the number at which the user wants to be called.

If the field is left empty, it defaults to N.

PhoneCallin

(Optional) Specifies the number the user must use to call in.

If the field is left empty, it defaults to N.

PhoneCntry

(Optional) Specifies the number that you dial to call a user who resides in another country. Enter numbers and underscores (_) only; do not include punctuation, such as dashes or periods.

If the field is left empty, it defaults to 1.

PhoneLocal

(Optional) Specifies the user's phone number. This field must contain only numbers. Do not include punctuation, such as dashes or periods.

If the field is left empty, the value is left blank.

Pin

(Optional) Specifies the user’s PCN audio personal identification number.

If the field is left empty, the value is left blank.

ResetPassword

(Optional) Resets the user's password and automatically selects the ForceChangePassword options. You can use this option if you suspect a problem with a user's password. Webex generates a temporary password for the user and prompts the user to change the password the first time they sign in.


 

This field is not applicable for CI-integrated sites, or for sites that use SSO. For these sites, leave the field blank, or enter N.

SaCPrivilege

No longer supported. Leave this field empty, and ignore it in the export file.

SaCProducts

No longer supported. Leave this field empty, and ignore it in the export file.

SaCSJMEDesc

No longer supported. Leave this field empty, and ignore it in the export file.

SaCSIsMgr

No longer supported. Leave this field empty, and ignore it in the export file.

SchedulePermission

(Optional) Applies only to Webex Meetings, Webex Training, and Webex Events sites. Specifies the users who can schedule sessions on behalf of this user. You can specify only those users who have accounts on the same Cisco Webex site as this user. To specify a user, type the user's email address exactly as it appears for the user's account.

You can specify multiple email address, by separating them with commas and without spaces—For example: jsmith@anyco.com,mbartel@anyco.com

If the field is left empty, the value is left blank.

SCOptions

(Optional) Available for Cisco Webex Support sites only. Specifies which Webex Support options users can use. You can specify the following value in this field:

AREC: Auto record. Specifies that Webex Support automatically records support sessions that the user conducts.

If the field is left empty, the value is left blank.

SCSaveLoc

(Optional) Available for Cisco Webex Support sites only. Applies only if you specified the Auto Record (AREC) for SCOptions for the user. For a Webex Support session, specifies the location at which Webex Recorder saves recording files. By default, Webex Recorder saves all recording files at the following location on the support representative's computer:

C:\My Recorded_Sessions

However, you can specify any location on either a support representative's computer or another computer on your network-for example:

C:\Session Recordings.

If the default location or a location that you specify does not exist, Webex Support creates the necessary folders.


 

If you specify a location on a computer on your network, ensure that

  • The support representative's computer is mapped to the appropriate network drive.

  • The support representative's network account has access to the location.

    If the field is left empty, the value is left blank.

SCShareColor

(Optional) Available for Cisco Webex Support sites only. For a Webex Support session, specifies the color setting for a shared application or desktop that appears on a support representative's or customer's screen by default. You can specify the following values for this field:

  • 256: 256 colors. Specifies that a shared application or desktop appears in 256 colors in the viewer or the support representative's or customer's screen. This option requires less bandwidth for sharing applications or desktops than does the High color (16B) option but provides lower imaging quality.

  • 16B: High color (16 bit). Specifies that a shared application or desktop appears in 16-bit color in the viewer or the support representative's or customer's screen. This option requires more bandwidth than the 256 color option, but provides better imaging quality.

    If the field is left empty, it defaults to 16B.

SCShareView

(Optional) Available for Cisco Webex Support sites only. For a Webex Support session, specifies how a shared application or desktop appears on a representative’s and a customer’s screen by default. You can specify the following values for this field:

  • FSSF: Full screen, scale to fit. Specifies that a shared application or desktop appears in a full-screen view on a support representative’s or customer’s screen. The size of the application or desktop adjusts to fit the full-screen view in its entirety.

  • FS: Full screen. Specifies that a shared application or desktop appears in a full-screen view on a support representative’s or customer’s screen. However, the size of the application or desktop does not adjust to fit the full-screen view in its entirety.

  • WSF: Window, scale to fit. Specifies that a shared application or desktop appears in a window a support representative’s or customer’s screen. The size of the application or desktop adjusts to fit the window in its entirety.

  • WIN: Window. Specifies that a shared application or desktop appears in a window a support representative’s or customer’s screen. However, the size of the application or desktop does not adjust to fit the window in its entirety.

    If the field is left empty, it defaults to FS.

SendWelcomeEmail

(Optional) Specifies whether your site automatically sends a Welcome email message to the user once you create the account.

If your site has the email templates option, you can edit the template for the Welcome email message that your Webex site sends to users.

This field can contain one of the following values:

  • Y: Specifies that the user receives the Welcome email message.

  • N: Specifies that the user does not receive the Welcome email message.


     

    This option is turned off by default for most Cisco Webex sites. If the option is off, specifying a value in this field has no effect. To turn on this option, contact your Webex account manager.

    If the field is left empty, it defaults to Y.

STAllComputers

(Optional) Available for Cisco Webex Support sites with the Remote Access option only. Applies only if you specified the Auto Record (AREC) for STOptions for the user. Specifies all computers for Remote Access. The computers must already be defined for Remote Access in Webex Site Administration. Type the computer names exactly as they appear in Webex Site Administration.

State/Province

(Optional) Specifies the state or province in which the user resides.

If the field is left empty, the value is left blank.

STComputers

(Optional) Available for Cisco Webex Support sites with the Remote Access option only. Applies only if you specified the Auto Record (AREC) for STOptions for the user. Specifies which computers the user can access remotely, using Remote Access. The computers must already be defined for Remote Access in Webex Site Administration. Type the computer names exactly as they appear in Webex Site Administration.

Note You can specify multiple computers for a user account. To specify multiple computers, separate them with commas, and no spaces-for example:

Computer 1, Computer 2

If the field is left empty, the value is left blank.

STLocations

(Optional) Available for Cisco Webex Support sites with the Remote Access option only. Applies only if you specified the Auto Record (AREC) for STOptions for the user. Specifies the location at which Webex Recorder saves recording files. By default, Webex Recorder saves all recording files at the following location on the support representative's computer:

C:\My Recorded Sessions

However, you can specify any location on either a support representative’s computer or another computer on your network—For example,

C:\RemoteAccess_Recordings.

If the default location or a location that you specify does not exist, Remote Access creates the necessary folders.


 

If you specify a location on a computer on your network, ensure that:

  • The support representative's computer is mapped to the appropriate network drive.

  • The support representative's network account has access to the location.

    If the field is left empty, the value is left blank.

STOptions

(Optional) Available for Cisco Webex Support sites with the Remote Access option only. Applies only if you specified the Auto Record (AREC) for STOptions for the user. Specifies which Remote Access options that user can use. You can specify the following value in this field:

AREC: Auto record. Specifies that Remote Access automatically records remote support sessions that the user conducts.

If the field is left empty, the value is left blank.

STShareColor

(Optional) Available for Cisco Webex Support sites only. Applies only if you specified the Auto Record (AREC) for STOptions for the user. For a Remote Support session, specifies the color setting for a shared application or desktop that appears on a support representative's or customer's screen by default. You can specify the following values for this field:

  • 256: 256 colors. Specifies that a shared application or desktop appears in 256 colors in the viewer or the support representative's or customer's screen. This option requires less bandwidth for sharing applications or desktops than does the High color (16B) option but provides lower imaging quality.

  • 16B: High color (16 bit). Specifies that a shared application or desktop appears in 16-bit color in the viewer or the support representative's or customer's screen. This option requires more bandwidth than the 256 color option, but provides better imaging quality.

    If the field is left empty, it defaults to 16B.

STShareView

(Optional) Available for Cisco Webex Support sites only. Applies only if you specified the Auto Record (AREC) for STOptions for the user. For a Webex Support session, specifies how a shared application or desktop appears on a representative's and customer's screen by default. You can specify the following values for this field:

  • FSSF: Full screen, scale to fit. Specifies that a shared application or desktop appears in a full-screen view on a support representative’s or customer’s screen. The size of the application or desktop adjusts to fit the full-screen view in its entirety.

  • FS: Full screen. Specifies that a shared application or desktop appears in a full-screen view on a support representative’s or customer’s screen. The size of the application or desktop does not adjust to fit the full-screen view in its entirety.

  • WSF: Window, scale to fit. Specifies that a shared application or desktop appears in a window a support representative’s or customer’s screen. The size of the application or desktop adjusts to fit the window in its entirety.

  • WIN: Window. Specifies that a shared application or desktop appears in a window a support representative’s or customer’s screen. However, the size of the application or desktop does not adjust to fit the window in its entirety.

    If the field is left empty, it defaults to FS.

SupportCascading

(Optional) Specifies whether download bandwidth optimization is enabled for your Webex Events users. Bandwidth optimization allows relaying traffic to other clients on the same subnet.

If the field is left empty, it defaults to N.

SupportCET

No longer supported. Leave this field empty and ignore it in the export file.

SupportCMR

(Optional) Specifies whether video device-enabled meetings are available for your users. This option is available for Webex Meetings and Webex Events (panelists only).

  • 1: Specifies that video device-enabled meetings are available for the user.

  • 0: Specifies that video device-enabled meetings are not available for the user.

If the field is left empty, the value defaults to 0.

SupportHQV

(Optional) Specifies whether high-quality video is available for your users (Webex Meetings, Webex Events, and Webex Training only).

If the field is left empty, it defaults to Y.

SupportHDV

(Optional) Specifies whether high-definition video is available for your users (Webex Meetings and Webex Trainings only).

If the field is left empty, it defaults to Y.

SupportPR

(Optional) Specifies whether Personal Room is available for your users (Webex Meetings only).

  • 1: Specifies that the user receives a Personal Room.

  • 0: Specifies that the user does not receive a Personal Room.

If the field is left empty, the value defaults to 0.

TCPrivilege

(Optional) Available for Cisco Webex Training sites only. Specifies which privileges the user has for Webex Training. This field can contain the following value:

HOLA: Specifies that the user can use the Hands-on Lab option for training sessions.

If the field is left empty, the value is left blank.

TeleAcct1–TeleAcct3

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields are populated with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If the field is left empty, all information is retained.

TeleAcct1RecordingDialOutNumFlagTeleAcct3RecordingDialOutNumFlag

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

  • 1: Specifies there's a toll.

  • 0: Specifies there's no toll.

TeleAcct1-SubACTeleAcct3-SubAC

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1Toll-AreaTeleAcct3Toll-Area

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1Toll-CntryTeleAcct3Toll-Cntry

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1TollFree-AreaTeleAcct3TollFree-Area

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1TollFree-CntryTeleAcct3TollFree-Cntry

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1TollFree-IsTollFreeTeleAcct3TollFree-IsTollFree

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1TollFree-NumTeleAcct3TollFree-Num

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1Toll-IsTollFreeTeleAcct3Toll-IsTollFree

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleconLocation

(Optional) Reserved for Cisco Webex teleconferencing service provider partners.

If the field is left empty, the value is left blank.

TelephonyPrivilege

(Optional) Specifies the types of teleconferencing services that the user can use when hosting a session. This field can contain one or more of the following values for an account, depending on the teleconferencing services supported by your Webex site:

  • CLIN: Call-in teleconferencing. Specifies that the user can host sessions in which attendees can call a phone number to join a teleconference.

  • TOLL: Toll-free call-in teleconferencing. Specifies that the user can host sessions in which attendees call a toll-free phone number to join a teleconference.

  • CLBK: Call-back teleconferencing. Specifies that the user can host sessions in which attendees receive a phone call from the Webex site to join a teleconference. Each attendee first calls a phone number, and then hangs up. The service then calls the attendee's phone number.

  • INTL: International call-back teleconferencing. Specifies that the user can host meetings or training sessions in which attendees receive an international phone call from the Webex site to join a teleconference.

  • VoIP: internet phone. Specifies that the user can host sessions that include an internet phone (Voice over IP) conference.

  • ILCI: International call-in numbers. Specifies that the user can host sessions for which attendees in other countries can call a local phone number to join a teleconference.

  • SELT: Teleconferencing location. Specifies that the user can select the location of the telephony bridge to use for a teleconference. Available only if your Webex site is provisioned with multiple bridge locations.

To determine which teleconferencing services your organization supports, see the Webex Site Administration home page.

To disable all telephony privileges for a user, enter a comma ("," without the quotes). You cannot remove telephony privileges for users with Personal Room enabled.


 

You can specify multiple teleconferencing types for any user account, if your organization has purchased the appropriate options. To specify multiple teleconferencing types, separate them with commas, without spaces—For example:

CLIN, CLBK, VoIP

TimeZone

(Optional) Specifies the index number for the time zone in which the user resides. If you do not specify a time zone for the user, Site Administration uses the time zone specified for your meeting service website. For a list of time zones and their index numbers, see Time Zones.

If the field is left empty, it defaults to the default time zone for your site.

UserID

Read-only

Indicates an identification number that Webex Meetings database for Site Administration automatically generates for the account.

Username

(Required) Specifies the identifier that the user to whom this account belongs uses to sign in to Webex services. Usernames:

  • Must be unique

  • Can consist of a maximum of 64 characters


     

    Cisco Webex recommends that you do not create usernames that include spaces or punctuation marks, except underscores, hyphens, and periods.

    If the field is left empty, it prompts for a username.

VideoDeviceAddress1-5

(Optional) Specifies the address of the video device, at which the user wants to be called.

If you leave this field empty, the value is left blank.

VideoDeviceName1-5

(Optional) Specifies the name of the video device, at which the user wants to be called.

If you leave this field empty, the value is left blank.

WebcastAdmin

(Optional) Specifies whether the current user is a Webcast Administrator or Presenter. If checked, the user is an Administrator.

If the check box is left empty, the value is left blank.

WebcastBasic

(Optional) Allows Cisco Webex Events users to broadcast online presentations and audio.

If the field is left empty, the value is left blank.

WebcastVideo

(Optional) Allows Cisco Webex Events users to stream video.

If the field is left empty, the value is left blank.

Zip/Postal

(Optional) Specifies the ZIP or postal code for the user's mailing address.

If the field is left empty, the value is left blank.

CSV File Format for Contacts

Before you import contact data in a CSV file, create a backup file of your contacts data, if any, by exporting the data.

  • All exports (report, user, contacts) are exported in Unicode tab-delimited text (UTF-16LE) format. All imports support CSV (for English data only) and Unicode tab-delimited text (for non-English data and mixed language data.)

  • A CSV file must include column headings at the top of the file. When creating a CSV file using a spreadsheet program, such as Microsoft Excel, ensure that the column headings are in the first row of a spreadsheet. Column headings must appear exactly as specified under Contact-Information Fields.

  • Some contact information is required, as specified under Contact-Information Fields. You must include all column headings for required fields. You need not include column headings for optional fields, for which you do not provide contact information.

  • To ensure that your CSV file contains all required column headings, in their proper format, Webex strongly recommends that you create a CSV file template.

  • The contact-information fields in a CSV file are not case-sensitive. Thus, you can type values in either uppercase or lowercase letters, or a combination of both. The values that appear in the contact's information on your site-such as the contact's name-will appear as you type them in the CSV file.

  • See Contact-Information Fields, for the correct format for contact information.

  • After you finish specifying contact information, ensure that you save the spreadsheet file as a CSV file.

  • When uploading a CSV file, Webex Site Administration displays a table containing the information that you specified in the file. Please review all information carefully, and verify its accuracy before you confirm that you want to upload the file.

  • If you specify any information for a contact incorrectly, Site Administration cannot create that contact. In this case, Webex Site Administration generates a list of records for the contacts that it was unable to create, including the cause for each error. You can download a file containing these records to your computer for reference or to correct the errors directly in that file.

  • If you correct the errors directly in the downloaded file, ensure that you delete the last column, labeled Comments, before you upload the file.

Alternately, you can edit contacts individually using Webex Site Administration. Or, you can contact your Webex account manager for assistance.

Create a CSV File Template for Contacts

When you export the CSV file, you get a baseline or template that you can use to add new contacts. Alternately, you can use the file to batch-edit multiple contacts. If no contacts currently exist on your site, manually add a least one contact to your site.

1

Sign in to Webex Site Administration and go to Manage Site > Company Addresses.

2

On the Company Address Book page, click Export.

3

Open the file containing the data that you exported in a spreadsheet program, such as Microsoft Excel.

4

If you want to only add new contacts, delete any contact data that the exported file contains.

Deleting this data does not affect the contacts when you upload the CSV file to Webex Site Administration.

Contact-Information Fields

Use this option...

To...

UUID

Indicates an identification number that Webex Site Administration automatically generates for the contact.

Important

  • If you are adding a new contact, do not provide any information in this column. Webex Site Administration generates this number once you upload the CSV file. Webex Site Administration requires this field to be empty to create a new contact.

  • If you are editing an existing contact, do not modify this number. If you modify the number for an existing contact, Webex Site Administration creates a new contact, using the data in that row. However, if required contact data—such as an email address—already exists for a contact on your site, Site Administration cannot create the new contact.

DUID

Indicates an identification number that Webex Site Administration automatically generates for Distributor Members.

Name

(Required) Specifies the contact's first and last name.

Email

(Required) Specifies the contact's email address.

Company

(Optional) Specifies the organization for which the contact works.

JobTitle

(Optional) Specifies the contact's job title or position in an organization.

URL

(Optional) Specifies the Web page address for the contact or his or her organization.

OffCntry

(Optional) Specifies the number that you must dial to call a contact who resides in another country. This field must contain only numbers.

OffLocal

(Optional) Specifies the contact's phone number. This field must contain only numbers. Do not include punctuation, such as dashes or periods.

CellCntry

(Optional) Specifies the number that you must dial to call a contact who resides in another country. This field must contain only numbers.

CellLocal

(Optional) Specifies the contact's mobile phone number. This field must contain only numbers. Do not include punctuation, such as dashes or periods.

FaxCntry

(Optional) Specifies the number that you must dial to call a fax machine that resides in another country. This field must contain only numbers.

FaxLocal

(Optional) Specifies the contact's fax number. This field must contain only numbers. Do not include punctuation, such as dashes or periods.

Address1

(Optional) Specifies the contact's mailing address.

Address2

(Optional) Specifies additional information about the contact's mailing address, if necessary.

City

(Optional) Specifies the city in which the contact resides.

State/Province

(Optional) Specifies the state or province in which the contact resides.

Zip/Postal

(Optional) Specifies the ZIP or postal code for the contact's mailing address.

Country

(Optional) Specifies the country in which the contact resides.

Time Zone

Specifies the time zone in which the contact resides.

Language

Specifies the language the contact uses.

Locale

Specifies the locale of the language the contact uses.

UserName

(Optional) If this contact has an account for your Webex site, you can include the contact's user name in this field. User names

  • Cannot include spaces or punctuation marks, except underscores, hyphens, and periods

  • Can consist of a maximum of 64 characters

Notes

(Optional) Specifies any additional information about the contact.

CSV File Format for Tracking Code Values

  • A CSV file must include column headings at the top of the file. When creating a CSV file using a spreadsheet program, such as Microsoft Excel, the column headings must be in the first row of a spreadsheet. Column headings must appear exactly as specified under Code-Value Information Fields.

  • Some tracking code information is required, as specified under Code-Value Information Fields. You must include all column headings, regardless of whether their information is optional, and format them exactly as specified.

  • The code-value information fields in a CSV file are not case-sensitive. Thus, you can type values in either upper- or lowercase letters, or a combination of both. The tracking code values appear on your site as they appear in the CSV file.

  • After you finish specifying code values, save the spreadsheet file as a CSV file, which as a .csv extension.

  • When uploading a CSV file, Webex Site Administration displays a table containing the information that you specified in the file. Review the information carefully, and verify its accuracy before you confirm that you want to upload the file.

  • If you specify any code values incorrectly, Webex Site Administration cannot add those values to the list. In this case, Site Administration generates a list of records for the values that it was unable to add, including the cause for each error. You can download a file containing these records to your computer for reference or to correct the errors directly in that file.

  • If you correct the errors directly in the file that Webex Site Administration creates for you, delete the last column, labeled Comments, before you upload the file to create the remaining code values.

Alternately, you can edit values individually in Webex Site Administration,on the Tracking Codes List page. Or, you can contact your Webex account manager for assistance.

Code-Value Information Fields

Use this option...

To...

Index

(Optional) Specifies the database ID of the tracking code value. An Index value must be a unique number from 1-500, inclusive. To prevent errors that duplicate index numbers can cause, you can leave this column blank. If the Index column does not contain values, Site Administration inserts the code values sequentially on the Tracking Codes List page.

Active

(Optional) Specifies the status of the tracking code value. A value must be Yes or No. If you leave this value blank, the status automatically defaults to Yes.

Code

(Requiredl) Specifies the value of the tracking code. A value can be up to 128 characters, and include letters, numbers, and special characters.

Time Zones

Time zones are organized in an easy-to-read format. The menu items appear differently, depending on whether the time zones are in DST (Daylight Savings Time). The time zone menu format uses this format:

Location (<Time zone name> <DST label> "Time", <GMT offset>)

An example of the time zone format as it appears is:

San Francisco (Pacific Standard Time), GMT-08:00

The following table lists the time zones by index and includes details about each time zone.

Table 1. Time Zone Index

Index

GMT

Name

Location

Standard

DST

0

-12 hr

Dateline

Marshall Islands

1

-11 hr

Samoa

Samoa

2

-10 hr

Hawaii

Honolulu

Standard

Daylight

3

-9 hr

Alaska

Anchorage

Standard

Daylight

4

-8 hr

Pacific

San Francisco

Standard

Daylight

5

-7 hr

Mountain

Arizona

6

-7 hr

Mountain

Denver

Standard

Daylight

7

-6 hr

Central

Chicago

Standard

Daylight

8

-6 hr

Mexico Central

Mexico City

Standard

Daylight

9

-6 hr

Central

Saskatchewan

10

-5 hr

S. American Pacific

Bogota

11

-5 hr

Eastern

New York

Standard

Daylight

12

-5 hr

Eastern

Indiana

Standard

Daylight

13

-4 hr

Atlantic

Halifax

Standard

Daylight

14

-4 hr

S. American Western

Caracas

15

-3.5 hr

Newfoundland

Newfoundland

Standard

Daylight

16

-3 hr

S. American Eastern

Brasilia

Standard

Daylight

17

-3 hr

S. American Eastern

Buenos Aires

18

-2 hr

Mid-Atlantic

Mid-Atlantic

Standard

Daylight

19

-1 hr

Azores

Azores

Summer

20

0 hr

Greenwich

Casablanca

21

0 hr

Greenwich Mean

London

Summer

22

1 hr

Central European

Amsterdam

Summer

23

1 hr

Central European

Paris

Summer

25

1 hr

Central European

Berlin

Summer

26

2 hr

Eastern European

Athens

Summer

28

2 hr

Egypt

Cairo

Standard

Daylight

29

2 hr

South Africa

Pretoria

30

2 hr

Eastern European

Helsinki

Summer

31

2 hr

Israel

Tel Aviv

Standard

Daylight

32

3 hr

Saudi Arabia

Riyadh

33

3 hr

Russia

Moscow

Standard

Daylight

34

3 hr

Nairobi

Nairobi

35

3.5 hr

Iran

Tehran

36

4 hr

Arabian

Abu Dhabi

37

4 hr

Baku

Baku

Standard

Daylight

38

4.5 hr

Afghanistan

Kabul

39

5 hr

West Asia

Ekaterinburg

40

5 hr

West Asia

Islamabad

41

5.5 hr

India

Bombay

42

5.5 hr

Columbo

Columbo

43

6 hr

Central Asia

Almaty

44

7 hr

Bangkok

Bangkok

45

8 hr

China

Beijing

46

8 hr

Australia Western

Perth

Standard

Daylight

47

8 hr

Singapore

Singapore

48

8 hr

Taipei

Taipei

49

9 hr

Japan

Tokyo

50

9 hr

Korea

Seoul

51

9 hr

Yakutsk

Yakutsk

52

9.5 hr

Australia Central

Adelaide

Standard

Daylight

53

9.5 hr

Australia Central

Darwin

54

10 hr

Australia Eastern

Brisbane

55

10 hr

Australia Eastern

Sydney

Standard

Daylight

56

10 hr

West Pacific

Guam

57

10 hr

Tasmania

Hobart

Standard

Daylight

58

10 hr

Vladivostok

Vladivostok

Standard

Daylight

59

11 hr

Central Pacific

Solomon Islands

60

12 hr

New Zealand

Wellington

Standard

Daylight

61

12 hr

Fiji

Fiji

130

1 hr

Central European

Stockholm

Summer

131

-8 hr

Mexico Pacific

Tijuana

Standard

Daylight

132

-7 hr

Mexico Mountain

Chihuahua

Standard

Daylight

133

-4.5 hr

S. America Western

Caracas

Standard

Daylight

134

8 hr

Malaysia

Kuala Lumpur

Standard

Daylight