Chapter 8 Retrieving and Storing Files Archiving Files
134 PM135 Powermeter Series
desired output file format, and then
click on Save.
6. Repeat the same for all tables you
wish to be converted.
7. Click OK.
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 Next Page
Loading...
Need help?
General
