Event Website data location in database

[irishrunner16]

I’m importing a ton (thousands) of events, and need to include the Event Website field with my import. I know that the CSV Importer currently does not include that field. Where in the MySQL database can I find the table that includes that data so I can try a workaround to get the Event Website data into my calendar?

[snorton]

tribe_events are custom post types (CPT), but they use the same wordpress tables as regular post types. For the meta, it is going to be located in your wp_postmeta table (name may have a prefix depending on how your database was setup).

[Barry]

Exactly (thanks Snorton!).

If you’re pulling from the database directly then this may not help, but in case you want to retrieve that field programmatically then it might help to know that any of these three approaches should work, so long as you know the post ID for the event:

$url1 = tribe_get_event_website_url( $post_id );
$url2 = tribe_get_event_meta( $post_id, '_EventURL', true );
$url3 = get_post_meta( $post_id, '_EventURL', true );

Good luck!

[irishrunner16]

Thanks Snorton and Barry! I’m a novice at coding, so I wasn’t sure if I’d be able to simply import the url’s as “_OrganizerWebsite” and then replace those in the database table as being “_EventURL” for the meta_key…but I see that won’t be possible since the Organizer Website is mapped to a different post_id.

I’ll need to ask around for some further direction or possibly hire a developer to assist. Thanks!

[Barry]

No problem, I hope you get there.

Good luck!

[Author]

Posts