[01:57:45] <legoktm>	 Nemo_bis: how is https://phabricator.wikimedia.org/T121332 ?
[07:09:22] <MatthiasG>	 Greetings, I get a vulva picture and spam for https://en.wikipedia.org/wiki/Keflav%C3%ADk_International_Airport (NSFW) when obtaining the page from Vancouver, Canada. It is not present if I log in or wget the page from a server in Germany. Any ideas?
[07:12:55] <ori>	 MatthiasG: you are getting served from different cache data centers; they can sometime briefly be out of sync. I don't see a lewd picture when loading from SF, though (which should be hitting the same DC as Vancouver0
[07:12:56] <legoktm>	 MatthiasG: there was some vandalism that was reverted, but it might still be in a cache somewhere...I think I cleared it, how is it now?
[07:13:53] <MatthiasG>	 It is present if I obtain the page with wget, so it is not my browser cache
[07:15:34] <MatthiasG>	 @legoktm okay, just did it another time and it seems fine now
[07:15:35] <MatthiasG>	 thanks
[10:15:14] <Nemo_bis>	 Glaisher: do you have enough open tasks in GCI?
[10:15:31] <Glaisher>	 No, just one so far.
[10:15:44] <Glaisher>	 I have others on mind but haven't gotten to do it yet
[10:16:01] <Nemo_bis>	 Glaisher: ok, I only asked in case we forgot to publish some.
[10:16:26] <Nemo_bis>	 It's quite hard to keep track per-mentor, see also https://groups.google.com/forum/#!topic/gci-mentors/OKG8hjBa5U4
[10:17:07] <Glaisher>	 ok
[10:17:12] <Glaisher>	 thanks
[10:47:38] <Nemo_bis>	 I keep expanding instructions on https://codein.withgoogle.com/dashboard/tasks/4582997936308224/preview/ , I hope they actually make things clearer...
[13:38:32] * twkozlowski got a database error when trying to oversight stuff on Commons. Ugh.
[13:39:27] <twkozlowski>	 Not sure if that should be followed-up with a bug report on Phabricator?
[13:43:51] <Reedy>	 lock wait timeout?
[13:47:59] <twkozlowski>	 https://phabricator.wikimedia.org/T121306#1876262
[21:07:27] <legoktm>	 Nemo_bis: how does {{#translation}} work?
[21:19:10] <dtm>	  <dtm> hey guys is it possible to set a sortable table to be *automatically* sorted by a particular column? 
[21:19:11] <dtm>	  <dtm> i just created this table and i want it sorted by year https://en.wikipedia.org/wiki/Game_Freak#Gameography
[21:40:15] <MGChecker>	 I think it isn't possible (maybe with special js tools)
[21:56:02] <Platonides>	 edit it so it's written sorted by that column…
[21:59:15] <quiddity>	 dtm, it is not possible. see https://en.wikipedia.org/wiki/Help:Sorting#Initial_sort_order_of_rows  -- i suggest possibly the easiest method to re-sort, would be copying the wikitext into a spreadhsheet, dragging the rows there, and copy&pasting that back into the article in visualeditor. (at least until https://phabricator.wikimedia.org/T88694 )
[22:13:31] <dtm>	 quiddity, oh okay!  thanks
[22:13:37] <dtm>	 thanx guyz
[22:13:52] <dtm>	 yeah i'd already done that and i should have told LibreOffice to sort it while it was there
[22:14:07] <dtm>	 i have a workflow for converting lists into tables
[22:14:53] <dtm>	 basically this:
[22:14:54] <dtm>	 #convert Wikipedia lists to tables
[22:14:54] <dtm>	 cat foo.text | gsed -e 's,* ,,g' -e "s,'' (,''\;,g" -e 's,) — ,;,g' > foo2.csv
[22:14:54] <dtm>	 #import csv to OpenOffice, rearrange columns
[22:14:54] <dtm>	 #export to csv with semicolon delimiters
[22:14:54] <dtm>	 #convert from csv to wikicode tables
[22:14:58] <dtm>	 cat foo3.csv | gsed -e 'G; s/$/|-/;' -e 's,;,||,g' -e 's,^,|,g' -e 's;,;||;g'
[22:21:39] <MGChecker>	 O, if you can sort it in an Office program there is a way with VisualEditor
[22:23:11] <dtm>	 MGChecker, orly.
[22:23:22] <dtm>	 i just did it manually but how is that done?
[22:23:41] <dtm>	 i guess i can try it again with the previous version just to see it ;)
[22:23:51] <dtm>	 it turns out that i needed to manually consolidate some too.
[22:24:24] <quiddity>	 select the table in openoffice, ctrl-C, and paste whilst editing with VE. :)  it works from csv, too.
[22:24:55] <MGChecker>	 I have heard some time ago you cn copy the table in view mode in your office program, sort it there and than paste it in VisualEditor
[22:26:11] <dtm>	 oh okay yeah.
[22:26:46] <dtm>	 well i would have done some of it more precisely anyway
[22:38:07] <dtm>	 Zhaofeng_Li, as the President of the ZHaofeng_Li fan club, i just wanted to let you know... every day, i am hanging on the hope that you will implement the ability to strip and reformat existing citations <3 <3  I am just about ready to make someone write me a regexp so i can just do it by copy and paste ;)
[22:38:17] <dtm>	 :-D
[22:38:31] <dtm>	 half the citaitons on wikipedia are hot garbage
[22:39:00] <dtm>	 it's the stupidest thing in the world how people add print-medium-like citations on a digital-only encyclopedia
[22:39:14] <dtm>	 to the point where they write out the domain name of the web site where they got it wtf
[22:39:23] <dtm>	 so stupid.
[22:41:41] <dtm>	 blammo
[23:14:55] <Nemo_bis>	 legoktm: {{#traslation:}} outputs nothing on base page or the language subcode like /it for translation pages