Page MenuHomePhabricator

Epic: Implement spreadsheet-like cell editing for tabular data
Open, Needs TriagePublic

Description

Add an ability to edit the table using a spreadsheet-like view (e.g. google spreadsheet, etc). Editing raw JSON is complicated and error prone.

Event Timeline

Yurik created this task.May 7 2016, 12:03 AM
Restricted Application added subscribers: Zppix, Aklapper. · View Herald TranscriptMay 7 2016, 12:03 AM
Eloy moved this task from Backlog to UI on the Commons-Datasets board.May 9 2016, 9:59 PM
cscott added a subscriber: cscott.

Parsoid actually has native support for JSON now: https://gerrit.wikimedia.org/r/295707

All that's needed is VE support for editing this table structure.

@cscott, is there an example of a custom content hadler VE implementation? Something to quickly get started?

Yurik renamed this task from Implement spreadsheet-like cell editing for tabular data to Epic: Implement spreadsheet-like cell editing for tabular data.Dec 22 2016, 7:13 PM
Yurik added a project: Epic.
Yurik updated the task description. (Show Details)Dec 23 2016, 12:11 AM
Reasno added a subscriber: Reasno.May 11 2017, 11:19 AM
TheDJ added a subscriber: TheDJ.Mar 18 2020, 9:16 AM

There are lots of potential libraries for this listed on https://jspreadsheets.com
Also some vue variants, which might be interesting as a test with our new Vue support.

Sophivorus added a subscriber: Sophivorus.

This was discussed at today's Wikipedia Weekly episode where one can watch Fuzheado and Keilana struggle with editing coronavirus statistics: https://www.youtube.com/watch?v=NryHemUKQos

This feature request particularly relevant in the current pandemic. (e.g. https://commons.wikimedia.org/wiki/Data:2019%E2%80%9320_coronavirus_outbreak.tab)

It is great that they are stored as JSON and can be transcluded by all Wikimedia projects, but the lack of a visual interface means that they are very cumbersome to edit.

Can we deploy something like the table editor in VisualEditor to the data namespace on Commons?

TheDJ added a comment.Apr 22 2020, 7:43 AM

@Fuzheado @Keilana there is a csv/excel import/export gadget for that that I made a couple years back. https://commons.wikimedia.org/wiki/MediaWiki:Gadget-TabularImportExport.js

It doesn't deal with the header completely, so you'll need to preserve that one, but it can help you in certain cases.

TheDJ updated the task description. (Show Details)Apr 22 2020, 7:54 AM
TheDJ updated the task description. (Show Details)

this is not a duplicate of T250877 Visual editing interface for tabular data on Commons.
a visual editing interface could edit JSON data like cells in a spreadsheet as VE does. but that is a down select you have made.

here are some examples of JSON as spreadsheet
https://medium.com/@donhopkins/representing-and-editing-json-with-spreadsheets-8f8832db5239

https://sunlightfoundation.com/2014/03/11/making-json-as-simple-as-a-spreadsheet/