Import error: Can't process number '#####' because it is too big (or too small)
Mar 5, 2020 12:55 PM
I'm attempting to import a file to update the value of a contact property for a set of contacts. The file contains the 'Contact ID', and a column containing the property value to be updated.
The property being updated is an 'Unformatted number'.
To date, this property has been set either via a form, or directly in the contact UI, with no issues.
The values being set for the property are 22 digit numbers which look like this: '0500191111111001110785'.
The import process is returning this error for every record in the file:
Can't process number '0500191111111001110785' (from column 'property_name') because it is too big (or too small)
However I can successfully set the same value via a form or in the contact UI.
It appears that some kind of validation is being applied to the value during the import, however I can't see what this validation is, or if it is configurable. I also don't understand why the import would apply validation that doesn't exist anywhere else, and prevent me from entering what is otherwise a perfectly valid value for this property.