Page MenuHomePhabricator

Provide data collected by ReaderFeedback extension for Portuguese Wikibooks users
Closed, ResolvedPublic

Description

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.


Version: unspecified
Severity: normal

Details

Reference
bz30427

Event Timeline

bzimport raised the priority of this task from to Normal.Nov 21 2014, 11:56 PM
bzimport set Reference to bz30427.
bzimport added a subscriber: Unknown Object (MLST).
He7d3r created this task.Aug 17 2011, 7:29 PM

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

Reedy added a comment.Aug 24 2011, 5:19 PM

The only field with seemingly issues is rfb_ip

Toolserver shows

mysql> describe reader_feedback;
+---------------+------------------+------+-----+----------------+-------+

FieldTypeNullKeyDefaultExtra

+---------------+------------------+------+-----+----------------+-------+

rfb_rev_idint(10) unsignedNONULL
rfb_userint(1)NO0
rfb_timestampbinary(14)NO
rfb_ratingsmediumblobNONULL

+---------------+------------------+------+-----+----------------+-------+

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.

Reedy added a comment.Aug 25 2011, 2:47 PM

(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.

(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.

Reedy added a comment.Sep 2 2011, 11:23 AM

Do you want this just sending to yourself, or putting somewhere more public so people can just download it if they want?

He7d3r added a comment.Sep 2 2011, 5:22 PM

I think it is better to provide it publicily, even if I keep a copy of the file(s).

[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!]

Reedy added a comment.Feb 4 2013, 1:00 AM

Created attachment 11725
Database table dumps

SQL dump of tables attached.

Uses a modified reader_feedback_noip table with the ip address field removed.

Attached: