Support

February 6, 2014 at 10:25 am

Hi Nicholas,

If you mark a name as attended and then unmark them a duplicate check-in date/time stamp entry appears in the excel spreadsheet. I also had a person who was registered once yet appears three times in the list – twice as attended/un-attended and then once as nothing at all.

I am seeing the duplicate issue as well. Very strange. It may be that the SQL query is joining on the check-in date column (screenshot: http://www.screencast.com/t/nXQAQWE59drq), then showing them as duplicates, because it still shows as one record in the database. I’ll create a ticket for the developers.

Also, I can’t see how to filter the column so you get all those who attended and are marked as such and those that registered but are no shows.

Are you talking about the Event Espresso admin or the Excel file?

February 6, 2014 at 5:57 pm

There isn’t a way to do that currently, it would have to be a little customization job to do it. Probably 2 support tokens would cover the time required.

February 14, 2014 at 1:06 pm

If you go into includes/functions/export.php and put this in right after line 429, it will fix it:

$rebuild_participants = array();
							foreach ($participants as $participant) {
								$rebuild_participants[$participant->att_id] = $participant;
							}
							$participants = $rebuild_participants;

February 17, 2014 at 5:17 am

I copied and pasted it into a different test setup and it seems to work fine. I’ll include some of the code around the part that I added above, so you can see it in context.
<pre class=”brush: php; gutter: true; first-line: 1; highlight: []; html-script: false”> $sql .= $espresso_member ? ") ORDER BY att_id " : " ORDER BY a.id ";

$participants = $wpdb->get_results($sql);
$rebuild_participants = array();
foreach ($participants as $participant) {
$rebuild_participants[$participant->att_id] = $participant;
}
$participants = $rebuild_participants;
$filename = ( isset($_REQUEST['all_events']) && $_REQUEST['all_events'] == "true" ) ? __('all-events', 'event_espresso') : $event_name;