Page MenuHomePhabricator
Create Task
Maniphest T32427

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

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
TitleReferenceAuthorSource BranchDest Branch
test-scap-backport shared change_id testsrepos/releng/train-dev!10jhuneidiT323277main
Scap backport: Request dependencies for a specific changerepos/releng/scap!72jhuneidiT323277master
Customize query in GitLab

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:56 PM
• bzimport added projects: Data-Engineering-Wikistats, acl*sre-team, Shell.
• bzimport set Reference to bz30427.
• bzimport added a subscriber: Unknown Object (MLST).
He7d3r created this task.Aug 17 2011, 7:29 PM
Bawolff added a comment.Aug 17 2011, 7:32 PM

As an aside, some of the data is available at the toolserver for folks with toolserver access.

Reedy added a comment.Aug 17 2011, 11:56 PM

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?

He7d3r added a comment.Aug 24 2011, 6:22 PM

(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

Reedy added a comment.Aug 27 2011, 11:53 PM

Do you have any preferences for the formatting of the output?

Is Tab/CSV ok?

He7d3r added a comment.Aug 29 2011, 3:32 PM

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

Reedy added a comment.Aug 31 2011, 3:23 PM

http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/ReaderFeedback/ReaderFeedback.sql?view=markup

Do you need/want all of the tables?

He7d3r added a comment.Aug 31 2011, 6:44 PM

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

MarkAHershberger added a comment.Oct 25 2011, 12:12 AM

http://rt.wikimedia.org/Ticket/Display.html?id=1801

Reedy added a comment.Oct 25 2011, 12:19 AM

(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

Aklapper added a comment.Dec 3 2012, 2:00 PM

[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:

ptwikibooksreaderfeedback.sql.gz426 KBDownload

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL