Export from multiple tables | ww.wp.xz.cn

Resolved creativ3y3
(@creativ3y3)

7 years, 9 months ago

Is it possible to export from multiple table data, or views in the database? IE I have one table with data that includes user id. I then want to export this data and get users with the same Id to get their email and join them to the relevant data. I know this can be done using SQL joins but can you do this with the plugin or look at such a view in the data and export it?
Thanks

Viewing 1 replies (of 1 total)

Plugin Author WP All Import
(@wpallimport)

7 years, 9 months ago

Hi @creativ3y3

You can only export from 1 table/post type at a time (the ones listed in the drop down on step 1), but in that export you can use custom PHP functions to grab data from other tables: http://www.wpallimport.com/tour/export-developer-friendly/.

For example, in a “Users” export you could set up multiple fields that are exporting the user ID and use functions on each of those fields to grab different data from other tables.

Viewing 1 replies (of 1 total)

The topic ‘Export from multiple tables’ is closed to new replies.

1 reply
2 participants
Last reply from: WP All Import
Last activity: 7 years, 9 months ago
Status: resolved