Export Settings

Export a screen shot or a data log from the current bench application. To export a screen image or data from all connected instruments, use the global Export All operation from the BenchVue application.

Note: By default, export operations are stored in the "My Documents" folder on your computer and are organized by instrument type. For example – C:\Users\<user_name>\Documents\Keysight\BenchVue\DAQ\Exports\.

Export Preference Options – Global Setting

For most export operations from the DAQ application, you can set the global export data preferences by clicking the Options... button from the corresponding export dialog box . These are global settings and apply to all subsequent export operations.

Select Columns to Export - Select "Scan Number" to include the scan number in the export data. Select "Include Alarms" to include the alarm status information in the export data (0 = No Alarm, 1 = LO, 2 = HI).

Column Separator - For exports to CSV, select Comma (default), Semicolon, or Tab as the character used to separate the columns in the output data.

Time Stamp Type - Select the desired time stamp type as "Start Time" (time of day) or "Elapsed Time" (time since start of scan).

Include Configuration Options - Include or exclude the selected configuration details as part of the export operation. By default, all first three of the following options are selected.

Instrument Configuration - Include instrument details such as number of modules installed in the mainframe, model number of module installed in each slot, and total number of channels in the current scan list.

Channel Configuration - Include channel details such as channel name, function, range, resolution, Mx+B scaling information, and alarm information.

Scan Control Configuration - Include scan details such as scan start condition, scan interval, and scan stop condition.

Comment Text - To include user description in the file.

Instrument ACAL Info - Include auto calibration date, time, and temperature (DAQM907A only).

Calibration Info - Include calibration details such as calibration date, time, and temperature (DAQ970A/DAQ973A only).

Unstrained Info - Include unstrained channels details (DAQ970A/DAQ973A only).

Chart Annotation - Include chart annotation by using the drop-down button (DAQ970A/DAQ973A only).

Exporting a Screen Shot

You can export a screen shot of the bench application to (1) the Windows clipboard or (2) a PNG, JPEG, or BMP image file.

Below are the Export dialog details:

Export File Details

File Name - The default file name has a "Screen" or "Trace" prefix followed by a numeric index. For example, Screen 0.

To change the default name, click on the existing name to open the file name editor. You can edit the prefix name and also have the option to include or exclude the date, current time, and numeric index. The date is in the form yyyy-mm-dd and the time is in the form hh-mm-ss (24-hour time format). For example, Screen 2013-09-20 11-40-26 1 – September 20, 2013 at 11:40:26 with a numeric index of 1.

Export Path - The currently selected path for saving the file on your computer. To change the path, click Browse... and browse to a different path.

Export Options

File Type - Select PNG, JPEG, or BMP graphics file type.

Export Preference Options - Click the Options... button to set the export preference options. These are global settings that apply to all subsequent export operations.

Export to File - Click this button to export the screen shot to the specified file type.

Close - Click this button to close the Export dialog.

Exporting a Digitized Data

You can export a digitized data from the bench application to a .CSV file.

Export to CSV

Trace Data Summary

Channel ID - The instrument channel enabled.

Samples Count - The number of samples for each channel.

Trigger Count - The number of trigger count for each channel.

Number of Channels Selected - The number of instrument channels enabled.

Total Samples Count - The number of samples in the data file

Select by Channel - Export all scan data from the selected channels in the current scan list. Click "Select All" and "Unselect All" to select/unselect all channel numbers in the list

Column Separator - For exports to CSV, select Comma (default), Semicolon, or Tab as the character used to separate the columns in the output data.

Export File Details

File Name - The default file name has a "Trace" prefix followed by a numeric index. For example, Trace 0.

To change the default name, click on the existing name to open the file name editor. You can edit the prefix name and also have the option to include or exclude the date, current time, and numeric index. The date is in the form yyyy-mm-dd and the time is in the form hh-mm-ss (24-hour time format). For example, Trace 2013-09-20 11-40-26 1 – September 20, 2013 at 11:40:26 with a numeric index of 1.

