In the hosted version of Discourse, which we’re using, we can export all user data, but I only want to export a list of users in one of our forums. It appears to be possible to do it with the self-hosted edition via an API. Is there a way we can get secure access or put in a request to get the data we need?
AI-generated summary
The discussion revolves around exporting user data from a specific category on a hosted Discourse site. Jon_Silvers seeks to export only users from one forum, noting that while a full user export is possible via the Admin / Users page simon, it doesn’t indicate which category users belong to. Jon_Silvers mentions that category-specific exports are possible via API in self-hosted setups, but not accessible on hosted sites. Simon confirms that hosted users lack backend access, making command-line tools unavailable. However, API access is available on hosted sites, though its utility for this task is uncertain. For Business plan users, the Data Explorer plugin can be used with support to create a custom query. For Standard plan users, contacting support directly is recommended for assistance.
You can export a CSV file of all users on your forum from your Admin / Users page. You can find details about how to do that in this topic: Exporting users to a CSV file.
Yes, but I only want to export users from one forum, not the entire community. When you export all users, the CSV doesn’t indicate which forum each user is in. As far as I can tell, the only way to export just users from a single forum – or the only way to identify which users are in each forum – is via the API export. However, for hosted users, we don’t have API access, I believe.
That makes sense. In Discourse terminology what you want to do is export a category. That is possible with the command line tools that are described in the topic that you linked to. On our hosted sites you do not have access to the site’s backend, so this will not be possible for you.
One thing to note, on our hosted sites you do have complete access to the Discourse API, but I’m not sure that will help for your case.
If you are on our Business plan, your best approach would be to use the Data Explorer plugin. We can help you to write a query for that if you’re stuck. If your site is on our Standard plan, get in touch with us through the support email address that’s on your admin dashboard. We’ll see what we can do to help.