1,438
edits
Changes
no edit summary
<!--T:1-->
'''This section will show you how to import a new datasource.'''
<!--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;
<!--T:35-->
<span style="color: red;">'''Important:'''</span> Data import is not allowed through tablets and smartphones.
<!--T:22-->
On the next screen:
<!--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>