|
eConcepts
|
March 29, 2016 at 4:34 am
Hi,
I need to identify which of the tables in the plugin database are used for the CSV Export function. Could you point me in the right direction please?
I’m trying to include the WP-User info with the downloaded CSV file.
I’m using EE4 with the WP User Integration.
Any assistance would e greatly appreciated.
|
|
Josh
|
March 29, 2016 at 1:51 pm
Hi there,
The CSV Export uses information from the following tables:
_esp_transaction
_esp_answer
_posts
_esp_answer
_esp_registration
_esp_ticket
_esp_price
You may want to have a look at the _usermeta table for the wp_EE_Attendee_ID meta_key. The meta_value there will match the value for the CSV export’s Attendee ID[ATT_ID] column. There you can get the user_id from the same row to get the User’s ID.
|
|
eConcepts
|
March 29, 2016 at 6:24 pm
Hi Josh,
Thanks a lot for that. That’s exactly what I needed. Can I also ask where the function to export is located?
Thanks again.
Owen
|
|
Josh
|
March 29, 2016 at 7:15 pm
Hi Owen,
It’s located in the EE_Export.class.php file. I can recommend using the FHEE__EE_Export__report_registrations__reg_csv_array
filter hook to add/remove columns. This way you’ll avoid altering the file directly.
|
