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.
- Powerful spreadsheet lib: https://github.com/handsontable/handsontable (No longer freely licensed)
Description
Description
Related Objects
Related Objects
Event Timeline
Comment Actions
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.
Comment Actions
@cscott, is there an example of a custom content hadler VE implementation? Something to quickly get started?
Comment Actions
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.
Comment Actions
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?
Comment Actions
@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.
Comment Actions
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/
Comment Actions
I'd like to also request such a feature. An interface on a wiki page similar to Google Spreadsheets would be convenient for large datasets. There are some open source javascript spreadsheet libraries like SlickGrid that might be able to be adapted to Mediawiki.
It would also be great if other wiki pages could read cells from these spreadsheets, something like {{{Sheet:Example|C43}}} to get the value of cell C43, as well as users had the ability to write to a specific cell with the API.