Support updating a read-only field during CSV import by concatenating two or more other fields
- Update to the existing VERA Data Import Utility
- User (requirement author) can import a requirement by using the VERA Data Import Utility and have a read-only field be populated by concatenating fields as configured in the Records Management Policy.
- User (requirement author) can update a requirement by using the VERA Data Import Utility and have a read-only field be populated by concatenating fields as configured in the Records Management Policy.
- VERA Data Import Utility will also prevent a user (requirement author) from importing a requirement that has a "Requirement ID" that is already used in the project by another requirement or is configured to be read-only.
- When the required source field (Name) is left blank in the CSV file the requirement will not be created/updated.
Figure: Import Summary confirms and display the expected import results
Field Contains Constraint
- A new constraint was added to VERA: "Field Contains". This constraint is designed to support looking up a particular value in a field. This constraint can be used in the Records Management Policy.
Figure: For this example, the constraint will evaluate to 'True' if the 'Approval Route' field contains the 'Level 2 (In Progress)' value. Otherwise, will evaluate as 'False'.
Field Is Unique Property
- A new field property was added to VERA: "Is Unique". This property is designed to prevent duplicated values for a particular field.
Figure: For this example, the 'CustomId' field should have unique values, otherwise, a warning message will be displayed to the user.