Support

Home Forums Event Espresso Premium Linking database to an Access front end

Linking database to an Access front end

Posted: May 20, 2014 at 6:12 am


blue level

May 20, 2014 at 6:12 am

Hi i am working on syncing the data from EE4 to an Access front end. I am struggling with which tables i can get the data from. for example; Event name and description i cannot find anywhere in the database!
Am i missing something simple here or is some of the info not stored on the database?
Any help with this would be amazing.
Thanks


Tony

  • Support Staff

May 20, 2014 at 6:35 am

Hi blue level,

Unfortunately this kind of customisation is outside the scope of support, although I can advise where those fields are within the database.

Within EE4 the events are actually Custom Post Types, as such they are stored within the wp_posts table similar to normal posts. So in that case, Event Name would be post_title, event description post_content.

However, depending on what you are trying to achieve it will likely not be a simple task, EE4 has MANY relationships within the tables for registrations, transactions etc.


blue level

May 27, 2014 at 7:02 am

ok thanks for the reply. I am now using ee3 as it seems a lot easier to navigate the db. does anyone have an ERD of the ee3 database? i am struggling to connect all the relationships together.


Tony

  • Support Staff

May 27, 2014 at 7:43 am

Unfortunately not although the development team use and recommend MySQL Workbench which can be installed locally and use to display an ERD for EE.


blue level

May 28, 2014 at 8:02 am

I have used MySQL Workbench to reverse engineer the database and display an ERD but there are no relationships between the tables. Has this not be done before? Surely someone must know how they all link together?


Josh

  • Support Staff

May 29, 2014 at 1:05 pm

Hi blue,

In Event Espresso 3 you’ll find the event name and the event description in the _events_detail table.

The support post ‘Linking database to an Access front end’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

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: closed

Updated by  Josh 5 years, 6 months ago ago

Topic Tags

Notifications

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