Carbon Black Cloud: Error Uploading CSV File To Approve or Ban

Products

• Carbon Black Cloud Endpoint Standard (formerly Cb Defense)

Issue/Introduction

• Attempt to upload CSV hash file fails
• Data looks correct in Excel
• Format looks correct in Excel

Environment

• Carbon Black Cloud: All Versions

Cause

Incorrect structure of data in a CSV file

Resolution

1. Open CSV file in a text editor (notepad.exe, notepad++, etc.)
2. Remove any blank lines or header lines at the top of the file
3. Remove any quotes from the start and end of each line
4. Ensure that any quotes only surround the Application Name and Comments fields
5. Remove any blank lines from the end of the file
6. Upload the file on the Reputations page

Additional Information

• 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