Assigning attributes to columns
The Assign column header page displays the defined columns with the skipped header text above. This text can help you assign an attribute to each column. You do not have to assign an attribute to every column. Columns without assigned column headers are not imported.
If you have a Constant Value that applies to each row in the file, at the top of the page click in the Undefined cell and select the attribute. Then enter the value or string for that attribute in the blank cell beside it. This would be the same as having a column with the same value in each row.
To assign each column header:
- Click in an Undefined header cell to display the list of possible attributes for the data type you are importing.
- Select a category to display attributes in the right column. All data types have required attributes. These are conveniently grouped together in a single category. Other categories are data type specific.
- Select the attribute for that column of data.
- Repeat 1-3 for each column. If your data files are the same format, you only need to assign the column headers once as you can save a template of the header selection to use in subsequent imports.
- Save the template. If you save the template on this step of the wizard, the template will also include the file format information.
- Click Next to go to the Summary page.