Importing & Exporting Requirements

Note: The features below are intended to primarily function with the Violet Requirements Module. If you intend to continue utilizing your existing requirements tool (e.g., DOORs, Jama, Valispace, etc.), you should establish an Integration between your tool and Violet to permit synchronization of changes.

Importing Requirements to Violet Requirements Module

After creating the destination Program, import requirements from any CSV file and map your existing fields to Violet Requirement fields.

Mapping CSV Columns to Requirement Attributes

When importing requirements from a CSV file, you will be able to map attributes of your existing requirements to the fields used in Violet Requirements. The most common ones are:

• Requirement ID

• Name

• External URL (to aid in navigating back to an external requirements tool, e.g.)

• Requirement Statement

• Requirement Approval Status

• Verification Method(s) (comma separated)

• Systems (comma separated)

  • Note: Systems will be created for you automatically as part of the import process. You can then manage, edit and nest them within the corresponding Program page.

• Owner(s)

• Approver(s)

If you wish to include additional attributes, you can optionally configure them prior to performing the import process (see Custom Fields). Or, Violet will automatically create new custom attributes for any unmapped columns for you.

Configuring Parent/Child Hierarchy for Import

Violet supports two approaches for capturing parent/child relationships between requirements during import: via Parent ID or Hierarchy Levels.

Your CSV file can be configured to support one of these options:

1. Parent ID: Include a Parent column in your sheet that indicates either:

   1. the Requirement ID of the parent requirement (exactly as it is listed elsewhere on the same CSV), or

   2. a delimited list of the Row IDs of the parent requirements (e.g., ROW-1, ROW-2)

2. Level: Include a Level column with a delimiter indicating hierarchical levels (e.g. 1.2.1).

We recommend consolidating all requirements into one CSV for import.

Export Violet Requirements

Violet Requirements can be exported to Excel or CSV as tables, or to a Word document. The export process is conducted from Violet's Tabular View.

1. Configure Requirements Attributes to Include in Export

   • In the tabular view, show the columns you wish to include in the exported view and hide the columns you do not want to export.

2. Select Requirements to Export

   • Use the checkboxes to select one or more requirements from the current view to include in the export (or select the top-most checkbox to select everything).

3. Initiate Export

   • Select the Export Requirements button located on the main toolbar to export to .csv, Excel or Word.

   • Alternatively, to export to CSV or Excel, you can right click on the requirements and choose "Export" or "Export Selected Rows." You will not have the ability to able to customize the filename or add a timestamp before downloading using this method.

4. Edit Exported File Name and Choose Format In the Export Requirements window:

   • Set a filename for your export. Use the check box to add a timestamp to the filename.

   • Use the dropdown arrow to choose a file format from the dropdown: .csv, .xlsx, or .docx.

5. Customize .docx Export (Optional)

   1. If exporting to .docx, you can choose to include Cover Page, Table of Contents, Header and Footer, Link to the Violet Requirement

   Note: Only individual requirement attributes will be included in the document. Parent folders are excluded.

6. Click Export to begin downloading the file.