Sync with Community Builder

I have added some new fields to Community Builder user records. I then went to Events Booking and added those fields to the registration form. I would like to populate the new fields from Community Builder into some existing EB registration records. When I enter updates for the fields into CB they don't populate into the corresponding fields in the registration records for that person in EB. Is there a way to do this?

Thanks,
Bob

I of course used Field Mapping in EB to associate the CB fields with the EB fields.

Hello Bob

Unfortunately, there is no way to do that at the moment. The data of that new field will only be used to pre-fill the form fields of new registration

For existing records, there is no way to update data from these new fields

Tuan

Ok thanks. Keep it in mind for possible future feature.

Bob

I guess what I really want a way to join the Community Builder user and Events Booking registrant tables so I could produce a list of registrants that have certain fields from CB included. Could this be done in PHPMyAdmin? Is there any other way?

Exactly what fields from CB you want to use to update data to what fields from Events Booking? If the fields from Events Booking are core fields (store in #__eb_registrants table), then it might be possible to do that via PHPMYadmin

Otherwise, a php script is needed

Regards,

Tuan

The fields I want to link are core fields in EB. In CB they are not core fields. I added them with their Field Management function. My idea is to join on first_name and last_name and pull the fields from CB into the EB registration record. I would not alter any exiting tables but would produce an additional table via a SQL select statement. That table could then be exported to provide the combined spreadsheet of EB and CB information.

How you procedure the speedsheet, then? If you can write SQL command, I guess you can join the two tables to have the data you need

#__eb_registrants
#__eb_events
#__comprofiler

Depends on the fields you need, you can write the query to get the data you want via PHPMYADMIn

Tuan

I want to ask about the pre-populating of these fields from CB on the registration form. This might solve my problem if I could make the fields be non-updatable on the registration form. If possible I'd also like to make them invisible on the registration form. This way the data would come from CB into the EB registration record and be carried forward to the backend and the registration extract file. I see there is a place in EB Configuration for custom CSS. Also there is a place in the Custom Field called Display Settings where you can enter custom CSS and something called Extra. Would it be possible to make my custom fields non-updatable and invisible on the registration form, but still visible in the backend and in the registration extract file? If so, do you have an example of the CSS that would make this work for a given field?

The fields mapped from CB are date fields. As such, I can't use the readonly and hidden attributes in the custom field Display Settings under Extra.