11,677
edits
Changes
Updating to match new version of source page
'''This section will show you how to import a new data sourcedatasource.'''
See also:
* [[Import/Update_data|Update Data]]
* [[Automate_Update_data|Data Update Automation]]
* Download a sample file here: '''[https[Special://wiki.taticview.com/taticfilesFilePath/Sales.xlsx |Sales.xlsx]]'''
* '''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;
* '''Name''': Data source Datasource name. This is the name that will be displayed on the '''[[Main Page Overview|main page]]''';* '''Description''': An optional description for the new data sourcedatasource.
* '''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;
* '''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 data sourcedatasource;
* '''Decimal Separator''': Specifies the decimal separator used in the file.
* 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 data sourcedatasource.
* 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.
Click the '''Next''' button to continue.
If you are [[Import/Update data|updating]] a data sourcedatasource, go directly to the [[New Data Source Summary|import summary]].
When the data source datasource import/update is completed, TaticView will automatically update the status on the [[Main_Page_Overview|main page]].