Technote Details :: When I try to import data from a CSV file, I get an error

When I try to import data from a CSV file with a CSV Import Wizard page, I get an error message on a column name that should have corresponding data:

Error:
Failed importing CSV file
 Line #
 - column name: The field is required.

There are several reasons why this error message will be displayed:

1. The CSV file does not contain a value for the column specified by the error message, or the value is NULL. If the database column is set not to accept null values, this error message is displayed.
2. Form Validation has been applied on the field, marking it as required. Although the database may accept NULL values, if no value exists in the CSV file, or it is NULL, the error message is displayed.
3. The header names are not correct. If the header names that exist in the CSV file do not match the ones specified when creating the page (in the CSV Import Wizard), the column is not recognized. As such it is considered as not having a value, and thus the error message is displayed.

To solve this issue, you can:

1. Check the CSV file contents at the lines specified by the error message. If no content exists for the specified column, or it is NULL, enter some data and try again.
2. Check the CSV file header names. If the header names do not match the ones displayed in the hint on the import page, correct them and try again.