I'm a Drupal newbie with very limited PHP coding - apologies for cross-posting.
I'm having some issues with Feeds and how Dates are handled - any help would be appreciated.....
Sytem: Windows XP, Drupal 6.22, XAMP distro with Apache/2.2.17; MYSQL 5.5.8 and PHP 5.3.5 .
Context: I'm setting up a site with 8000+ books listed on it. I want to import the original list from a CSV or Excel file to a custom Node built with CCK fields and I then need to be able to update these nodes with new prices and publication dates on a fairly regular basis.
It looks like the Feeds module is the answer.
When I run the CSV Importer most of the data is imported correctly but about 50% of the 'date' data isn't imported.
I've opened the spreadsheet in LibreOffice and then saved it set to UTF-8, making sure that data in the date column is consistent.
From what I can see it is a formatting issue.
I want to use DD/MM/YYYY formatting as this makes the most sense to my customer base. I've set up the CCK Datefield to that style of formatting and looking at the CSV file it appears in that formatting style as well.
But when the import is finished the Nodes are showing the date field in MM/DD/YYYY format.
As I've set up the Drupal end in the style that I want I presume that it must be the CSV file that formats date in MM/DD/YYYY as it's standard format - is there any way to change this?
Does any one have any ideas, pointers to what I should be looking for?