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 account that I’ve already created. is this possible in an easy-enough way?

[תמונה] 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, t.first_post_id first_post_id, t.view_count, p.user_id user_id, p.message raw, p.post_date created_at FROM #{TABLE_PREFIX}post p, #{TABLE_PREFIX}thread t WHERE p.thread_id = t.thread_id AND p.message_state = 'visible' AND t.discussion_state = 'visible' ORDER BY p.post_date LIMIT #{BATCH_SIZE}" # needs OFFSET add AND p.post_id = t.first_post_id to the WHERE clause [תמונה] Jason: I also want to re-assign the thread starter to a different discourse forum/user account that I’ve already created Change mapped[:user_id] = user_id_from_imported_user_id(m["user_id"]) || -1 to mapped[:user_id] = xxx where xxx is the Discourse user ID you want to assign the topics to.

@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 me i appreciate it

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

[תמונה] 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

להעביר תוכן Xenforo ספציפי

תמיכה הגירה

Firepup650 (Firepup Sixfifty) 13 בינואר,‏ 2024,‏ 6:44pm 5

You could probably make a topic in Marketplace.

נושא		תגובות	צפיות
Import Data from Xenforo to Discourse Marketplace	3	509	13 בינואר,‏ 2024
Migrating Xenforo 2.2 to Discourse Marketplace	2	1263	24 במרץ,‏ 2022
Questions About Migrating From Xenforo Self-hosting	21	6744	21 בנובמבר,‏ 2016
Importing a Xenforo forum to Discourse in 2024 - anything to be aware of? Migration xenforo	0	138	26 בספטמבר,‏ 2024
Migrate a XenForo forum to Discourse Sysadmins how-to	95	23473	5 באוקטובר,‏ 2026

להעביר תוכן Xenforo ספציפי

נושאים קשורים