CSV import behavior for fields "Target start" and "Target end" are inconsistent based on User preference language

XMLWordPrintable

    • 1
    • Minor

      Issue Summary

      User try to import CSV file with fields "Target start" and "Target end", which are used in Advanced roadmaps.
      And user set the date value for these fields like "15/JUN/23" in CSV, as these require the date format 'd/MMM/yy' .

      Then, if user account preference language is Japanese, below error occurs:

      In Japanese:
      [ 無効な日付の形式です。日付は 'd/MMM/yy' の形式で入力してください。; 無効な日付の形式です。日付は 'd/MMM/yy' の形式で入力してください。 ]
      
      In English:[ Invalid date format. Please enter the date in the format "d/MMM/yy".; Invalid date format. Please enter the date in the format "d/MMM/yy". ]
      

      And if user try to import with different date format like "15/6/23", above error not occurs.

      If user account preference is English and date format is like "15/JUN/23", error not occurs.
      If user account preference is English and date format is like "15/6/23", above error occurs.

      These behavior is inconsistent.

      This is reproducible on Data Center: (yes) / (no)

      Steps to Reproduce

      1. User account preference language is Japanese
      2. Try to CSV import with date format "d/MMM/yy" like "15/JUN/23" for "Target start" and "Target end"
      3. Above error occurs and import failed

      Test files:
      Account preference language: Japanese > Result: Error
      CSV: CSVimport_Error-inJPN.csv
      Config file: Log_Error-inJPN.txt
      Log: Log_Error-inJPN.txt

      Account preference language: English > Result: Error
      CSV: CSVImport_Error-inENG.csv
      Config file: configurationFile-Error-inENG.txt
      Log: Log_Error-inENG.txt

      Expected Results

      Even the account preference language is Japanese, system should accept date format "d/MMM/yy"

      Actual Results

      Validation of date format for "Target start" and "Target end" are inconsistent based on user preference language.

      Workaround

      If user account preference language is Japanese, use date format like "15/6/23".
      If user account preference language is English, use date format like "15/JUN/23".

        1. configuration-Error-inJPN.txt
          1 kB
          R. Fujimura
        2. configurationFile-Error-inENG.txt
          1 kB
          R. Fujimura
        3. CSVImport_Error-inENG.csv
          0.1 kB
          R. Fujimura
        4. CSVimport_Error-inJPN.csv
          0.1 kB
          R. Fujimura
        5. image-2023-06-19-15-07-03-418.png
          143 kB
          Shaikh Ashif Iqbal
        6. Log_Error-inENG.txt
          0.6 kB
          R. Fujimura
        7. Log_Error-inJPN.txt
          0.7 kB
          R. Fujimura

            Assignee:
            Unassigned
            Reporter:
            R. Fujimura
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: