Finisar Surveyor manual Exporting Counter Log Files to Excel

Surveyor

User’s Guide

networks. Surveyor exports data into a special .csv file format that can be easily read by the Optimal Performance product.

Perform the following steps to export data to Optimal Performance format:

1.Select Application Layer Matrix from the Monitor View or Capture View menus.

2.Select the Table tab to view the data in tabular format.

3.Choose View Options from the View menu. Using the check boxes, select six additional columns to display:

Station Address 1 Station Address 2 Frames 2 --> 1 Frames 1--> 2 Bytes 1 --> 2 Bytes 2 --> 1

4.Choose Export to Optimal Performance from the File menu.

5.Enter the file name in the Save As dialog box. Table views will automatically be saved in Optimal CSV format and the file is given an extension of .csv.

6.Click the Save button.

Surveyor logs both a start and stop time to the .csv file. The start time is the time the table/chart window is first opened and the stop time is the last time the file is exported or saved to disk.

Exporting Counter Log Files to Excel

Use these steps to view the counter data in the log files as Excel™ 5.0 graphics. The Excel template, charts.xlt, is located in the ...\examples directory.

1.Start Excel 5.0 and open charts.xlt. You should see an empty worksheet called “Data Sheet”. Worksheets are named using tabs at the bottom of the Excel rows and columns.

2.Open the log file. Remember box, to .csv or to All Files (

to set the Files of Type field in the Open dialog *.*) so you can see the log file.

3.Select the entire worksheet. Move the mouse to the small button at the top left corner of the worksheet. Click the button to highlight everything on the worksheet.

4.Use Copy from the Edit menu or Ctrl + C to copy the contents of the worksheet into the Windows clipboard.

13-10