nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can you import dates into Created and Updated

Ste404

Hi there,

I am trying to import some incident data via a CSV into JSM. I want to update the created and updated date but can't get them to stick.

I have checked and the date format in the csv d/mm/yyyy hh:mm is the same as Jira (I exported some issues) as well as in the import screen I am setting the date to be the same format.

There are no errors, I am just getting the current date and time of the import in the created and updated fields.

Any suggestions with this?

Accepted answers

Nic Brough -Adaptavist-

You can only set the created date when importing new issues. It's not editable in existing issues because it would be inaccurate to let you do so.

The updated date is a little different - it's calculated from the last change to the issue - in the code on server, it actually does import it. But then it sets it to "now" because the import is an update!

Jira doesn't hold emails, but I think you mean the email address of the requestor. It doesn't store that either, it expects the email address of the requestor to be in the directory entry for the requestor (reporter)

If your requestor/reporter does not exist in your user list, then the reporter field won't be set, but you could create a text custom field to import the requestor email address.

All comments

Ste404

Also, if an issue has been emailed in by a project customer, where is Jira holding that email.

This data has some customer records (requester and requestor email). Requester I am mapping to reporter, but not sure what to do about the email?

Nic Brough -Adaptavist-

You can only set the created date when importing new issues. It's not editable in existing issues because it would be inaccurate to let you do so.

If your requestor/reporter does not exist in your user list, then the reporter field won't be set, but you could create a text custom field to import the requestor email address.

unknown

Either you import via CSV or JSON, Jira will save only the updated date. So there's no way to add two dates due to the Jira's processes.

Ste404

ok thanks. I have the created date working fine now so that is good and duh of course, why didn't I realise the updated date would be the date the record was created / updated in Jira.. facepalm moment there.

The email is a tricky one, will need to look at that more and yeh maybe store a specific email field for those ones where there is no stored 'reporter'.

Thanks

james.maida

It's not clear on updating dates when importing. I had to revise the resolved dates and hte import correctly did that but unfoirtauintely changed all the updated dates to the date of the import. If I want to revise only the updated date now is that possible? I've tried several imports and I was unable to change the updated date to the date listed in the CSV file.

I beleive when importing - it will not change the updated date to anything other than the date of the import. Any other methods for changing the updated date?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management