Is it possible to export topic post data to a csv file? I’d like to take a topic post and all of it’s replies and turn it into a handy wiki (for example). I could copy and paste the replies and find a good way to group them. However, if it’s easier to do an export of a topic and all replies I’d welcome the time saver. If not an option via csv, could this be done via the data explorer? I’d like to see the reply content along with the associated user who replied.

Yes, you can export the query result to a CSV file. You have a button for that action: [image] I’m not entirely certain if this is precisely what you had in mind, but I can provide you with a starting point. You provide a topic ID and the post number you want to get all replies from: -- [params] -- integer :topic_id -- integer :post_number SELECT u.id, u.username, p.raw, p.cooked FROM topics t JOIN posts p ON t.id = p.topic_id JOIN users u ON p.user_id = u.id WHERE t.id = :topic_id AND p.reply_to_post_number = :post_number AND p.hidden_at IS NULL AND p.deleted_at IS NULL This looks like this: [image]

Thanks for your advice, @merefield and @Arkshine. I shall explore and give some things a go.

האם ניתן לייצא נתוני פוסטים של נושא ל-CSV?

תמיכה

merefield (Robert) 14 בפברואר,‏ 2024,‏ 3:53pm 2

This might help, if not exactly what you ask, raw format:

https://meta.discourse.org/raw//295350

נושא		תגובות	צפיות
Need data explorer query to export an entire topic Data & reporting sql-query	2	551	12 בנובמבר,‏ 2023
User posts export as csv or text Data & reporting sql-query	5	1276	31 ביולי,‏ 2023
Is there a way to export topics/posts that are displayed when filtering? Product Support	6	929	28 בספטמבר,‏ 2023
How-to export list of all topics in csv? Data & reporting sql-query	2	948	25 במרץ,‏ 2023
Capture just the posts in a topic Product Support	5	685	22 בנובמבר,‏ 2022

האם ניתן לייצא נתוני פוסטים של נושא ל-CSV?

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