There are a few reasons your data is not uploading, or has been rejected. Here are a few things we recommend you look out for in your data, and check before attempting to upload.
1. Your file should not contain multiple sheets. If the file contains multiple sheets, the upload process will not know which one to choose, and will reject it.
2. Make sure your column names do not contain any special characters, these are not accepted by the upload process, so please avoid things like underscores, commas, question marks etc (? , . - _ # ! £ $ “ & *)
3. Make sure you map your external ID as a field within your data set! The external ID is your unique identifier per each of the instances. Without this, the data will not be uploaded.
4. Make sure your file does not contain formatting. This can include things like drop downs, conditional formatting etc. The file should be plain text/numerical values.
5. Double check the values for each of your columns match what is expected in the Force24 external data fields. For example, if the field ‘Price’ is integer in Force24, the field in the file must contain an integer value (numerical). Inputting a text value may result in it being rejected.
6. When uploading a CSV file, if it contains numerical values that have a comma within this value, the comma must be removed from the values first, or alternatively the file must be converted to XLSX to upload because CSVs will treat a comma separated value and not be translated appropriately when uploaded.