|
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
|
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
|
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
|
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.
|
