WebEx-Specific CSV File Export and Import Reference

Document created by Cisco Documentation Team on May 20, 2016Last modified by Cisco Documentation Team on Aug 18, 2017
Version 11Show Document
  • View in full screen mode
 

WebEx-Specific CSV File Export and Import Reference

The information in this article is for administrators who use Cisco Spark Control Hub to manage Common Identity (CI)-enabled WebEx sites. For a CI-enabled site, the Common Identity service stores all identities. Each user has one common identity for all collaboration services, including WebEx.

For information about how to manage standalone (not CI-enabled) WebEx sites, visit Help Central: WebEx Site Administration.

Bulk Modify User Attributes

You can use comma-separated values (CSV) files to bulk-inspect and -update privileges and options that are specific to WebEx, for existing entitled users. The WebEx-specific CSV file method is the best way to modify

  • WebEx-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-specific CSV file to add or to entitle users. For information about how to use CSV files to bulk-add and -entitle new users, see Add Multiple Users With the CSV Template.

     
 Command or ActionPurpose
1    Create a WebEx-Specific CSV File Template
  

In this step, you export a CSV file that includes all of the existing entitled WebEx users for your site.

  
2    Batch Edit WebEx Settings and Privileges for Multiple Users
  

In this step, you edit the CSV file (WebEx-specific CSV file template) that you created in step one. After you update the file, import the file back in to your WebEx site.

  

Create a WebEx-Specific CSV File Template

You can export a CSV file that contains the WebEx-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.

           
1    From the customer view in https://admin.ciscospark.com, go to Services.
2    In the Meeting section, click the link for your site or click View all, and then select a site from the list.
3    In the Actions column, click Bulk Modify User Attributes beside the WebEx-entitled site that you want to modify.
4    Click Export.  

While the export is in progress, you see the status "Exporting" in the Actions column. After the export process completes, the status changes to Export Results.

  
5    Click Export Results.
6    In the Export Results dialog, click Download.
7    Click Save File, and then click OK.
8    Navigate to the location where you want to save the file, and then click Save.

Batch Edit WebEx Settings and Privileges for Multiple Users

Use a spreadsheet editor such a Microsoft Excel to update the WebEx-specific CSV file template that you exported for your site.

  
Important:  

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 Excel and Keep the Leading Zeros.

  

When you save a CSV file, Microsoft Excel removes the leading zeros from all number codes. For workaround instructions, see Save a CSV File in Excel and Keep the Leading Zeros.

  
Before You Begin

Create a WebEx-specific CSV file template.

           
1    Use a spreadsheet editor to open the CSV file template.
2    Make the changes to the user settings and then save the file.
3    From the customer view in https://admin.ciscospark.com, go to Services.
4    In the Meeting section, click the link for your site or click View all, and then select a site from the list.
5    In the Actions column, click Bulk Modify User Attributes for the WebEx-entitled site that you want to modify.
6    Click Import.
7    Browse to the location of the updated CSV file, select the file and then click Open.
8    In the Bulk Modify User Attributes dialog, click Import.  

While the export is in progress, you see the status "Importing" in the Actions column. After the import process completes, the status changes to Import Results. After the import process completes, you can click Import Results to see a summary of the results.

  
Note        

Some attributes are common and read-only; during the import, the system ignores changes that you make to read-only attributes.

  
  

Open a CSV File in Excel and Keep the Leading Zeros

            
1    Open a new blank Excel workbook.
2    Select the Data tab.
3    In the Get External Data category, select From text.
4    Use Windows Explorer to browse to and to select the .CSV file, and then select Open.
5    Under Original data type, select Delimited, and then select Next.
6    Under Delimiters, select Tab, and then click Next.
7    Under Column data format, select Text.
8    Under Data Preview, select all of the columns.
Tip      

Select the first column, hold Shift while you scroll to and select the last column.

9    Select Finish.

Save a CSV File in Excel and Keep the Leading Zeros

         
1    With the 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, select the Format Cells: Numbers () icon.
4    On the Number tab, from the Category list, select Custom.
5    In the Type box, enter the number format, such as 000-000-0000 for a Phone number, or 0000 for a four-digit Host PIN.
6    Select OK.