Export Path - The currently selected path for saving the file on your computer. To change the path, click Browse... and browse to a different path.

Export to File - Click this button to export the digitized data to the specified file type.

Close - Click this button to close the Export dialog.

Exporting a Data Log

You can export a data log from the bench application to a file. After exporting, the corresponding application (Excel, for example) will automatically open and display the data. Click here to see an example of an exported data log.

The following options are available for exporting a data log:

Export to MATLAB

Trace Data Summary

Number of Channels - The number of instrument channels enabled.

Samples Per Channel - The number of samples per channel in the data file.

Export File Details

File Name - The default file name has a "Trace" prefix followed by a numeric index. For example, Trace 0.

To change the default name, click on the existing name to open the file name editor. You can edit the prefix name and also have the option to include or exclude the date, current time, and numeric index. The date is in the form yyyy-mm-dd and the time is in the form hh-mm-ss (24-hour time format). For example, Trace 2013-09-20 11-40-26 1 – September 20, 2013 at 11:40:26 with a numeric index of 1.

Export Path - The currently selected path for saving the file on your computer. To change the path, click Browse... and browse to a different path.

Export to File - Click this button to export the data log to the specified file type.

Close - Click this button to close the Export dialog.

Export to Microsoft Excel

Note: If the exported data exceeds the maximum number of rows and/or columns allowed by Microsoft Excel, the export operation will be split into multiple individual files.

Note: Due to charting limitations with some versions of Microsoft Excel, a chart will not be included in the exported Excel file for a data series containing more than 32,000 data points.

Trace Data Summary

Number of Channels - The number of instrument channels enabled.

Samples Per Channel - The number of samples per channel in the data file.

Select by Channel - Export all scan data from the selected channels in the current scan list. Click "Select All" and "Unselect All" to select/unselect all channel numbers in the list

Select by Function Type - The list is automatically populated with functions currently configured on the channels in the "Select by Channel" list above. When you select a function, all channels configured for the same function will be automatically selected in the "Select by Channel" list above.

Select Rows to Export

All Scans - Export all scan data from the start of the scan to the end of the scan.

Filter by Scan Number - Export the scan data filtered by the specified scan number range. Click "Set to Start" to select the first channel in the scan list as the "From" filter. Click "Set to End" to select the last channel in the scan list as the "To" filter.

Filter by Scan Start Time - Export the scan data filtered by the specified date-time range. Click "Set to Start" to select the beginning time of the scan as the "From" filter. Click "Set to End" to select the end time of the scan as the "To" filter. The date is in the form yyyy-mm-dd and the time is in the form hh-mm-ss (24-hour time format).

Data Reduction Option

Data reduction allows you to reduce the amount of unnecessary data exported. Click "Data Reduction Option" to select following options:

None - No data reduction option selected. All full scanned data is exported.

Export every Nth Scan Sweeps - When selected, only every Nth scan is exported. For example, with a specified N of 10, every 10th scan is exported. When N-Scan Sweep Average/Channel option is checked, only the average of every N scans is exported. For example, with a specified N of 10, the average value of every 10th scans is exported.

Export only Scan Sweeps that include an Alarm - Select this option to export scanned data that include an alarm. Enter number of Scan Sweeps before and after Alarm into the edit box.

Export File Details

File Name - The default file name has a "Trace" prefix followed by a numeric index. For example, Trace 0.

To change the default name, click on the existing name to open the file name editor. You can edit the prefix name and also have the option to include or exclude the date, current time, and numeric index. The date is in the form yyyy-mm-dd and the time is in the form hh-mm-ss (24-hour time format). For example, Trace 2013-09-20 11-40-26 1 – September 20, 2013 at 11:40:26 with a numeric index of 1.

Export Path - The currently selected path for saving the file on your computer. To change the path, click Browse... and browse to a different path.

Export Preference Options - Click the Options... button to set the export preference options. These are global settings that apply to all subsequent export operations.

Export to File - Click this button to export the data log to the specified file type.

