Description of column configuration settings
The Column Name is the field name key that will be pushed to the data destination.
Display Labels will be shown in the header row that the user will see while doing an import. Each Display Label internally maps to a Column Name. While the Display Label will be seen by the users inside the import widget, the corresponding Column Name will be pushed to the destination as the field name. If Display Label is not specified, then the Column Name will be shown to the users by default. This helps you to display a user-friendly label to the users while pushing a column name that your app understands. For example, 'p_id' can be the Column Name and 'Product ID' can be the Display Label.
Info Hints are help tooltips that will get displayed when the users hover the mouse over the Column Name (or click it) in the importer. They are useful to convey additional information about the Column.
You can provide a set of keywords as alternative matching options to help users match column names automatically. For example, let's say you have a column name 'First Name'. If you think a lot of your users might have sheets with columns as 'F_Name' or simply 'First', then you can add two matching keywords 'F_Name' and 'First'. The importer will then automatically match columns to the specified keywords to speed up column mapping.
Apart from Matching Keywords, CSVBox auto-maps columns via continuous learning.
The importer remembers the columns mapped by the users. It then uses the historical mappings to automatically map columns for new uploads. This way the importer adapts and collects new User Keywords as more sheets get uploaded.
You have the option to view and delete the User Keywords via Column Settings.
You also have the option to disable the user keywords-based column mapping completely. Go to the Sheets page > Options tab > Select Enable or Disable User Keywords for Column Mapping.
You can specify a default filler value for the column in case the incoming data is blank.
This option helps you specify the data type of the incoming data and configure relevant validation rules. You can select the column type from the dropdown and set conditions for how the data should be formatted. If the incoming data does not match the column type (and its validation rules), then the user will see a relevant error message identifying what the problem is and how to fix it. This ensures that the data is clean and ready to use before it gets pushed to your app.
The Required checkbox indicates whether a column is mandatory. If the Required checkbox is ticked, then the importer will validate the column for missing/empty data. If any cell in the column is found to be empty then the user will be shown a relevant error message.