Data Uploads can go into error for a number of reasons. The best way to avoid frequently occurring errors is to ensure the data is written and formatted in the correct way to be uploaded to - and stored in - the database.
Data Types
The data in the cells needs to match the data type of the fields that the columns in the spreadsheet are being mapped to e.g. if the spreadsheet column is being mapped to a Date field, the data in the cells must be in the correct date format with digits only and no alphabetical characters.
Column Headers/Sheet Names
Due to how the database handles and stores the data that is uploaded, only certain characters can be used in the column names and the sheet names. The database will only be able to process alphanumeric characters (a-z, A-Z, 0-9) and underscores (_) in the column names and sheet names. Any punctuation characters (e.g. &, @, %) will cause upload errors. Although hyphens can sometimes be used in column names and upload successfully, the database can't always process them, so it is best to avoid using them.
By ensuring the data is submitted according to these steps it prevents Data Uploads from going into error unnecessarily and allows Support to investigate and identify potential bugs or other underlying issues, should an error occur.
If you have any questions, feel free to reach out to us through the live chat function available bottom right in your Force24 Platform. Our team is ready to assist you and provide support whenever you need it!