Import

Import allows you to upload and append historical data to newly automated sensors. Upload multiple sensors of the same type simultaneously from a single .CSV file. Import allows you to attach previously collected data to a sensemetrics configured sensor or associate it with a dummy sensor to simply view the foreign data.

 

 

Step 1

Navigate to File Import: Click on the Data module then navigate to the "Import" sub-module.

Step 2

Choose File: Drag and drop the desired .CSV file into the  button. The file will then be pre loaded and previewed at the bottom. 

Step 3

Select the correct column headers for you data: Every sensor will have certain fields that are required for data upload. These are the raw data values that make up a data point for that particular sensor. Sensor name and date are required for every sensor, the rest will depend on the sensor type.

If the file has a header row containing titles, keep the checkbox below selected to prevent the software from using the top row as a data entry.

Match each column with the field it represents. Establish the column that is the sensor ID (Name) first. This will then search the column for different sensors and list them out to be mapped to sensemetrics configured sensors.

 

Step 4

Map Sensors: Each sensor in the .CSV file will need to be matched to a sensor in sensemetrics or excluded from the import.

Every sensor name listed in the file will now be shown in the "External Sensor" column. Click the  Sensor Selection Tool to choose which sensemetrics configured sensor the data will be appended to. If you choose to exclude data from a sensor listed in the .CSV file, click the  to turn it into an  and it will not be uploaded.

If you are trying to import data that is not associated with a sensemetrics automated sensor, you will need to create an "Import Sensor" to attach the data to.

Step 5

Finish mapping columns: Now that sensemetrics knows what type of sensor you are importing, it will autofill the metrics that are required to create data in the database. Map each column to to the metric it represents and choose the units it is recorded in.

Make sure to have a column selected for every field required to create that particular type of sensor.

Any extra columns within your file that do not match the required metrics will need to be excluded. Click the  above the column to turn it to an  and exclude it.

 

Step 6

Upload Data: Once every sensor has been mapped to one in sensemetrics and every column entry has been identified, you are now ready to upload. Select the  button and a message will appear notifying you the import was successful. 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.