Last modified: 2013-02-04 01:00:33 UTC
On bug 29983 we requested the installation of ArticleFeedback extension on Portuguese Wikibooks, but since we currently use the ReaderFeedback extension[1], and the two extensions are not compatible (e.g. to export the data from one to the other), it would be useful to have some table with the data collected by the extension so far. PS: * I'm not sure if this is the right component to set for this request. * I'm marking this as a blocker for bug 30426, although they are not strictly dependent on each other. So, feel free to correct it ;-) [1] It was installed in January, per bug 26451.
As an aside, some of the data is available at the toolserver for folks with toolserver access.
I suppose we just need to check if there is any sensitive data, if there isn't, there shouldn't be much issue with creating a dump of the tables
The only field with seemingly issues is rfb_ip Toolserver shows mysql> describe reader_feedback; +---------------+------------------+------+-----+----------------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+----------------+-------+ | rfb_rev_id | int(10) unsigned | NO | | NULL | | | rfb_user | int(1) | NO | | 0 | | | rfb_timestamp | binary(14) | NO | | | | | rfb_ratings | mediumblob | NO | | NULL | | +---------------+------------------+------+-----+----------------+-------+ I'm presuming you don't need that information?
(In reply to comment #3) > I'm presuming you don't need that information? Do you mean, the IP number of the raters? If so, I agree. It is likely unneeded.
(In reply to comment #4) > (In reply to comment #3) > > I'm presuming you don't need that information? > > Do you mean, the IP number of the raters? > If so, I agree. It is likely unneeded. Yeah, that's what I was meaning. I'll bring it up with ops and look at getting you a dump sorted
Do you have any preferences for the formatting of the output? Is Tab/CSV ok?
(In reply to comment #6) > Do you have any preferences for the formatting of the output? > > Is Tab/CSV ok? I think so, since it could be imported to a software such as [[LibreOffice]] Calc for analysis of the data.
http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/ReaderFeedback/ReaderFeedback.sql?view=markup Do you need/want all of the tables?
(In reply to comment #8) > http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/ReaderFeedback/ReaderFeedback.sql?view=markup > > Do you need/want all of the tables? Yep! I would like to have all of them, if that is possible.
Do you want this just sending to yourself, or putting somewhere more public so people can just download it if they want?
I think it is better to provide it publicily, even if I keep a copy of the file(s).
http://rt.wikimedia.org/Ticket/Display.html?id=1801
(In reply to comment #12) > http://rt.wikimedia.org/Ticket/Display.html?id=1801 Original ticket still is http://rt.wikimedia.org/Ticket/Display.html?id=1357
[mass-moving wikistats reports from Wikimedia→Statistics to Analytics→Wikistats to have stats issues under one Bugzilla product (see bug 42088) - sorry for the bugspam!]
Created attachment 11725 [details] Database table dumps SQL dump of tables attached. Uses a modified reader_feedback_noip table with the ip address field removed.
