Configuration is performed by the Parasoft DTP administrator and only needs to be done once. 

Connecting DTP to CSV as an External System

1. Choose Report Center Settings from the settings (gear icon) menu and choose External System.
2. Click Edit Settings.
3. Enable the Enabled option.
4. Choose CSV from the System type menu.
5. Enter a name for the external system in the Name field. The name is required but does not affect the connection settings.
6. If your CSV files will be published on a server that requires authentication, enable the Authentication enabled option and enter your credentials in the Username and Password fields.
7. Click Confirm.

Associating Parasoft DTP Projects with CSVs from an External System

You can associate multiple projects in DTP with a CSV file, but you cannot associate the same DTP project with more than one CSV file. CSV files must be hosted on an HTTP server.

1. Choose Report Center Settings from the settings (gear icon) menu and choose External System.
2. Click Create Project Association.
3. Choose the DTP project that you want to use for this integration from the DTP Project menu.
4. Enter the URL to the CSV file from which DTP should draw data about the requirements in the External Project field.
   • The CSV file should be published on an HTTP server.
   • The name of the CSV will be what appears in the CSV Project field when configuring the CSV File widgets.
   • See CSV Requirements below for information concerning the format requirements of this file.
5. Click Create. 

The CSV file URL will be shown in the Project Associations table in the External Project column for easy review.

CSV Requirements

You will need to export basic information about your project requirements from your RMS into a CSV file. The first line of your CSV should be just the following column headers:

req-id,req-name,req-url

where:

• req-id is the requirement ID
• req-name is the requirement name
• req-url is the requirement URL

Each subsequent line should be data for each requirement, one requirement per line. The requirement URL is optional, but each requirement should have at least an ID and a name.

The CSV file needs to be placed on an HTTP server that DTP can access.

Advanced Configuration

If your CSV file contains column headers different from the default ones described above (req-id, req-name, and/or req-url) or it uses something other than a comma as a column separator, you can modify your DTP settings to ensure that it is parsed properly. To do so, edit the ExternalSystemSettings.properties file located in the <DTP_DATA_DIR>/conf directory and use the following property keys to specify your custom CSV column names and/or column separator:

csv.requirementId.columnName=<REQUIREMENT-ID-COLUMN-NAME>
csv.requirementName.columnName=<REQUIREMENT-NAME-COLUMN-NAME>
csv.requirementUrl.columnName=<REQUIREMENT-URL-COLUMN-NAME>
csv.columns.separator=<COLUMN-SEPARATOR>

Note: When setting the csv.columns.separator property, enter the actual character, not a text description. For example, if your CSV uses semicolons as a column separator, you would enter ; not semicolon.