Data uploads can go into error for a number of reasons. The best way to avoid the most common ones is to make sure your data is written and formatted correctly before you upload it, so it can be stored properly in the database.
How should I format the data in my cells?
The data in each column needs to match the data type of the field it is being mapped to.
For example, if a column is mapped to a Date field, every cell in that column must contain a valid date, using digits only and no letters.
What can I use in column headers and sheet names?
Because of how the database handles and stores uploaded data, only certain characters can be used in column headers and sheet names. The database can only process:
- Letters (a-z, A-Z)
- Numbers (0-9)
- Underscores (_)
Any punctuation, such as &, @ or %, will cause upload errors.
What about hyphens?
Hyphens can sometimes be used in column headers and upload successfully, but the database can't always process them. It is best to avoid them.
Why does this matter?
Formatting your data this way stops uploads going into error unnecessarily. It also means that if an upload does error, our support team can focus on finding any bugs or underlying issues rather than ruling out formatting problems.
Still need help?
If you have any questions, get in touch through the live chat in the bottom right corner of your Force24 platform. Our team will be happy to help.