Data Import

Data import is the process of importing a batch of records into SpreadsheetWEB for populating the database of a web application or using in dashboards. This can be done by importing from an external data file (CSV) into the database of an existing data collection application.

SpreadsheetWEB also allows importing data for use in dashboard applications. You can import any data from a flat text file, and use a Dashboard application to create dashboard reports without any programming involved.

Step 1: Establish Data Hierarchy

Begin by selecting from available data import options. New Data will create a completely new data set. Append Data will add the imported data into an existing data map. Replace Data will replace an existing data map with the data you upload. Once you make your selection, you must define a name for your Data Map and Data Set. You can think of Data Set as the tables that contain actual data, and Data Map as a group of Data Sets.

Step 2: Upload the Data File

Here, click the Data File box, or simply drag and drop your data file into it. Then, assign the Data File to any number of Groups.

Step 3: Field Mapping

On the third step, you can map the data columns from your CSV files to the ones in the database. When ready, press Next to start uploading your data.

Step 4: Import Process Complete

Last page will complete data import and show a report of successes and failures. This is the end of the data import and the new data will be available for the application under the Data Tab.