5 archiving files – E-Mon E-PS-E-RTU-N User Manual
Page 128

Chapter 8 Retrieving and Storing Files Archiving Files
128
PowerSmart+ Power Quality Meter
The first row of the Excel table lists data names (see Appendix D) and the
second row provides data codes, which identify recorded data points (see
Modbus communications guide for data codes) that may be useful for
automated table processing.
Each table row is provided with the device identifier that you can define in
the meter database (see
Creating a New Site for your Meter
).
8.5 Archiving Files
Microsoft Access databases tend to grow fast. Databases above 0.5
Gigabytes can drastically slow down file operations.
To avoid enormous growing files, you can either periodically change the
target database, or use the Upload Scheduler’s file archiver to
automatically move older data to archives.
The Upload Scheduler archives files upon a weekly, monthly or yearly
schedule. When archiving data, a new database is created to where older
data from your present database with the expired archiving date is
moved.
An archive file keeps the original database name to which the date of the
oldest database record is added, so you can easily identify your archives
and work with them as you work with a regular database.
To provide a schedule for archiving files:
1. When defining a schedule for uploading files from your meter,
click on Configure or double click on the site row.
2. Click Auto Archive.
3. Check the Enable box and select a periodic schedule for archiving
your files for this site.
4. Click OK.
To avoid archiving partially updated data, archiving is performed in a day
after expiring a scheduled period and not before 2 hours a.m.