Fix respondents file upload failures by reviewing common error messages and correcting missing fields, invalid formats or duplicate columns.
If any field is not in the correct format in the respondent data file, exceeds the maximum length, or a required field is missing, the respondent file load will fail on the first occurrence.
Gallup Access will display details about this error. Fix the errors and then reload the file.
Note: Gallup is always adding more detailed messages, so the following list may be incomplete.
| Error Message | Reason for Error |
|---|---|
| You must first select a file to upload. | You did not select a file to upload. Select a file to upload. |
| File upload failed. | The file wasn’t transferred to Gallup Access successfully. Wait a few minutes, then attempt to upload the file again. If you receive this error again, save the file to a local drive if possible and load it again. |
| An error occurred with the uploading of the data in the file. | This is a general error and will display if a more specific error isn’t available. |
| File does not contain any respondent data. | The file contains column headers but no respondent data. Add respondent data and reload the file. |
| Required column is missing: column name | A column that is required to be in the file is missing. Required columns are External ID, First Name, Last Name, Email (or Survey Code), and Country Code. |
| Duplicate columns exist. | The file contains columns that have duplicate header text. Each column header must be unique. |
| Unknown file format. | Gallup Access does not recognize the file format you are attempting to upload. You can only use comma-delimited CSV filetypes to upload respondent data. |
| Required field value missing or invalid for ‘Country’ at row n. | A country code is missing or is invalid in the upload file. |
| A value exists outside of the defined columns in the CSV file. Please remove any extraneous values and load the file again. | There is a value in the Excel file that exists outside the columns that have headings. For example, if you have columns A–G populated and a value exists in column X row 169, you will receive this error. |
| A file is already being loaded. Please wait for this file to successfully load before loading another file. | A file is currently processing and has not completed yet. Wait until you either receive a message that the file has errored out or that it loaded successfully before you load another file. |
| Language code is not recognized as a valid code used by Gallup Access. | You must use a valid language code. |
| A Column Name is larger than 50 characters. Rename the column to be 50 characters or less. | All column header names must be 50 characters or less. Please update your file and then reload. |
| Email column or Survey_Code column is required. | If you selected the Survey Code option, a respondent record must have either the Email or Survey Code field populated in the file. |