External Data Upload Error Handling

There are a few reasons your data may not be uploading, or may have been rejected. Here are some things we recommend you check in your data before you try to upload it.

1. Use a single sheet

Your file should not contain multiple sheets. If it does, the upload process will not know which one to choose and will reject the file:

2. Avoid special characters in column names

Make sure your column names do not contain any special characters, as the upload process does not accept them. Please avoid characters such as underscores, commas and question marks. The full list is shown below:

3. Map your external ID

Make sure you map your external ID as a field within your data set. The external ID is the unique identifier for each instance, and without it the data will not be uploaded:

4. Remove formatting from your file

Make sure your file does not contain formatting, such as drop-down lists or conditional formatting. The file should contain plain text and numerical values only.

5. Match the values to your Force24 fields

Double check that the values in each of your columns match what is expected in the Force24 external data fields. For example, if the Price field is an integer in Force24, the matching column in your file must contain an integer (numerical) value. Entering a text value may result in the file being rejected.

6. Watch for commas in numbers in CSV files

If you are uploading a CSV file that contains numerical values with a comma in them, you need to remove the commas from those values first. Alternatively, convert the file to XLSX before uploading. This is because a CSV treats the comma as a separator, so the value will not be read correctly when it is uploaded.