Importing data

You can import work items of a certain type from a CSV file to the opened board.

In order to import data to the currently opened board press the main menu button in the left top corner and then select Open and then Import. Press Import from CSV button and select the file. The selected file must have .csv extension. If this is not the case you will get a message:

If the input file starts with a line specifying the list separator this separator will be taken into account, otherwise the separator will be guessed from the content of the file.

The input file may start from the header line. The tool will ask you if it is the case.

Press Yes or No depending on the file content. Now, the content of each column will be analyzed separately to determine what is its possible data type. Then, the following dialog is shown:

If the input file contains a header the columns are identified by their names. If header is not present then the column is identified by the content of its first row and the dialog looks differently:

If the content of the first row does not give you enough information to recognize the column then you can press Extra data button to see the rest of the column.

The assumption is that all lines of the input file will be imported as work items of the same type. Thus, if a teamboard has more than one work item type you must select what type will be used.

The columns from the input file are shown as rows in the dialog. On the left hand side, you have the input column identifier, on the right hand side there is a drop down list where you can select the corresponding field of the selected work item type. To perform the import at least the title field must be mapped to one of the columns (it is the Summary field in the dialogs above). Map the other columns to the fields if you wish and press OK. The work items from the file will be added to the currently opened teamboard.