User talk:West.andrew.g

From Wikipedia, the free encyclopedia
Jump to: navigation, search


This is the talk page for user West.andrew.g. Should you need to contact me in a more private manner, it is not hard to find my email address on my professional homepage. Though I am usually a good talk page watcher, sometimes professional deadlines and conference travel may slightly delay the process. If you are not a regular here, I will generally post talkback templates to your user page. If you are a regular, I operate on the assumption you've watchlisted this page. Thanks!

Page view stats[edit]

Hi Andrew, I noticed that you populate the list of "most viewed" pages for En WP using the page view data dumps. I was wondering if there is a way to do this completely programmatically; I want to replicate that for Fa WP through a bot, if possible. Please advise here or on my talk page or feel free to email me. Thanks in advance, hujiTALK 17:51, 6 August 2015 (UTC)

@Huji: Hi there. My lists are generated completely programmatically, but it would take some work and a database server to port them to another language. Basically, my workflow is that a 'cron' script hits [1] nightly and gets the 24 hourly files. It parses only English NS0 portions to an SQL database on a machine that I own. On Sunday nights I essentially run a big sort query over the weekly column aggregate to produce the ranking, and format this as a pretty report on-wiki committed via the Mediawiki API. All meaningful code is in Java. If we're still speaking the same language here I am more than happy to provide the source code I use to run this, but I cannot volunteer my SQLDB/server. Thanks, West.andrew.g (talk) 19:07, 6 August 2015 (UTC)
Thanks Andrew. I would love to see the code. I may end up rewriting it as a bash script, and most likely run it on the Labs servers, but having a look at your code can be really influential. You can email me via the wiki. Thanks hujiTALK 18:52, 7 August 2015 (UTC)
Yes check.svg Done. West.andrew.g (talk) 19:08, 7 August 2015 (UTC)

TOP 5000 isn't loading properly in my computer anymore[edit]

It loads the first image, but then crashes. I've done a check of my computer and internet connection, and apparently there's nothing wrong on my end. Might you have some idea of what's going on? Serendipodous 08:08, 11 August 2015 (UTC)

Works fine here. Anyone else? Thanks, West.andrew.g (talk) 22:28, 11 August 2015 (UTC)
I saw this week's just fine, as I have for quite a few weeks in a row. The new workflow of deleting the old list just before posting the new list seems to help. -- WeijiBaikeBianji (Watch my talk, How I edit) 22:45, 11 August 2015 (UTC)
It must be my computer then. I have no idea what's wrong. According to my ISP, my connection is fine. Serendipodous 07:02, 13 August 2015 (UTC)
I'm probably not going to get this sorted without paid help, so for the time being, could you create a "Top 50 or so" (possibly before Sunday?) so I can do the Top 25 report? Serendipodous 13:58, 13 August 2015 (UTC)

──────────────────────────────────────────────────────────────────────────────────────────────────── Maybe the raw wiki mark-up version via API is of some help? Thanks, 20:28, 13 August 2015 (UTC)

Seems searchable, so I guess it will have to do for now. Thank you! :) Serendipodous 20:33, 13 August 2015 (UTC)

Detecting socks working on promotional articles[edit]

In case you or someone in the group you left at your university have some time, there is an interesting problem that could possibly be solved with an analysis of recent edits. The background is that a massive group of socks has just been revealed as being involved in a nasty racket to earn money. They would monitor new articles (or drafts) looking for weak articles on companies that will probably be deleted. I'm not sure of the details, but apparently they kept the wikitext, then waited for the article to be deleted. When that happened they would contact the company and offer to create an article and monitor it, for a fee.

Background reading:

Suggestion #11 ("Actively look for mutual patrolling") on the last page is where an analysis would help. Part of the method was that editor A would create the article after a fee had been set, and editor B would mark the page as patrolled. A and B are part of a team of socks who mutually support each other. By marking the page as patrolled, they hope one of the hard-nosed new-page patrollers won't notice, and the weak article might not be nominated for deletion. A nice project for an advanced student (or an advanced PhD!) would be to try to detect groups of mutually supporting editors who do a few inconsequential edits on other pages to disguise their intentions, but who focus on helping each other on new company articles. Interesting? Johnuniq (talk) 10:58, 1 September 2015 (UTC)

Stiki Down[edit]

Hi Andrew, is it just my computer or is stiki down at the moment? Regards, Telfordbuck (talk) 17:59, 3 September 2015 (UTC)

ClockC -- STiki is down, and I've contacted my colleague. Unfortunately, he reports that physical security has changed and he no longer has access; troubleshooting that now. Thanks, West.andrew.g (talk) 18:23, 3 September 2015 (UTC)