-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
Component/s: Import/Export - External System Import
-
None
-
1
-
Severity 3 - Minor
Issue Summary
When importing a CSV file into Jira Cloud using the External system import (CSV) feature, date values that contain Japanese AM/PM markers (午前 / 午後) fail to parse — even when the correct SimpleDateFormat pattern (yy/M/dd h:mm a) is specified in the import wizard's "Date format in import file" setting.
Steps to Reproduce
- Set your Jira Cloud profile language to Japanese (日本語).
- Set the Jira Cloud system default language to Japanese as well.
- Prepare a CSV file that contains a date value with a Japanese AM/PM marker (午前 or 午後).
For example:
Issue Type,Summary,Datetime Task,summary,25/3/26 10:22 午前
4. Go to System > External system import > Switch the old experience > CSV and import the CSV file.
5. In the import wizard, set "Date format in import file" to yy/M/dd h:mm a, which corresponds to the date format used in the CSV.
Expected Results
The date format pattern yy/M/dd h:mm a correctly matches 25/3/26 10:22 午前, and the date field is imported successfully.
Actual Results
The date fails to parse, and the following warning is logged during import:
Unparseable date: "25/3/26 10:22 午前"
Workaround
Replace Japanese AM/PM markers in the CSV with their English equivalents before importing.
- Before (fails):
Issue Type,Summary,Datetime Task,Summary,25/3/26 10:22 午前
- After (works):
Issue Type,Summary,Datetime Task,Summary,25/3/26 10:22 AM
- is related to
-
JRACLOUD-80353 [Tracking in issue links] Date time format issues (system, custom, all views and inputs)
- Gathering Interest