Adobe-Consulting-Services / acs-aem-commons

http://adobe-consulting-services.github.io/acs-aem-commons/
Apache License 2.0
454 stars 602 forks source link

Data Importer does not set time properly #3437

Open EAVilleda opened 1 month ago

EAVilleda commented 1 month ago

Required Information

Expected Behavior

I am trying to use the Data Importer to create pages with date properties. Going by what is mention in the documentation, I assumed "A representation of date and time" should work.

Actual Behavior

The dates are properly being set, but the time is set to midnight. I have the column header set as "jcr:content/eventTime@date". I have tried entering the data "2024-10-15T17:00:00.000-05:00" as a General cell, "2024-09-15 17:00 +00:00" as General cell, and "2024-09-15 17:00 +00:00" as Date cell. The time is always zeroes, such as "2024-09-15T00:00:00.000-05:00".

If time is not meant to be imported (so it would be a feature request), I can maybe work on this in the future. I just want to be sure my issue is not caused by user input.

Steps to Reproduce

  1. Create a spreadsheet to create a new page, including a column for date property such as "jcr:content/eventTime@date".
  2. Use the Data Importer, be sure to include jcr:content nodes.
  3. Uncheck dry run and start.
  4. Confirm page was created.
  5. Check the date property. It should have the entered timestamp. (If the dialog field does not show both date and time, check in CRXDE.)

Links

I unfortunately do not have time to provide a package using we-retail pages. But hopefully this can be simply answered rather than need testing.