Template generation
When you create a new template, you can automatically generate it from a file.
You will need to upload a spreadsheet file, and select the necessary settings for generation.
If the spreadsheet file contains multiple sheets, the first sheet will be used for generation.
The first row of the spreadsheet will be used as column names. If a column has no name, it will be named Unnamed: №.
You can read more about the column settings that will be generated in the "Column settings" article.
Data format is completely correct
ON (default) - the data type of a column will be recognized only if the values of this column fully correspond to the format of one of the available data types.
I.e. columns will have the data type:
- Date - all values fully match the format of YYYY-MM-DD
- Date and time - YYYY-MM-DD HH:mm:ss
- Time - HH:mm:ss
OFF - it will automatically check if it is possible to convert column data to one of the valid formats. And if it is possible, the column will be assigned the appropriate data type.
So if the setting is turned off, some columns may get a data type that they don't currently match, but they can be converted to it.
If the column does not match any data type, it will be considered as Text.
Spreadsheet may contain errors
ON (default) - the template generation will take into account that a small portion of the spreadsheet data may contain errors.
OFF - the generation will assume that the spreadsheet data is completely correct and error free.
This setting affects the definition of the data type. If it is ON and a column contains most of the data in one format and a small amount in another, the data type will be defined for most of the data.
It does not affect the recognition of column limits.
Generate column limits
ON (default) - the template generation will recognize column limits, including determination of column dependencies on each other (IF limits).
OFF - column limits will not be recognized.
You can read more about column limits in the "Column limits settings" article.