Palo Alto Networks Knowledgebase: Error When Importing a CSV File into a Custom URL Category

Error When Importing a CSV File into a Custom URL Category

2289
Created On 02/07/19 23:48 PM - Last Updated 02/07/19 23:48 PM
URL Filtering
Resolution

Issue

Attempting to import a CSV file, created by Excel on a Macintosh (Mac) computer, into a Custom URL Category by clicking "Import" under Objects > Custom URL Category, Category Name results in the following error:

"Invalid characters found in file"

Import Error.PNG

Cause

By default, Excel on a Mac will create a file that uses only carriage return characters to separate lines instead of the Unix EOL format (newlines) or the Windows EOL format (both newlines and carriage returns). This causes the import to fail.

Resolution

When using Excel on a Mac, and saving a CSV file that will be used to import URLs into a firewall, save the file as"Windows Comma Separated (.csv)" instead of the default CSV format. This will save the file in a compatible format.

Import Error Cropped.png

owner: jhess



Attachments
Actions
  • Print
  • Copy Link

    https://knowledgebase.paloaltonetworks.com/KCSArticleDetail?id=kA10g000000CltuCAC&refURL=http%3A%2F%2Fknowledgebase.paloaltonetworks.com%2FKCSArticleDetail

Attachments
Choose Language