|
bhhsflpg
|
September 24, 2021 at 1:11 pm
Hi,
Using Zapier to automate the creation of events on Google Calendar to match what’s created in EE via MySQL triggers.
I would like to be able to populate venue information. I’ve found the relevant venue names in the wp-posts table, and the corresponding address and other info in wp_esp_venue_meta. However have not been able to determine where the connection between the event and its related venue are stored for the lookup.
For example, my event has an event id of 7975, found in the posts table. My venue has an id of 6506 also in the wp-posts table. However, I’ve not been able to find the reference which connects 6506 to the event id of 7975.
Can someone please point me in the correct direction?
Thank you,
Stephanie
|
|
Tony
|
September 27, 2021 at 3:57 am
Hi Stephanie,
the relationships between the event and venue(s) are stored within wp_esp_event_venue.
There you’ll find the EVT_ID linked to the VNU_ID and the table has:
EVV_ID (unique ID for each row)
EVT_ID (the Event ID)
VNU_ID (the venue ID)
EVV_primary (if this is the primary venue for the event)
(EVV_primary is there because the database has been set up for an event to support multiple venues, currently the user interface doesn’t support setting multiple venues but may do eventually)
So for your example, you’ll have something like:
EVV_ID = X
EVT_ID = 7975
VNU_ID = 6506
EVV_primary = 1
Is that what you are looking for?
|
|
bhhsflpg
|
September 27, 2021 at 12:53 pm
That’s perfect, thank you!
|
|
Tony
|
September 27, 2021 at 1:34 pm
You’re most welcome 🙂
|
