Hi,<\/p>\n
We were provided with a function by yourselves which is posted below, so that we can join WooCommerce information to the export, essential for our CSV export as we then upload this information to our database.<\/p>\n
However this has been getting slower and slower and then failed to export last week. We were able to isolate it as the below function, as on removing the function it exported without error. I reduced the number of columns to just first name, last name and postcode, and it did finally export.<\/p>\n
This morning, with more ticket sales over the weekend, it is now failing to export again.<\/p>\n
Can you please advise on how I can at least limit the number of rows per export, is there any way I can do this in chunks?<\/p>\n
With the ongoing known issue of not exporting the ticketing information correctly, this is a real problem and now I have been asked to look at alternatives to Event Tickets Plus. We have also experienced very slow page load times (admin and front end) which has been isolated to events with additional fields (which is not theme related).<\/p>\n
I urgently need to resolve this export issue at the very least as we have ticket data we cannot import into our database.<\/p>\n
Your assistance is greatly appreciated.<\/p>\n
Many thanks,<\/p>\n
Penny<\/p>\n
\/———————————————————————————–<\/em>\/ function tribe_export_custom_set_up ( $event_id ) { if ( ! is_admin() ) { } else { $filter_name = “manage_{$screen_base}_columns”;<\/p>\n add_filter( $filter_name, ‘tribe_export_custom_add_columns’, 100 ); function tribe_export_custom_add_columns ( $columns ) { function tribe_export_custom_populate_columns ( $value, $item, $column ) {<\/p>\n $order = new WC_Order( $item[‘order_id’] );<\/p>\n $firstname = utf8_decode($order->get_billing_first_name()); if ( isset($order) ) {<\/p>\n }
\n\/* TRIBE
\n\/———————————————————————————–<\/em>\/<\/p>\n
\n \/\/Add Handler for Community Tickets to Prevent Notices in Exports<\/p>\n
\n $screen_base = ‘tribe_events_page_tickets-attendees’;<\/p>\n
\n $screen = get_current_screen();
\n $screen_base = $screen->base;
\n }<\/p>\n
\n add_filter( ‘tribe_events_tickets_attendees_table_column’, ‘tribe_export_custom_populate_columns’, 10, 3 );
\n}
\nadd_action( ‘tribe_events_tickets_generate_filtered_attendees_list’, ‘tribe_export_custom_set_up’ );<\/p>\n
\n $columns[‘wc_first_name’] = ‘First Name’;
\n $columns[‘wc_last_name’] = ‘Last Name’;
\n $columns[‘wc_address_1’] = ‘Address line 1’;
\n $columns[‘wc_address_2’] = ‘Address line 2’;
\n $columns[‘wc_address_city’] = ‘Address city’;
\n $columns[‘wc_address_state’] = ‘Address state’;
\n $columns[‘wc_address_postcode’] = ‘Address postcode’;
\n $columns[‘wc_payment’] = ‘Payment’;
\n $columns[‘wc_date’] = ‘Date’;
\n return $columns;
\n}<\/p>\n
\n$lastname = utf8_decode($order->get_billing_last_name());
\n$address1 = utf8_decode($order->get_billing_address_1());
\n$address2 = utf8_decode($order->get_billing_address_2());
\n$addresscity = utf8_decode($order->get_billing_city());
\n$addressstate = utf8_decode($order->get_billing_state());
\n$addresspostcode = utf8_decode($order->get_billing_postcode());
\n$payment = utf8_decode($order->get_payment_method());
\n$datecreated = utf8_decode($order->get_date_created());<\/p>\nswitch ($column) { \ncase 'wc_first_name':\n $value = $firstname;\n break;\ncase 'wc_last_name':\n $value = $lastname;\n break;\ncase 'wc_address_1':\n $value = $address1;\n break;\ncase 'wc_address_2':\n $value = $address2;\n break;\ncase 'wc_address_city':\n $value = $addresscity;\n break;\n case 'wc_address_state':\n $value = $addressstate;\n break; \n case 'wc_address_postcode':\n $value = $addresspostcode;\n break;\ncase 'wc_payment':\n $value = $payment;\n break;\ncase 'wc_date':\n $value = $datecreated;\n break;\n<\/code><\/pre>\n
\n } else {
\n $value = ‘-‘;
\n }
\n return $value;
\n}<\/p>\n","protected":false},"template":"","class_list":["post-1463538","topic","type-topic","status-closed","hentry"],"yoast_head":"\n