Understand and fix CSV upload errors using the descriptions below
After you submit your CSV file, you will see a screen that gives you the status of each entry (row) that was on the CSV file. If an entry does not upload successfully, an error message will appear. See the list below for information on what the error messages mean.
Important:
- If the system catches an error in an entry on the CSV, it stops evaluating that entry. The first error it encounters for that entry will be noted, but that does not mean it is the only error for that entry.
- When fixing your CSV file to re-upload, make sure you remove the entries that were successfully uploaded and leave only the entries that failed. If you do not remove the successful entries, duplicates will be created on the platform.
General Error Messages
Your CSV file is empty: The CSV file was empty. Double check your file, and if the entries are present, try re-uploading.
You've provided too much data: The CSV file was too large. The CSV file can only contain 50 entries and cannot have information in any rows beyond row 51. If you have less than 50 entries in your file, scroll down to see if there is any extra data hanging out further down the file (e.g., row 73 has a character in one of the cells).
Check for comma, there should be no standalone commas in your file. If there are no standalone commas, confirm that you don't have data in any column beyond those listed in the CSV: Remove all commas from the entry.
Field-Specific Error Messages
Missing: The following error messages indicate that the required field is missing information on the CSV.
- engagement_description missing
- work_state missing
- send_company_questionnaire_to_other missing
- company_questionnaire_email missing
- company_questionnaire_first_name missing
- company_questionnaire_last_name missing
- company_questionnaire_dept missing
- send_and_create_contractor_questionnaire_to_contractor missing
- contractor_email missing
- contractor_first_name missing
- contractor_last_name missing
- contractor_company_name missing: if the contractor does not have a company name, use “N/A”
Char limit: The following error messages indicate that the field contains too many characters.
- engagement_description char limit: field contains more than 4096 characters
- company_questionnaire_email char limit: field contains more than 64 characters
- company_questionnaire_first_name char limit: field contains more than 32 characters
- company_questionnaire_last_name char limit: field contains more than 32 characters
- company_questionnaire_dept char limit: field contains more than 32 characters
- contractor_email char limit: field contains more than 64 characters
- contractor_first_name char limit: field contains more than 32 characters
- contractor_company_name char limit: field contains more than 32 characters
Format: The following error messages indicate that the field contains a formatting error.
- work_state format: state entered does not match the full state name (or District of Columbia); check for misspellings, use of abbreviations, or uncapitalized first letter of the state name
- send_company_questionnaire_to_other format: field is not yes or no; Yes, Y, y, No, N, n are not accepted
- company_questionnaire_email format: field is not formatted as a standard email address
- send _and_create_contractor_questionnaire_to_contractor format: field is not yes or no; Yes, Y, y, No, N, n are not accepted
- contractor_email format: field is not formatted as a standard email address
NO owner match: The following error messages indicate that send_company_questionnaire_to_other is no and the information provided does not match the owner's information in the platform.
- company_questionnaire_email is not owner_first_name: email address must match the owner's email address in the platform
- company_questionnaire_first_name is not owner_first_name: first name must match the owner’s first name in the platform
- company_questionnaire_last_name is not owner_last_name: last name must match the owner’s last name in the platform
- company_questionnaire_dept not owner_dept: department does not match the owner’s department in the platform