Validation errors

Error	Explanation
Invalid data: 'XYZ' is not a valid value	This happens if importing data into a checkbox, radio button, or dropdown and 'XYZ' isn't one of the storage values for that field. For example, if importing into a checkbox, use the X and NULL values.
Invalid data: 'XYZ' is not a valid date or in the expected format of mm/dd/yyyy or mmddyyyy	This happens if importing into a date field and 'XYZ' isn't formatted as either mm/dd/yyyy or mmddyyyy.
Invalid data: does not agree with the defined data type	This happens if importing alpha characters into a numeric field or vice versa.
There should be 9 columns in the row for TRT	The data record doesn't have exactly 9 columns in it.
There is no blank line at the end of the file and thus the last line of the import file will fail to import	The last line in your spreadsheet / file should be blank so that all records above are imported.
Form and field combination require copy / group / subgroup / grouping4 / grouping5	This happens when importing into a field that's part of at least 1 group and a group number hasn't been specified in the proper column.

Warnings a validation report
Warning	Explanation
Invalid data: 'XYZ' is longer than the allowable length of number - data will be truncated	The data value 'XYZ' is longer than the maximum length of the field and 'XYZ' will be truncated when imported.
Copy / group / subgroup / grouping4 / grouping5 value set to # but not needed for form and field combination so will be ignored	This happens when importing into a field that's not a part of at least 1 group, but at least 1 number in a group column exists that doesn't need to be there.
Invalid form name	The form name for this data record does not exist.
Invalid field name for Form ABC	The form name ABC for this data record is valid but a field with this field name does not exist.

This article applies to: