To resolve this:
First, access the File Layout Help for this Data Refresh type and determine if the column(s) are mis-spelled or need to be removed from the data file (not listed in the File Layout Help).
If your message is in one of these forms:
The following columns are not part of your layout (Alumni). ().
The following columns are not part of your layout (Parents). ().
The following columns are not part of your layout (Students). ().
The last part of the message identifies the issue: "( )" means the the data file contains an empty column. No column name displays within the parenthesis because the column is empty and has no name.
An empty column sometimes is the result of exporting from the source application, converting from a different file format to .csv or from modifying the data file in Excel after exporting it.
- In Excel, open the original data file. You may need to auto-widen the columns so they show all of the data in the fields or columns.
- Slowly scroll right until you see a column with no header.
- Delete that column as well as the next 5 columns (just in case there is more than one).
- Re-save the Excel file.
- Save the file again but this time in .CSV (Comma Separate Value) format.
Warning: Different problems can be introduced if you open a .CSV file in Excel, edit it, and then re-save it as .CSV. For example, doing this will drop any leading zeros which can cause problems during a data refresh. So if the original file format was Excel, open and edit the original file, instead of editing the .CSV formatted file.