I’m new to Discourse and have recently inherited a ownership/admin of small, older Discourse community. One of the things I need to do is perform an export of the community’s content: topics, replies, endorsements, associations (author, participants), etc. in CSV, XML or JSON. As a platform novice, how would I go about securing this export? I’ve performed a site backup, but I can’t do anything with the sql file in the tar.gz that I received. I’m currently on the Standard plan. Thanks! (Updated to include that my community is on Discourse.)

The first thing to do is search “#howto YOUR_OLD_COMMUNITY_SOFTWARE”. Then you look in discourse/script/import_scripts at main · discourse/discourse · GitHub. If you are coming from some platform that isn’t supported, the best course of action is to start with one of the existing import scripts. vbulletin might be a good starting point. If that’s not your style, then you can post in #marketplace. I generally do a few of these a month. If you are coming from a popular forum, you can switch to the business plan, pay for a year up front, and get it done for free.

EDIT: @Charles.Dane Since you are using Discourse already, this is what you need to do: Just download a backup and restore it to your new site. You’ll need to contact support and have them restore it.

Hi Jay, appreciate for the response. I just updated my post to specify the community I’ve inherited is already on Discourse. Thanks for the advice to take a look at GitHub, I’ll see what I can find over there. Cheers!

[image] Charles.Dane: One of the things I need to do is perform an export of the community’s content: topics, replies, endorsements, associations (author, participants), etc. in CSV, XML or JSON. What do you want to accomplish with this?

Thanks for the response. My organization is in the process of investigating community platform options, and a review of the community’s content (in one of the three formats) will help us determine our overall scope of effort.

So your have some tool that you want to use to…somehow analyze the data in discourse? What is that tool? What is the analysis that you want to do?

If you absolutely need a database dump in XML/CSV or JSON, why not download a backup and then convert it? There are many tutorials online: [Elitmiar] How to export table as CSV with headings on Postgresql? postgresql, csv, export-to-csv, heading asked by Elitmiar on 03:19PM - 13 Jul 09 UTC The process would be Download backup Extract backup Load backup into local postgres database Export the tables you wish to export as CSV/JSON or XML

Discourse export assistance needed

Product Support Migration

RGJ (Richard - Communiteq) May 4, 2020, 4:56pm 5

What do you want to accomplish with this?

Topic		Replies	Views
Import CSV User Activity from one Discourse to Another Feature	16	1861	December 20, 2023
How migrate from Discourse to another platform of community? Migration	21	2255	May 23, 2023
Migrating Small Community from Discord to Discourse Migration	3	397	February 7, 2025
Downloading Content Product Support	3	303	September 10, 2024
Forum Aquisition Product Support	4	266	March 14, 2026

Discourse export assistance needed

Related topics