Exporting all Topic titles and IDs?

[Frank_Bailey]

Hey folks, is there a way I can export a list of topic titles and IDs? I’m happy to do it from the command line in the DigitalOcean droplet via SSH if I have to, if someone might be able to point me in the right direction?

[techAPJ (Arpit Jalan)]

You can do it via data explorer plugin:

Data Explorer Plugin

Summary: The Data Explorer plugin allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. GitHub: https://github.com/discourse/discourse-data-explorer.git Install: Follow the plugin installation guide. Features After installing the plugin, head to /admin/plugins . [de1] Click on the “Settings” button, and turn on data explorer enabled, then return and reload the page. There should now be a tab in the stacked nav cal…

There is an option to export data in CSV format.