Import from CSV

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: if you haven't previously established systems, they 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.