Hello. I don’t know if it’s possible, and if it is I googled a lot and did not find anything about this, but I would like to sort all the replies of all the topics of my forum by the created date. I’ve been working on a migration of data from an old forum to a brand new Discourse one. To do that, I am recreating the topics and replies via API so that I can send them to Discourse on the date the reply was created initially. That has been working just fine as when I go to the created replies on Discourse I can see that the original date is over there. [image] But even though all the replies are with the original date, they are sorted by the order they were created on the API. I don’t know if this is a bug or meant to be or if there is any way to sort them by the date I set on the API POST call, but if so I’d like some help on this topic. Cheers guys. I am using version 2.8.8.

[image] Carlos Daniel: To do that, I am recreating the topics and replies via API Don’t do that. You want to use an import script. You can look at discourse/script/import_scripts at main · discourse/discourse · GitHub for examples and search here for instructions for running import scripts for other forums. Posts are displayed in the order in which they are created. So you’d need to have your API script (that you really don’t want to use) create them in the proper order.

Hmmm, thanks for the reply. I did think about using a script a while ago but since Discourse has a lot of table relationships I decided to go through the API. But is there any way to create a script that will insert data in one table and then Discourse handles the rest of the relationship? That might make things easier for me.

But I mean, the migration via API has been working so far. I wonder what is the point of being able to send a created_at attribute on the endpoint to create posts if Discourse won’t show it sorted by it anyway… Shouldn’t this be a feature request?

[image] Carlos Daniel: But is there any way to create a script that will insert data in one table and then Discourse handles the rest of the relationship Yes, in fact, there is! I linked to examples. [image] Carlos Daniel: the migration via API has been working so far. If that were true, you’d not have posted. :wink: [image] Carlos Daniel: Shouldn’t this be a feature request No, because the way to solve your problem is to use one of the dozens of examples that I linked to is the way to solve your problem. I promise it will be much, much easier. I wrote several import scripts before I really even learned ruby. Even if you wanted to use the API, you still need to create the posts in the created_at order. There are ways to sort them in a plugin v(or maybe theme component?) , but you really don’t want to do that. @JammyDodger points out that there is a rake task rake posts:reorder_posts That might solve your problem. If you are importing a few dozens of topics and a few hundreds of posts, you might give that a try.

I see. I will keep following my idea, just wanted to know regarding the created_at attribute on the POST call when creating a post - which is, as it seems, useless, if the posts can’t be sorted by it. Thanks anyway.

Just FYI, the reason things don’t just sort by created date is because things are designed to support moving posts from one topic to another, and in that scenario, it’s proven less desireable to have posts get “mixed up” if the dates overlap. Here’s an earlier discussion about that: [image]Moved posts to existing topic - dates out of order Not sure if this is the correct behaviour, but when moving posts to an existing topic do the posts “blend” together by date or do all the posts that are “merged in” appear at the bottom and dates are ignored. On the topic of how best to approach a migration, I agree w/ Jay. You’re likely better off following prior art here. While not a web API, the existing scripts rely on a lower level “migration API” of sorts with this in mind. The web API is largely designed as an API for the front-end Discourse app. While it’s successfully used for various integrations, it is optimized for it’s primary purpose.

How can I sort the topic replies by date

Product Support Migration

pfaffman (Jay Pfaffman) September 8, 2022, 5:52pm 8

It’s not useless, it sets the created_at date as advertised. Just sort your posts by created_at before you create them.

Topic		Replies	Views
API topic post creation ordered by updated_at or created_at? Product Support	7	1369	April 12, 2018
How to Order Topic Replies in Chronological Order By Default Product Support	4	647	March 27, 2024
How to resort a topic's messages by date? Product Support	5	887	August 4, 2020
Importing from Vanilla Forums results in out-of-order replies. Re-index Replies? Development	9	885	November 11, 2021
Replies in thread showing out of order Product Support	13	2613	December 2, 2020

How can I sort the topic replies by date

Related topics