Hi all, I want to export a user’s posts as a text/CSV file do anyone know how I can achieve this with data explorer or any other way?

I found this code works for data explorer SELECT t.title, p.raw as text, p.created_at as dateposted FROM posts p LEFT JOIN topics t ON t.id = p.topic_id WHERE t.archetype != 'private_message' AND t.user_id = 1 AND p.user_id = 1 AND t.category_id IN (13,7,1,) AND t.deleted_at is null But it only shows 336 results is there any way to pass this limit? as there are around 5k posts.

A user can request a full copy of their posts and other data in CSV format via the Export Your Data section of Preferences. For example here on meta it’s at: https://meta.discourse.org/my/preferences/account System will message them with a link to a zip file. The user_archive.csv contains the post data.

[תמונה] kynic: But it only shows 336 results is there any way to pass this limit? as there are around 5k posts. Isn’t that because the 5000 posts include PMs (maybe deleted messages as well) and you filter your categories?

Including t.user_id would only give posts where the user was also the OP. Could that be the main issue? I noticed a couple of extra bits that may be useful too. Something like: -- [params] -- user_id :user SELECT t.id AS topic_id, t.title, p.raw as text, p.created_at as dateposted FROM posts p JOIN topics t ON t.id = p.topic_id WHERE t.archetype != 'private_message' AND p.post_type IN (1, 4) AND p.user_id = :user AND t.deleted_at ISNULL AND p.deleted_at ISNULL ORDER BY p.created_at

משתמש מפרסם ייצוא כ-CSV או טקסט

קהילה נתונים ודיווח

kynic 29 ביולי,‏ 2023,‏ 5:18pm 4

But this includes PM also and I want only public posts.

נושא		תגובות	צפיות
Is it possible to export topic post data to csv? Product Support data-explorer	3	451	14 בפברואר,‏ 2024
I want to Data Export all the posts for analysis Product Support	8	1206	25 בינואר,‏ 2021
Is there a way to export topics/posts that are displayed when filtering? Product Support	6	929	28 בספטמבר,‏ 2023
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14437	6 במאי,‏ 2025
Discourse Public Data Dump Developer Guides	1	1277	13 במאי,‏ 2025

משתמש מפרסם ייצוא כ-CSV או טקסט

נושאים קשורים