FEU Date Import
Posted: Thu Sep 16, 2010 3:34 pm
I am using 1.8.2. and FEU 1.12 and have just imported a group of users using FEU's own built-in importer.
The import went without any reported errors. One of the fields I imported was called 'dob' (for 'Date Of Birth') and was in the format suggested (MM-DD-YYYY). The corresponding property 'dob' in FEU was set up as a date field. On import FEU appears to have mis-read the data in some way. Users' dates of birth are shown, but are all wrong by a mile.
When I look in the cms-module-feusers_properties table in MySQL, I see the dates shown as a number string (e.g:975542400) held in the 'data' column/field within that table. I am also using the CG User Directory module on this site and when I look at a member's record, it shows the date of birth as a straight read of this data, e.g "Date Of Birth: 975542400"
Any clues as to what is wrong with my import - and how to fix it - gratefully received.
TIA
The import went without any reported errors. One of the fields I imported was called 'dob' (for 'Date Of Birth') and was in the format suggested (MM-DD-YYYY). The corresponding property 'dob' in FEU was set up as a date field. On import FEU appears to have mis-read the data in some way. Users' dates of birth are shown, but are all wrong by a mile.
When I look in the cms-module-feusers_properties table in MySQL, I see the dates shown as a number string (e.g:975542400) held in the 'data' column/field within that table. I am also using the CG User Directory module on this site and when I look at a member's record, it shows the date of birth as a straight read of this data, e.g "Date Of Birth: 975542400"
Any clues as to what is wrong with my import - and how to fix it - gratefully received.
TIA