Skip Navigation

[Resolved] Relationship post data export to CSV

This support ticket is created 6 years, 4 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- - 14:00 – 20:00 14:00 – 20:00 14:00 – 20:00 14:00 – 20:00 14:00 – 20:00
- - - - - - -

Supporter timezone: Asia/Ho_Chi_Minh (GMT+07:00)

This topic contains 6 replies, has 2 voices.

Last updated by Beda 6 years, 4 months ago.

Assisted by: Beda.

Author
Posts
#957379

I have a custom post type for events, I created another custom post type for event participants registration. I added one to many relationship from events to events participants post type (following https://toolset.com/learn/create-membership-site-wordpress-using-toolset-plugins/allowing-members-sign-special-activities/).

Now I want to know, how can I export the list of participants of a particular event?

#957906

That is not possible with Toolset.

Toolset lets you create, display, and even export the structure of those data sets.
However, the data is stored by WordPress, in native WordPress (or custom) Database tables, and belongs to the content, not the structure, which is what Toolset lets you export/import.

In that sense, Posts content (participants) should be exported with the Tools > Export of WordPress For example, but they do not allow to filter by our relationships or any other relations.

The particular scenario where you want a button or other mechanisms to export a certain set of posts only, needs custom code.

Additionally you may be interested in this:
https://toolset.com/documentation/user-guides/how-to-import-content-into-wordpress-using-csv/how-to-import-data-from-a-csv-file-using-the-wp-all-import-toolset-types-add-on-plugin/

It allows you as well to import posts with an add-on to wp-all-import plugin.
But this is for Import, not export.

Last but not least, have you seen https://toolset.com/download/toolset-advanced-export/?
It allows you to export various settings which are not covered by the WordPress XML export as seen in Tools > Export.
But in that you can no0t handle posts, I just wanted too share that in case you can use it.
You can export Reading settings, Customizer setup, Menu setup and Widget setup.

That is basically all we cover in Toolset.

The particular feature you mention would need something new, that is not within the scope of Toolset, but interesting.
I will keep this as a note, and eventually we can iterate such a feature in future, but for now this is not possible.

it would however be possible to display those posts with Views.
Do you need information how to do that?

#957912

Yes Beda, that would be a very useful feature to have in Toolset. I had tried to use "WP All Export" plugin (https://wordpress.org/plugins/wp-all-export/) but couldnt figure out how to get the field where it stores relationship data (I mean the event name which that person registered for). I am just getting list of the custom fields of that post type.

I had already gone through the links you mentioned before opening this ticket.

Can you please explain me how to show list of participants of particular event in view? I am a bit confused of the "one to one" or "one to many" or "many to many" relationships. Would be helpful if your team could make short videos explaining them.

#957932

Never mind I got the list with view

#957935

Great!

Please let me know if you need more help with this list of the related posts.
The DOC is here, I forgot that earlier:
https://toolset.com/documentation/post-relationships/how-to-display-related-posts-with-toolset/

#957944

The solution I found is (incase anyone else want to know) to display all the entries in a table and created a print style sheet to hide everything else but the table. That way I can print and save the list as PDF which works for me.

#957946

Changing State of ticket - Thank you for sharing the solution!