Contents > 4 The SDMetrics User Interface > 4.15 Exporting Data > 4.15.1 Exporting Data Tables
4.15.1 Exporting Data Tables
Figure 23 shows the export dialog for data tables.
Figure 23: Data Export Dialog
To specify the export, you have a number of options:
Select export to one file or separate files. Usually, you will
have several data tables, one for each element type. Here you
specify if you want to store all tables in one file, or have each
table written to a separate file.
Sanitize data. This option is only applicable to the data tables
of the metric data tables view. The first table column of those tables shows the
names of the design elements that were analyzed. Check this option to
suppress the output of the element names. This can be useful if, for
confidentiality reasons, you want to pass on or publish the metric
data without disclosing the element names.
Select the file name. Enter the name of the file to write the
data to. If you chose to export the data to separate files, the name
you enter here will serve as a base name for the files created.
Example: You have tables for classes, packages, and interfaces, and
enter "data" as file base name. This will create three
files:
- data_Class.txt
- data_Package.txt
- data_Interface.txt
The file base name is extended with an underscore and the name
of the model element type the file contains.
Select the file format (Files of type). The following formats
are available from the "Files of type" dropdown menu:
- Tab-separated text.
Writes the data to text files with ".txt" file
extension. Columns are separated by tabs, the first row contains the
metric names. This format can be read by most spreadsheet software and
statistical packages.
- Comma-separated vectors.
Writes the data to text files with ".csv" file
extension. Columns are separated by commas, unless you specified
a different delimiter, see Section 4.16.3 "Output".
- HTML.
Writes the data to HTML files, using HTML tables.
- OpenDocument Spreadsheet
Writes the data to .ods files.
This format is used by OpenOffice.org 2.x and many other office solutions.
- Excel XML File
Writes the data to .xml files for Microsoft®
Excel™ XP or later.
- OpenOffice.org Calc
Writes the data to .sxc files for
OpenOffice.org 1.0 Calc or later.
Note: To import a set of tables in a single Excel 2000
workbook with each data table on a separate worksheet:
- Activate the "Create Microsoft Office 2000 XML code in HTML output files"
option in the output preferences dialog (Section 4.16.3 "Output").
- Export the tables to separate HTML files. This will also create two
additional HTML files with extensions "_index.html" and
"_framenav.html" that define a frame set.
- Open the file with the
extension "_index.html" in Excel (or drag and drop the file
into the Excel window). Excel may pop up a message dialog that can be
ignored, just press "Yes" to complete the import.