Obtaining the Import Spreadsheet

To import configuration data into a system database, it must be saved in . Comma Separated Values. A type of database file that separates data fields with a comma.csv format. The Import Spreadsheet is designed to make it easy for you to collect and save the import data. Using the Import Spreadsheet, you can easily verify and save data in . Comma Separated Values. A type of database file that separates data fields with a comma.csv format, simply by clicking the buttons provided.

To prepare data for import, you have two options:

• Collect and save configuration data directly in the Import Spreadsheet
  or

• Save an existing spreadsheet of configuration data in . Comma Separated Values. A type of database file that separates data fields with a comma.csv format.

If you wish to save an existing configuration file in .csv format, you do not need a copy of the Import Spreadsheet. See Preparing an Existing Spreadsheet for Import for more information.

Accessing the Spreadsheet

You can obtain a copy of the Import Spreadsheet from the System Administration Tool.

• Notes:

• You need Microsoft Excel® 97 (SR-2), Excel 2000 (SP 3), Excel 2003 (SP 2) or higher installed on your client station to read the Import Spreadsheet.

• You need a archive application such as WinZip® installed on your client station to open the Import Spreadsheet form after downloading it.

To download the Import Spreadsheet from the System Admin Tool

1. From any form that supports Import. (See Overview of the Import Process for a list forms that do not support Import.)
   Click Import.

2. From the Import dialog box, click download a copy of the Import Spreadsheet.

3. Click Save to save the .tar file to your PC.

4. Open the .tar file using WinZip.

5. Extract the .xls and .txt files using WinZip to the same directory, then launch the spreadsheet (.xls file) from that directory. This ensures that all columns are present in the spreadsheet. The columns correspond to the fields in the System Administration  Tool forms and are derived from data contained in the .txt file.

CAUTION: You must extract both the .xls and .txt files to the same directory before opening the spreadsheet (.xls) file. Otherwise, you will not get the latest version of the spreadsheet.

6. Proceed to Collecting and Recording Data.

To download the Import Spreadsheet from the 3300 ICP Installation CD:

1. Navigate to the following file directory: Tools\ImportSpreadsheet\

2. Proceed to Collecting and Recording Data.

• About Importing User and Device Data

• Overview of the Import Process

• About the Import Spreadsheet

• Creating an Import File for New Users and Devices

• Previewing and Importing the Spreadsheet

• Troubleshooting Import Issues

• Create Profiles with the User and Device Configuration Form