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 Medium.Nov 21 2014, 11:56 PM
bzimport set Reference to bz30427.
bzimport added a subscriber: Unknown Object (MLST).

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;
+---------------+------------------+------+-----+----------------+-------+

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.

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

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

[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
Database table dumps

SQL dump of tables attached.

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

Attached: