I have successfully imported an export from Vanilla Forum, but the replies in some Topics are not in the correct order. Sometimes by days, sometimes by years. The problem appears to be that Vanilla Porter is simply exporting the replies out of order, with no discernable pattern. Then, when the Discourse import script goes line-by-line and puts the record in its appropriate place, the replies receive an out-of-order ID. I see two possible options: Somehow fix Vanilla Porter Re-index the replies within the Discourse database based on their Create Date #2 seems like it would be easier to do, if at all possible. Any suggestions?

i would log into the cmd line, enter the container and rebake all the post and see if that works cd /var/discourse ./launcher enter app rake posts:rebake

I think there’s a specific rake task - rake posts:reorder_posts [image] Moving posts into an existing topic doesn't keep chronology Feature I had a need to use this for some email threads that were split into separate topics during import so I thought I would elaborate on this in case anyone else also needs it. You’ll need to be able to access the command line on the server running your Discourse instance. Start by moving all the desired posts into the target topic, then get the topic ID. In the address bar you might see something like the following, where the topic ID is 24855: /t/topic-slug/24855/9 On your server, enter the Di…

If the rake task mentioned above doesn’t do it, then what I would do next is to adjust the query that the import script uses to see that the posts are imported on order.

Thanks all! We got it to work. I don’t have command line access, so I’m just waiting for confirmation from the guy who does to see which command he used. I’ll update this thread when I get that.

He was pretty vague, but said he used both commands. So, if anyone needs to do this in the future, give both a try. Sorry I couldn’t be more specific. Thanks for the prompt assistance, folks!

So just rake posts:reorder_posts should do the job?

As long as the posts not being in chronological order is the only issue, yep. The posts:reorder_posts task will deal with exactly that and nothing else.

Perfect, thanks for the clarification! Hope this helps someone else in the future.

Importing from Vanilla Forums results in out-of-order replies. Re-index Replies?

Development

Simon_Manning (Simon Manning) November 11, 2021, 2:48pm 7

The rebake task shouldn’t be necessary, that deals with the contents of the posts which don’t need to change when reordering them.

Topic		Replies	Views
Replies in thread showing out of order Product Support	13	2616	December 2, 2020
How to Order Topic Replies in Chronological Order By Default Product Support	4	648	March 27, 2024
How to resort a topic's messages by date? Product Support	5	888	August 4, 2020
Re-order merged posts Product Support	4	789	August 16, 2022
How can I sort the topic replies by date Migration rest-api	7	1296	September 8, 2022

Importing from Vanilla Forums results in out-of-order replies. Re-index Replies?

Related topics