Dates are not properly imported from CSV file
プラットフォームについて: Cloud、Server、および Data Center - この記事はすべてのプラットフォームに等しく適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
症状
You are able to import all the data from a CSV file into Jira. However, the dates are not properly imported, either in a wrong format or completely skipped. It causes discrepancies on several fields (e.g. Resolved, Updated, Created).
原因
This error occurs because the format in which the dates are disposed in the CSV file doesn't match the date format chosen before starting the import.
ソリューション
If you have multiple date formats in the CSV file, it's best to convert all of them to only use a single format.
In the setup screen of CSV import, make sure you choose the right date format that matches exactly what you have in your CSV.
Be sure to look at the date in a plain text file and not Excel since Excel formats the dates in a standard way.
If you wish to import issue dates such as created, updated or resolved, make sure you select fields that are Issue Fields and not Custom Fields.
