Changes

'''This section will show you how to import a new data sourcedatasource.'''

* [[Importing a New Data Source Tutorial|Video See a Tutorial]]

* [[Import/Update_data|Update Data]]* [[Automate_Update_data|Data Update Automation]]* Download a sample file here: '''[http[Special://wiki.taticview.com/taticfilesFilePath/Sales.xlsx |Sales.xlsx]]'''  <!--T:35--><span style="color: red;">'''Important:'''</span> Data import is not allowed through tablets and smartphones.

First select the ''New datasource'' option in the [[Main Page Overview#Menu (Sidebar)|Menu (Sidebar)]] in the [[Main Page Overview#Datasource Tab|Main Page]];:

'''<!--T:22-->On the next screen.''':

[[File:Novo arquivoNovo_arquivo+en-US.PNG||500px800px|link=]]

* '''Name''': Data source Datasource name. This is the name that will be displayed in on the '''[[Main Page Overview|main page]]''';* '''Description''': An optional description for the new data sourcedatasource.  <!--T:24-->If you have doubts, click on the links "''Tutorial Video''", "''A sample spreadsheet''" and other "''Importing Tips''".  <!--T:31-->'''Spreadsheet sample'''

'''<!--T:26-->On the next screen , you must inform the file specifications.''':

[[File:Formatação dos dados+en-US.PNG|500px800px|link=]]

* '''Charset''': Specifies the file charset. Usually , the correct option is automatically selected. For CSV files only;

* '''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;

* '''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 sourcedatasource;

<!--T:27-->'''Notes:'''* Is very important to 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.

* When 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.  <!--T:36-->If you made a sctructure change the header collums apper whit different collors an extra screen will show you add new the alterations to confirm the changes.* New columns in the imported file , the header color will be redyellow.* You can´t delete existing Probably wrong columns in data sourcethe header collor will be red. <!--T:37-->'''Attention:''' After you confirm this screen and process the importation you can't undo the changes.  <!--T:38-->[[File:newfields+en-US.PNG|800px|link=]]  <!--T:39-->[[File:newfields1+en-US.PNG|800px|link=]]

If you are [[Import/Update data|updating]] a data sourcedatasource, go directly to the [[New Data Source Summary|import summary]].

'''On the next screen , you can automatically generate automatically a set of dashboards with your imported data.''':

<!--T:28-->The process will try to find compatible dashboards with the information you provided. New generated dashboards will have the [[File:db_genenerated.png]] icon.

<!--T:29-->[[File:Colunas geração+en-US.PNG|500px800px|link=]]

Select the main [[Date]], [[Text]] and [[Value]] columns that TaticView will use to automatic automatically generate dashboards.

[[File:Resumo importação+en US.PNG|500px800px|link=]]

Use When the Refresh option in datasource import/update is completed, TaticView will automatically update the status on the [[Main Page Overview#Data SourcesMain_Page_Overview|main page]] to update the data source information with it current status and check whether the import is finished.