CSV File Format for Cisco Webex User Accounts
Before you import user account data in a CSV file, create a backup file of your existing user accounts by exporting the data. You only need to import data for the accounts that you're adding or updating.
-
All exports (report, user, contacts) are exported in Unicode tab-delimited text (UTF-16LE) format. All imports support CSV (for English data only) and Unicode tab-delimited text (for non-English data and mixed language data).
-
A CSV file must include column headings at the top of the file. When creating a CSV file using a spreadsheet program, such as Microsoft Excel, ensure that the column headings are in the first row of a spreadsheet. Column headings must appear exactly as specified in the Account-Information Fields section.
-
Some user account information is required, as specified in the Account-Information Fields section. Include all column headings for required fields.
-
We strongly recommend that you create a CSV file template. The template helps to ensure that your CSV file contains all required column headings, in their proper format.
-
The account-information fields in a CSV file aren't case-sensitive. Thus, you can type values in either uppercase or lowercase letters, or a combination of both. The values that appear in the user’s profile on your site appear as you enter them in the CSV file. To sign in to their accounts, users must type their default passwords exactly as you specify them in the CSV file.
-
See the Account-Information Fields section for information about how to format the user account information.
-
After you finish specifying the user account information, save the spreadsheet as a CSV file.
-
If you specify information for a user account incorrectly, Webex Site Administration can't create that account. Webex Site Administration generates a list of records for the accounts that it was unable to create, including the cause for each error. You can download a file containing these records to your computer, for reference or to correct the errors directly in that file.
Create a CSV File Template
When you export the CSV file, you get a baseline or template that you can use to add new users. Alternately, you can use the file to batch-edit multiple user accounts.
1 | Sign in to Webex Site Administration and go to . |
2 | On the Batch Import/Export Users page, select Export. A message appears to confirm receipt of your request. You receive an email message when the export process is complete. |
3 | Click the link in the email message and open the exported file in a spreadsheet program, such as Microsoft Excel. |
4 | If you want to only add new user accounts, delete any account data that the exported file contains. Deleting this data does not affect any existing accounts when you upload the CSV file to Webex Site Administration. |
Open a CSV file in Microsoft Excel and keep the leading zeros
1 | Open a new, blank Excel workbook, and click the Data tab. | ||
2 | In the Get External Data category, select From text. | ||
3 | Browse to the location of the CSV file, select the file, and then click Import. | ||
4 | Under Original data type, select Delimited, and then click Next. | ||
5 | Under Delimiters, check Tab, and then click Next. | ||
6 | Under Column data format, choose Text. | ||
7 | Under Data Preview, select all of the columns.
| ||
8 | Click Finish. | ||
9 | In the Import Data window, choose where to place the data, and then click OK. |
Save a CSV file in Microsoft Excel and keep the leading zeros
1 | With the CSV file open in Excel, select the cell or range of cells that you want to format. |
2 | Select the Home tab. |
3 | In the Number group, click the Number Format () icon. |
4 | In the Format Cells window, select the Number tab, and select Custom from the category list. |
5 | In the Type box, enter the number format, such as 000-000-0000 for a phone number. |
6 | Click OK. |
7 | Select the File tab, choose Save As, select the location to save the CSV file, and in the Save As window, click Save. |
Account-Information Fields
Field | Description | ||
---|---|---|---|
AccessAnywhere | (Optional) Applies only to accounts for which you have specified PRO in the My Webex field. Specifies whether the user can set up and access remote computers, using Access Anywhere. This field can contain one of the following values:
| ||
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. | ||
AP1Cntry, AP2Cntry | (Optional) Specifies the number that you dial to call a pager user who resides in another country. Enter numbers and underscores (_) only; do not include punctuation, such as dashes or periods. If the field is left empty, it defaults to 1. | ||
AP1Local, AP2Local | (Optional) Specifies the user's pager number. This field must contain only numbers. Do not include punctuation, such as dashes or periods. If the field is left empty, the value is left blank. | ||
CellCallback | (Optional) Specifies the extension of the user's mobile phone number. This field must contain only numbers. If the field is left empty, it defaults to N. | ||
CellCallin | (Optional) Specifies the user’s mobile phone number at which the user wants to be called. If the field is left empty, it defaults to N. | ||
CellCntry | (Optional) Specifies the number that you dial to call a mobile phone user who resides in another country. Enter numbers and underscores (_) only; do not include punctuation, such as dashes or periods. If the field is left empty, it defaults to 1. | ||
CellLocal | (Optional) Specifies the user's mobile phone number the user must use to call in. If the field is left empty, the value is left blank. | ||
City | (Optional) Specifies the city in which the user resides. If the field is left empty, the value is left blank. | ||
Country/Region | (Optional) Specifies the country or region in which the user resides. If the field is left empty, the value is left blank. | ||
Custom1-10 | (Optional) If Tracking Codes are enabled on your site, fields can be renamed as desired to track information. By default, the first four fields are named Group, Department, Project, and Other. The first tracking code is used for billing and invoicing. If the field is left empty, the value is left blank. | ||
DefaultTPSessionType | (Optional) Specifies the default TelePresence session type, as set in the user Preferences page. If the field is left empty, the value is the session type which supports TelePresence with the minimum meeting type ID. | ||
DefaultVideoDeviceIndex | (Optional) Specifies the index number (from 1 to 5) of the user's default video device. If you leave this field empty, the value is left blank. | ||
EditorPrivilege | No longer supported. Leave this field empty, and ignore it in the export file. | ||
| (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:
| ||
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:
| ||
LabAdmin | (Optional) Applies only to Webex Training. Specifies Webex Training privilege as an administrator for Hands-on Lab. If the field is left empty, it defaults to N. | ||
Language | (Optional) Specifies the language that is selected by default on the user's Preferences page. This option determines the language in which text appears to the user on your meeting service website. Depending on which languages your site supports, this field contains one of the following short name values. In the following list, the short name appears next to the corresponding language. If the field is left empty, it defaults to the default language for the site. Language - ID English: en-us Simplified Chinese: zh-cn Traditional Chinese: zh-tw Japanese: jp Korean: ko French: fr German: de Italian: it Castilian Spanish: es-me Latin American Spanish: es-sp Swedish: sw Dutch: nl Portuguese: pt-br Russian: ru | ||
LastName | (Required) Specifies the last name of the user to whom this account belongs. If the field is left empty, it prompts for a last name. | ||
DisplayName | (Optional) Displays the user's preferred name in the Meeting Participants List. If the field is left empty, FirstName + LastName will display in the Meeting Participants List. | ||
MeetingAssist | (Optional) Specifies whether Meeting Assist services are available for your users. If the field is left empty, the value is 0. | ||
MeetingPrivilege | (Optional) Specifies which types of meetings the user can host. This field can contain one or more codes, with up three digits, that indicate the meeting types a user can host. Note
| ||
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 |
| ||
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. | ||
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. | ||
PhoneCntry | (Optional) Specifies the number that you dial to call a user who resides in another country. Enter numbers and underscores (_) only; do not include punctuation, such as dashes or periods. If the field is left empty, it defaults to 1. | ||
PhoneLocal | (Optional) Specifies the user's phone number. This field must contain only numbers. Do not include punctuation, such as dashes or periods. If the field is left empty, the value is left blank. | ||
Pin | (Optional) Specifies the user’s PCN audio personal identification number. If the field is left empty, the value is left blank. | ||
ResetPassword | (Optional) Resets the user's password and automatically selects the ForceChangePassword options. You can use this option if you suspect a problem with a user's password. Webex generates a temporary password for the user and prompts the user to change the password the first time they sign in.
| ||
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.
| ||
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.
| ||
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:
| ||
SupportAnnotationTools_NewEvents | Specifies if the user can start annotation tool in the meeting. | ||
SupportAppShare_NewEvents | Specifies if the user can share applications in the meeting. | ||
SupportAppShareRemote_NewEvents | Specifies if the user can control application share remotely. | ||
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. | ||
SupportChat_NewEvents | Specifies if the user can use the chat function in Webinar. | ||
SupportDesktopShare_NewEvents | Specifies if the user can share desktop. | ||
SupportDesktopShareRemote_NewEvents | Specifies if the user can control desktop share remotely. | ||
SupportFileTransfer_NewEvents | Specifies if the user can share files with attendees. | ||
SupportHQV | (Optional) Specifies whether high-quality video is available for your users (Webex Meetings, Webex Events, and Webex Training only). If the field is left empty, it defaults to Y. | ||
SupportHDV | (Optional) Specifies whether high-definition video is available for your users (Webex Meetings and Webex Trainings only). If the field is left empty, it defaults to Y. | ||
SupportMeetingRecord_NewEvents | Specifies if the user can record the meeting locally. | ||
SupportNetworkBasedRecord_NewEvents | Specifies if the user can record the meeting on cloud. | ||
SupportPolling_NewEvents | Specifies if the user can start polling funciton in webinar. | ||
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. | ||
SupportPresentation_NewEvents | Specifies if the host can share document in the meeting. | ||
SupportQandA_NewEvents | Specifies if the user can host a meeting with Q&A function. | ||
SupportWebTour_NewEvents | Specifies if the user can share web browser. | ||
SupportWebTourRemote_NewEvents | Specifies if the user can control Web browser remotely. | ||
SupportWhiteboard_NewEvents | Specifies if the user can host a meeting with whiteboard function. | ||
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.
| ||
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.
| ||
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.
| ||
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.
| ||
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.
| ||
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.
| ||
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.
| ||
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.
| ||
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.
| ||
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.
| ||
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.
| ||
TimeZone | (Optional) Specifies the index number for the time zone in which the user resides. If you do not specify a time zone for the user, Site Administration uses the time zone specified for your meeting service website. For a list of time zones and their index numbers, see Time Zones. If the field is left empty, it defaults to the default time zone for your site. | ||
UserID | Read-only Indicates an identification number that Webex Meetings database for Site Administration automatically generates for the account. | ||
Username | (Required) Specifies the identifier that the user to whom this account belongs uses to sign in to Webex services. Usernames:
| ||
VideoDeviceAddress1-5 | (Optional) Specifies the address of the video device, at which the user wants to be called. If you leave this field empty, the value is left blank. | ||
VideoDeviceName1-5 | (Optional) Specifies the name of the video device, at which the user wants to be called. If you leave this field empty, the value is left blank. | ||
WebcastAdmin | (Optional) Specifies whether the current user is a Webcast Administrator or Presenter. If checked, the user is an Administrator. If the check box is left empty, the value is left blank. | ||
WebcastBasic | (Optional) Allows Cisco Webex Events users to broadcast online presentations and audio. If the field is left empty, the value is left blank. | ||
WebcastVideo | (Optional) Allows Cisco Webex Events users to stream video. If the field is left empty, the value is left blank. | ||
Zip/Postal | (Optional) Specifies the ZIP or postal code for the user's mailing address. If the field is left empty, the value is left blank. |
CSV File Format for Contacts
Before you import contact data in a CSV file, create a backup file of your contacts data, if any, by exporting the data.
-
All exports (report, user, contacts) are exported in Unicode tab-delimited text (UTF-16LE) format. All imports support CSV (for English data only) and Unicode tab-delimited text (for non-English data and mixed language data.)
-
A CSV file must include column headings at the top of the file. When creating a CSV file using a spreadsheet program, such as Microsoft Excel, ensure that the column headings are in the first row of a spreadsheet. Column headings must appear exactly as specified under Contact-Information Fields.
-
Some contact information is required, as specified under Contact-Information Fields. You must include all column headings for required fields. You need not include column headings for optional fields, for which you do not provide contact information.
-
To ensure that your CSV file contains all required column headings, in their proper format, Webex strongly recommends that you create a CSV file template.
-
The contact-information fields in a CSV file are not case-sensitive. Thus, you can type values in either uppercase or lowercase letters, or a combination of both. The values that appear in the contact's information on your site-such as the contact's name-will appear as you type them in the CSV file.
-
See Contact-Information Fields, for the correct format for contact information.
-
After you finish specifying contact information, ensure that you save the spreadsheet file as a CSV file.
-
When uploading a CSV file, Webex Site Administration displays a table containing the information that you specified in the file. Please review all information carefully, and verify its accuracy before you confirm that you want to upload the file.
-
If you specify any information for a contact incorrectly, Site Administration cannot create that contact. In this case, Webex Site Administration generates a list of records for the contacts that it was unable to create, including the cause for each error. You can download a file containing these records to your computer for reference or to correct the errors directly in that file.
-
If you correct the errors directly in the downloaded file, ensure that you delete the last column, labeled Comments, before you upload the file.
Alternately, you can edit contacts individually using Webex Site Administration. Or, you can contact your Webex account manager for assistance.
Create a CSV File Template for Contacts
When you export the CSV file, you get a baseline or template that you can use to add new contacts. Alternately, you can use the file to batch-edit multiple contacts. If no contacts currently exist on your site, manually add a least one contact to your site.
1 | Sign in to Webex Site Administration and go to . |
2 | On the Company Address Book page, click Export. |
3 | Open the file containing the data that you exported in a spreadsheet program, such as Microsoft Excel. |
4 | If you want to only add new contacts, delete any contact data that the exported file contains. Deleting this data does not affect the contacts when you upload the CSV file to Webex Site Administration. |
Contact-Information Fields
Use this option... | To... |
---|---|
UUID | Indicates an identification number that Webex Site Administration automatically generates for the contact. Important
|
DUID | Indicates an identification number that Webex Site Administration automatically generates for Distributor Members. |
Name | (Required) Specifies the contact's first and last name. |
| (Required) Specifies the contact's email address. |
Company | (Optional) Specifies the organization for which the contact works. |
JobTitle | (Optional) Specifies the contact's job title or position in an organization. |
URL | (Optional) Specifies the Web page address for the contact or his or her organization. |
OffCntry | (Optional) Specifies the number that you must dial to call a contact who resides in another country. This field must contain only numbers. |
OffLocal | (Optional) Specifies the contact's phone number. This field must contain only numbers. Do not include punctuation, such as dashes or periods. |
CellCntry | (Optional) Specifies the number that you must dial to call a contact who resides in another country. This field must contain only numbers. |
CellLocal | (Optional) Specifies the contact's mobile phone number. This field must contain only numbers. Do not include punctuation, such as dashes or periods. |
FaxCntry | (Optional) Specifies the number that you must dial to call a fax machine that resides in another country. This field must contain only numbers. |
FaxLocal | (Optional) Specifies the contact's fax number. This field must contain only numbers. Do not include punctuation, such as dashes or periods. |
Address1 | (Optional) Specifies the contact's mailing address. |
Address2 | (Optional) Specifies additional information about the contact's mailing address, if necessary. |
City | (Optional) Specifies the city in which the contact resides. |
State/Province | (Optional) Specifies the state or province in which the contact resides. |
Zip/Postal | (Optional) Specifies the ZIP or postal code for the contact's mailing address. |
Country | (Optional) Specifies the country in which the contact resides. |
Time Zone | Specifies the time zone in which the contact resides. |
Language | Specifies the language the contact uses. |
Locale | Specifies the locale of the language the contact uses. |
UserName | (Optional) If this contact has an account for your Webex site, you can include the contact's user name in this field. User names
|
Notes | (Optional) Specifies any additional information about the contact. |
CSV File Format for Tracking Code Values
-
A CSV file must include column headings at the top of the file. When creating a CSV file using a spreadsheet program, such as Microsoft Excel, the column headings must be in the first row of a spreadsheet. Column headings must appear exactly as specified under Code-Value Information Fields.
-
Some tracking code information is required, as specified under Code-Value Information Fields. You must include all column headings, regardless of whether their information is optional, and format them exactly as specified.
-
The code-value information fields in a CSV file are not case-sensitive. Thus, you can type values in either upper- or lowercase letters, or a combination of both. The tracking code values appear on your site as they appear in the CSV file.
-
After you finish specifying code values, save the spreadsheet file as a CSV file, which as a .csv extension.
-
When uploading a CSV file, Webex Site Administration displays a table containing the information that you specified in the file. Review the information carefully, and verify its accuracy before you confirm that you want to upload the file.
-
If you specify any code values incorrectly, Webex Site Administration cannot add those values to the list. In this case, Site Administration generates a list of records for the values that it was unable to add, including the cause for each error. You can download a file containing these records to your computer for reference or to correct the errors directly in that file.
-
If you correct the errors directly in the file that Webex Site Administration creates for you, delete the last column, labeled Comments, before you upload the file to create the remaining code values.
Alternately, you can edit values individually in Webex Site Administration,on the Tracking Codes List page. Or, you can contact your Webex account manager for assistance.
Code-Value Information Fields
Use this option... | To... |
---|---|
Index | (Optional) Specifies the database ID of the tracking code value. An Index value must be a unique number from 1-500, inclusive. To prevent errors that duplicate index numbers can cause, you can leave this column blank. If the Index column does not contain values, Site Administration inserts the code values sequentially on the Tracking Codes List page. |
Active | (Optional) Specifies the status of the tracking code value. A value must be Yes or No. If you leave this value blank, the status automatically defaults to Yes. |
Code | (Requiredl) Specifies the value of the tracking code. A value can be up to 128 characters, and include letters, numbers, and special characters. |
Time Zones
Time zones are organized in an easy-to-read format. The menu items appear differently, depending on whether the time zones are in DST (Daylight Savings Time). The time zone menu format uses this format:
Location (<Time zone name> <DST label> "Time", <GMT offset>)
An example of the time zone format as it appears is:
San Francisco (Pacific Standard Time), GMT-08:00
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 |