Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-sales domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the better-click-to-tweet domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-amazon domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-stats domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wordpress-seo domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114
SQL Data Access? | Event Espresso - Staging Server

Support

Home › Forums › Pre-Sales › SQL Data Access?

SQL Data Access?

Posted: June 13, 2013 at 3:22 pm

Viewing 6 reply threads


Mike Johnson

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


Sidney Harrell

  • Support Staff

    •

June 13, 2013 at 3:44 pm

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 );


Mike Johnson

June 24, 2013 at 2:48 pm

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


Josh

June 24, 2013 at 3:34 pm

Hi Mike,

This might answer your SQL tech’s question about interfacing with the database:
http://codex.wordpress.org/Class_Reference/wpdb

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.


Mike Johnson

June 25, 2013 at 2:10 pm

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

 

 


Mike Johnson

June 25, 2013 at 2:11 pm

Mjohnson@firstplan.com

503-221-20230

Client:  Overton Safety Training

 

 


Josh

June 25, 2013 at 3:55 pm

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:

http://staging.eventespresso.com/product/espresso-json-api/
Viewing 6 reply threads

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.

Status: closed

Updated by Josh 11 years, 6 months ago ago

Topic Tags

Tagged: ,

Notifications

This topic is: not resolved
Event Espresso - Staging Server