Change UID to User ID in user export

Problem

Because the first column of the export files is called "UID" programs like Excel think the file is in a different format than CSV and refuse to properly open the file.

Source https://www.alunr.com/excel-csv-import-returns-an-sylk-file-format-error/

After many hours of pulling my hair out trying to work it out I discovered that if you make the first letters “ID” of a text file Excel incorrectly assumes you are trying to open an SYLK file (whatever one of those is!).

Solution

Rename the first column from UID to User ID.

The biggest problem with this solution is that it will break existing scripts that use this information (so it's a breaking change).

An alternative solution would be to simply add "User ID" as first column instead, that avoids the issue. It has the disadvantage of duplicating the user id in the data (the ID field can then be deprecated for a future version)?

Possibly it could also resolved by moving the User ID to be the second or last column in the CSV file but that makes user readability more difficult. However, if a script is properly written (to use the header names and not the positions of the columns) then this shouldn't break any scripts relying on the CSV data.

Other

No matter the solution this will probably need a change record.