🚩 Red Triangle: Errors in List Creation
When you create a recipient list by importing a .CSV file, the Atom system performs automatic validation of all data. If it detects inconsistencies, it will show you a warning indicator.
🔍 How to See Error Details?
After importing customers, you will be able to see the upload details and its status. If there are failures, you will see an error counter in red (the famous red triangle or red number). By clicking on this number, you will be able to download a file with the exact details of what failed and in which row.
📋 Common Errors Guide and Solutions
Below, we detail the possible error messages you will find in your downloadable report and what you should do to resolve them:
Error message in the report | Main cause and Solution |
The value of the {header} column could not be converted to number | The information field in Atom is configured as numeric or currency, but your CSV file is sending text or special characters (letters, symbols). Review the column and remove the text. |
The length of the {header} column is greater than {length} | The text you are trying to upload exceeds the maximum character limit allowed for that specific field. You must shorten the information in your Excel. |
Duplicate phone number in the file | Atom has detected that multiple rows (records) are attempting to load the exact same phone number. Filter and remove duplicates in your original database. |
Phone number format is not correct | The phone number entered is not valid. Remember that it must be a numeric value of 10 to 13 digits. The system accepts that it includes (or does not include) the |
The row does not have the same number of values as the file header | There is a mismatch in the document structure. This generally occurs when the CSV separator (commas |
Does not contain the phone field | The most important field for sending (the phone) is empty in that specific row. |
💡 Expert Tip
Before exporting your Excel to CSV format, select the entire phone number column and make sure the cell format is "Text" or "Number without decimals" to prevent programs like Excel from converting long numbers to scientific notation (e.g. +5.73E+11).
Flawless databases, successful campaigns! 🚀
The red triangle and its downloadable report are not blockers, but your best quality auditors. Before attempting to upload your file a second time, make sure to clean empty cells, review numeric formats, and remove duplicate contacts. A clean list is the first big step to ensuring the success of your campaign! ✅