Batch Import and Export Users Options
Import Accounts for Cisco Unified MeetingPlace Users
Your Cisco Unified MeetingPlace implementation may include a directory service integration. In this case, MeetingPlace users can sign in to your WebEx (WBS30) site with a single sign-on, beginning on a MeetingPlace site.
For sites without the directory service integration enabled, you can import MeetingPlace user accounts into your Cisco Unified MeetingPlace site. You can import user accounts once you have exported the MeetingPlace accounts into a text (.txt) or comma-separated values (.csv) file.
Add or Edit Multiple User Accounts
You can import a CSV (comma-separated values) with new account information to add, or to edit multiple user accounts simultaneously. You export the user account information to a CSV file and then use a spreadsheet program such as Microsoft Excel to add or edit the information. After you complete all the changes, you import the CSV file back into WebEx. For Cisco Unified MeetingPlace users, you can also import a MeetingPlace-exported text (.txt) file.
|1||On the navigation bar, select .|
|2||Select Export. |
The page refreshes with the message that your batch export request is received. You receive an email notification when the request is complete.
|3||Select OK. |
The page refreshes to show the status of your export job and the request number for the job. You can stop the export by selecting Abort.
|4||On the Import/Export Users page or in the email notification, select Download exported csv file, and then select Save.|
|5||Navigate to the location, to which you want to save the file, enter a name for the file, and then select Save.|
|6||After the download completes, on the Download a CSV file window, select Close Window.|
|7||Use a spreadsheet program, such as Microsoft Excel, to edit the file. |
Microsoft Excel removes the leading zeros from all number codes when you open or save a CSV file. For workaround instructions, see Open a CSV File in Excel and Keep the Leading Zeros and Save a CSV File in Excel and Keep the Leading Zeros.
|8||On the Import/Export Users page, select Import.|
|9||Select Browse, navigate to the CSV file, and then select Open.|
|10||Select the Delimiter type.|
|12||Carefully review the information in the table to verify that you specified it correctly, and then select OK. |
You receive an email notification when the request is complete. Select the link in the notification email and carefully review and verify the information. If Site Administration reports errors, download the file to your computer, correct the errors, delete the last column, labeled Comments, and then import the file again.
Open a CSV File in Excel and Keep the Leading Zeros
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.|
Status of Your Import or Export
It can take a considerable amount of time to batch import or export. There is an Export and Import summary page that displays the status of the import or export. Batch jobs are placed in a queue and are run approximately every 5 minutes. The page is displayed after the export or import command has been selected and a file chosen. To refresh the status page, select the Import/Export Users link on the navigation bar. When an export job finishes, the status page displays a link to download the exported file. An email is also sent to the person who requested the batch job when the job finishes. The message has several important pieces of information: