Export topics to Excel

Hi Team,

I have a requirement where user can export all the topics/based on search result all the topics, who created, when created, email address and location to be exported in to excel file. i have searched in the tool report section but haven’t find anything specific to this requirement, all are giving graphical representation of topics and export option.

Regards,
Sundaram

See Data Explorer Plugin. You cask allow group members to run a query. You might be able to write a query that will allow users to add search terms.

Discourse tries pretty hard not to allow users to get email addresses.

1 Like

Thank you Jay but I am looking for something from the Discourse app some report where end users can see the report in tabular format in the forum and can also download it as excel.

You’ll need a custom plugin, then. And I’d think that it would look a lot like how data explorer works.

thank you all for sharing your thought. let me explore data explorer and see how it works. also, is there any possibility down the line provide export button in search result screen like users tab, where user click on export down load the search result as tabular format with Category, Topic, Who Created, When Created, how many likes and views? if discourse team can incorporate this it will be a great help to all the consumers.

Can you please provide the data explorer plugin details? if I have tried the link above but no luck, I don’t see data explorer in the plugin section.

If you are self hosted, you can use the instructions in the link above. If you are using a hosted service you’ll need to contact the provider to get the plugin added (cdck hosting includes data explorer on business hosting).

1 Like

I’m using azure VM linux ubuntu server. i am using ssh script to open app.yml file using nano caontainers/app.yml and i cna see the details also. but when i add the git clone discourse-spoiler-alert.git as per the info shared in above link. I don’t see the data explorer plugin in plugin section. is it the correct plugin name i am using?

No. The data explorer plugin is not named spoiler-alert. That was an example for how to install a plugin. You’ll need to substitute the url for the data explorer plugin.

2 Likes

I am not able to find data explorer plugin url, if you can provide me that details it will be great help.

is it GitHub - discourse/discourse-data-explorer: SQL Queries for admins in Discourse?

I am using Azure VM (Linum Ubuntu server) using command line i am able to open the app.yml file and added the line of code git pull and while saving ctrl+s i am getting error you don’t have permission to write. but this is my root user and using this i have updated discourse and installed also. how can i give permission to that file as i can’t login to the VM only i have ssh command line.

Error writing containers/app.yml: Permission denied

Thank you all, for your help. I am able to enable data explorer and do the querying on live DB and Export as well.

2 Likes