Support

August 23, 2024 at 8:54 am

Hi Tony,

Thank you very much. The ‘Phone’ data is fixed.

No, I don’t have an additional code for the Ticket URL. Can you either:
1. Share any existing Forum posts that have successfully performed this task. OR
2. What code should I add to the PHP file?

August 23, 2024 at 10:15 am

Hi Tony, I intend to use the Ticket URL in WhatsApp messaging so that the attendees can access the ticket details (with QR code) without digging into their inboxes.

So I just add this code (https://gist.github.com/Pebblo/735d17aa2c4b5939bc1aa0c687815bca) to the existing PHP file for it to work?

Sorry, I’m still not familiar with coding.

August 24, 2024 at 6:18 am

Hi Rio, yes, I created a site-specific plugin and inserted the PHP file into it.

With my limited knowledge I copy and paste the code from https://gist.github.com/Pebblo/735d17aa2c4b5939bc1aa0c687815bca to my PHP file, here is how it looks like:

<?php
/*
Plugin Name: Site plugin for events.heydavid.io
Description: Site specific code for events.heydavid.io
*/
/* Begin Adding Functions Below This Line; Do not include an opening PHP tag as this sample code already includes one! */

/*
* This function allows you to set an array of ‘allowed’ fields that will be output to the registration CSV.
* The order in which they are set in the ‘allowed_fields_in_order’ array is the order that will be used by the CSV itself.
*/
function tw_ee_espresso_reg_report_filter_columns_ordered($csv_row, $registration_db_row)
{
// Set the allowed fields here and also set them in the order you want them to be displayed within the CSV
$allowed_fields_in_order = array(
__(‘Last Name’, ‘event_espresso’),
__(‘First Name’, ‘event_espresso’),
__(‘Email Address’, ‘event_espresso’),
__(‘Phone’, ‘event_espresso’),
__(‘Ticket URL’, ‘event_espresso’),
);

// Flip the array so the values are now the keys.
$allowed_fields_in_order = array_flip($allowed_fields_in_order);

// Set the value for each of the array elements to an empty string.
// This is incase any of the above questions do not exist in the current registration’s questions,
// they still need to be included in the row but the value should be nothing.
$allowed_fields_in_order = array_fill_keys(array_keys($allowed_fields_in_order), ”);

// Sets $filtered_csv_row to only contain the ‘allowed’ fields.
$filtered_csv_row = array_intersect_key(
$csv_row,
$allowed_fields_in_order
);

// Now lets set $filtered_csv_row to use the same custom order we set $allowed_fields_in_order to
$filtered_csv_row = array_merge($allowed_fields_in_order, $filtered_csv_row);

return $filtered_csv_row;
}
add_filter(‘FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array’, ‘tw_ee_espresso_reg_report_filter_columns_ordered’, 10, 2);

function ee_tw_add_reg_url_link_to_csv( $reg_csv_array, $reg_row ) {

$reg_csv_array[ ‘Registraion URL link[REG_url_link]’ ] = $reg_row[ ‘Registration.REG_url_link’ ];
return $reg_csv_array;

}
add_filter( ‘FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array’, ‘ee_tw_add_reg_url_link_to_csv’, 10, 2 );
/* Stop Adding Functions */

The website is crashed.(Note: Before adding the snippet, it was working fine except the Ticket URL filed is still empty)