Export and import of users from IDP should use tab delimited .csv instead of comma delimited .csv

Hi,

When we export the list of users and their settings from the IDP today, the data gets exported into a .csv file that works with regular commas as separator objects. This can cause problems, as it is possible to have commas in emails, in metadata, in the name of the role, etc. If then the file is opened and worked with, the columns can get misaligned because of this. Same issue with importing - commas can appear in the middle of a role, and cause everything to get misaligned.

My recommendation is to change this export and import to a tab delimited .csv file. There is no way to add tabs anywhere in the IDP page, so this will never cause issues when exporting. Imports will also be easier to navigate, and the files will have less of a chance of "breaking" while working with data that has been exported from idp.

Thanks.

Tagged:
3
3 votes

Open For Voting · Last Updated