Support

Home Forums Event Espresso Premium Import data from other system

Import data from other system

Posted: February 15, 2017 at 10:12 am


jfchatelain

February 15, 2017 at 10:12 am

Hi,

For our current event we decided to go with EE but before that we sold tickets on platform like eventbrite and picatic.

What would be the best way to import those users in EE and generate the right registration data?

We have around 500 people that we need to import in EE.

Thanks for your help.

Jean-Francois


Tony

  • Support Staff

February 15, 2017 at 12:17 pm

Hi Jean-Francois,

Currently Event Espresso does not include an import feature you can use for this so the registrations would need to be manually added to the event(s) by the admin.

You can do this from the front end as a normal registrant, or through the admin:

https://eventespresso.com/wiki/manually-add-registrant-wordpress-dashboard/


jfchatelain

February 15, 2017 at 12:22 pm

Thanks for your answer.

If I wanted to do a sql script, could you validate my steps just to be sure i’m not missing anything?

1. Since I’m using WP Users Integration, I would first create all those users
2. I would create a registration entry for each user
3. I would create a transaction entry for each new registration.

Thanks again for your help.

JF


Tony

  • Support Staff

February 15, 2017 at 12:34 pm

There are multiple relationships setup within a registration so what you are trying to do is not simple.

Your users would be a standard wp user.

Each user would also need an EE_contact which would then also be linked to the wp user you created.

Each registration created will need to be assigned to the correct EE_contact.

Within each registration you need to be assign the correct ticket (which will also need to be created within the event), each ticket needs to be assigned to its relevant datetime (which again will need to be created) within the event.

The datetime sold value will need to incremented with each registration added to the system to keep track of the registration count

You can not simply just create registrations and have them show up in Event Espresso, if it’s a single event within ticket it gets a little easier but there is still a lot more data to manage than users and registrations for this to work.


jfchatelain

February 15, 2017 at 12:44 pm

Thanks for your feedback Tony.

Yes its a single event setup.

I understand that this is not be easy. And like you said it impacts a lot of table. I certainly don’t want to corrupt anything.

But is there anything I can do to speed up the registration of 500 people without having to go through the registration process one by one?

Thanks again for your precious help


jfchatelain

February 15, 2017 at 1:15 pm

Hi Tony, I did some test and created a registration for a user that already exists as a WP user and I was expecting the shortocode [ESPRESSO_MY_EVENTS] to display the ticket that was created from the admin panel.

I read that the admin panel was not compatible with WP User Integration. Do you know what is missing so it could be tied up?

Thanks


Tony

  • Support Staff

February 15, 2017 at 1:39 pm

But is there anything I can do to speed up the registration of 500 people without having to go through the registration process one by one?

Other than manually entering them into the system the only other option is to create a custom import, however it is not something we can provide support for on the forums.

I read that the admin panel was not compatible with WP User Integration. Do you know what is missing so it could be tied up?

Registrations manually added by the admin will not link to the user account, only registrations made on the front end using registration details that match the EE contact whilst logged into the users account will be linked and shown in the ‘My Events’ section.

It could be the ATT_ID within esp_registration is either not set or set to the wrong attendee/contact id so it won’t show but I’m not sure I follow exactly what you did to test, just add a registration through the admin using a user details then switched to that account to view my events?


jfchatelain

February 15, 2017 at 3:18 pm

Yes this is exactly what I did.

1. Logged in as an admin and created a manual registration for user
2. Logged out
3. Logged in again but with the user’s credentials.
4. Looked at my events and could not see anything.

Should this be happening or should I add custom code?

Thanks


Tony

  • Support Staff

February 16, 2017 at 7:17 am

Event Espresso does not link registrations to users if that user did not make that registration whilst logged into their account AND if the first name, last name and email address do not match their user account details.

So adding a registration via the admin will not add that registration to the user my events section, you would need to switch to the user and register on the front end for it to show.


jfchatelain

February 16, 2017 at 8:32 am

Good morning Tony,

I was able to make it work this morning simply by inserting a row wp_EE_Attendee_ID in the wp_usermeta assigning the right attendee id to the right wp user id.

Do you see any issues with this manipulation?

Thanks


Tony

  • Support Staff

February 16, 2017 at 10:38 am

That should be fine, its basically what happens when you use the front end to add the registration whilst logged into the account.


jfchatelain

February 16, 2017 at 10:40 am

Great!

Do you know of any filter or hook that I can use to programaticaly do that?


Tony

  • Support Staff

February 21, 2017 at 7:49 am

You could take a look how the EE4 User Integration add-on adds the value:

https://eventespresso.com/product/eea-wp-user-integration/

It uses the hook AHEE__EE_Single_Page_Checkout__process_attendee_information__end which is fired at the end of ‘step 1’ of the checkout when the details are submitted.


jfchatelain

February 21, 2017 at 8:21 am

Great Thanks Tony,

I will take a look.

Have a good day,

JF


Josh

  • Support Staff

August 8, 2019 at 8:01 am

Update:

The Event Espresso 4 Importer add-on is released and its feature allows for importing registrations into events. You’ll find more information here:

https://eventespresso.com/wiki/event-espresso-importer-add-on/

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: publish

Updated by  Josh 1 week, 5 days ago ago

Topic Tags

Notifications

This topic is:
pending
Do NOT follow this link or you will be banned from the site!