[01:18:04] <Platonides>	 a "problem" there for cross-wiki aggregation is that the user ids are different on each wiki :/
[01:22:26] <effeietsanders>	 yeah, that's something i'm set up for to fix already :)
[01:22:36] <effeietsanders>	 already ran query to collect those ID's
[01:23:57] <Platonides>	 you will need to collect those ids per wiki
[01:24:52] <effeietsanders>	 yes
[01:25:38] <Platonides>	 I'm interesting on what you will find
[01:27:28] <effeietsanders>	 I did some preliminary analysis earlier, suggesting for sep/oct participants that arounf 1% edited in the following january
[01:27:53] <effeietsanders>	 but I'm making the numbers more robust now, and more detailed.
[01:28:05] <effeietsanders>	 I expect to present them at Wikimania
[02:18:25] <danilo>	 my plan to agregate was get the global id for each user, I had drafted the code some time ago but I ended giving up, I thought there was not significant applications for that... but it seems I was wrong
[17:54:58] <effeietsanders>	 danilo just saw your message from yesterday. If it is of any use, feel free to reuse: https://github.com/lgelauff/wikimedia-analysis/blob/main/functions/get_actor_id.py
[18:06:29] <danilo>	 thanks, but the code I was planning is to get the global user id in the centralauth.globaluser table and create a "global.dat" with the agregated data from all wikis using the global user id
[18:07:49] <danilo>	 I started to develop a function for that but I didn't finish it
[18:26:35] <effeietsanders>	 ah, i see. That sounds cleaner than relying on the username, I guess (less hassle with characters) and you'd be able to match through the localuser table? Too bad I didn't think of that earlier :)
[18:49:35] <danilo>	 effeietsanders: no, global user id are not in wikis database, it is only in centralauth database
[18:52:25] <danilo>	 unfortunately the only way to find the global id for each local id is get the username for each local id and then use the username to get the global id
[18:59:46] <effeietsanders>	 danilo wouldn't this table allow you to convert? https://www.mediawiki.org/wiki/Extension:CentralAuth/localuser_table
[19:00:31] <effeietsanders>	 (I'm just not entirely sure if there are still some local users out there that don't have a global user id?)
[20:02:12] <danilo>	 effeietsanders: I missed that table, with that table it is easier than what I was thinking
[20:02:58] <danilo>	 I am also not entirely sure if all users are there, but I guess yes
[21:24:22] <effeietsanders>	 Is there a problem with PAWS currently? I'm experiencing delays logging in and getting anything to run (it worked like a charm up to an hour ago at least).
[21:45:01] <effeietsanders>	 Getting 504 errors now
[23:02:10] <effeietsanders>	 (was able to restart server - now works again)