I try to import a csv (or excel with feeds_xls) with a title-, date- and body field in Drupal 7. The date has a calendar widget
When imported the date is empty. I think because of the difference in notation:
English: Y/m/d H:i
Belgian: d/m/Y H:i
My client has to be able to use the Belgian (EU) notation. He or she puts it in the .csv like this:
d/m/Y
for example: 19th of August 2016 becomes a string:
'16/8/2016'
I have tried the following steps:
- dev
-version of the feeds_tamper module
- tried the feeds_tamper-str_to_time_with_custom_format_plugin-2631092-1.patch
- tried the strtotime
plugin of the feeds_tamper module
- wrote a custom plugin that tries to convert the string
- tried a text-widget
The closest I get is what I think is the original item:
array(
'TITEL' => 'Test',
'DATUM' => '41671',
'BESCHRIJVING' => 'test',
)
that is the right date (DATUM). Can anyone shine a light on this for me?
Y/m/d