Environment
- Carbon Black Cloud: All Versions
Symptoms
- Attempt to upload CSV hash file fails
- Data looks correct in Excel
- Format looks correct in Excel
Cause
Incorrect structure of data in a CSV file
Resolution
- Open CSV file in a text editor (notepad.exe, notepad++, etc.)
- Remove any blank lines or header lines at the top of the file
- Remove any quotes from the start and end of each line
- Ensure that any quotes only surround the Application Name and Comments fields
- Remove any blank lines from the end of the file
- Upload the file on the Reputations page
Additional Notes
- Required fields: list type, indicator type, indicator value, description (must be in this order)
- Optional field: application name (must appear after those above)
- Blank lines at the beginning or end of the CSV file are seen as a single field
- Header information such as column titles do not match the expected information for the Web Console
- Quotation marks indicate the entire content enclosed in quotes is a single text field instead of individual fields
- If you open the CSV in Excel and the data appears in a single column there are quotes at the front and back of each line
- Copying the data from the CSV into a text editor can also clear data
- Make sure to save the file as a "CSV (MS-DOS)" not a "CSV UTF-8 (Comma delimited)"
- The error "List Type "type" is invalid at line:" can be caused by using UTF-8 with bom, save it without bom
Related Content
