Page MenuHomeMiraheze

Ext:DataTransfer requires outdated PHPExcel, Should use PHPSpreadsheet
Closed, DeclinedPublic

Description

I want to make articles generated from tables on spreadsheets (CSV) to document all Wikimedia wikis. I know that this already works in another wiki I work in, Bluepages (https://www.bluepageswiki.org/).

I'm sure that this relates to the Special:ImportCSV function that is currently inacessible for my means, and returns "You are not allowed to execute the action you have requested."

Please help!

Event Timeline

AmandaCath subscribed.

Hi @Dibbydib. In order to access Special:ImportCSV and Special:ImportXML you need to grant the datatransferimport permission to administrators (or whichever user group you wish to be able to import data). You can do this via Special:ManageWiki/permissions. Access that page on your wiki and then select which group you want to grant the right to from the dropdown menu. You should then see a checkbox that says "datatransferimport (import data)" - check that box and submit the changes. The import special pages should then work.

RhinosF1 closed this task as Invalid.EditedJun 29 2020, 08:08
This comment has been deleted.

Whoops, it was 'Import Spreadsheet', not 'ImportCSV' that I was looking for

which that doesn't work either, although I'm getting somewhere! "You must have the PHPExcel library installed to run this page." it says. Can't find an extension like that though.

You must have the PHPExcel library installed to run this page."

Link or Screenshot?

RhinosF1 edited projects, added Extensions, Upstream; removed MediaWiki.

It looks like DataTransfer is very outdated. Support for PHPExcel ended 2019, has been deceprated since 2017 and was last updated in 2015.

It should be https://github.com/PHPOffice/PhpSpreadsheet.

I'll move this upstream later.

RhinosF1 renamed this task from ImportCSV to Ext:DataTransfer requires outdated PHPExcel, Should use PHPSpreadsheet.EditedJun 29 2020, 08:23
RhinosF1 closed this task as Declined.
RhinosF1 claimed this task.
RhinosF1 moved this task from Backlog to Deployed Extension Bugs on the Extensions board.
RhinosF1 moved this task from Assignments to Tracking on the Amanda Catherine board.