Support

September 8, 2017 at 3:26 pm

TKT Price is not in the spreadsheet. Or at least the class they register for….that is also not there.

September 11, 2017 at 7:16 am

We need it to show the Event name. Does [REG_final_price] show ht event name?

September 11, 2017 at 9:13 am

She doesn’t want so many columns in the export, so using the following… but need to know which field to use to show the event name.

//only include these 4 columns in the registration CSV output
add_filter( ‘FHEE__EE_Export__report_registrations__reg_csv_array’, ‘espresso_reg_report_filter_columns’, 10, 2);
function espresso_reg_report_filter_columns( $csv_row, $registration_db_row ) {
$filtered_csv_row = array_intersect_key(
$csv_row,
array_flip( array(
__( ‘First Name[ATT_fname]’, ‘event_espresso’ ),
__( ‘Last Name[ATT_lname]’, ‘event_espresso’ ),
__( ‘Email Address[ATT_email]’, ‘event_espresso’ ),
‘Phone[ATT_phone]’,
‘Transaction Status’,
‘Amount Paid’,
‘Gateway Transaction ID(s)’,
‘Transaction Promotions’,
‘Count of this registration in the group registration [REG_count]’,
‘radio’,//custom question’s admin label, doesn’t need to be translated. note though: if you ever change the custom question’s admin label, this code will need to be adjusted
) ) );
return $filtered_csv_row;
}

?>

September 11, 2017 at 10:20 am

I did an export from another site and didn’t see the even in a column.

Do I add ‘Event’, ?

September 11, 2017 at 11:01 am

Thanks, I’ll check…

but for the code I have above, would I put ‘Event’, to show the event?

September 12, 2017 at 1:50 pm

I added ‘Event’ and it did not work.

September 12, 2017 at 2:38 pm

The other fields show in the export…just not events:

<?php

//only include these 4 columns in the registration CSV output
add_filter( ‘FHEE__EE_Export__report_registrations__reg_csv_array’, ‘espresso_reg_report_filter_columns’, 10, 2);
function espresso_reg_report_filter_columns( $csv_row, $registration_db_row ) {
$filtered_csv_row = array_intersect_key(
$csv_row,
array_flip( array(
__( ‘First Name[ATT_fname]’, ‘event_espresso’ ),
__( ‘Last Name[ATT_lname]’, ‘event_espresso’ ),
__( ‘Email Address[ATT_email]’, ‘event_espresso’ ),
‘Phone[ATT_phone]’,
‘Transaction Status’,
‘Event’,
‘Amount Paid’,
‘Gateway Transaction ID(s)’,
‘Transaction Promotions’,
‘Count of this registration in the group registration [REG_count]’,
‘radio’,//custom question’s admin label, doesn’t need to be translated. note though: if you ever change the custom question’s admin label, this code will need to be adjusted
) ) );
return $filtered_csv_row;
}

?>

September 12, 2017 at 3:32 pm

She is doing this:

When you click on approved registrations, the number. You then see all the registrations. Then click Event Registration CSV Report.

September 13, 2017 at 10:20 am

From customer:

Hi Dorian,

What you’ve explained below is not at all what I was asking ☹ I’m not trying to understand All registrations CSV. I’m trying to understand individual tickets inside a single event.

I don’t want the name of the specific event to show on the report. As you said, that’s duplicate. What I’m trying to explain (not very well evidently) is that a single event may have two different tickets for that single event. I’m going to repeat what I said below again exactly.

So single event, I’m choosing the 9U Speed event:

15 people reserved the home plate and 30 people reserved the 3 pumpkin stack. Now I need to know who those 15 and 30 peoples names are so that I can hand them the right door hanger….(Make sense?)

So now I’m clicking on the 37 (Approved Registrations) and I get all their names and what they registered for which is good. But it’s hard to page through 37 registrations so we want to export it to excel, but when you export, you lose their individual ticket.

You’ll see there is a “EVENT REGISTRATIONS” and a “FILTERED” but neither gives you the “ticket” that they registered for :