Support

October 9, 2016 at 5:37 pm

Hello,

Could you upload your version of the FHEE__EE_Export__report_registrations__reg_csv_array (https://github.com/eventespresso/ee-code-snippet-library/blob/master/admin/registration_report_limit_columns_shown.php) to something like pastebin or GitHub gist and share here so we can share feedback?

—
Lorenzo

October 18, 2016 at 9:53 am

Hi Manuel,

The reason it’s not working for you is because the field names were translated. The translation functions will take care of translating the strings before they’re sent to the CSV. So basically where you have this:

__( 'Nombre [ATT_fname]', 'event_espresso' ),
__( 'Apellidos [ATT_lname]', 'event_espresso' ),
__( 'Email [ATT_email]', 'event_espresso' ),

You’ll need to change it to be this:

__( 'First Name[ATT_fname]', 'event_espresso' ),
__( 'Last Name[ATT_lname]', 'event_espresso' ),
__( 'Email Address[ATT_email]', 'event_espresso' ),

October 24, 2016 at 6:28 am

Hi there,

Using the translated strings within the function works fine however your strings MUST match the CSV output fields exactly (yours did not). You also don’t need to run translated strings through the translation function again when doing that.

The problem with the current setup is the translations don’t match the values within the CSV array, so these fields:

__( 'First Name[ATT_fname]', 'event_espresso' ),
__( 'Last Name[ATT_lname]', 'event_espresso' ),
__( 'Email Address[ATT_email]', 'event_espresso' ),

Don’t match any of the fields available within the CSV array because they include the DB field name within the translation. The above needs to be changed to:

__( 'First Name', 'event_espresso' ) . '[ATT_fname]' ,
__( 'Last Name', 'event_espresso' ) . '[ATT_lname]',
__( 'Email Address', 'event_espresso' ) . '[ATT_email]' ,

Because EE is translating the field name, then appending the DB field to the translation, but the example function is translating the field name including the DB field, which will never match anything. So we need to translate the field name, then add the DB field name to the end so that the full field name matches what is in the array.

Make sense?

The other option you have is to skip the translation within the function and just add the full field names you want to include in the CSV. So you look within the CSV, find the field name and add that to the function directly.

For example, here is a CSV I generated using the above code – http://take.ms/vpEeP

So the three fields I want are Apellido(s)[ATT_lname], Nombre de pila[ATT_fname] & Dirección de correo electrónico[ATT_email].

So lets use those directly within the function:

$allowed_fields_in_order = array(
	'Apellido(s)[ATT_lname]',
	'Nombre de pila[ATT_fname]',
	'Dirección de correo electrónico[ATT_email]',
);

As mentioned you don’t need to run those fields through the translate function __() again because you have translated them yourself.

That then exports the fields in the exact same way as above with the fixed snippet.