Posted: June 13, 2013 at 3:22 pm
We would like to automated the process of entering event registrant information into our Sage ACT CRM system. To do this we need to be able to access the SQL data tables. How can we do this?
Thanks | |
We define a number of constants to hold the names of the tables. Other than that, it is just a matter of declaring the wpdb global object and using it to access the tables. ie: global $wpdb, $org_options; $SQL = "SELECT ea.email, ea.event_id, ea.registration_id, ea.txn_type, ed.start_date,"; $SQL .= " ea.attendee_session, ed.event_name, ea.lname, ea.fname, ea.total_cost,"; $SQL .= " ea.payment_status, ea.payment_date, ea.address, ea.city, ea.txn_id,"; $SQL .= " ea.zip, ea.state, ea.phone, ed.event_meta FROM " . EVENTS_ATTENDEE_TABLE . " ea"; $SQL .= " JOIN " . EVENTS_DETAIL_TABLE . " ed ON ed.id=ea.event_id"; $SQL .= " WHERE ea.id = %d"; $temp_data = $wpdb->get_row( $wpdb->prepare( $SQL, $payment_data['attendee_id'] ), ARRAY_A ); | |
Hi Sideny, Thanks for your reply. I’m stuck in the middle between EE and my SQL tech. He keeps asking me how he can get direct access to the SQL tables to automate the import of registrant data to ACT CRM. I don’t understand what you wrote. Can you please dumb it down for me? Thanks – Mike | |
Hi Mike, This might answer your SQL tech’s question about interfacing with the database: Event Espresso extends a normal WordPress database with its own tables, so everything in the above linked documentation that shows how to interface with the database will apply to the database tables that Event Espresso uses. | |
Hi Josh – Can we arrange a 5 minute phone all? Give me a time & I’ll get you and Chuck Hogan together. I’m the limiting factor in this dialog.
Thanks – Mike
| |
503-221-20230 Client: Overton Safety Training
| |
Hi Mike, We generally do not do phone support, and I’m pretty sure that if Chuck looks over the documentation it will answer his questions about how to interface with the database. Another alternative way to access the event registration information from the database would be to use the new API that was developed earlier this year: | |
The support post ‘SQL Data Access?’ 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.
