If a CSV file contains special characters, you cannot import the user data by using the LDAP import for UBA. When you upload a CSV file by using the import tool, you receive the following message:
The file name must not contain spaces or special characters.
- SSH into your QRadar console.
Note: You can do this on any system with access to the grep command.
- Copy the CSV file to your current directory.
- Use the following command to find the invalid characters:
grep -P "[\x80-\xFF]" invalid_characters.csv
Rows with an invalid character are displayed, and the invalid characters appear in red. Edit the file to remove them, then upload the CSV as normal.
Was this topic helpful?
09 November 2022