Error when uploading CSV file for bulk actions

Environment

• Knox cloud services
• Microsoft Excel

Overview

When performing a Bulk Action in the Knox Admin Portal, you may encounter an error where your CSV file upload isn’t accepted despite following the instructions for the Knox cloud service.

Cause

The CSV file may have failed to upload due to the following conditions:

• Encryption: The uploaded CSV file must be decrypted. Your computer may automatically encrypt files.
• Truncated numbers: Numerical values in the CSV file must be left expanded. Microsoft Excel automatically formats large numbers into scientific notation.
• Default list separator: The CSV file must use the comma (,) delimiter. For example, the default list separator in your region may be the semicolon (;).

Workaround

When uploading a CSV file, ensure the decrypted CSV file is correctly formatted:

• One device IMEI or Serial Number per row
• No headers
• No empty rows
• No truncated numbers
• Uses the comma (,) list separator

If you’re using a spreadsheet software like Microsoft Excel, you can adjust your configuration to follow this format.

To turn off truncated numbers in Microsoft Excel:

1. Select the cell(s) containing truncated numbers.
2. Right click and select Format Cells from the menu. The Format Cells window opens.
3. In the Number tab, select Number from the Category list. This ensures long numbers are stored without being converted into scientific notation.
4. Set Decimal places to 0 and click OK.

To change the default list separator in Microsoft Excel:

1. Click File > Options from the top menu. The Excel Options dialog pops up.
2. Go to the Advanced tab.
3. Under Editing options, de-select Use system separators.
4. Set the Decimal separator to period (.).
5. Set the Thousands separator to comma (,).

You can review and edit a CSV file to ensure that it’s following the correct format by opening it as a TXT file. You can also create a valid CSV file from a TXT file using applications like Notepad++.