Close - Click this button to close the Export dialog.

Export to Microsoft Word

Trace Data Summary

Number of Channels - The number of instrument channels enabled.

Samples Per Channel - The number of samples per channel in the data file.

Export File Details

File Name - The default file name has a "Trace" prefix followed by a numeric index. For example, Trace 0.

To change the default name, click on the existing name to open the file name editor. You can edit the prefix name and also have the option to include or exclude the date, current time, and numeric index. The date is in the form yyyy-mm-dd and the time is in the form hh-mm-ss (24-hour time format). For example, Trace 2013-09-20 11-40-26 1 – September 20, 2013 at 11:40:26 with a numeric index of 1.

  • If included, the date, time, and numeric index fields are automatically updated with each subsequent export operation from this bench application.
  • The date and time fields are based on your computer's internal clock setting.

Export Path - The currently selected path for saving the file on your computer. To change the path, click Browse... and browse to a different path.

Export to File - Click this button to export the data log to the specified file type.

Close - Click this button to close the Export dialog.

Export to CSV

Trace Data Summary

Number of Channels - The number of instrument channels enabled.

Samples Per Channel - The number of samples per channel in the data file.

Select by Channel - Export all scan data from the selected channels in the current scan list. Click "Select All" and "Unselect All" to select/unselect all channel numbers in the list

Select by Function Type - The list is automatically populated with functions currently configured on the channels in the "Select by Channel" list above. When you select a function, all channels configured for the same function will be automatically selected in the "Select by Channel" list above.

Select Rows to Export

All Scans - Export all scan data from the start of the scan to the end of the scan.

Filter by Scan Number - Export the scan data filtered by the specified scan number range. Click "Set to Start" to select the first channel in the scan list as the "From" filter. Click "Set to End" to select the last channel in the scan list as the "To" filter.

Filter by Scan Start Time - Export the scan data filtered by the specified date-time range. Click "Set to Start" to select the beginning time of the scan as the "From" filter. Click "Set to End" to select the end time of the scan as the "To" filter. The date is in the form yyyy-mm-dd and the time is in the form hh-mm-ss (24-hour time format).

Data Reduction Option

Data reduction allows you to reduce the amount of unnecessary data exported. Click "Data Reduction Option" to select following options:

None - No data reduction option selected. All full scanned data is exported.

Export every Nth Scan Sweeps - When selected, only every Nth scan is exported. For example, with a specified N of 10, every 10th scan is exported. When N-Scan Sweep Average/Channel option is checked, only the average of every N scans is exported. For example, with a specified N of 10, the average value of every 10th scans is exported.

Export only Scan Sweeps that include an Alarm - Select this option to export scanned data that include an alarm. Enter number of Scan Sweeps before and after Alarm into the edit box.

Column Separator - For exports to CSV, select Comma (default), Semicolon, or Tab as the character used to separate the columns in the output data.

Export File Details

File Name - The default file name has a "Trace" prefix followed by a numeric index. For example, Trace 0.

To change the default name, click on the existing name to open the file name editor. You can edit the prefix name and also have the option to include or exclude the date, current time, and numeric index. The date is in the form yyyy-mm-dd and the time is in the form hh-mm-ss (24-hour time format). For example, Trace 2013-09-20 11-40-26 1 – September 20, 2013 at 11:40:26 with a numeric index of 1.

Export Path - The currently selected path for saving the file on your computer. To change the path, click Browse... and browse to a different path.

Export Preference Options - Click the Options... button to set the export preference options. These are global settings that apply to all subsequent export operations.

Export to File - Click this button to export the data log to the specified file type.

Close - Click this button to close the Export dialog.

Auto Export at End of Scan

Two options available:
a) Perform export operation at the end of every scan - automatically export data log to MATLAB, Excel, Word, or CSV. You can select the default folder on your computer or click Browse... to browse to a different folder.
b) Perform export operation at the completion of every scan sweep (periodically) - only export data log to CSV is available in this option.