I have spent a day trying to import events with date/time fields from a csv file and still cannot get it to work, even after applying the patch in #722740: Feeds Date mapper converts imported dates to GMT unless in UNIX timestamp format.

Finally, I converted the dates, which need to be US eastern time, to Unix timestamps. But even then the data inserted into the db is off by 1 hour during daylight time. The field is set to use the site's timezone, and dates entered directly into new nodes work fine. I am using the most recent dev version of date with the patch from #998076: Problem with timezone handling (caused by date_get_timezone_db returning only UTC).

It appears that the importer is doing a conversion even when it is fed a Unix timestamp, which should require no manipulation.

Comments

rsbecker created an issue. See original summary.

MegaChriz’s picture

MegaChriz CreditAttribution: MegaChriz at WebCoo commented
Status: Active » Postponed (maintainer needs more info)

First, can you try the latest dev version of Feeds and check if the problem is still in there? There have been more date related fixes in dev, for example: #2225019: Make FeedsDateTime stringable..

If the problem is also present in the dev version, can you bundle the configuration you have in a feature module and provide a sample source file? That would make it easier to replicate the problem.

The feature module should ideally contain the following:

  • Your Feeds importer
  • Feeds Tamper configuration (if used)
  • The content type selected on the processor
  • Field bases of fields used on your content type
  • Field instances of your content type
  • Strongarm variables belonging to your content type (install the Strongarm module to make them available).
  • Strongarm variables that contain date/timezone configuration (starts with "date_").
  • Eventually other exportable configuration that is related.

Also tell me which value you expected to be shown after import and which value is shown in the end, for example:

Expected to be shown on the node page: August 4, 16:14.
Actual: August 4, 15:14