Check the Import Results

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. A link to download the import results appears on the WebEx Sites page, in the Action column for the site. The error log is in the CSV file format and you can open it in a spreadsheet editor such as Microsoft Excel.

          
1    From the customer view in https://admin.ciscospark.com, go to Services.
2    In the Meeting section, click the link for your site or click View all, and then select a site from the list.
3    In the Action column for the site, click Import Results.
4    In the Import Results dialog box, click Download the import error log.  

The link to download the import error report appears only if errors occurred during the import process.

  
5    In the Save dialog box, click Save File, and then clickSave.
6    Navigate to the location where you want to save the file, and then click Save.
7    Use a spreadsheet editor to open the file.

WebEx-Specific Information Fields

The following table lists the fields (columns) that comprise WebEx-specific CSV files. The description for a read-only field specifically indicates that the field is read-only.

 
                                                                                                                                                                         

Field

Description

UserID

Read-only

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

 

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:

  • Y: The user account is active.

     

  • N: The user account in inactive.

     

If the field is empty, the default is Y.

FirstName

Read-only

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

 

LastName

Read-only

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

 

Email

Read-only

Specifies the user's email address.

Language

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

 

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

Language - ID

 

English: en-us

 

Simplified Chinese: zh-cn

 

Traditional Chinese: zh-tw

 

Japanese: jp

 

Korean: ko

 

French: fr

 

German: de

 

Italian: it

 

Castilian Spanish: es-me

 

Latin American Spanish: es-sp

 

Swedish: sw

 

Dutch: nl

 

Portuguese: pt-br

 

Russian: ru

HostPrivilege

Read-only

Specifies the type of user account. This field can contain the following account types:

 
  • HOST: Specifies that the user has a host account.

     

  • ADMN: Specifies that the user has a site administrator account.

     

  • ADMV: Specifies that the user has a view-only site administrator account.

     

  • ATTND: Specifies that the user has an attendee account.

     

If this field is empty, the default is the HOST account type.

MeetingPrivilege

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

 
Note      
  • To obtain a valid code for this field, see the Site Administration home page, which lists the Index values for each session type. However, if your site includes the Access Anywhere meeting type, do not type its code in this field.

     

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

     

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

     

    15,120

     

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

     

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

     

TelephonyPrivilege

  
Note        

Values specific to MeetingPlace are supported for WBS30 only.

  

(Optional) Specifies the types of teleconferencing services that the user can use when hosting a session. This field can contain one or more of the following values for an account, depending on the teleconferencing services that your organization's WebEx service supports:

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

     

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

     

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

     

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

     

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

     

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

     

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

     

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

     

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

     

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

     

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

 
Note      

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

 
  • CLIN, CLBK, VoIP

     

  • To determine which teleconferencing services your organization supports, refer to the Site Administration home page.

     

 
 

SCOptions

(Optional) Available for Support Center 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 leave this field empty, the value is left blank.

STComputers

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

 
Note      

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

 

Computer 1, Computer 2

 

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

TimeZone

(Optional) Specifies the index number for the time zone in which the user resides.

 

If you leave this field empty, WebEx uses the default time zone for the WebEx site.

PhoneCntry

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

 

If you leave this field empty, it defaults to 1.

PhoneLocal

(Optional) Specifies the user's phone number. Enter numbers only; do not include punctuation, such as dashes or periods.

 

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

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.

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.

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 you leave this field empty, it defaults to 1.

CellLocal

(Optional) Specifies the user's cell phone number. Enter only numbers; do not include punctuation, such as dashes or periods.

 

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

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.

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.

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

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.

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.

Pin

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

 

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

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.

TeleAcct1TollFree-Cntry

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

 
Caution      

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

TeleAcct2TollFree-Area

TeleAcct3TollFree-Area

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

 
Caution      

Do not add or edit data in these fields. If you export user account data, these fields 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

TeleAcct2TollFree-Num

TeleAcct3TollFree-Num

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

 
Caution      

Do not add or edit data in these fields. If you export user account data, these fields 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

TeleAcct2TollFree-IsTollFree

TeleAcct3TollFree-IsTollFree

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

 
Caution      

Do not add or edit data in these fields. If you export user account data, these fields 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

TeleAcct2Toll-Cntry

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

 
Caution      

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

TeleAcct2Toll-Area

TeleAcct3Toll-Area

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

 
Caution      

Do not add or edit data in these fields. If you export user account data, these fields 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-Num

TeleAcct2Toll-Num

TeleAcct3Toll-Num

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

 
Caution      

Do not add or edit data in these fields. If you export user account data, these fields 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

