Editing Various Field Types
The export format for various field types are the following:
|
Fields
|
Description
|
|---|---|
|
Text fields
|
Text fields are exported as-is to Excel.
|
|
Date Fields
|
Date fields are dates exported as native Excel dates in a cell and also imported from native date cells. The importer can also import a date from a string formatted cell; the date format is configurable on the importer Graphical User Interface (GUI).
|
|
Number Fields
|
The number and integer fields are exported as number or integer cells to Excel. A cell constraint only allows the appropriate double numbers and integer numbers to be entered in cells.
|
|
Boolean fields
|
Boolean fields are exported as a dropdown list with true and false as possible values.
|
|
Choice Fields
|
Choice fields are exported to the Excel document as the current value, represented by the choice’s text, and they only accept the possible values provided in a dropdown list  |
|
Multi-Value Choice Fields and Other Multi-Value Fields
|
Multi-value choice fields can be imported using various import data formats. For more information see Excel Multi-Choice And Multi-Value Import
|
|
Table Fields
|
Table fields are exported to Excel tables, and every row becomes a new row in the Excel sheet. The importer can also import such structured Excel files back.
|
|
User and Member Fields
|
The exporter exports the users and roles such as bond,[Developer]. The users are exported as their account names, the roles are exported as [<role-name>] text, and multi-values are separated by a comma (,).  When importing this field back, the importer will recognize the same format. The roles are searched in the same project where the target tracker is. |
|
Reference fields
|
Reference fields are exported as follows:
• [ITEM:8334] - v 7.4, where the [ITEM:8334] is the interwiki reference of the referenced item (it contains the type and the id number) and is followed by the name or short description of the referenced item.
• If multiple references are exported, they are separated using a comma (,), for example, [ITEM:8334] - v 7.4,[ITEM:8335] - v 7.5.
When modifying references in Excel, you can:
• Remove a reference by deleting its interwiki reference text, such as removing the [ITEM:8334] from the cell.
• Add a reference by inserting its interwiki reference, such as adding [WIKIPAGE:43] to the cell anywhere (the surrounding text is ignored).
• Use the [TESTCASE-1234] format for tracker-item references. This will look up the referenced item in the format of [${tracker-key}-${id}].
• Add a new reference by adding the name as the simple text of the referenced work item. For example, if the cell contains Banana in a reference field, the importer will try to search for the work item named Banana, and the reference field will point to that.
• The Excel import process does not consider the filter configured for the status or resolution value in a reference field with work or config item datasource. For more information about this behavior, refer to Limitations for the Status or Resolution Filter in Reference Fields
with Work/config items Datasource.
|
|
Wiki text fields
|
Wiki fields are exported using their wiki source, as Excel cannot represent them otherwise, for example, as rich text in cells.
For more information, see Why my wiki is exported as wiki source
|
|
Field length limitation
|
An Excel cell cannot contain more than 32000 characters. Therefore, the long text is truncated and is added to the end. This truncated text appears as orange and strike through.
It is in a read-only cell, which shows an error message if user tries to edit it. For example:  When trying to import such Excel data, the importer will automatically recognize truncated cells and ignore them, so the truncated data will not overwrite the full data. For example:  |
|
Read-only fields
|
Some fields are not editable. For example, when exporting a Submitted At field using round-trip, the Excel cell will be read-only.
|