Import data from Files
If you have data stored in local drives in tabular file formats such as CSV, Excel, JSON, etc., you can easily import them into Analytics Plus. Analytics Plus offers easy import and copy-paste options of such data to jump start your reporting and advanced analysis.
Supported file types
- What are the various formats in which files can be imported into Analytics Plus?
- What are the sources from which I can import data into Analytics Plus using the Files option?
- How do I import data from a CSV file into Analytics Plus?
- How do I import data from Excel into Analytics Plus?
- How do I import data from an HTML file into Analytics Plus?
- How do I import data from JSON into Analytics Plus?
- How do I import data from XML into Analytics Plus?
- How do I import data from Statistical Files into Analytics Plus?
- How do I import data from Microsoft Access Database files into Analytics Plus?
- How do I import data from Spatial Files into Analytics Plus?
Supported data locations
- How do I import data from a local file into Analytics Plus?
- How do I import data from an FTP Server?
- How do I paste copied data into Analytics Plus easily?
- Is it possible to import data into an existing table?
- Can I import large files into Analytics Plus?
- How do I set a custom date format?
- Is it possible to map a column from the source file to a column in an Analytics Plus table while importing?
- Can I retain the data source's relational data modeling?
- How do I set On Import Error options?
- Why do I see Warning Details in the Import Summary?
- Can I schedule data import?
Supported File Types
You can import data into Analytics Plus in the following formats:
Analytics Plus allows you to import data from the following data locations using the Files tile in the Import Your Data page.
Supported data locations
Data can be imported into existing tables in Analytics Plus in any of the applicable file formats, from the supported data locations.
Follow the steps below to import data into existing tables.
Open the table into which you wish to import additional data.
Click the Import Data button on the top right corner, and select the Import Data into this Table option.
In the Import Your Data page that appears, select the required tile to import data from local files, web URLs or cloud drives.
In the page that appears, choose the appropriate option from the How do you to Import? drop down. The following options are available:
Add records at the end: Use this option to append imported records to the end of the table.
Delete existing records and add: Use this option to delete all the records in the table and add the new records into the table.
Add records and replace if already exists: Use this option to update existing records with the new values and append new records to the end of the table.
Add records, replace existing and delete missing record: This option allows you to update the existing records with new values, append new records to the end of the table and delete the records in the table that are not present in the file that is being imported.
Note: When replacing existing records in Analytics Plus, select the columns in the source file that are to be matched to the existing ones in Analytics Plus. The values in these columns will be used as the key to match the existing records in the table to the new records being imported. Thus, the columns should be selected such that they uniquely identify each record in the table. If unique records are not identified, all records will be appended to the end of the table.
Choose the required file type and data location, select the source file, and click Next to proceed with the import process as usual.
Analytics Plus has the following restrictions on data import:
You cannot import more than 5 million rows into Analytics Plus using the Import wizard.
Files whose sizes exceed 500 MB should be compressed and imported into Analytics Plus.
To can import files larger than 500MB or those that contain more than 5 million rows, use the Analytics Plus Agent. It is a packaged downloadable tool that directly accesses your database, queries the required data and uploads it to Analytics Plus. Scheduled data imports can also be set up. To learn more, refer the Analytics Plus Agent help document.
By default, Analytics Plus identifies the date format of the date columns in the data being imported. If the default format is incorrect, you can easily modify the same while importing data into Analytics Plus.
There are two ways to set a custom date format for your date columns.
Select the required date format from the Format of Date Column (s) drop down. This option will apply the selected date format to all date columns in the data being imported.
You can also set different date formats for each date column in your data. To do this, click the Settings icon in the preview column header, select the Change Date Format option and set the required date format.
Refer the Constructing a Custom Date format document to know more.
2. Is it possible to map a column from the source file to a column in an Analytics Plus table while importing data?
While importing data into an existing table in Analytics Plus, you can map a column from the imported file to a specific column in the Analytics Plus table. In the Data Preview section of the Import wizard, use the drop down in the column header to choose the required column. You can either select the column the data needs to be mapped to, or specify that it is a new column.
While you cannot retain your source's relational data modeling, Analytics Plus allows you to auto join tables during data import. While importing data into an existing table, Analytics Plus auto identifies similar columns and provides suggestions for lookup.
The following presentation explains how this works.
The On Import Errors drop down in the Import wizard allows you to specify how import errors are to be handled in Analytics Plus.
The following are the available options:
Set Empty Value for the Column: This option sets an empty value to columns that had problems while importing.
Skip Corresponding Rows: This option skips the rows in which an error occurred during data import.
Don't Import the data: If any errors occur during data import, this option allows you to abort the import process.
In case any error occurs during import, the details of the same would be shown in the Import Summary dialog. Refer the next question to know more.
Specifying a wrong data type for your column will generate errors on import. Analytics Plus will handle such errors per the specified On Import Errors option and display details of the same in the Import Summary dialog.
Analytics Plus allows you to schedule the import of data from FTP servers and web URLs.
Note: To schedule data import, it is mandatory that the data has a column header.