Hi Discourse comm, I have a lot of content from an old xenforo database that I want to import, but I don’t want to do a few things: Ideally, I only want to import the threads and the first post from each thread, I also want to re-assign the thread starter to a different discourse forum/user accoun…

[image] Jason: import the threads and the first post from each thread just modify the SQL in the import script SELECT p.post_id id, t.thread_id topic_id, #{@prefix_as_category ? "t.prefix_id" : "t.node_id"} category_id, t.title title, …

@RGJ thanks for the quick response, you couldn’t happen to show me the SQL statement with the correct4 edit, ive tried including the AND p.post_id = t.first_post_id to the where clause but im getting SQL validation errors on the statment oh and where is this import script?! thanks for spoonfeeding …

[image] Spent hours trying and got no where really, is there no paid support with discourse for this type of thing?

[image] Jason: is there no paid support with discourse for this type of thing? You could probably make a topic in Marketplace .

So I’m getting this error: cannot load such file – /var/discourse/config/environment and in base.rb line 16 this exists: require_relative “../../config/environment” nothing in any import/migraton tutorial mentions the fact this doesn’t exist

Migrate specific Xenforo content

Support Migration

Firepup650 (Firepup Sixfifty) January 13, 2024, 6:44pm 5

You could probably make a topic in Marketplace.

Topic		Replies	Views
Import Data from Xenforo to Discourse Marketplace	3	484	January 13, 2024
Migrating Xenforo 2.2 to Discourse Marketplace	2	1224	March 24, 2022
Questions About Migrating From Xenforo Self-hosting	21	6610	November 21, 2016
Importing a Xenforo forum to Discourse in 2024 - anything to be aware of? Migration xenforo	0	124	September 26, 2024
Migrate a XenForo forum to Discourse Sysadmins how-to	95	22908	October 5, 2026

Migrate specific Xenforo content

Related topics