Adding data

DataInsights provides rich data access capabilities. You can add data through the following ways.

Upload files

Before uploading files, Hosting Server and Relational Storage should be configured. Currently, the following data type files are supported:

• Excel files (*.xls and *.xlsx)
• CSV file with comma delimiter (*.csv)
• GeoJSON file
• Zip package compressed from Shapefile data

To add data via uploading, in the "Add Data" tab, select "Upload File", click "Select File" button, select a file, then click "Upload" to finish adding.

If the uploaded data is in *.xls, *.xlsx or *.csv format, you need to specify the X and Y coordinates with the corresponding fields from data.

If you upload an Excel or CSV file that only contains attribute information but without spatial information, you need to associate the data with a SuperMap REST data service with location information before visulizing data on map and accessing analysis capabilities. In "Spatial Location" dialog box, select "Code", finish the following settings:

• Original value: The unique identifier in uploaded table used to associate the data service.
• Associated table: The SuperMap REST data service name that has been published in iPortal to be associated.
• Associated field: The corresponding identifier field from the published REST data service. Associated field and original field must correspond one-to-one.

After completing the settings, click the "OK" button to complete the association process.

The uploaded data files are automatically saved to My Data . You can share data files with other iPortal users and use in other apps.

Sample data

DataInsights provides sample data which can be used for testing. In the "Add Data" tab, select "Sample Data", check any data you want to test and click the "Add" button.

Existing data and services in iPortal

DataInsights supports following ways to access existing data and services in iPortal:

You can add data files in "My Data" in the iPortal’s portal and user-managed data stores (such as HDFS, Hadoop Distributed File System). In the "Add Data" tab, select "My Data", check any data you want to add and click the "Add" button.

You can also choose the services in “My Services” tab in the iPortal’s portal including registered services and hosted services. The service types support SuperMap REST map services and data services. In the "Add Data" tab, select "My Services" and select any service you want to choose. The right side will list all the layers of the service, check one or more layers and click the "Add" button.

After adding the data, you can preview the data in the data page, click the field of the table to sort the data, move the mouse to the field, click on the right side to change the name and type of the field.

Next is to create view operation.