Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-25219

CSV Importer can't import Date properties with times

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 9.10-HF10
    • Fix Version/s: 9.10-HF24, 10.3
    • Component/s: CSV Importer
    • Release Notes Summary:
      Support for Date properties with times in CSV importer
    • Tags:
    • Backlog priority:
      650
    • Browser:
    • Upgrade notes:
      Hide

      Dates in CSV files must be formatted using the W3C format. More information on the W3C documentation.

      It is possible to use the old legacy date format (without time information) MM/dd/yyyy by setting the configuration property nuxeo.csv.import.legacyDateFormat to true:

      <require>org.nuxeo.ecm.csv.core.properties</require>
<extension point="configuration" target="org.nuxeo.runtime.ConfigurationService">
  <property name="nuxeo.csv.import.legacyDateFormat">true</property>
</extension>
      Show
      Dates in CSV files must be formatted using the W3C format. More information on the W3C documentation . It is possible to use the old legacy date format (without time information) MM/dd/yyyy by setting the configuration property nuxeo.csv.import.legacyDateFormat to true : <require> org.nuxeo.ecm.csv.core.properties </require> <extension point= "configuration" target= "org.nuxeo.runtime.ConfigurationService" > <property name= "nuxeo.csv.import.legacyDateFormat" > true </property> </extension>
    • Sprint:
      nxfit 10.3.8, nxfit 10.10.1
    • Story Points:
      5

      Description

      The CSV Importer specifies that "Dates must use the format MM/dd/yyyy". Thus timestamps cannot be used to accurately populate Date properties e.g. dc:created. This results in errors such as "Unable to convert field dc:created with value 2018-02-23T13:24:56.089Z".

        Attachments

          Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. NXP-26247 Fix CSV import with document properties

          • Blocker - Blocks development and/or testing work, production could not run.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-26283 Backport NXP-25219 to 9.10

          • Major - Major loss of function.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 3 hours, 30 minutes
                  1d 3h 30m