Community Wishlist Survey 2023/Editing/Create an easy-to-use editing interface for JSON tabular data
Create an easy-to-use editing interface for JSON tabular data
- Problem: Most graphs are uploaded by the creator as an image and can't be edited by anyone else. You can use tabular data that can be edited by anyone, but this requires knowledge of JSON and the tabular data system.
- Proposed solution: Create an easy-to-use editing interface for JSON tabular data pages. This same tool could seemingly be used to edit any JSON page.
- Who would benefit: Editors of tabular data, and readers who want to consume more up-to-date data.
- More comments:
- Phabricator tickets: phab:T248897
- Proposer: Wikideas1 (talk) 09:18, 25 January 2023 (UTC)
Discussion
- @Wikideas1: What you're looking for may already be possible! Have you looked at Help:Tabular Data for information about storing the spreadsheet data on Commons (there's a gadget for working with CSV) and the Graph extension for displaying that data? SWilson (WMF) (talk) 10:06, 25 January 2023 (UTC)
- Pinging @Wikideas1 again in case they missed the first ping. MusikAnimal (WMF) (talk) 22:04, 3 February 2023 (UTC)
I tried it is too complicated. --Wikideas1 (talk) 05:57, 4 February 2023 (UTC)
IMO there are a number of problems that make Graph + tabular data infeasible in practice, solving any one of them would be a good step.
- Make the tabular data editor a little more functional (T248897).
- On top of that, maybe make it possible to edit without going to Commons.
- Allow flexible (more granular that the whole spreadsheet) sourcing (T250919).
- Show a useful diff for changes to a data table (as opposed to raw JSON diffs).
- Figure out change propagation (right now Vega is just making cross-wiki API requests which is not a reasonable solution).
- Figure out the no-JS experience for graphs (T249419) although this is probably too big for CommTech.
- Add some kind of templating system for Graph, where you can plug in basic chart settings and get a Vega definition out of it. Maybe this can be done already with normal templates, not sure; there are some that are pretty easy to use (mw:Template:Graph:World Historical Highlights, mw:Template:Graph:Weather monthly history) but those all assume a very rigid data format and a very narrow use case.
- Expose some of that functionality via VisualEditor.
On the more general topic of how to store data tables, there has been some discussion (related to Covid data) at T250065.
The improvements to the tabular data editor would be a good sized project for CommTech IMO, although in itself it doesn't help that much with this wish, but goes maybe third of the way towards decent graph management functionality. --Tgr (talk) 04:31, 5 February 2023 (UTC)
- Thanks for the detailed breakdown of the situation, Tgr! I agree and am thinking that overall, rewording this proposal to suit the first task you mention (Create an easy-to-use editing interface for JSON tabular data pages) would make for a perfectly-sized project for us and would be helpful even beyond management of graphs. @Wikideas1: How do you feel about that? With your permission, I will make these changes to your proposal, then run them by you once more for approval. Let me know what you'd like to do. Thanks, MusikAnimal (WMF) (talk) 03:21, 6 February 2023 (UTC)
- That all sounds good to me.
Thank you Wikideas1 (talk) 04:03, 6 February 2023 (UTC)- @Wikideas1 How does it look now? I also would like to rename the proposal to "Create an easy-to-use editing interface for JSON tabular data pages", but I'd like you to first confirm your happy with the rewording I've done to your proposal. Thanks, MusikAnimal (WMF) (talk) 18:49, 6 February 2023 (UTC)
- Sounds interesting I like it. I’m looking forward to seeing what it looks like.
- Wikideas1 (talk) 19:13, 6 February 2023 (UTC)
- @Wikideas1 How does it look now? I also would like to rename the proposal to "Create an easy-to-use editing interface for JSON tabular data pages", but I'd like you to first confirm your happy with the rewording I've done to your proposal. Thanks, MusikAnimal (WMF) (talk) 18:49, 6 February 2023 (UTC)
- That all sounds good to me.
Voting
- Support--Proeksad (talk) 20:55, 10 February 2023 (UTC)
- Support عُثمان (talk) 23:45, 10 February 2023 (UTC)
- Support --NGC 54 (talk|contribs) 00:44, 11 February 2023 (UTC)
- Support XtexChooser (talk) 02:40, 11 February 2023 (UTC)
- Support Tgr (talk) 03:24, 11 February 2023 (UTC)
- Support And please, make it easier to use them on a Wikipedia, mention exactly on the Help page what to write on a Wikipedia page, for a beginner, to get a Data file there (and make it as easy as placing a photo on Wikipedia); I did not succeed to even get an existing Data file in my Sandbox. --JopkeB (talk) 06:02, 11 February 2023 (UTC)
- Support Libcub (talk) 06:58, 11 February 2023 (UTC)
- Support Lion-hearted85 (talk) 12:51, 11 February 2023 (UTC)
- Support OwenBlacker (Talk) 14:40, 11 February 2023 (UTC)
- Support CROIX (talk) 15:14, 11 February 2023 (UTC)
- Support This is extremely useful for storm seasons summary page. Thingofme (talk) 16:00, 11 February 2023 (UTC)
- Support HLFan (talk) 07:29, 12 February 2023 (UTC)
- Support Wiki-uk (talk) 09:42, 12 February 2023 (UTC)
- Support Acky69 (talk) 13:21, 12 February 2023 (UTC)
- Support Current realisation is not easy to use. D6194c-1cc (talk) 15:46, 12 February 2023 (UTC)
- Support HenriHa (talk) 17:41, 12 February 2023 (UTC)
- Support — putnik 14:28, 13 February 2023 (UTC)
- Support Excellence (talk) 20:28, 13 February 2023 (UTC)
- Support cyrfaw (talk) 12:17, 15 February 2023 (UTC)
- Support Aishik Rehman (talk) 07:27, 16 February 2023 (UTC)
- Support β16 - (talk) 15:53, 16 February 2023 (UTC)
- Support Zache (talk) 05:08, 19 February 2023 (UTC)
- Support Niskka2 (talk) 22:14, 19 February 2023 (UTC)
- Support — Draceane talkcontrib. 11:10, 20 February 2023 (UTC)
- Support Eli0030 (talk) 14:28, 20 February 2023 (UTC)
- Support Jeeputer (talk) 21:35, 20 February 2023 (UTC)
- Support Althair (talk) 03:56, 23 February 2023 (UTC)
- Support Juandev (talk) 10:49, 23 February 2023 (UTC)
- Support CmdrDan (talk) 17:39, 24 February 2023 (UTC)