Every column/parameter retrieved from the database has the following configuration options available:
|
Worksheet Column Label
|
Purpose
|
|
Display
|
Choose to display or hide the column from the user. Columns that are not displayed can still be used to pass values to the database object and are used when the loader needs to control default values.
If columns are not required entering, setting Display value to 'No' will create smaller more manageable templates for your users.
|
|
Mandatory
|
Indicate if the column should be mandatory.
If the selected loader template requires a value for this field, the value will be set to 'Yes'.
This will appear as a yellow field in the data entry form and be validated by the Wizard as a not null column.
|
|
Custom View Label
|
Change your loader column headings to more meaningful values for your users. Spaces in column headings are acceptable.
|
|
Comment
|
Enter your own comments which will be displayed as Excel cell comments. These are useful when you need to describe more about the column to users.
|
|
Read Only
|
Choose to make a column read-only where data is displayed but not uploaded.
|