Jira - Bug Tracking - Create Older Issues

Hello,

I just downloaded Jira to evaluate and use the same if it fits my requirements. Basically it fits most of my expectations and workflow. But i have few older projects with Issues listed in Excel, i would like to add those to Jira with the Created date as stated in excel (Which will be few months or days before). But i could not find an option to create an issue in Jira with the past dates.What ever i create by default it take current date.

Please advice how this can be done, so i can add all my older issues in Jira and see how it helps me.

Thanks,

Vishnu.

2 answers

Hi Vishnu,

There's no way to modify the creation date from a JIRA issue on the interface;

I suggest you to create a Date Picker custom field called "Excel Created Date" and then, on the CSV Import process, map this custom field with the correct row on Excel.

After that you can copy via database the data from the 'Excel Creaed Date' custom field to the 'created' column on the jiraissue table (you can also do it without the custom field, but it will be easier):

jira527=# select * from jiraissue where pkey = 'MTP-1';
  id   | pkey  | project | reporter | assignee | issuetype |    summary    | description | environment | priority | resolution | issuestatus |          created           |          updated           | duedate | resolutiondate | votes | watches | timeoriginalestimate | timeestimate | timespent | workflow_id | security | fixfor | component 
-------+-------+---------+----------+----------+-----------+---------------+-------------+-------------+----------+------------+-------------+----------------------------+----------------------------+---------+----------------+-------+---------+----------------------+--------------+-----------+-------------+----------+--------+-----------
 10804 | MTP-1 |   10203 | admin    | admin    | 1         | Test issue 01 | asdasdasd   |             | 3        |            | 4           | 2013-02-13 15:22:15.646-02 | 2013-03-29 15:39:31.373-03 |         |                |     0 |       1 |                      |              |           |       10813 |          |        |          
(1 row)

So, the update statement will be something like:

UPDATE jiraissue set created = (
SELECT datevalue from customfieldvalue where issue = (
SELECT id FROM jiraissue where pkey = 'MTP-1')
AND customfield = (
SELECT id FROM customfield where cfname like 'Excel Created Date')
)
where pkey = 'MTP-1';

('MTP-1' is the JIRA issue that I want to modify).

Just remember to perform a database backup before using this SQL.

Best regards,
Lucas Timm

Hi Lucas, just wondering... It's there any need to vote down the answer?

oh, my bad. Sorry for that.

Hi Vishnu, if I remember correctly you can configure your excel file to be a .csv and then do the import.

The first row will be the field and you can specify the column that will be created date so Jira can use that.

Have you read the documentation?

https://confluence.atlassian.com/display/JIRA/Importing+Data+from+CSV

I did this to import all the issues from other software (our own software).

Thanks a TON, Lucas & Ramiro. Your inputs really helped me a lot.

-Vishnu

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,308 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot