Hello! I am attempting to use External System Import to update the Resolution Date for one issue in Jira (cloud). Steps: * Search for the issue in Advanced Search (issue = XXX-72) * Export to Google Sheets * Clear all columns except for KEY, SUMMARY, RESOLUTION, RESOLVED * Download as CSV * Open External Importer (I am a Jira Admin) * Choose file (.csv) and select Next * Select project, adjust date/time format to match the CSV, and select Next * Map KEY -> ISSUEKEY, SUMMARY -> SUMMARY, RESOLUTION -> RESOLUTION, RESOLVED -> DATE RESOLVED, select "Map field value" for each and select Next * Manually confirm and select Begin Import * Success message "None issues and projects imported." This is the message I get when the import is successful Here's where the issue is: in the CSV I had set the Resolved Date for 5/11/2022, but the issue in Jira now says 1/11/2022. This is different than the date that was listed before the import (3/4/2023), but not the date I put in the CSV. Any thoughts as to what is going on?

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; } } }

Jira Admin External System Import not updating Resolution Date correctly

Robb Robins_7k5n3b

Hello!

I am attempting to use External System Import to update the Resolution Date for one issue in Jira (cloud).

Steps:

Search for the issue in Advanced Search (issue = XXX-72)
Export to Google Sheets
Clear all columns except for KEY, SUMMARY, RESOLUTION, RESOLVED
Download as CSV
Open External Importer (I am a Jira Admin)
Choose file (.csv) and select Next
Select project, adjust date/time format to match the CSV, and select Next
Map KEY -> ISSUEKEY, SUMMARY -> SUMMARY, RESOLUTION -> RESOLUTION, RESOLVED -> DATE RESOLVED, select "Map field value" for each and select Next
Manually confirm and select Begin Import
Success message "None issues and projects imported." This is the message I get when the import is successful

Here's where the issue is: in the CSV I had set the Resolved Date for 5/11/2022, but the issue in Jira now says 1/11/2022. This is different than the date that was listed before the import (3/4/2023), but not the date I put in the CSV.

Any thoughts as to what is going on?

Accepted answers

Ashish Bijlwan_zogaqs

Hi @Robb Robins

Kindly refer https://docs.oracle.com/javase/1.5.0/docs/api/java/text/SimpleDateFormat.html for the Date Format for External System Import

Thank you,
Ashish

All comments

Ashish Bijlwan_zogaqs

Hi @Robb Robins

Kindly refer https://docs.oracle.com/javase/1.5.0/docs/api/java/text/SimpleDateFormat.html for the Date Format for External System Import

Thank you,
Ashish

Robb Robins_7k5n3b

Hi Ashish,

Thanks for the reply! My dates are formatted correctly, to my knowledge. Do you see something off?

Ashish Bijlwan_zogaqs

Hi @Robb Robins

Please check and change the format to d-m-yyyy (5-11-2022) instead of dd-MM-yyyy.

Follow the pattern as given examples

If date format is 2-1-2022use d-m-yyyy

else if 2-01-2022use d-mm-yyyy

else 02-01-2022 use dd-mm-yyyy

Robb Robins_7k5n3b

Following the pattern you show above results in the same result.

The issue still has 01/11/2022 as the resolved date. The CSV I am importing has 05/11/2022 as the value.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud