Filter
Top Products
13-10
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 to set the
Files of Type field in the Open dialog
box, to .csv or to All Files (*.*) 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.