Citizens and Resident Citizens don't have library articles, so I didn't have any way to pull your actual start date, Jarl, but I'm working on matching it up with Membership's records instead... soonish.
Sa' told me she has a membership sheet which has dates for more folks. Once I have that, I should be able to do another batch before it devolves to manual edits. Updating an individual's line is easy, but there were well over a thousand total to do, so trying to get them done in bulk wherever...
Well, I can't post a gifv in here directly, so you'll have to click a link :(
https://i.imgur.com/m7E1p46.gifv
Something to add to me ever growing todo list
And Marrow, you're in the group I'm working on now. There was a group which was excluded from the original db query (57) which I'm working through now, to see which ones I'll be able to update (looks like most of them)
Okay, for the 479 people who have a Library article, which has the spelling *exactly* match their board username, and also have their start date listed, the Joined dates now match what was in the Library.
I have a list of those who don't have dates in their Library articles and I have another...
Yeah, I figured out a way to pull the data from the library for all the accounts that have it there. Then I'll need to fix any broken dates and then convert them to epoch time, and then update the appropriate rows in the forums, and then verify that they worked.
TLDR: it's probably not going...
I can make this happen. It's not super high on my priority list, but it's also fairly easy to do if you know SQL (which I do) and have a properly formatted list of Names and Join Dates (which I do not). Looks like we have some volunteers for making a properly formatted file, though, so I'll...