How To
Summary
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.
Objective
Steps
Identify the invalid characters in your CSV.
- 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
Result
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.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBQAC","label":"IBM Security QRadar SIEM"},"ARM Category":[{"code":"a8m0z000000cwt3AAA","label":"QRadar Apps"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
09 November 2022
UID
ibm16619159