Changes

<!--T:20-->See also:* In the select window, click on the [[Importing a New Data Source Tutorial|See a Tutorial]]* [[Excel Importing Guide|Excel Importing Guide]]* [[CSV Importing Guide|CSV/Text Importing Guide]]* [[Importing Problems|Check Importing Problems]]* [[Import/Update_data|Update Data]]* [[Automate_Update_data|Data Update Automation]]* Download a sample file here: '''[[Special:FilePath/Sales.xlsx|Sales.xlsx]]'Add new data source'' option;

See <!--T:2-->First select the ''New datasource'' option in the [[File and identificationMain Page Overview#Menu|Menu]] for information on how to continue.in the [[Main Page Overview#Datasource Tab|Main Page]]:

<!--T:3-->[[File:Novo_arquivo+en-US.PNG|800px|link=]]  <!--T:23-->* '''File''': Choose the file to be imported. Click on the ''Browser'' button to search your computer for files. See [[Supported File Formats]] for more information;* Columns can not '''Name''': Datasource name. This is the name that will be added between displayed on the '''[[Main Page Overview|main page]]''';* '''Description''': An optional description for the new datasource.  <!--T:24-->If you have doubts, click on the links "''Tutorial Video''", "''A sample spreadsheet''" and other "''Importing Tips''".  <!--T:31-->'''Spreadsheet sample''' <!--T:32-->[[File:Exemplo_en-US.PNG||1000px|link=]]  <!--T:25-->Click '''Send File''' button to continue.  <!--T:26-->On the next screen, you must inform the original columns in file specifications: <!--T:4-->[[File:Formatação dos dados+en-US.PNG|800px|link=]]  <!--T:5-->* '''Charset''': Specifies the filecharset. Usually, the correct option is automatically selected. For CSV files only; <!--T:6-->*'''Start row''': Specifies which row of the file the import process should start reading. Headings should be included if the ''Header row'' option is checked. For CSV files only; <!--T:7-->* It is possible to add column '''Date mask''': Choose the [[Date]] fields mask in the file. The selected mask must be exactly equal to the end of format used by dates in the file.; <!--T:8-->* '''Delimited by''': Specifies the columns delimiter character. Select between ''Tab'', ''Semicolon'', ''Collon'' or ''Another character'' (for ''Other'' type the desired delimiter in the field). Usually, the correct option is selected automatically. For CSV files only; <!--T:9-->* Columns names can not '''Header''': Check if the file has a ''Header row'' that identifies the columns. The header will be changed used as the default name for the columns in the datasource; <!--T:10-->* '''Decimal Separator''': Specifies the decimal separator used in the file . <!--T:11-->* '''Columns options''': Click the column headerin the preview table to select and change its options:** '''Column data type''': Specifies the column data type: [[Date]], [[Text]] or [[Value]];** '''Column names can be changed in name''': Specifies the column name.;** '''Decimal places''': Specifies how many decimal places. For [[Input Data FormatValue]] stepcolumns only;  <!--T:27-->'''Notes:'''* Is very important to set the right type for each column. When the type is not right, but objects that already use this column the word NULL will keep be shown in the previous namecells.* The Formula columns show the expression used in the spreadsheet or text file.*You can´t delete existing columns in the datasource.* To updateIn value columns, remove and add again the column empty cells (NULL) will be converted to the object;"0".* Columns can In date columns, empty cells or not valid dates will be converted to NULL.* In text columns, empty cells will be removed from converted to NULL.  <!--T:36-->If you made a sctructure change the header collums apper whit different collors an extra screen will show you the alterations to confirm the file;changes.* Columns must maintain its original order New columns in the imported file;, the header color will be yellow.* Columns Probably wrong columns the 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=]]  <!--T:12-->Click the '''Next''' button to continue. <!--T:13-->If you are [[Import/Update data|updating]] a datasource, go directly to the [[New Data Source Summary|import summary]].  <!--T:14-->On the next screen, you can automatically generate a set of dashboards with your imported data type : <!--T:28-->The process will try to find compatible dashboards with the information you provided.  <!--T:29-->[[File:Colunas geração+en-US.PNG|800px|link=]]  <!--T:15-->Select the main [[Date]], [[Text]] and [[Value]] columns that TaticView will use to automatically generate dashboards.  <!--T:30-->Click the '''Next''' button. To skip the automatic dashboards generation, click '''Skip step'''. You can not be changed;do this later. See [[Generate dashboards]].  <!--T:17-->[[File:Resumo importação+en US.PNG|800px|link=]]  <!--T:18-->Check the summary information and click the '''Finish''' button to complete the operation and schedule the data import.  <!--T:33-->[[File:progresso_importacao+en-US.PNG|800px|link=]]  <!--T:34-->Wait for TaticView to create/update the required structures and schedule the data import. If everything is ok, click the '''Done!''' button.  <!--T:19-->When the datasource import/update is completed, TaticView will automatically update the status on the [[Main_Page_Overview|main page]].    </translate>