Introduction
...
- Change the Item Finder from Site to Periodic HFD Channel to view a list of all Periodic Channels in your database
- Or use the Multi List Selector to select the Periodic Channels
- Select the Periodic Channels you want to check
- Or click on one, then Control + A to highlight them all
- Click Edit Items to see the Data Selection popup
- Tick Name
- Tick Channel ID
- In the Data Selector popup, use the arrows to move to the References tab and tick Include Meter, Commodity and/or Site
- Click Edit Fields to display the data
Comparing the data
...
- Click
- Enter the beginning of the Importer name (given to you by Support)
- Click Search
- Choose the correct Importer from the displayed list
- Click OK
- Click Next
- Click Finish
The Importer has now been added to your Favourites list and is ready to use.
Importing the Data
Once you have the Importer in your favourites list, it will be available to use each time you want to import data.
- Click
to see the list of your Favourite Importers - Highlight the Importer
- Click Next
- Tick Use date range (if required - usually this is left blank to allow all the data to be imported)
- Click Next
- Click
- Click
- Find the file you want to import
- Click OK
- Click Next
- Click
- Click
| Excerpt |
|---|
Viewing the importing progressThe file will show in the Queued And Running Imports area (depending how long the import takes, sometimes it doesn't show)
Refreshing the Run History
Click here for more details on the Run History section, including viewing run details and downloading log files. |
Checking the Import and Data
Click here for more details on the Run History section, including viewing run details and downloading log files.
Checking the Data in the Channel
Once the import has completed, it is advisable to do a spot check to ensure the data has imported.
- Open the Estate Management Activity
- Search for a Channel Data Load ID to view the data:
- Change the Item Finder from Site to Periodic HFD Channel
- Search for a Channel that was in the import (taking the ID from the spreadsheet you have just imported)
- Highlight the Channel
- The screen will open on the Meters & Channels tab
- Note the data in the Analysis section - this should match the data you have imported
- Hover over the chart to see the date of the last entry
Alternatively
View the data in the Channel Editor.
From the Meters & Channels tab:
- Highlight the Periodic Channel
...
.
...
| Excerpt |
|---|
What happens to data that can't be matched in Sigma?If the Periodic Channel hasn't been set up, or the Channel ID isn't correct, Sigma will still import the data, but add it to the Unmatched Imported Objects. Click here for more details. |
...