We have a Moodle site that we need to bulk assign existing LDAP users a system role. Our users are enrolled via SOAP UI messages from our enrolment platform. I've got a spreadsheet of over 1000 employees (email address and full name) to update, but I cannot confirm if all have logged into the system (to create the local account in Moodle). I am aware that Moodle has a bulk edit feature, but I don't want to use this in case it creates manual Moodle accounts for users it cannot locate, as this won't connect the Moodle account via LDAP and with the SOAP UI messages coming through.
With this in mind, how can I bulk update these users with the system role required?