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) |
||
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. | ||
− | * When you add new columns in the imported file the header color will be red. | + | * When you add new columns in the imported file, the header color will be red. |
− | * You can´t delete existing columns in data source. | + | * You can´t delete existing columns in the data source. |
+ | * 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. |
Revision as of 04:15, 5 October 2017
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.
- When you add new columns in the imported file, the header color will be red.
- You can´t delete existing columns in the data source.
- 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.