3Com VCX Connect Installation And Configuration Manual

Also see for VCX: Quick reference guide Guide Guide Guide

Contents

3Com VCX Connect Installation And Configuration Manual Manual pdf 44 page image

44 CHAPTER 3: C ONFIGURING IP TELEPHONYFile Formats3Com suggests that users create a Microsoft Excel spreadsheetcontaining the user information. Alternative file formats includecomma-separated value files and tab-delimited value files. Both of thesecan be created by exporting data from the Microsoft Excel spreadsheet.CAUTION: You cannot import data from an Excel Spreadsheet if thespreadsheet contains any Excel formulas. If you have used formulas togenerate any of your data (for example, extension numbers), you must:■ Remove all formulas from the spreadsheetOR■ Export the spreadsheet to a comma-separated value file or atab-delimited file.In a Microsoft Excel spreadsheet, each user is defined by a separate row inthe spreadsheet. Each row contains several columns, some of which arerequired and some of which are optional. To leave a user parameterundefined, leave the corresponding cell in the table blank.Resource Files The VCX Connect server includes the following sample files in the/opt/3com/downloads directory.The Import Data tool in the VCX Central Manager interface loads any ofthe following files and creates VCX telephone extensions and associateduser data based on the content of the files.■ VCX-Connect-Sample-import-file.xls – This file contains user datawithin a Micrsoft Excel spreadsheet file.■ VCX-Connect-Sample-import-file.csv – This file contains user data,separated by commas.■ VCX-Connect-Sample-import-MAC.xls – This Excel file contains asubset of the user data (user name, telephone extension, telephoneMAC address, and MAC lock indicator). Importing this file updates thespecified users and ties one telephone (per line in the file) to a user byspecifying the MAC address of the telephone. A user can have morethan one telephone tied to their name.■ VCX-Connect-Sample-import-MAC.csv – This comma separatedvalue file contains a subset of the user data (user name, telephoneextension, telephone MAC address, and MAC lock indicator).