How to import issues from CSV into JIRA
Former user (Deleted)
Former user (Deleted)
Former user (Deleted)
Steps for importing Tasks and/or Epics into ITS PRO
Prepare Data
Prepare data for upload using Epic and Task Import List.xlsx
Save all prepared data as .xlsx. or .csv file
Create new seperate.csv file with subset of Epics or Tasks to try out upload
Try Upload Out
Download Epic Task Import List config file
Browse to Issue → Import Issues from CSV (contact its-pro@ucsd.edu for permission if it doesn't appear in the dropdown )
Specify .csv file and configuration file you want to use
Call out project you want to import tasks and/or Epics to
Since
It is always a good idea to test with 1 or 2 issues before importing all of them.
Always use Validate before Importing. If you see any errors, DO NOT import as your data will be imported incorrectly.
Known Issues:
Object type on Epics doesn't properly import the second value
For example if you entered "Document → Design Doc" under the Object Type column, only the "Document" will be imported. You will then need to go in and manually edit the Epic. If you are importing a lot of epics, you may reach out to an admin for help on the best way to do this.
If you don't use the Sample.txt configuration file, you will need to modify the Date time format on the screen when you select the project (the screen after you select the csv file)
Tips on the spreadsheet
Original estimate is in seconds.
Epic Name applies to Epics only
It also can be a copy and paste of Summary
Epic Link applies to Tasks only
It will be the Epic Name of the Epic
| File | Modified | |
|---|---|---|
|
Microsoft Excel Spreadsheet Task Import List.xlsx |
Jan 10, 2019 by Former user | |
| Jan 10, 2019 by Former user | ||
|
Text File Task Import List Configuration.txt |
Jan 10, 2019 by Former user | |
| Apr 29, 2019 by Former user | ||
| Apr 29, 2019 by Former user | ||
|
Microsoft Excel Spreadsheet Epic and Task Import List.xlsx |
Apr 29, 2019 by Former user | |
|
Microsoft Excel Spreadsheet Epic Import List.xlsx |
Apr 30, 2019 by Former user | |
|
PNG File image2019-6-24_16-21-9.png |
Jun 24, 2019 by Chris Ranglas | |
|
PNG File image2019-6-25_12-7-39.png |
Jun 25, 2019 by Chris Ranglas | |
|
PNG File image2019-6-25_12-11-14.png |
Jun 25, 2019 by Chris Ranglas | |
|
PNG File image2019-6-25_12-12-0.png |
Jun 25, 2019 by Chris Ranglas |
