You could pre-process the CSV file using Excel or Google Sheets, and map the internal custom id to the ID number using the XLOOKUP function.
Moodle in English -> Attendance (plugin) attendance Plugin - Problem to import CSV -> Re: attendance Plugin - Problem to import CSV
by Eoin Campbell -