I’m in the process of migrating a legacy forum with about 1.3 million posts and two decades of history to Discourse.
What I would like to avoid is for every user to show 0 read time from the start upon the successful migration, since many have 5, 10, and some 15+ years of history.
With Discourse’s emphasis on read time (which is great IMHO) it would be nice to be able to do a best efforts calculation of this stat for users who have significant history so that they don’t feel like the clock got reset on their contribution post migration. (While gamification can be a huge inspiration and motivator, it can also be a demoralizer when stats users take pride in are wiped out.)
I realize there’s no perfect way to display data that was never previously tracked, but is there a script I can run, or perhaps something that can be added to an import script that would essentially estimate a users’ historic read time based on their current post count?
PostCount = SELECT posts_count FROM posts WHERE id = (current user id being imported)
ReadTimePerPost = 300 (seconds)
RetroactiveReadTime = PostCount * ReadTimePerPost
Would it theoretically be possible to do this and then insert that number into the database tied each user?
If so, where and how is the read time stored?
And BTW, valuing each post at 300 seconds of read time is just my my estimate. Honestly it is probably very low, all things considered, but much more accurate than 0.