Support

March 5, 2019 at 4:51 am

Hi Josh,

thank you!

This code works but i also need to display the custom questions (or all other columns) and answers for the registrants. how can i do that? what is the right code for phone number, adress etc.?

thank you!

March 6, 2019 at 5:07 am

Hey Josh, thank you 🙂

but where do i find the names of the specific fields/columns so that i can write it down in this code snippet? For example: what is the name of phone number or adress?

is it like my example:

$fields_to_exclude_from_csv = array(
//Add the fields you wish to exclude from the CSV here.
//These excluded fields are an example of how to remove fields, your list will be different.
__( ‘phone number’, ‘event_espresso’ ),
__( ‘adress’, ‘event_espresso’ ),

);

???

March 6, 2019 at 6:28 am

thanks tony!!!

last question 🙂
how can i display the values per column in excel just like shown in your link?

March 6, 2019 at 7:07 am

have a look:

https://abg-wuppertal.de/test-event-espresso/

it’s all in one column in excel 🙁

March 6, 2019 at 1:35 pm

Tony, wow!

yes it works now!

thank you very much, you made my day 🙂

March 7, 2019 at 8:40 am

Tony, sorry, got another problem…

i cannot remove every specific column that i want to. i integrated this code-snippet:

/*
Plugin Name: Exclude custom fields from EE registrations export. Description: Allows you to set felds that will be excluded from the registrations CSV export file.
Author: Tony Warwick Version: 1.0
*/
function ee_exclude_custom_fields_from_export($reg_csv_array, $reg_row) {

$fields_to_exclude_from_csv = array(
//Add the fields you wish to exclude from the CSV here.
//These excluded fields are an example of how to remove fields, your list will be different.
__( ‘Transaktions ID’, ‘event_espresso’ ),
__( ‘Teilnehmer ID’, ‘event_espresso’ ),
__( ‘Registrierungs-ID’, ‘event_espresso’ ),
__( ‘Time registration occurred’, ‘event_espresso’ ),
__( ‘Unique Code for this registration’, ‘event_espresso’ ),
__( ‘Registrations share of the transaction total’, ‘event_espresso’ ),
__( ‘Transaktionsstatus’, ‘event_espresso’ ),
__( ‘Transaction Amount Due’, ‘event_espresso’ ),
__( ‘Bezahlter Betrag’, ‘event_espresso’ ),
__( ‘Zahlungseingang’, ‘event_espresso’ ),
__( ‘Zahlungsart’, ‘event_espresso’ ),
__( ‘Gateway Transaction ID(s)’, ‘event_espresso’ ),
__( ‘Check-Ins’, ‘event_espresso’ ),
__( ‘Ticketname’, ‘event_espresso’ ),
__( ‘Address Part 1’, ‘event_espresso’ ),
__( ‘Payment Date(s)’, ‘event_espresso’ ),
__( ‘Payment Method(s)’, ‘event_espresso’ ),
__( ‘Gateway Transaction ID(s)’, ‘event_espresso’ ),
__( ‘Währung’, ‘event_espresso’ ),
__( ‘Stadt’, ‘event_espresso’ ),
__( ‘Land’, ‘event_espresso’ ),
__( ‘PLZ’, ‘event_espresso’ ),
__( ‘Address Part 2’, ‘event_espresso’ ),
__( ‘Bundesland’, ‘event_espresso’ )
);

foreach( $fields_to_exclude_from_csv as $single_field_to_exclude ) {
//For each field within $fields_to_exclude_from_csv, check if that value is within the CSV array.
if ( array_key_exists( $single_field_to_exclude, $reg_csv_array )) {
//If the field is set remove it from the array.
unset( $reg_csv_array[$single_field_to_exclude] );
}
}

this link will show you which csv export is generated:

https://abg-wuppertal.de/test-event-espresso/

so, “Währung” is removed but many other columns are still available in the csv export like “Transaktions ID” or “Teilnehmer ID”, “Registrierungs-ID”, “Unique Code for this registration” and so on…

what can i do now?

Thank you again 🙂

March 8, 2019 at 6:47 am

Hey Toni,

here is the link:

https://pastebin.com/DFQnPas3

the csv export hides “Währung” but not “Transaktions ID”, you can see the export here:

https://abg-wuppertal.de/test-event-espresso/

We do only need the yellow columns for our csv export.

Thank you a lot!!

March 8, 2019 at 1:46 pm

Hi,

perfect, it works now, i’m very happy 🙂

thank you very much, your support is really, really great!!

have a nice weekend!

greets from germany