Rebels can be imported using spreadsheet files

[mhulet]

The current import (/rebels/imports/new) allows to copy-paste CSV lines.

Local group coordinators want to import Excel files instead. We have to provide a template (can be done manually at an early stage, then a template could be generated for each local group).

The local group coordinator should be able to upload an Excel/Calc file. Then we process the file and import rebels to the local group.

This feature needs more details. If you are interested in working on it, please ping me here and I'll start describing it.

[begault]

Hello @mhulet 👋
Do you have an example of the Excel file wanted ?
If not, do you have an example of the CSV one, to have an idea of what is expected ?

[mhulet]

Hey @begault, thanks a lot for your questions. I will provide a template.

We currently ask coordinators to provide this kind of CSV:

This is this callout: https://github.com/extinctionrebellion/RebelsManager/blob/master/app/views/rebels/imports/new.html.slim#L36

But coordinators want to add more details on Excel files, like skills or working groups. I will shape this feature up until we agree on what should be done.

[mhulet]

Didn't take time yet to shape this feature up.

Basically we want to provide a template to coordinators and they should be able to import rebels.

They should be able to set skills and working groups but users won't like IDs. The best way would be to provide a downloadable template, and this file would include a sheet listing local groups, working groups and skills. Then on the import sheet itself, users will be able to select a local group, working groups and skills.

Also, if it is relevant, we should provide 2 templates: one for Excel, one for OpenOffice Calc.