CSV File Format Reference

Document created by Cisco Documentation Team on Sep 24, 2015Last modified by Cisco Documentation Team on Jul 5, 2017
Version 13Show Document
  • View in full screen mode
 

CSV File Format for User Accounts

This article provides an example of a comma-separated values (CSV) file that was formatted in Microsoft Excel. This example does not show all the possible fields for which you must provide values. Create your own, company-specific CSV file template.

Notes and Considerations

  • Before you import user account data in a CSV file, create a backup file of your existing user accounts, by exporting their 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 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.

     


    Note


    We do not recommend deleting any fields from the .csv file before importing. If a field doesn’t require change, leave the field empty; the import process retains the existing value for that field.

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

     

  • The account-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. However, the values that appear in the user’s profile on your site (such as the user’s name) 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 user account information, ensure that you save the spreadsheet file as a CSV file.

     

  • If you specify any information for a user account incorrectly, Site Administration cannot create that account. In this case, 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.

     

  • If you want to change information for one or more user accounts, you can also edit accounts individually by using Site Administration > Edit User List. Or, you can contact your WebEx account manager for assistance.

     

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    Select 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    Using the link in the email message, open the file containing the data that you exported in a spreadsheet program, such as 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 Site Administration.

Account-Information Fields

                                                                                                                                                                                                                                                                                                 

Field

 

Description

 

UserID

 

(Required) Indicates an identification number that WebEx database for Site Administration automatically generates for the account.

 
Important:
  • If you are adding a new account, do not provide any information in this column. Site Administration generates this number after you upload the CSV file. Site Administration requires that this field is empty to create a new account.

     

  • If you are editing an existing account, do not delete or modify this number. If you modify the number for an existing account, Site Administration creates a new user account, using the account data in that row. However, if necessary account data (such as a username or email address) exists for an account on your site, Site Administration cannot create the new account.

     

    If you leave the field empty, a new user is added and a UserID is generated automatically.

     

 
 

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, 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.

 

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.

 

Username

 

(Required) Specifies the identifier that the user to whom this account belongs uses to sign in to your organization's WebEx service. Usernames:

 
  • Must be unique

     

  • Can consist of a maximum of 64 characters

     

    Important:

    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.

     
     
 

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 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.

     

Note      

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.

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.

Note      

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.

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.

     

    Important:

    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.

     
     
 

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.

 

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

 

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 your organization's WebEx service to host meetings.

     

  • ADMN: Specifies that the user has a site administrator account. The user can sign in to your organization's WebEx service to host meetings and use Site Administration to administrate your WebEx service.

     

    Important:

    Important A site administrator can manage user accounts, handle registration requests, and specify preferences for your organization’s WebEx service. Therefore, WebEx 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 your organization’s WebEx service to host meetings. They can also use Site Administration to view user account information, registration requests, WebEx configuration and preferences, and meeting usage reports. However, a site administrator with view-only privileges cannot change user account information or settings for your organization’s WebEx service.

     

  • ATTND: Specifies that the user has an attendee account. The user can sign in to your WebEx service. They can view a list of meetings to which the user was invited and attend meetings that require an account on your site. The user can also maintain a user profile. However, the user 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, 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.

     

 

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 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.

     

 

TelephonyPrivilege

  
Note        

Values specific to MeetingPlace are supported for WBS30 only.

  
 

(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 that your organization's WebEx service supports:

 
  • 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 service 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 service 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 service is provisioned with multiple bridge locations.

     

  • MPCLIN: Call-in teleconferencing for Cisco Unified MeetingPlace(used to update MeetingPlace audio privileges). Specifies that the user can host sessions in which attendees can call a phone number to join a teleconference.

     

  • MPCLBK: Call back teleconferencing for Cisco Unified MeetingPlace(used to update MeetingPlace audio privileges). Specifies that the user can host sessions in which attendees receive a phone call from the WebEx service to join a teleconference. Each attendee first calls a phone number, and then hangs up. The service then calls the attendee’s phone number. If MPCLBK is supported, then MPCLIN must be supported.

     

  • MPINTL: International call-back teleconferencing for Cisco Unified MeetingPlace(used to update MeetingPlace audio privileges). Specifies that the user can host meetings or training sessions in which attendees receive an international phone call from the WebEx service to join a teleconference.

     

 

To determine which teleconferencing services your organization supports, see the 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.

Note      

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

 

GeneralPriv

 

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

 

BADM: Specifies that the user is a billing administrator. The user can access Billing reports from WebEx in My WebEx. Applicable only to WebEx service sites that have the Billing Administrator option.

 

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

 

EditorPrivilege

 

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

 

TCPrivilege

 

(Optional) Available for Training Center sites only. Specifies which privileges the user has for Training Center. 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.

 

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.

 

SCOptions

 

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

 

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

 

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

 

SCShareView

 

(Optional) Available for Support Center sites only. For a Remote 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.

     

 

SCShareColor

 

(Optional) Available for Support Center sites only. 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.

     

 

SCSaveLoc

 

(Optional) Available for Support Center sites only. Applies only if you specified the Auto Record (AREC) for SCOptions for the user. For a Remote 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, Support Center creates the necessary folders.

 
Important:

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 Support Center 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.

 

STShareView

 

(Optional) Available for Support Center sites only. Applies only if you specified the Auto Record (AREC) for STOptions for the user. For a Remote 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.

     

 

STShareColor

 

(Optional) Available for Support Center 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.

     

 

STComputers

 

(Optional) Available for Support Center 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 Site Administration. Type the computer names exactly as they appear in 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 Support Center 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.

 
Important:

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.

     

 
 

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.

 

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.

 

PhoneCallin

 

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

 

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

 

PhoneCallback

 

(Optional) Specifies the 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.

 

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.

 

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.

 

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.

 

AP1Callin, AP2Callin

 

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

 

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

 

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.

 

Pin

 

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

 

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

 

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.

 

City

 

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

 

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

 

State/Province

 

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

 

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.

 

Country/Region

 

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

 

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

 

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.

     

 
Note      
  • 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, 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, 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.

     

 
 

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 Contacts is 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.

     

 

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.

     

 

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.

     

 

MyWorkspaces

 

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

 

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

 

MyRecordings

 

(Optional) Applies only to accounts on a Training Center site and for which you have specified PRO in the MyWebEx 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.

     

 

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.

     

 

MyReports

 

(Optional) Applies only to accounts on a Training Center site and for which you have specified PRO in the MyWebEx 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.

     

 

AccessAnywhere

 

(Optional) Applies only to accounts for which you have specified PRO in the MyWebEx 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.

     

 

WebcastVideo

 

(Optional) Allows Event Center users to stream video.

 

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

 

WebcastAdmin

 

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

 

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

 

WebcastBasic

 

(Optional) Allows Event Center users to broadcast online presentations and audio.

 

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.

 

MeetingAssist

 

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

 

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

 

SupportCET

 

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

 

SupportCMR

 

(Optional) Specifies whether Collaboration Meeting Rooms (CMR Cloud) is available for your users (Meeting Center only).

 
  • 1: Specifies that CMR Cloud is available for the user.

     

  • 0: Specifies that CMR Cloud is not available for the user.

     

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

 

SupportPR

 

(Optional) Specifies whether Personal Room is available for your users (Meeting Center 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.

 

SupportHQV

 

(Optional) Specifies whether high-quality video is available for your users (Meeting Center, Event Center, and Training Center only).

 

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

 

SupportHDV

 

(Optional) Specifies whether high-definition video is available for your users (Meeting Center and Training Center only).

 

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

 

SupportCascading

 

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

 

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

 

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.

 

MyPMR

 
Note      

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

 

OneClickSetup

 

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

 

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

 

AdditionalStorage

 

(Optional) Applies only to accounts for which you have specified PRO in the MyWebEx 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.

 
Note      
  • Your organization’s 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 Site Administration.

     

  • If you exceed the total amount of extra storage space for your site, 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.

     

 
 

AdditionalComputers

 

(Optional) Applies only to accounts for which you have specified PRO in the MyWebEx 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.

 
Note      
  • Your organization’s 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 Site Administration.

     

 
 

If you exceed the total number of extra computers for your site, 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.

 

EventDocument

 

(Optional) For Enterprise Edition sites with Event Center. 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.

     

 

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.

 
Caution      

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.

 
 

TeleconLocation

 

(Optional) Reserved for WebEx teleconferencing service provider partners.

 

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

 

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 service 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.

     

    Note      

    This option is turned off by default for most 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.

     

 

LabAdmin

 

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

 

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

 

SchedulePermission

 

(Optional) Applies only to Meeting Center, Training Center, and Event Center 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 WebEx service 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.

 

PCNAcc1AutoGenerate

 

(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.

     

 

PCNAcc1TollFreeCallinNum

 

(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.

 

PCNAcc1TollCallinNum

 

(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.

 

PCNAcc1ILNum

 

(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.

 

PCNAcc2AutoGenerate

 

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

 

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

 

PCNAcc2TollFreeCallinNum

 

(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.

 

PCNAcc2TollCallinNum

 

(Optional) Specifies the toll call in number.

 

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

 

PCNAcc2ILNum

 

(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.

 

PCNAcc3AutoGenerate

 

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

 

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

 

PCNAcc3TollFreeCallinNum

 

(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.

 

PCNAcc3TollCallinNum

 

(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.

 

PCNAcc3ILNum

 

(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.

 

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.

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.

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.

CSV File Format for Contacts

The following figure is an example of a comma-separated values (CSV) file that was formatted in Microsoft Excel. You must create your own, company-specific CSV file template.

Notes and Considerations

  • Before your 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 below.

     

  • Some contact information is required, as specified under Contact-Information Fields below. Thus, 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. However, 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.

     

  • Refer to Contact-Information Fields below for the correct format for contact information.

     

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

     

  • When uploading a CSV file, 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, 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 file that Site Administration creates for you, ensure that you delete the last column, labeled Comments, before you upload the file to create the remaining contacts.

     

  • If, after uploading a CSV file, you want to change information that you specified for one or more contacts, you can edit contacts individually using Site Administration. Or, you can contact your WebEx account manager for assistance.

     

Create a CSV File Template

        
1    If no contacts currently exist on your site, manually add a least one contact to your site.
2    On the navigation bar, under Manage Site, select Company Addresses.
3    On the Company Address Book page, select Export.
4    Open the file containing the data that you exported in a spreadsheet program, such as Excel.
5    If you want to only add new contacts, delete any contact data that the exported file contains. Deleting this data does not affect any contacts when you upload the CSV file to Site Administration.

Contact-Information Fields

                                                                            

Use this option...

 

To...

 

UUID

 

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

 

Important

 
  • If you are adding a new contact, do not provide any information in this column. Site Administration generates this number once you upload the CSV file. 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, 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 Site Administration automatically generates for Distributor Members.

 

Name

 

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

 

Email

 

(Requiredl) 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 service, 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

The following is an example of comma-separated values (CSV) contentl. You must create your own, company-specific CSV file template.

 

Notes and Considerations

  • 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 Code-Value Information Fields below.

     

  • Some tracking code information is required, as specified under Code-Value Information Fields below. However, 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. However, the values that appear in the list of values for a tracking code on your site will appear as you type them in the CSV file.

     

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

     

  • When uploading a CSV file, 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 code values incorrectly, 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 Site Administration creates for you, ensure that you delete the last column, labeled Comments, before you upload the file to create the remaining code values.

     

  • If, after uploading a CSV file, you want to change information that you specified for one or more code values, you can edit values individually 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 displayed in an easy-to-read format. The menu items display differently depending on whether or not 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 displays 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

 
 
 

Attachments

    Outcomes