Webex Meetings CSV file import and export in Control Hub
For sites that have the map tracking codes to user attributes feature, the custom attributes and profile fields in the Webex Meetings CSV file will be read-only. If you want to manage custom attributes and new profile fields in bulk, follow the steps for the user CSV file instead.
Webex Meetings CSV file import and export
The information in this article is for administrators who manage Webex sites through Control Hub. For a Control Hub-managed site, the identity service stores all identities. Each user has one identity for all collaboration services, including the Webex Meetings service.
When you import a comma-separated values (CSV) file, you only need to import data for the accounts that you're updating. Note the following points:
-
All exports (report, user, contacts) use the Unicode tab-delimited text (UTF-16LE) format. All imports support the same Unicode tab-delimited text (UTF-16LE) 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 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.
-
Don't omit or remove any columns from the CSV file. Removing columns can cause features to stop working.
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.
You can use CSV files to bulk-inspect and -update privileges and options that are specific to Webex Meetings, for existing entitled users. The Webex Meetings-specific CSV file method is the best way to modify:
-
Webex Meetings-specific attributes for many users.
-
Attributes that differ from one user to another (such as, Audio PIN and TSP audio accounts).
You cannot use the Webex Meetings-specific CSV file to add users. You can add multiple users in Control Hub using the CSV template.
You can export a CSV file that contains the Webex Meetings-specific settings for all entitled users for your site. You can use this file to bulk-inspect settings or as a template that you can edit.
If you also manage sites using Site Administration, note that the CSV export files for Control Hub don't include the same columns.
By default, phone numbers are exported in a E.164 format as [+][country code][phone number with area code] in one column, e.g. +11231234567.
If you want to export the phone numbers in two columns by country code and phone number, then uncheck the Support E.164-format phone numbers in reports option before exporting the CSV file.
| 1 |
Sign in to Control Hub, then go to Services. |
| 2 |
Under Meetings, select Sites, and then choose the site for which you want to create a template. |
| 3 |
In the Licenses and Users section, click Bulk Manage. |
| 4 |
In the CSV Bulk Modify User Attributes window, choose one of the following options:
|
| 5 |
Click Generate Report. |
| 6 |
After the export process is complete, click Export Results. You can also wait until you receive the confirmation email, then click the link in that email. |
| 7 |
In the Export Results window, click Download. |
| 8 |
In the Save As window, browse to the folder where you want to save the file, and then click Save. The CSV file downloads to the location that you selected.
|
Use a spreadsheet editor, such a Microsoft Excel, to update the Webex Meetings-specific CSV file template that you exported for your site.
When you open a CSV file, Microsoft Excel removes the leading zeros from all number codes. For workaround instructions, see Open a CSV file in Microsoft Excel and keep the leading zeros in this article.
Before you begin
Create a Webex Meetings-specific CSV file template.
| 1 |
Sign in to Control Hub, then go to Services. |
| 2 |
Under Meetings, select Sites, and then choose the same site for which you created the template. |
| 3 |
In the Licenses and Users section, select Bulk Manage. |
| 4 |
Do one of the following:
|
| 5 |
In the CSV Bulk Modify User Attributes window, click Import. |
| 6 |
After importing completes, click Import Results. |
| 7 |
If there are errors in the Import Results window, click Download the import error log. The downloaded CSV file lists why any updates did not go through. |
| 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. |
| 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 ( |
| 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. |
After the import process is complete, you can view the import results and download the import error log (if applicable). The error log lists each record that failed to update, along with a reason for the failure. The error log is in the CSV file format, and you can open it in a spreadsheet editor such as Microsoft Excel.
| 1 |
Sign in to Control Hub, then go to Services. |
| 2 |
Under Meetings, select Sites, and then choose the site that you want to create a template for. |
| 3 |
In the Licenses and Users section, select Bulk Manage. |
| 4 |
Do one of the following:
|
| 5 |
In the CSV Bulk Modify User Attributes window, click Import. |
| 6 |
After importing completes, click Import Results. |
| 7 |
If there are errors that are recorded in the Import Results window, click Download the import error log. |
| 8 |
Use a spreadsheet editor to open the file. |
-
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, Control Hub 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, Control Hub cannot add those values to the list. In this case, Control Hub 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 Control Hub 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 Control Hub,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, Control Hub 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. |
The following table lists the fields (columns) that comprise Webex Meetings-specific CSV files for Control Hub. The description for a read-only field specifically indicates that the field is read-only.
|
Field |
Description |
|---|---|
|
Active |
Read-only Specifies whether a user account is active or inactive. To host Webex Meetings, training sessions, support sessions, or events, the host’s account must be active. This field can contain one of the following values:
If the field is empty, the default is Y. A user with any status in Control Hub other than Active, has a value of N for this field. Other statuses can include Inactive, Not Verified, Verified, or Pending. |
|
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. |
|
AP1Callback and AP2Callback |
(Optional) Specifies the pager number, at which the user wants to be called. Enter numbers only; do not include punctuation, such as dashes or periods. If you leave this field empty, it defaults to N. |
|
AP1Callin and AP2Callin |
(Optional) Specifies the number that the pager user requires to call in. Enter numbers only; do not include punctuation, such as dashes or periods. If you leave this field empty, it defaults to N. |
|
AP1Number and AP2Number |
(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 you leave this field empty, it defaults to 1. |
|
AP1Local and AP2Local |
(Optional) Specifies the user's pager number. Enter numbers only; do not include punctuation, such as dashes or periods. If you leave this field empty, the value is left blank. |
|
CellCallback |
(Optional) Specifies the cell phone number, at which the user wants to be called. Enter numbers only; do not include punctuation, such as dashes or periods. If you leave this field empty, it defaults to N. |
|
CellCallin |
(Optional) Specifies the number that the user requires to call in. Enter numbers only; do not include punctuation, such as dashes or periods. If you leave this field empty, it defaults to N. |
|
CellNumber |
(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 you leave this field empty, it defaults to 1. |
|
Custom 1–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. |
|
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. |
| Department | |
| Display | |
| Division | |
|
|
Read-only Specifies the user's email address—this value must be unique across sites; a user can have only one email address. |
|
EnableLiveStreaming |
Toggles the Live Streaming feature.
|
|
FirstName |
Read-only Specifies the first name of the user to whom this account belongs. |
|
HostPrivilege |
Read-only Specifies the type of user account. This field can contain the following account types:
If this field is empty, the default is the HOST account type. |
| InvalidEmailFormat | |
|
LabAdmin |
(Optional) Applies to Webex Training sessions only- specifies whether the user is an administrator for Hands-on Lab. If you leave this field empty, the default is 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 |
Read-only (Required) Specifies the last name of the user to whom this account belongs. |
|
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. |
|
MeetingPrivilege |
(Optional) Specifies which types of meetings the user can host. This field can contain one or more codes that indicate the meeting types a user can host.
|
| Other | |
| Password | |
|
PCNAcc1AutoGenerate– PCNAcc3AutoGenerate |
(Optional) Specifies whether the system automatically generates an access code. This field can contain one of the following values:
If you leave this field empty, it defaults to Available. If PCN is not enabled, the value is left blank. |
|
PCNAcc1HostAccCode– PCNAcc3HostAccCode |
Read-only (Optional) Specifies the host access code. If PCN is not enabled, the value is left blank. |
|
PCNAcc1ILNum– PCNAcc3ILNum |
(Optional) Specifies that PCN account supports international call-in. If PCN is not enabled, the value is left blank. |
|
PCNAcc1TollCallInNum– PCNAcc3TollCallInNum |
(Optional) Specifies the backup toll call number. If PCN is not enabled, the value is left blank. |
|
PCNAcc1TollFreeCallInNum– PCNAcc3TollFreeCallInNum |
(Optional) Specifies the toll-free call in number. If PCN is not enabled, the value is left blank. |
|
PhoneCallback |
(Optional) Specifies the number, at which the user wants to be called. Enter numbers only; do not include punctuation, such as dashes or periods. If you leave this field empty, it defaults to N. |
|
PhoneCallin |
(Optional) Specifies the number that the user requires to call in. Enter numbers only; do not include punctuation, such as dashes or periods. If you leave this field empty, it defaults to N. |
|
PhoneNumber |
(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 you leave this field empty, it defaults to 1. |
|
Pin |
(Optional) Specifies the user’s PCN audio personal identification number. If you leave this field empty, the value is left blank. |
| Project | |
|
SchedulePermission |
(Optional) Applies to Webex Meetings, Training session, and Event sites only. Specifies the users who can schedule sessions on behalf of this user. You can specify only users who have accounts on the same Webex Meetings 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 You can leave this field empty. |
|
SCOptions |
(Optional) Available for Webex Support sites only. 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 you don't want to enable Auto record, you can leave this field empty. |
|
STComputers |
(Optional) Available for Webex Support sites with the Remote Access option only. Applies only if you specify 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. You can specify multiple computers for a user account. To specify multiple computers, separate them with commas, without spaces. For example: Computer 1, Computer 2 If you leave this field empty, the value is left blank. |
|
SupportCascading |
(Optional) Specifies whether download bandwidth optimization is enabled for Event Center users. Bandwidth optimization allows relaying traffic to other clients on the same subnet. If you leave this field empty, the default is N. |
|
SupportCMR |
Read-only (Optional) Specifies whether video device-enabled meetings are available for the user. This option is avaialble for Webex Meetings and Webex Webinars (panelists only).
If you leave this field empty, the default is 0. |
|
SupportPR |
(Optional) Specifies whether Personal Room is available for the user (Meeting Center only).
If you leave this field empty, the default is 0. |
|
SupportHQV |
(Optional) Specifies whether high-quality video is available for the user (Meetings, Events, and Training sites only). If you leave this field empty, the default is Y. |
|
SupportHDV |
(Optional) Specifies whether high-definition video is available for the user (Meetings, Events, and Training sites only). If you leave this field empty, the default is Y. |
|
TeleAcct1-PartAC–TeleAcct3-PartAC |
(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. |
|
TeleAcct1RecordingDialOutNumFlag– TeleAcct3RecordingDialOutNumFlag |
(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.
|
|
TeleAcct1-SubAC– TeleAcct3-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-Area– TeleAcct3Toll-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-Cntry– TeleAcct3Toll-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-Area– TeleAcct3TollFree-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-Cntry– TeleAcct3TollFree-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-IsTollFree– TeleAcct3TollFree-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-Num– TeleAcct3TollFree-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-IsTollFree– TeleAcct3Toll-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. |
|
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 that your organization's Webex Meetings service supports:
To disable all telephony privileges for a user, enter a comma (,). 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:
|
|
TimeZone |
(Optional) Specifies the index number for the time zone in which the user resides. If you leave this field empty, Webex Meetings uses the default time zone for the Webex site. |
| UnverifiedEmail | |
|
UserID |
Read-only Indicates an identification number that Webex Meetings database for Site Administration automatically generates for the account. |
|
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. |
|
WebcastAdmin |
(Optional) States whether the current user is a Webcast Administrator or Presenter. If checked, the user is an Administrator. If you leave this field empty, the value is left blank. |
|
WebcastBasic |
(Optional) Allows Webex Events users to broadcast online presentations and audio. If you leave this field empty, the value is left blank. |
|
WebcastVideo |
(Optional) Allows Webex users to stream video. If you leave this field empty, the value is left blank. |
If you use both Site Administration and Control Hub to manage your Webex sites, you may notice the differences between the CSV files for each tool. The following table lists the Webex-specific fields available in CSV files for Site Administration, and specifies which don't apply to Control Hub.
|
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:
|
|
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:
|
|
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.
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.
|
|
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. |
|
AP1Number, AP2Number |
(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. |
|
CellNumber |
(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. |
| Department | The name of the department used for tracking. |
| DisplayName | When the field is left empty, FirstName + LastName will display in the Meeting Participants List. |
| Division | The name of the division used for tracking. |
|
EditorPrivilege |
No longer supported. Leave this field empty, and ignore it in the export file. |
|
|
(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. |
|
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:
|
|
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:
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:
|
| InvalidEmailFormat | |
|
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. |
|
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
|
|
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:
|
|
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:
|
|
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:
|
|
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:
|
|
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:
|
|
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:
|
|
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:
|
|
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. |
| Other | A group name used as a tracking code. |
|
Password |
(Required) Specifies the password for the account. Passwords:
|
|
PCNAcc1AutoGenerate–PCNAcc3AutoGenerate |
(Optional) Specifies whether you automatically generate an access code. This field can contain one of the following values:
|
|
PCNAcc1ILNum– 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. |
|
PCNAcc1TollCallinNum–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. |
|
PCNAcc1TollFreeCallinNum–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. |
|
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. |
|
PhoneNumber |
(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. |
| Project | Specifies the name of the project. |
|
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
|
|
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:
|
|
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:
|
|
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:
|
|
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:
|
|
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:
|
|
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:
|
|
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).
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. |
|
SupportPR |
(Optional) Specifies whether Personal Room is available for your users (Webex Meetings only).
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. |
|
TeleAcct1RecordingDialOutNumFlag–TeleAcct3RecordingDialOutNumFlag |
(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.
|
|
TeleAcct1-SubAC–TeleAcct3-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-Area–TeleAcct3Toll-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-Cntry–TeleAcct3Toll-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-Area–TeleAcct3TollFree-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-Cntry–TeleAcct3TollFree-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-IsTollFree–TeleAcct3TollFree-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-Num–TeleAcct3TollFree-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-IsTollFree–TeleAcct3Toll-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:
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 in this article. If the field is left empty, it defaults to the default time zone for your site. |
| UnverifiedEmail | |
|
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:
|
|
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. |
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
| 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 |
