Changes

Jump to: navigation, search

Importing a New Data Source

2 bytes added, 13:14, 10 June 2020
no edit summary
** '''Column name''': Specifies the column name.;
** '''Decimal places''': Specifies how many decimal places. For [[Value]] columns only;
 
 
<!--T:27-->
'''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 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.
* New columns in the imported file, the header color will be yellow.
* Probably wrong columns the header collor will be red.
 
'''Attention:''' After you confirm this screen and process the importation you can't undo the changes.
[[File:newfields1+en-US.PNG|800px|link=]]
 
<!--T:27-->
'''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 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.

Navigation menu