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.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
oh, my bad. Sorry for that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.