Attendees List still needs Last Name Column

[barback]

You sure are quick to close topics to further discussion!

So, I’ll have to respond to https://theeventscalendar.com/support/forums/topic/event-tickets-split-first-name-last-name/#post-1051182 by starting a new thread.

One of the events for which we have used The Events Calendar and WooTickets is a festival that takes place at many venues around our town, sometimes with multiple events at the same time. We use volunteers to check people in, and the low-tech paper method works best, at least for now. Volunteers at the box office of the theater handle the paper list better than all the technology.

Woo Commerce still collects billing info as separate names, so the content that I need is present in the system, I’ve just lost the ability to harvest it — and I guess RSVP “tickets” would still be a single name field.

In an earlier version I would modify the file class-wootickets.php adding this line:

$lname = get_post_meta( $order_id, ‘_billing_last_name’, true );

and then then in a file called tribe-tickets-attendees.php I added the next line to get the column in the report.

‘purchaser_lname’ => __( ‘Purchaser last name’, ‘tribe-events-calendar’ ),

With new Events Calendar and Events Tickets Plus installed, I tried the following, but it didn’t work: — Can you point me to how I can harvest the last name from the order metadata (which WooCommerce has collected)?

Plugins/event-tickets-plus/src/Tribe/Commerce/WooCommerce/Main.php

add Line 944
$lname = get_post_meta( $order_id, ‘_billing_last_name’, true );

add Line 989
‘purchaser_lname’ => $lname,

[barback]

