Introduction
Use cases
Import a lot of external properties.
Import external properties from external tools (like such as testing tools, internal systemsapplications, etc.).
How to import external properties?
To import external properties from Excel spreadsheets:
Navigate to the
Import
tab
...
Import template
...
Successful import
...
Failed import
...
Imported files
...
Limits
The .
Drag and drop or click the dropzone to upload your files.
...
How to download a sample spreadsheet?
To download a sample spreadsheet:
Navigate to the
Import
tab.Click the
Download
button.You can use it as a starting point to import your data.
...
What’s the expected format for spreadsheets?
For now, the import template is fixed:
You cannot select the columns to import.
The first row must contain the column names.
The first column must contain the requirement keys.
All the following columns must contain external property valuesThe following non-empty columns must contain the external property values.
For external property columns, the first row must contain the external property name.
The first column must contain the requirement keys.
...
How does the import work?
The external properties are imported into the current space.
The external properties are imported into the current variant.
When a cell is empty, the corresponding external property is removed.
Existing external properties are overridden.
How to find out more about the imports?
When you import files, a temporary history of imported files is displayed.
...
Successful import
When a file is successfully imported, you can check the details to find out how many external properties were created, updated or removed.
...
Failed import
When a file import fails, you can check the details to find out more about the reason for the failure.
...
Limitations
For now, only external properties can be imported.
External properties can only be imported to the current space.
External properties can only be imported to the current variant.
We only support .XLS and .XLSX files.
We limit the size of the spreadsheet to 10 MB.
We limit the number of columns to 200 columns per spreadsheet.
We limit the number of rows to 1000 rows per spreadsheet.