TeleAcct2Toll-IsTollFree

TeleAcct3Toll-IsTollFree

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

 
Caution      

Do not add or edit data in these fields. If you export user account data, these fields 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

TeleAcct2-SubAC

TeleAcct3-SubAC

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

 
Caution      

Do not add or edit data in these fields. If you export user account data, these fields 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-PartAC

TeleAcct2-PartAC

TeleAcct3-PartAC

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

 
Caution      

Do not add or edit data in these fields. If you export user account data, these fields 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

TeleAcct2RecordingDialOutNumFlag

TeleAcct3RecordingDialOutNumFlag

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

 
Caution      

Do not add or edit data in these fields. If you export user account data, these fields 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.

 

LabAdmin

(Optional) Applies to Training Center only. Specifies whether the user is an administrator for Hands-on Lab (Training Center).

 

If you leave this field empty, the default is N.

SchedulePermission

(Optional) Applies to Meeting Center, Training Center, and Event Center 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 service site as this user. To specify a user, type the user's email address exactly as it appears for the user's account.

 

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

 

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

PCNAcc1AutoGenerate

PCNAcc2AutoGenerate

PCNAcc3AutoGenerate

(Optional) Specifies whether the system automatically generates an access code.

 

This field can contain one of the following values:

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

     

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

     

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

PCNAcc1HostAccCode

PCNAcc2HostAccCode

PCNAcc3HostAccCode

(Optional) Specifies the host access code.

If PCN is not enabled, the value is left blank.

PCNAcc1TollFreeCallInNum

PCNAcc2TollFreeCallInNum

PCNAcc3TollFreeCallInNum

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

 

If PCN is not enabled, the value is left blank.

PCNAcc1TollCallInNum

PCNAcc2TollCallInNum

PCNAcc3TollCallInNum

(Optional) Specifies the backup toll call number.

If PCN is not enabled, the value is left blank.

PCNAcc1ILNum

PCNAcc2ILNum

PCNAcc3ILNum

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

 

If PCN is not enabled, 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.

WebcastBasic

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

 

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

WebcastVideo

(Optional) Allows Event Center users to stream video.

 

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.

 

SupportCMR

  

Read-only

(Optional) Specifies whether WebEx Meeting Center Video Conferencing is available for the user (Meeting Center only).

 
  • 1: Specifies that WebEx Meeting Center Video Conferencing is available for the user.

     

  • 0: Specifies that WebEx Meeting Center Video Conferencing is not available for the user.

     

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

SupportPR

(Optional) Specifies whether Personal Room is available for the user (Meeting Center only).

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

     

  • 0: Specifies that the user doesn't have a Personal Room.

     

 

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

SupportHQV

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

 

If you leave this field empty, the default is Y.

SupportHDV

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

 

If you leave this field empty, the default is Y.

VideoDeviceName1-5

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

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

VideoDeviceAddress1-5

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

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

DefaultVideoDeviceIndex

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

 

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

Time Zones

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

 

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

 

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

 

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

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

Table 1 Time Zone Index

Index

 

GMT

 

Name

 

Location

 

Standard

 

DST

 

0

 

-12 hr

 

Dateline

 

Marshall Islands

 
  

1

 

-11 hr

 

Samoa

 

Samoa

 
  

2

 

-10 hr

 

Hawaii

 

Honolulu

 

Standard

 

Daylight

 

3

 

-9 hr

 

Alaska

 

Anchorage

 

Standard

 

Daylight

 

4

 

-8 hr

 

Pacific

 

San Francisco

 

Standard

 

Daylight

 

5

 

-7 hr

 

Mountain

 

Arizona

 
  

6

 

-7 hr

 

Mountain

 

Denver

 

Standard

 

Daylight

 

7

 

-6 hr

 

Central

 

Chicago

 

Standard

 

Daylight

 

8

 

-6 hr

 

Mexico Central

 

Mexico City

 

Standard

 

Daylight

 

9

 

-6 hr

 

Central

 

Saskatchewan

 
  

10

 

-5 hr

 

S. American Pacific

 

Bogota

 
  

11

 

-5 hr

 

Eastern

 

New York

 

Standard

 

Daylight

 

12

 

-5 hr

 

Eastern

 

Indiana

 

Standard

 

Daylight

 

13

 

-4 hr

 

Atlantic

 

Halifax

 

Standard

 

