Difference between revisions of "Translations:Importing a New Data Source/27/en"
(Importing a new version from external source) |
(Importing a new version from external source) |
||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | Notes: | + | '''Notes:''' |
− | * Is very important set the right type for each column. When the type | + | * Is very important to set the right type for each column. When the type is not right, the word NULL will be shown in the cells. |
* The Formula columns show the expression used in the spreadsheet or text file. | * The Formula columns show the expression used in the spreadsheet or text file. | ||
− | * | + | * You can´t delete existing columns in the datasource. |
− | * | + | * In value columns, empty cells (NULL) will be converted to "0". |
+ | * In date columns, empty cells or not valid dates will be converted to NULL. | ||
+ | * In text columns, empty cells will be converted to NULL. |
Latest revision as of 02:30, 5 October 2022
Notes:
- Is very important to set the right type for each column. When the type is not right, the word NULL will be shown in the cells.
- The Formula columns show the expression used in the spreadsheet or text file.
- You can´t delete existing columns in the datasource.
- In value columns, empty cells (NULL) will be converted to "0".
- In date columns, empty cells or not valid dates will be converted to NULL.
- In text columns, empty cells will be converted to NULL.