E-Mon E-PS-S-HV-RTU - Manual (Page 163)

Chapter 8 Retrieving and
Storing Files
Archiving Files
PowerSmart Socket Power Quality Meter 163
Exporting Files in Excel Format
Power Software can automatically convert data files into the
Microsoft Excel workbook format while retrieving data from
your meters via the Upload Scheduler.
To store files in Excel format, follow instructions in the
previous section and select Excel Workbook as the output file
format.
The first row of the Excel table lists data names (see
Appendix A) 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 ).
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.