Support

June 26, 2019 at 3:44 am

Hi there,

1. We are trying to get todays events and then get the registrant data for each event i.e First/Last name and the custom registration fields. This needs to be custom so we are looking to use the classes which I have got a start with but want to see if there’s a better way as it isn’t finding the first and last names (probably using the wrong class).

Can you post the code you currently have so we can take a look?

We can’t write custom code for you but we can help point you in the right direction.

2. We have custom meta fields on the user so wondering if there’s a hook we can use so upon registering (when the account is created) can we save the registration custom fields (etc) to the user account.

When registering onto an event and the account is created by EE you mean?

If so then you’re using the WP User integration add-on to create/update the user accounts? If so take a look in: \eea-user-intergration\EED_WP_Users_SPCO.module.php at the process_wpuser_for_attendee method.

It has 2 hooks:

AHEE__EED_WP_Users_SPCO__process_wpuser_for_attendee__user_user_created

and

AHEE__EED_WP_Users_SPCO__process_wpuser_for_attendee__user_user_updated

both are passed the user account and the current registration.

June 26, 2019 at 5:19 am

For #1 EE offers event specific registration exports already:

Event Espresso -> Events -> {hover over event name} -> Registrations

That lists all of the registrations for that specific event.

All of the CSV fields are passed through a filter, meaning you can use that filter to add additional columns or remove columns. So in short, if all you are looking to do is create a CSV that looks like the above, you can do that using the FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array filter without having to build out a completely custom solution.

I’m assuming based on your reply that you’ve already seen similar uses of that filter (or one similar) top remove/re-order the fileds but you can completely change the CSV output using that if needed.

I’m guessing some of those fields are based on user meta rather than all from the registration form?

June 26, 2019 at 7:41 am

Thanks Tony, the problem with it is they want to section out each event. So if you look at the screenshot the CSV will be like that but for each event on one csv printout with necessary headings.

Ah, right, ok that’s not really clear in the screenshot but I understand now.

Have you done that before with a CSV? Some of what you have in the image can’t be saved in CSV, for example, the merged fields for the header, I don’t think you can save that in the field, the header sure, but not the formatting to merge the fields.

What issue do you have with your current code?

Right now you’re overwriting the save value in the $values array with the name of the attendee, so it will essentially also contain a single value and that the First Name of the last registration’s attendee.

June 26, 2019 at 8:21 am

It isn’t printing the fname as it says it doesn’t exist in the class?

What’s the exact error you are getting?

I’m guessing PHP Fatal error: Uncaught Error: Call to a member function fname() on null and if so, you’re getting that error as you have registrations that are incomplete (meaning they have no EE contact assigned to them).

You’ll need to either check you have a valid EE_Attendee object for each registration first, or exclude those registrations from the query which you can do with:

'Transaction.STS_ID' => array(
	'NOT IN',
	array(
		EEM_Transaction::failed_status_code,
	),
)

Add that to the where conditions for the EEM_Registrations call.

How would I get the custom registration fields from that also?

I’d recommend you take a look at how EE constructs the default registration csv rows in:

\event-espresso-core-reg\core\libraries\batch\JobHandlers\RegistrationsReport.php::get_csv_data_for()

The code there will guide you through on how to pull all of the information you need.

June 26, 2019 at 8:47 am

The above error means your not passing my code in the where conditions but as a query parameter.

The above means you have something like this:

$registrations = EEM_Registration::instance()->get_all(
    array(
        array(
	    'EVT_ID' => array( '=', $event_id ),
	),
        'Transaction.STS_ID' => array(
	    'NOT IN',
	    array(
                EEM_Transaction::failed_status_code,
            ),
        ),
    )
);

You need something like this:

$registrations = EEM_Registration::instance()->get_all(
    array(
        array(
            'EVT_ID' => array( '=', $event_id ),
            'Transaction.STS_ID' => array(
                'NOT IN',
                array(
                    EEM_Transaction::failed_status_code,
                ),
            ),
        )
    )
);

June 26, 2019 at 10:08 am

You’re most welcome.

June 27, 2019 at 8:42 am

My apologies but I’m not sure I follow.

In EE there’s a 1 to 1 relationship between tickets and registrations, each ticket creates a registration within EE and the checkout page shows a breakdown of all of your registrations already so I guess I don’t understand your question.

Can you add a screenshot showing what it is you want to do?

https://eventespresso.com/wiki/troubleshooting-checklist/#screenshots

July 4, 2019 at 3:53 am

Are you sure the EE_Attendee object that you’re seeing above is in the same iteration of your loop?

If you know you have an EE_Attendee object then you won’t be getting an error like:

PHP Fatal error: Uncaught Error: Call to a member function fname() on null

On that iteration of the loop.

What you can do is build out your $values array better so you know which registration it’s failing on, for example:

foreach( $registrations as $registration ) {
    $value[$registration->ID()];
    $attendee = $registration->attendee();
    if($attendee instanceof EE_Attendee) {
        $values[$registration->ID()]['First Name'] = $attendee->fname();
    }
}

That will change your $values array to index by registration ID and any index that doesn’t have a name assigned to it above, didn’t have an EE_Attendee object meaning you can then start investigating why that is on using the Registration ID (the array index).

Get into the habit of checking you have an instance of something before you try to use one of its methods, it’ll prevent the fatal errors your getting, it doesn’t fix the problem (as the problem is the registration doesn’t have an attendee) but stops the fatal and allows you to trace it back from there.

July 4, 2019 at 2:38 pm

Your not getting a DateTime object in the code above so I’m not sure?

If you mean the code to pull registrations created between certain dates, ie:

'REG_date' => array( 'BETWEEN', array( strtotime('2019-07-03 00:00:00'), strtotime('2019-07-03 23:59:59')) )

then no, the above is the correct way to do it, although you’ll obviously want that to be more dynamic. However, that is different from your original request as that’s essentially pulling a daily request of registrations…. so you want registration made on the day of the event?

Or to pul it in the context of that code, you want all of the registrations created between 2019-07-03 00:00:00 & 2019-07-03 23:59:59? Note registrations linked to events on that date, but registrations actually made/created between those times?

If you want all of the registrations for a specific event, you don’t need to set REG_date, you just pull the registrations for that date passing the EVT_ID as you did before.