Import from Excel
This topic provides reference information that may be useful when importing Work Items defined in Microsoft Excel.
Supported Work Item fields
Columns and data in Excel can be mapped to the following Work Item fields during import to Polarion. Please see following notes on mapping multivalued data to multivalued fields.
Assignee *
Author
Categories *
Comments
Custom fields *
Description
Due Date
Hyperlinks *
Initial Estimate
Linked Work Items *
Priority
Remaining Estimate
Resolution
Resolved On
Severity
Status
Time Spent
Title
An asterisk * character in the above list means the field supports import of multivalued data. Note that import of multivalued custom fields is supported for enumeration types only, not for primitive types, which can still be imported as single values.
Multivalued data and fields
It is possible to define multivalued data in Excel so that it can be mapped to multivalued fields in Polarion Work Items, and multiple values written to such fields during import.
The following fields must be written in a special format using a specific pattern:
Linked Work Items: pattern: "[role:][project/]id". External linked items pattern is: "[role:]URL".
Hyperlinks: pattern: "[role:]URL"