feat: add structure import from csv

[spaenleh]

This PR adds support for the new import CSV feature.

In general:

• the handling of the CSV import is now handled in the backend. The frontend only reads the header of the file to determine if a group column is present.
• if there is a group_name column, then the user has the possibility to select an item that will be used as the template for the groups.

In the following video, I import a file that results in 1 membership and 1 invitation.

import.users.csv.mov

import.groups.mov

[ReidyT]

It looks nice, I will check this PR ! I just have few questions about the videos:

• In the first one, why test 1 is not imported in the permission list ?
• In general, could it be possible to add a preview of what the CSV will do ? For example, just listing the mails of the invited users in the first video and displaying the preview before confirming in the second one ? It is just a suggestion but it could be interesting I think.

[spaenleh]

@ReidyT Thank you for the comment.

1. In the first video, there are 2 emails in the csv file, [email protected] is already a member, so a membership is created, [email protected] is not a member, so an invitation is created. You do not see the invitations table in the screen but the invitations is created correctly.
2. I think a plan feature would be really nice indeed, but for the moment it has not been implemented. We do very basic checks to ensure that the file has the minimal required columns ("email") and we try to detect the "group_name" column so show the template selection UI.
3. what could also be added is the possibility to select any type of item. Currently the selection dialog only allows folders but the structure feature would allow to create groups for single items.

[ReidyT]

Really nice PR ! LGTM I just le some comments 🫠

[sonarqubecloud]

Quality Gate passed

Issues
5 New issues
0 Accepted issues

Measures
0 Security Hotspots
No data about Coverage
0.0% Duplication on New Code

See analysis details on SonarCloud