The CSV event file importer is designed to provide a way to upload one-off data for sites not currently monitored by MPEC loggers. This tool can be accessed via the sites tab and is listed under the actions menu next to each site.
Event files must be formatted using the following guidelines;
The file must start with the site name, on line 1. No other information is required.
Line 2 must be blank
Files created in Excel will add in extra commas on lines 1 and 2, these can be safely left in.
The first event must start on line 3. Each line should have the following form:
All fields must be separated by single comma. Spaces are not required. A trailing comma is not required but will be removed automatically when read by Centrix.
Files created in Excel may add an extra comma to each event line, this can be safely left in.
File must be saved as .csv, any other file type will be not be uploaded.
If an event already exists for a relay at the time listed in the file, that event will be marked as duplicate and not uploaded.
|Centrix generally expects event data to be imported in chronological order. Events that are imported out of sequence can cause unexpected results, especially with regard to Virtual Channels and Alerts. You may also find that the map initialises some objects to the wrong state if events are imported out of order for the site you are viewing.|
|Centrix expects to receive initialisation events for channels if there is a 'dark' period. For example, if you import some event data covering 8AM to 9AM and then subsequently import data from 11AM to 12PM, you should ensure that the beginning of the 11AM-12PM file contains the starting state for every channel. This is because there is an unknown period between 9AM and 11AM where the state transitions are missing. If you do not initialise the state at the beginning of the data set then you can experience some unexpected behaviour similar to those highlighted in the 'out of order' event warning above.|
One of the purposes of the CSV event upload is to allow testing of functions (e.g. virtual channels or alerts). If you are using the functionality for this purpose you should ideally use a test site to upload the data to rather than the actual live site. There is currently no means to delete or undo any data upload, so once the data is uploaded it will remain there.
As there is no means of removing data and bearing in mind that events should be imported in chronological order, it is recommended that if you wish to run the same data set multiple times for testing then you should increment the time frame of the data in the CSV file each time you run the test. This will ensure that the data set doesn't overlap the previous test data which may cause invalid test results.