Triva isn't available right now.
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, M/DD/YYYY, MM/D/YYYY, M/D/YYYY, or MMDDYYYY | This happens if importing into a date field and ‘XYZ’ isn’t formatted as either MM/DD/YYYY, M/DD/YYYY, MM/D/YYYY, M/D/YYYY, or MMDDYYYY. |
Invalid data: doesn’t 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 previous records are imported. |
Form and field combination require copy / group / subgroup / grouping4 / | 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. |
File needs to be encoded as ANSI | The file contains some invalid characters that can't be read or the file is not in the required CSV file format. If you used Excel to save the CSV file, make sure you select the regular CSV option, not the CSV UTF 8 option. Using the UTF 8 option might create invalid characters and won’t be readable on import. |
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 doesn’t exist. |
Invalid field name for Form ABC | The form name ABC for this data record is valid but a field with this field name doesn’t exist. |