I want to remove some of the 'optional' data fields from Moodle in order to make Moodle GDPR compliant (I don't want to store data I don't need). This is proving to me much trickier that it sounds. I have found a way to hide the fields, but before doing this I want to erase all data within them. There doesn't seem to be an easy way to do this. Some of the optional fields I can remove, by bulk downloading all users, deleting the data from those columns, and then re-uploading the users, but some of the fields (e.g. alternate names) don't show up in the bulk download so this technique doesn't work.
I cannot even find a way to filter for users that have filled these in, so only option is to go through every single user in turn and check them - which isn't practical.
I am assuming that I am not the only one wanting to do this.
Any advice would be gratefully received.