I have a simple csv file I'm trying to import with feeds. Most of the fields are going in just fine, but the dates are failing. And after following the process through in a debugger, I cannot see why this fails - the date exists when Feeds saves the node, so why does this fail?.
Above: This screenshot of my debugger shows that entity has date information immediately after entitySaved is called. I cannot detect anything unusual about the object format - looks kosher. The date was added as the
field_deadline_proposals:end. A date can be a range, so I assume this is the proper way to save a single date (non-range).
Above: This is a screenshot of the database table for field_deadline_proposals immediately after node save. Node 258 does not have the information I expect.
This is the relevant excerpt from my csv doc, with headers:
id,rfp_num,description,title,published,rfp_filename,response_deadline,QA_deadline,mod_date,create_date 4,034-009 Robinson Pkwy,"Robinson Pkwy -Walkthru 6/22/09 9:30am. Log onto the website for more information. Due date has been moved to 7/6/09 11:00am",TRUE,RFP_034-009 Robinson Pkwy_034-009_doc.pdf,7-6-2009 11:00,29-06-2009 13:00,7-1-2009 13:50,19-06-2009 9:29
My dates are currently in
d-m-yyyy hh:mm format, which seems to work just fine and was recommended in this related post. Frankly, I don't think the date format it much of an issue - I have had success with other formats, including using feeds_tamper to convert the date to UNIX timestamps. In all cases, though, the save fails, so I suspect some other issue :-/