Im doing the following to import some data from a csv file via php:<\/p>\n
$venueData = array();
\n$venueData[‘Venue’] = venuename
\n$venueData[‘post_type’] = ‘tribe_venue’;
\n$venueData[‘Country’] = country;
\n$venueData[‘Address’] = address;
\n$venueData[‘City’] = city;
\n$venueData[‘State’] = state;
\n$venueData[‘Zip’] = zip;
\n$venueData[‘ShowMap’] = true;
\n$venueData[‘ShowMapLink’] = true;
\n$venueData[‘Phone’] = phone;
\n$venueData[‘URL’] = url;
\n$event[‘Venue’]=$venueData;
\n$event[‘post_title’] = Title;
\n$event[‘post_status’] = ‘pending’;
\n$event[‘post_type’] = ‘tribe_events’;
\n$event[‘post_author’] = $postAuthor;
\n$event[‘post_content’] = $postBody;
\n$event[‘EventStartDate’] = date(“Y-m-d H:i:s”, now());
\n$event[‘EventEndDate’] = date(“Y-m-d H:i:s”, ‘+1 day’);
\n$event[‘EventShowMapLink’] = true;
\n$event[‘EventShowMap’] = true;<\/p>\n
$postID = tribe_create_event($event);<\/p>\n
This works fine (I might have an error in the code above as I wrote this off the top of my head, but you get the point).<\/p>\n
1. How do I test to see if a venue already exists in my db? For example, if the venue name in the csv is “my place” but I already have “my place” defined in the database, I dont want to create a second instance. I want to use the one thats already there<\/p>\n
2. If I already have it defined, how can I set the params above to use THAT venue name \/ id instead of defining it like above?
\nThanks!<\/p>\n","protected":false},"template":"","class_list":["post-102684","topic","type-topic","status-closed","hentry"],"yoast_head":"\n