Hi, we would like to export specific topics after we filtered for them. As an example: I filter for posts/topics that have more than 1000 views. It shows about 50 results. Then I would like to be able to export the 50 topics, answers included. The export as CSV or PDF would be my preference. Backg…

Another solution is to recreate your query in Data Explorer , and that provides .csv or .json export formats [image]

Stick .json on the end of the path and that will give you a JSON export? e.g. https://mydiscourse.org/tag/my-fab-tag/l/top.json?period=quarterly or https://mydiscourse.org/search.json?q=user%3A%20bob%20cats Then just copy the text from the browser … and store wherever.

This works only for selfhosted discourse i guess?

Nope. That should work on any instance. Added examples above.

Alright I see. The .json works for the list of topics, but does not include the answers. So I will have to use the Data Explorer instead. I saw that in another topic here before, but I thought there would be any other chance. Seems not. Thank you @merefield for the quick response and help!

Just noting this initiative here as related: [图片] Experimental topics list filter feature Feature We have recently introduced an innovative /filter route, enabling more sophisticated filtering of the topics list. Significantly, this marks the initial step towa…

是否有办法导出筛选时显示的帖子/主题？

支持

merefield (Robert) 2023 年9 月 21 日 07:39 5

另一种解决方案是在 Data Explorer 中重新创建查询，它提供 .csv 或 .json 导出格式

3 个赞

话题		回复	浏览量
Export topics to Excel Support	12	1285	2021 年3 月 30 日
Need data explorer query to export an entire topic Data & reporting sql-query	2	496	2023 年11 月 12 日
Exporting all Topic titles and IDs? Dev	1	1523	2018 年1 月 22 日
Is it possible to export topic post data to csv? Support data-explorer	3	353	2024 年2 月 14 日
User posts export as csv or text Data & reporting sql-query	5	1100	2023 年7 月 31 日

是否有办法导出筛选时显示的帖子/主题？

相关话题