Changes

<!--T:20-->See also:* In the dialog window, select 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]]:

* Columns can not be added between the original columns in the file;<!--T:3-->** It is possible to add column to the end of the file;* Columns names can not be changed in the file header;** Column names can be changed in the [[Input Data FormatFile:Novo_arquivo+en-US.PNG|800px|link=]] step, but objects that already use this column will keep the previous name.** To update, remove and add again the column to the object;* Columns can not be removed from the file;* Columns must maintain its original order in the file;* Columns data type can not be changed;

<!--T:23-->* '''TutotialFile''': Choose the file to be imported. Click on the ''Browser'' button to search your computer for files. See [[Supported File Formats]] for more information;* '''Name''': Datasource name. This is the name that will be displayed on the '''[[Main Page Overview|main page]]''';* '''Description''': An optional description for the new datasource.

 <object width= !--T:24-->If you have doubts, click on the links "''Tutorial Video''", "425''A sample spreadsheet''" height=and other "344''Importing Tips''".  <!--T:31-->'''Spreadsheet sample''' <param name!--T:32-->[[File:Exemplo_en-US.PNG||1000px|link="movie" value]]  <!--T:25-->Click '''Send File''' button to continue.  <!--T:26-->On the next screen, you must inform the file specifications: <!--T:4-->[[File:Formatação dos dados+en-US.PNG|800px|link="http]]  <!--T:5-->* '''Charset''': Specifies the file charset. 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-->* '''Date mask''': Choose the [[Date]] fields mask in the file. The selected mask must be exactly equal to the format used by dates in the file.; <!--T:8-->* '''Delimited by'''://wwwSpecifies the columns delimiter character. Select between ''Tab'', ''Semicolon'', ''Collon'' or ''Another character'' (for ''Other'' type the desired delimiter in the field).youtubeUsually, the correct option is selected automatically.com/v/MDedb1Kgjys&ap=%2526fmt%3D18" /For CSV files only; <!--T:9-->* '''Header''': Check if the file has a ''Header row'' that identifies the columns. The header will be used as the default name for the columns in the datasource; <!--T:10-->* '''Decimal Separator''': Specifies the decimal separator used in the file. <param !--T:11-->* '''Columns options''': Click the column header in the preview table to select and change its options:** '''Column data type''': Specifies the column data type: [[Date]], [[Text]] or [[Value]];** '''Column name''': Specifies the column name="allowFullScreen" .;** '''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 datasource.* In value=columns, empty cells (NULL) will be converted to "true0" /.* 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 the alterations to confirm the changes.* New columns in the imported file, the header color will be yellow.* Probably wrong columns the header collor will be red. <embed src="http!--T:37-->'''Attention://www''' After you confirm this screen and process the importation you can't undo the changes.youtube  <!--T:38-->[[File:newfields+en-US.com/v/MDedb1Kgjys&apPNG|800px|link=%2526fmt%3D18" type]]  <!--T:39-->[[File:newfields1+en-US.PNG|800px|link="application]]  <!--T:12-->Click the '''Next''' button to continue. <!--T:13-->If you are [[Import/xUpdate 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: <!--T:28-->The process will try to find compatible dashboards with the information you provided.  <!--T:29--shockwave>[[File:Colunas geração+en-flash" allowfullscreenUS.PNG|800px|link="false" width]]  <!--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 do this later. See [[Generate dashboards]].  <!--T:17-->[[File:Resumo importação+en US.PNG|800px|link="425" height]]  <!--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="344"]]  <!--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/embed>update is completed, TaticView will automatically update the status on the [[Main_Page_Overview|main page]].    </objecttranslate>