rcgillis initiated a discussion in the Product Support category, seeking a method to export specific post metadata (such as category, URL, title, and author) for posts within a particular forum category. They expressed difficulty using the data-explorer plugin for this purpose and asked if alternative plugins or external utilities existed.
Adam_Root responded that the Data Explorer is indeed the optimal tool for this task, eliminating the need for additional plugins. He explained that users can construct custom SQL queries to retrieve only the desired fields while excluding post content. Additionally, queries can be filtered by category ID to restrict the export scope. Adam_Root noted that results can be downloaded directly as a CSV file and asked for clarification on whether the user needed data for individual posts or topics, as this distinction affects the SQL structure.
rcgillis clarified that they intended to export details for individual posts, not just topics. Although they acknowledged their limited SQL skills and a preference for simpler solutions, they agreed to revisit the Data Explorer with this guidance.
Finally, Moin offered a practical workaround for the technical barrier, suggesting that the AI bot at ask.discourse.com is highly effective at generating Data Explorer SQL queries. They also encouraged the user to seek further assistance within the forum community if needed. The thread highlights that while the default interface may present a learning curve, combining Data Explorer with AI-assisted query writing provides a robust solution for metadata extraction.
I’m looking to export the metadata of some of my posts within my Discourse forum.
For, example, within one particular category on my forum, I want to export just some of the metadata for the posts: e.g. category, URL, title, author, etc. and not the contents of the posts themselves.
I tried using the data explorer, but couldn’t really get there - curious if there’s another plugin or external utility that might do this job.
Thanks in advance for any insight anyone could provide.
I think Data Explorer would actually be the best option for this. You shouldn’t need another plugin.
You can create a custom SQL query that pulls only the fields you need, such as category, topic title, URL and author, without including the post content.
You can also filter the results by category ID, so you’re only exporting data from that particular category.
Once the query is working, you can download the results as a CSV file.
Are you looking to export details for each individual post or just the topics within that category? The SQL query would be slightly different depending on that.
Thanks for your response. Will give the Data Explorer another chance - my SQL skills aren’t the best, so I was hoping for an easier option, but I’ll see what I can do.
I think I would be looking to export a few details for individual posts, but not all of the post metadata (e.g. date, title, category,etc.)