In response to your suggestion (in the now closed topic https://theeventscalendar.com/support/forums/topic/event-tickets-split-first-name-last-name/#post-1051182 ) that we sort our print out by security code:

We are trying to make the process user friendly and environment friendly, and we re-word the confirmations to say “You do not need to print out your ticket. We will have your name on a list at the door.” Asking them to print out or remember a security code is not a solution.

You are right in your reply that as a developer of this plugin used by thousands of users in many different scenarios, you have to consider more than just one client — I’m just feeling like you’ve made changes to the software that effect my client, and that in your responses in this forum you’ve made it clear that you’re not interested in how THIS client wants and needs to use your software.

[George]

Hey @Barback,

That original thread was by and for @xrossglobalgroup – while posting in other people’s threads is allowed, of course, we try to keep threads to only one customer voice and one Support Team voice. It’s efficient and more organized than alternatives, which we’ve tried in the past.

So, thanks for opening a new thread for your own, and, while similar, also specific complaints.

—

Speaking of such complaints, there are a number of specific things I would like to address.

We use volunteers to check people in, and the low-tech paper method works best, at least for now. Volunteers at the box office of the theater handle the paper list better than all the technology.

Back in the original thread, I acknowledged specifically that you might not be able to use a smartphone or computer for check-ins. As for this:

We are trying to make the process user friendly and environment friendly, and we re-word the confirmations to say “You do not need to print out your ticket. We will have your name on a list at the door.” Asking them to print out or remember a security code is not a solution.

To clarify, the features of our plugins are to sell tickets, but it sounds like you are trying to have a good system in place that does not use tickets (i.e. because you are trying to make it so that people do not bring their tickets to the event).

So:
• The point of our plugin is to let users of your site buy tickets that they bring to an event
• We provide features for check-in and Attendee management

You are using our plugins in a specific way, which from the sound of it essentially:
• Does not want to rely on users having/bringing tickets to the event
• Does not use the features for check-in and Attendee management that our plugin provides.

This is fine, of course – you can use our plugin in any way you would like. However, I’m just being honest and up front that we will likely not be changing our name input configuration for the time being.

This leads into your comment here:

You are right in your reply that as a developer of this plugin used by thousands of users in many different scenarios, you have to consider more than just one client — I’m just feeling like you’ve made changes to the software that effect my client, and that in your responses in this forum you’ve made it clear that you’re not interested in how THIS client wants and needs to use your software.

To re-iterate, no, we ARE interested in how you want to use the software and are always interested in feedback. You have voiced your feedback, and we have noted your feedback. There is no immediate action that can be taken as a result of this, however. I am sorry about this reality.

—

Finally, as for your customization issues, it is true that Event Tickets and Event Tickets Plus do not work exactly the same way as WooCommerce Tickets of old, so your original customization will not work in exactly the same way.

However, please read the “Product Support” section of this page → http://theeventscalendar.com/terms

We cannot help with custom coding projects, so the support I can provide here is limited, but in either case, can you clarify why you have these two sentences in your first post here?

add Line 944
$lname = get_post_meta( $order_id, ‘_billing_last_name’, true );

add Line 989
‘purchaser_lname’ => $lname,

Are you asking me to add those code snippets to the corresponding lines of code above the snippets? I’m just not sure what this content means, so let me know why you pasted these two blocks of text into your post and I will try to offer some advice on getting that WooCommerce information out of WooCommerce.

— George

[barback]

George,

I was trying to apply similar modifications to the new software, and indicated what I had already tried.

I tried adding the snippets to the file named above the snippets.

[George]

Hey @Barback,

To reiterate this point because it is important, we cannot help with customizations of any kind. You will have to take the reins on this to get things working how you want them.

That being said, while I admit I’m still not quite sure how exactly you want things to look, here is an example bit of code that will change the display of names in the Attendees List so that last names are first. This does not make the columns sortable – that is a complicated customization to do, unfortunately.

However, here is some code I wrote for you despite our policies as an example of modifying the attendees table:

if ( function_exists( 'event_tickets_plus_init' ) ) {
/**
* Modify the display of names in Attendees lists.
*
* @link http://theeventscalendar.com/?p=1051350
*/
function barback_support_example( $value, $item, $column ) {

if ( 'purchaser_name' !== $column || ! isset( $item['order_id'] ) ) {
return $value;
}

$fname = get_post_meta( $item['order_id'], '_billing_first_name', true );
$lname = get_post_meta( $item['order_id'], '_billing_last_name', true );

return sprintf( '%s, %s', $lname, $fname );
}

add_action( 'tribe_events_tickets_attendees_table_column', 'barback_support_example', 20, 3 );
}


Put that into your theme’s functions.php file.

Here is a screenshot of how the attendees table looks without this code → https://cldup.com/r1mccXrGBA-2000×2000.png

Now, here is a screenshot of the attendees table when the code is added → https://cldup.com/6mSjBzYP5G-1200×1200.png

The “purchaser name” column in the second example has the last names of the attendee first, which seems like a step forward based on what you’ve written thus far.

This hopefully serves as a good example for further tinkering.

Cheers,
George

[barback]

Thanks for this George — it didn’t work for me — I got an attendees list with the name column displaying only a comma!

If you still have your test environment available, could you check the CSV export with your custom function in place? If we could get this to work, and have it export to the csv as it displays this would be good. If the CSV pulls from somewhere else, then it’s not worth tinkering with this. You said it couldn’t sort the displayed table on that column, but if it would pull into the CSV in that format, we could sort it there.

Meanwhile, I’m also struggling to get the RSVP section of my list to have a status column at all – WHERE is the code that generates the CSV?

Thanks!

[George]

If only a comma shows up, then the code DOES work – but for the given order, the “Billing First Name” and “Billing Last Name” fields were not filled out by the user.

—

As for a “Status column” on your RSVPs, can you clarify what this means? Please share a screenshot if possible. You can do so by uploading the screenshot to Imgur.com, Flickr.com, CloudUp.com, or any similar image-hosting site; then just share the links to those images here and I’ll take a look.

Cheers,
George

[barback]

Ah yes. The one site uses EDD (no billing_lname collected – and only a , in attendees list)
The other site, using Woo Commerce did populate the name field with last, first but the csv export was in the original single name order and the rsvps now have only a comma instead of a name.

rsvps missing status column:

When paid tickets are combined with rsvps in one attendee list, it displays fine in the web view, but the csv produced misaligns the columns, as there is no order-status for the rsvps. I have a separate thread about this, but both issues come back to the question, where is the code that creates the csv export?

[George]

Thank you for clarifying the first issue – in regards to the misaligned CSV columns when there is a mix of RSVP and paid tickets, I will investigate this and we can make development tickets to improve this in future releases. That will unfortunately take some time – for the time being, when you ask where the CSV export is generated, the main output is built in the Tribe__Tickets__Tickets_Handler class, in its _generate_filtered_attendees_list() method. If you head into the Event Tickets plugin files to src/Tribe/Tickets_Handler.php you will find this.

Cheers!
George

[barback]

There seems to be code in the file you point me to that deletes columns if there is no data — so…

I think the solution may lie in getting rsvp process to add a status of “rsvp confirmed” — then the two lists will have the same columns and the mis-aligned spreadsheet will be sortable without having to create / run macros, etc.

I just couldn’t find how to do that in the rsvp.php file.

[George]

Hey @Barback,

Thank you for reporting these issues – we definitely need to take a closer look at the CSV exporting and handle the column alignment issues better.

There is unfortunately not any immediate action that can be taken on this, though 🙁 I’m sorry to disappoint about this.

— George

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts