Data Export

This topic provides information about exporting data for use in other applications.

In this topic:

Exporting Data

You are limited to exporting 60 columns of data that display in the upper pane. Databases have limitations as well. Verify that the application in which you intend to use the exported data can accept all 60 columns. Exported data can be imported into Microsoft Access, Microsoft Excel, or other applications.

To export data that can be imported into other applications, do the following:

1. Select a folder from the folder tree or in the upper pane on the Folder tab.

2. Click a component tab.

   If you are exporting specific items in the upper pane, also select the specific items.

3. Right-click in the upper pane and choose Advanced > Export from the context menu.

   Note: For the Audit component only, select Export from the context menu. This opens the Export dialog box.

4. Move the fields you want to export from the Available fields list to the Show these fields in this order list.

   Move them in the order you want them presented in the target application.

5. Specify which items to export in the Export for group.

   You can export selected items or all items in the upper pane.

6. Select the desired export options in the Options group.
7. Type a path and filename in the Output file name field, or browse to an existing file to overwrite it.

   Note: Use .txt as the filename extension, or another extension which the target application can import. By default, the file is assigned a .txt extension.

8. Click OK.

   The export file is generated.

9. Open the target application and import the exported file.

   Print a report if desired.

Back to top

Export Options

Use the Export dialog box to export data to a text-delimited file for import into other applications

To specify export options, open the Export dialog box. Right-click in the upper pane and choose Advanced > Export.

Below are the fields and options in the Export dialog box.

Available Fields	Lists all the fields displayed as columns in the upper pane which are available for export. You are limited to displaying 60 columns in the upper pane, and therefore, are limited to exporting 60 columns of data. The target application must be able to import the number of fields you are exporting.
Advanced Fields	Displays the advanced fields in the Available Fields list.
Show These Fields In This Order	Lists the fields you selected for export. The fields will be exported in the order they appear in this list.
Current Selection	Specifies that the export should only include the items currently selected in the upper pane on the active component tab .
All Items	Specifies that the export should include all the items in the upper pane on the active component tab.
Export Field Names	Includes the column header fields for the report.
Replace Embedded Carriage Returns With Spaces	Exports the data without embedded carriage returns/line feeds.
Text Qualifier	Specifies the text qualifier to use at the beginning and end of text fields for preventing the special treatment of carriage returns/line feeds and other special characters that occur in HTML output.
Delimiter	Specifies the character to use to separate the data fields in the exported text file. You may enter a custom delimiter or choose from the predefined list.
Encoding	Specifies the encoding to use for the exported data.
Output File Name	Specifies the location and name of the output text file. The file must have a .txt extension, or another extension the target application will import. The default extension is .txt.

Back to top

Data Export with Datamart

StarTeam Datamart is a complementary product to StarTeam Server. StarTeam Datamart uses the StarTeam SDK to communicate with StarTeam Server to create a reporting database that you can use with popular third party reporting applications such as Crystal Reports and Business Objects (reporting applications are not included with StarTeam Datamart ).

StarTeam Datamart extracts data from a StarTeam server and places the data into a relational database, where reporting tools can access it. The data is stored in meaningful text instead of IDs.

StarTeam Datamart can extract information from every project, every view in each project, every folder in each view, and every item in each folder, as well as labels, links, and history for each item. You can restrict the extracting to a particular project and view, and also restrict to extract only for certain tables.

A sample Business Objects universe and sample reports in both Business Objects and Crystal Reports formats are included. These samples can be used as a basis for creating custom user defined reports.

Datamart Extractor	Extracts the data from a StarTeam Server and puts the data into a relational database. For StarTeam administrator use.
Datamart Synchronizer	Opens the universe and synchronizes the data to reflect any field changes. For StarTeam administrator use.

Back to top