Support

Home Forums WP User Integration Identify Tables for CSV Export

Identify Tables for CSV Export

Posted: March 29, 2016 at 4:34 am


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

  • Support Staff

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

  • Support Staff

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.

The support post ‘Identify Tables for CSV Export’ 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.

Event Espresso