Open main menu

TaticView β

Changes

Importing a New Data Source

19 bytes added, 19:32, 19 October 2016
no edit summary
<!--T:5-->
* '''Charset''': Specifies the file charset. Usually , the correct option is automatically selected. For CSV files only;
<!--T:6-->
<!--T:8-->
* '''Delimited by''': Specifies the columns delimiter character. Select between ''Tab'', ''SemicollonSemicolon'', ''Collon'' or ''Other Another character'' (for ''Other'' type the desired delimiter in the field). Usually , the correct option is selected automatically. For CSV files only;
<!--T:9-->
* '''Header''': Check if the file have has a ''Header row'' that identifies the columns. The header will be used as the default name for the columns in the data source;
<!--T:10-->
<!--T:27-->
Notes:
* Is very important set the right type for each column. When the type isn't is not right normally , the word NULL will be show 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.
<!--T:14-->
'''On the next screen , you can generate automatically a set of dashboards with your imported data.'''
<!--T:28-->
<!--T:15-->
Select the main [[Date]], [[Text]] and [[Value]] columns that TaticView will use to automatic automatically generate dashboards.
<!--T:30-->
<!--T:19-->
Use the Refresh option in on the [[Main Page Overview#Data Sources|main page]] to update the data source information with it its current status and check whether the import is finished.
</translate>