Historic Import is accessible from the Data Source context menu in the Workspaces Tree. You can upload/import historic data from a locally accessible file, into New or Existing Parameters, or update the historic coordinate data for Locations.
The Historic Import Wizard will guide you through the following steps to successfully import your time series data:
Select a file to import from your computer or device and configure import options.
Select the type of file you would like to import:
Data is stored as rows of values separated with a specific delimiter character.
JSON Time Series
Data is stored in the JSON Time Series format. Note: JTS files to be imported must contain a columns header that specifies name and dataType of each column included in the data.
Select how the new data will be imported:
Merge and overwrite [API: MERGE_OVERWRITE_EXISTING]
Insert the imported data into the existing historic data and overwrite the existing values when timestamps match.
Merge and preserve [API: MERGE_PRESERVE_EXISTING]
Merge the imported data into the existing historic data and do not overwrite existing values when timestamps match.
Replace [API: INSERT_DELETE_EXISTING]
Remove all existing historic data within the range of data being imported and replace with imported data.
Merge the imported data into the existing historic data and and update specific record attributes when timestamps match.
Merge the imported data into the existing historic data but fail if timestamps match.
Insert new data only if there is no existing historic data within the range being imported.
Delete historic data encapsulated by the range of the imported data.
Delete historic data that matches the timestamps of the imported data.
The Text Parser allows you to define how the delimited text file being imported should be processed including defining series to be assigned to Parameters. See Text Parser Configuration for a detailed guide to using the Text Parser.
Assign the newly defined Series to New or Existing Parameters. You can also assign the series to the Source’s Location for the import of historic coordinate data.
Assign Series to New or Existing parameters by toggling the New/Existing button (only enable when there are existing Parameters matching the data type of the Series). Uncheck any Series you do not want want to import.
Any newly created parameters will be created within the Source and shown as GREYED out in the Workspaces Tree and Content Views to distinguish them from parameters assigned to series being automatically collected by the Data Source.
Parameters can be re-assigned to new Series at any time without loosing existing historic data.
The series icon indicates the type of parameter that can be assigned to the Series.
The Process and Upload screen displays a progress bar and status information about the current operation. If any problem is encountered an error message and Retry button will be displayed, otherwise the Successfully Completed status message will be shown. Click Finish to close the import wizard.
Files containing a large number of records may be time consuming to process. Some browsers/devices may also enforce certain limits which prevent successful import of large files even if they are smaller than the 250MB limit.