Chapter 8 Retrieving A N D S T O R I N G F I L E S
Archiving F I L E S
130 PM130 PLUS Powermeter Series
Exporting Files in Excel Format
PAS allows you to convert data tables into the Microsoft Excel workbook
format, either manually, or automatically 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 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.
To Next Page
Loading...
Need help?
General
