Page 1 of 1

MAMS User import date format

Posted: Tue Aug 19, 2025 10:34 am
by webform
I have a couple of User Properties as type Date (Birthday etc.) But most users fail to import with error message "Invalid value for column birthday".

How do i import users with a birthday older than 1970-01-01?

I've tried to convert the birthday to strtotime before import and this works for some users but not most.
A user with birthday "1941-04-04" converted to "-907113600" does import. But a user with birthday "1955-01-14" converted to "-472262400" does not ???

Re: MAMS User import date format

Posted: Wed Sep 03, 2025 3:47 pm
by webform
It was a date restriction in the MAMS import function.

I made a temporary override of the date restriction in the user import function so that I could import all users with dates older than 1970-01-01.

It would of course be better if the import function did not have that limitation on importing date fields.