Daylight

 

14

 

-4 hr

 

S. American Western

 

Caracas

 
  

15

 

-3.5 hr

 

Newfoundland

 

Newfoundland

 

Standard

 

Daylight

 

16

 

-3 hr

 

S. American Eastern

 

Brasilia

 

Standard

 

Daylight

 

17

 

-3 hr

 

S. American Eastern

 

Buenos Aires

 
  

18

 

-2 hr

 

Mid-Atlantic

 

Mid-Atlantic

 

Standard

 

Daylight

 

19

 

-1 hr

 

Azores

 

Azores

 
 

Summer

 

20

 

0 hr

 

Greenwich

 

Casablanca

 
  

21

 

0 hr

 

Greenwich Mean

 

London

 
 

Summer

 

22

 

1 hr

 

Central European

 

Amsterdam

 
 

Summer

 

23

 

1 hr

 

Central European

 

Paris

 
 

Summer

 

25

 

1 hr

 

Central European

 

Berlin

 
 

Summer

 

26

 

2 hr

 

Eastern European

 

Athens

 
 

Summer

 

28

 

2 hr

 

Egypt

 

Cairo

 

Standard

 

Daylight

 

29

 

2 hr

 

South Africa

 

Pretoria

 
  

30

 

2 hr

 

Eastern European

 

Helsinki

 
 

Summer

 

31

 

2 hr

 

Israel

 

Tel Aviv

 

Standard

 

Daylight

 

32

 

3 hr

 

Saudi Arabia

 

Riyadh

 
  

33

 

3 hr

 

Russia

 

Moscow

 

Standard

 

Daylight

 

34

 

3 hr

 

Nairobi

 

Nairobi

 
  

35

 

3.5 hr

 

Iran

 

Tehran

 
  

36

 

4 hr

 

Arabian

 

Abu Dhabi

 
  

37

 

4 hr

 

Baku

 

Baku

 

Standard

 

Daylight

 

38

 

4.5 hr

 

Afghanistan

 

Kabul

 
  

39

 

5 hr

 

West Asia

 

Ekaterinburg

 
  

40

 

5 hr

 

West Asia

 

Islamabad

 
  

41

 

5.5 hr

 

India

 

Bombay

 
  

42

 

5.5 hr

 

Columbo

 

Columbo

 
  

43

 

6 hr

 

Central Asia

 

Almaty

 
  

44

 

7 hr

 

Bangkok

 

Bangkok

 
  

45

 

8 hr

 

China

 

Beijing

 
  

46

 

8 hr

 

Australia Western

 

Perth

 

Standard

 

Daylight

 

47

 

8 hr

 

Singapore

 

Singapore

 
  

48

 

8 hr

 

Taipei

 

Taipei

 
  

49

 

9 hr

 

Japan

 

Tokyo

 
  

50

 

9 hr

 

Korea

 

Seoul

 
  

51

 

9 hr

 

Yakutsk

 

Yakutsk

 
  

52

 

9.5 hr

 

Australia Central

 

Adelaide

 

Standard

 

Daylight

 

53

 

9.5 hr

 

Australia Central

 

Darwin

 
  

54

 

10 hr

 

Australia Eastern

 

Brisbane

 
  

55

 

10 hr

 

Australia Eastern

 

Sydney

 

Standard

 

Daylight

 

56

 

10 hr

 

West Pacific

 

Guam

 
  

57

 

10 hr

 

Tasmania

 

Hobart

 

Standard

 

Daylight

 

58

 

10 hr

 

Vladivostok

 

Vladivostok

 

Standard

 

Daylight

 

59

 

11 hr

 

Central Pacific

 

Solomon Islands

 
  

60

 

12 hr

 

New Zealand

 

Wellington

 

Standard

 

Daylight

 

61

 

12 hr

 

Fiji

 

Fiji

 
  

130

 

1 hr

 

Central European

 

Stockholm

 
 

Summer

 

131

 

-8 hr

 

Mexico Pacific

 

Tijuana

 

Standard

 

Daylight

 

132

 

-7 hr

 

Mexico Mountain

 

Chihuahua

 

Standard

 

Daylight

 

133

 

-4.5 hr

 

S. America Western

 

Caracas

 

Standard

 

Daylight

 

134

 

8 hr

 

Malaysia

 

Kuala Lumpur

 

Standard

 

Daylight

 
 

Attachments

    Outcomes