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.
Background is, that we are trying to exclude one Category and before that, we need to export the most viewed topics.
Thanks alot!
merefield
(Robert)
September 21, 2023, 7:20am
2
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.
1 Like
This works only for selfhosted discourse i guess?
merefield
(Robert)
September 21, 2023, 7:29am
4
Nope. That should work on any instance. Added examples above.
1 Like
merefield
(Robert)
September 21, 2023, 7:39am
5
Another solution is to recreate your query in Data Explorer , and that provides .csv or .json export formats
3 Likes
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!
2 Likes
merefield
(Robert)
September 28, 2023, 3:55pm
7
Just noting this initiative here as related:
We have recently introduced an innovative /filter route, enabling more sophisticated filtering of the topics list. Significantly, this marks the initial step towards a unified topic filtering language for both search and filtering. Additionally, the dedicated route for topic list filtering enhances the customizability of the sidebar, as users can now incorporate links as custom section links within the sidebar.
How to turn it on
Enable the experimental_topics_filter site settings in the admin iā¦
system
(system)
Closed
October 28, 2023, 3:56pm
8
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.