CSV import fails to parse Japanese AM/PM markers (午前/午後) in date fields

XMLWordPrintable

    • 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

       

      1. Set your Jira Cloud profile language to Japanese (日本語).
      2. Set the Jira Cloud system default language to Japanese as well.
      3. 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 

       
       
       

              Assignee:
              Unassigned
              Reporter:
              M.Shimizu
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: