|
Runemester
|
April 1, 2014 at 7:24 am
Hi,
Since Friday last week I’ve been noticing a strange issue with the ‘date paid’ (M) column in export all attendees spreadsheet.
I’m not sure whether this can be related to the quickpay-gateway that we’re using – or the ../includes/functions/export.php file on line 519
. $s . escape_csv_val(event_date_display($participant->payment_date, get_option('date_format'))) // M
First thing I noticed is that date format is DD-MM-YYYY in date paid column and MM-DD-YYYY in reg date column (which is the global date setting)
Second the date paid column is displaying (seems like a random date) 01-04-2014 on a number of events/attendees. 435 attendees and 33 events to be precise ranging in (event)date from July 2013 until November 2014.
Especially this last issue baffles me? Can this behaviour in any way be attributed to a user copying/editing/reactivating old/inactive events?
Any ideas?
Thanks
Rune
|
|
Josh
|
April 1, 2014 at 12:04 pm
Hi Rune,
01-04-2014 may not be a random date after all since that’s today’s date formatted as DD-MM-YYYY.
If you look at the attendee records in the database do they have the same dates?
|
|
Runemester
|
April 2, 2014 at 12:11 pm
Hi Josh,
Thanks.
I double checked. In the DB (wp_events_attendee) the dates in the ‘timestamp’ YYYY-MM-DD and the ‘payment_date’ correlate – in the format DD/MM/YYYY. But I can’t find the date value 01-04-2014 from the export file in the coresponding attendee data in the DB.
And sorry – I accidentally mixed up the two formats in my previous post. What I meant was that the reg date column (and global date setting) is in the format DD-MM-YYYY and the payment date seems to be MM-DD-YYYY (in the export file).
Rune
|
|
Josh
|
April 4, 2014 at 3:10 pm
Hi Rune,
I’m comparing what’s in the database and what’s in the export from my test site and what this looks like to me is the Date Paid gets recorded in the database as formatted text, and the date format matches the date format in WP General Settings. Then the export function runs this text through event_date_display, which it really doesn’t need to because the value for Date Paid should already be formatted. This can get messed up even more if at any time the date format gets changed in WP General Settings.
I can suggest changing what’s in export.php on line 519 to this instead:
. $s . escape_csv_val($participant->payment_date)
That will let the export send the stored value from the database instead of it getting potentially reformatted.
|
