Run History for Manual Imports

Sigma Online User Manual

Run History for Manual Imports

Introduction

The Run History details show in the Importing Activity when an import has been run manually.

More details on how to run Imports can be found here:

 

Once the data has been imported, you can view the progress of the Import, including viewing the run details and downloading the log file.

Opening the Importing Activity

  • Click on Importing

Refreshing the Run History

This is performed from the Importing Activity:

  • Open the Importing Activity

  • Click on the

    Refresh icon in the Run History section

  • The screen will refresh to show the latest import, and its status (success or failed)

Available Columns

The default setting is to show the following columns:

 

Adding/hiding columns

  • Click on the downward arrow on the Column Header

  • Click Columns

  • Tick / Untick as required

If you have added additional columns and want to see the data more clearly, double click on the ellipse 

 to make the section full screen

Double click again on the ellipse to reduce the section.

Filtering

If you want to filter to specific data, such as Failures:

  • Click on 

     for the Filter options to show

 

  • Enter the filter criteria and the screen will adjust 

 

  • Remove the filter data, and then click 

     again to remove the Filter option

 

Sorting Columns

  • Columns can also be sorted by clicking in the Column name in the Column Header 

 

Run Details

To see the details of the Import:

  • Highlight the Import you want to check

  • Click 

     to show the Run Details pop up

          

Run Details Options

  • Filter - shows the filter bar 

  • Refresh - click to refresh the data

  • Title - shows the title shows the Importer used, ie IMSev - From file basic hr0030

  • Diagnostics - click to see further details on the Import, such as the earliest and latest dates in the data (only available if the Import has been successful)

  • Excel  - click to export details to Excel

          

If the Import has been successful, you can see the Diagnostics:

  • Click 

     to see further details on the Import, such as the earliest and latest dates in the data

 

Diagnostic Options 

 

  • Filter - shows the filter bar 

  • Refresh - click to refresh the data

  • Edit the Item  - opens  the Channel Editor for the line you have highlighted

  • Excel  - click to export details to Excel 

 

Spot Checking the Data

Once the data has been imported, use the Diagnostics to link you to a Channel to check the data

  • From the Run History section, right click on the Import > Run Details

  • Right click on the Import line > Diagnostics OR

    • Click Diagnostics at the top of the pop up

This will show all of the data that has been imported

 

  • Right click on a line > Edit Item to open the Channel Editor

  • Note that the following are in line with what you have just imported:

    • The Date range

    • The Latest import time and date

    • The Latest Importer used

 

  • Click Edit Data to view all the values for that Channel to spot check a particular time and date

 

  

 

 

Downloading the Log File

Only available if there is a Y in the Log column

  • Highlight the Import

  • Click 

     and the file will be downloaded to your desktop 

 

Excel

  • Click 

     and the columns you have showing on screen will be downloaded

 

Right click options

The above options are available by right clicking on an Import:

 

 

@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018