[图片] These days we have a category importer and exporter that @neil built, you would use that to merge instances I’m trying to use this and I am not having much success. [图片] Move topics from one Discourse instance to another Self-Hosting Need to move some stuff from one instance of Discourse to another? There is a command line tool to export a topic, a set of topics, or an entire category, and another to import them in at the other end. Topic Export/Import one or more topics and their replies the users who posted in the topic Category Export/Import the category and all its subcategories its security settings custom groups mentioned in the security settings warning if any of the groups have ‘membership requests’ enable… Discourse A has ~100k posts and Discourse B ~30k posts. I’ve moved all categories under one main category and then exported it from Discourse B. When I import into Discourse A only 5 posts are added and two are attributed to an incorrect user. For the incorrectly attributed example post I’ve noticed that in Discourse B it was made by a user with a user id 176, and in Discourse A it is attributed to a user with the same user id. But those are two distinct users. No users in A and B have the same email address, but ~100 have the same user name. Oddly, when I first tried a test to see if this could work, I ran the export-import and it seemed that most of the 30k posts were transferred, but post ownership was completely jumbled. Perhaps a fix to the post ownership issue could be to change user ids in Discourse B before export so that they don’t have a duplicate in Discourse A. Can this be done in bulk? Do i need to change usernames in B, and can it be done in bulk by adding “_2” to each username? As for the 29,995 posts that didn’t make it over - I’m stumped. I see those topics scroll by during import, but not in Discourse A after import.

If you have a budget and would like me to write an importer, let me know or post in #marketplace. Users, posts, and categories should be easy enough, but you’d also want to replace @mentions and post/topic links within discourse, which would add a bit of complexity. Maintaining user and post stats could also be done with more time or money.

[图片] omarfilip: No users in A and B have the same email address, but ~100 have the same user name. I think I see why that’s happening. The topic importer only looks at email address, but it uses a common importer method to create a new user when it doesn’t find an existing user with the email address. That method will look for a matching username, which is not what I want… This is a bug so I’ll have a look. Scratch that. It does work by looking only at email addresses. @omarfilip Was your Discourse A site a migration from other forum software?

[图片] neil: Was your Discourse A site a migration from other forum software? Yes - “A” is from phpBB using @gerhard’s awesome importer, and “B” came from an ancient forum that @pfaffman successfully converted from a sql dump.

I see. So user id 123 from phpBB “A” is not the same user as user id 123 from ancient forum “B”, but the importers are going to see them as the same and not create possible duplicate users. That’s normally the behaviour we want, but not in this case. We need a way to force treat all incoming users as new.

OH! In that case you (or I) should run that script on top of your new data rather than try to merge the two Discourses. I didn’t know (or didn’t fully appreciate) that was what you were trying to do. I think it might “just work” to run it on top of your forum, but it might need some tweaks. Send me an email with the details and we’ll figure out how to proceed.

[图片] neil: user id 123 from phpBB “A” is not the same user as user id 123 from ancient forum “B” Correct. However, username johndoe from “A” is the same person with username johndoe in “B.” In my case it would not matter much if during the conversion (or in a prep step before) johndoe from B became johndoe_2.

[图片] omarfilip: However, username johndoe from “A” is the same person with username johndoe in “B.” In my case it would not matter much if during the conversion (or in a prep step before) johndoe from B became johndoe_2. That should happen automatically if the import script runs on top of your existing Discourse database.

[图片] pfaffman: run that script on top of your new data rather than try to merge the two Discourses. Would an incremental import from phpBB work after that script was run? (To catch up with posts that were made after I made the initial import from phpBB.)

I’m pretty sure that this will work: freeze the live formerly phpbb Discourse, backup restore that backup to a development machine import the ancient data on dev machine backup restore to prodcution profit The only question is whether there are any clashes between import ID on the phpBB data and the ancient data. This should be pretty easy to fix in the importer (e.g., add “X” before all of the import IDs).

Merging two Discourse forums

Product Support Migration

pfaffman (Jay Pfaffman) 2017 年10 月 23 日 05:01 2

Hmm. I think the solution might be to write an importer for Discourse.

Could be an interesting project.

话题		回复	浏览量
Merging 2 discourse forums Product Support	15	2973	2021 年1 月 8 日
Merge two Discourse forums into one Marketplace	3	500	2024 年3 月 28 日
Migrate a phpBB3 forum to Discourse Migrating to Discourse how-to	464	109417	2025 年9 月 4 日
Merge two Discourse sites into one Migrating to Discourse how-to	5	9902	2025 年1 月 25 日
[Paid] Migrate proprietary forums to Discourse Marketplace delivered	3	1494	2020 年4 月 16 日

Merging two Discourse forums

相关话题