First you need to export you data from Jira. To do so, go the a project, select "Issues and flters" and click on advanced search. Now select "Advanced Search". Afterwards an "Export" button should appear at the top right corner. Select the option "Export Excel CSV (all fields)" and download the .csv file.
You can open the .csv with excel, but all the data will be in one column. You can change that by performing the following steps:
- Select the column with the data
- Go to "Data" and "Text to Colums"
- Select the option "Delimited" in the pop-up
- Select the option "comma" and select "finish"
The content will now be in different columns, from where you can copy the content to the awork import template. The field-mapping is the following:
|Project name||<->||Project Name|
|Client||<->||Field is not available in the Jira-Export|
|Type of Work||<->||Issue Type|
|Start Date||<->||Field is not available in the Jira-Export|
|Due Date||<->||Due Date|
|Planned Effort||<->||Original Estimate|
Now you can import the data into your workspace, as described here.