KONsys Knowledgebase
Contents
Knowledge Base Library
AVReporter introduction
Software requirements
Hardware requirements
Review of the AVReporter software packages
AVReporter v2.1 Installation
AVReporter Overview
AVReporter Components Overview
AVReporter Extension possibilities
Compare AVReporter Editions
AVReporter Database Management
AVReporter Security Features
AVReporter Localization
AVReporter Administration Tool
AVReporter User Perspective
Billing Reports Application
AVReporter Desktop Manager
Running the software
First startup (Configuration wizard)
Language setting
Step 1. Setting the database connection
Step 2. Selecting the database
Step 3. User name and password (to get access to the database)
Step 4. Reviewing the parameters and testing the database connection
Buildup of the User Interface of AVReporter Desktop Manager
File and Help bar
Preferences
Other settings
Visual settings
Importing and exporting AVReporter report groups
Menu bar
Application Browser
AVReporter settings
Main settings
Add ins (plugins)
Scheduler configuration
Registration
AVReporter reports (Working with Group)
Adding and deleting a report group
Modifying a report group
Moving report groups
Adding reports to the report group
AVReporter modules
Starting the AVReporter application modules
Operations with reports
Plugins
Printer Plugin
Mailer Plugin
Basic Reporter Module
Running the software
Settings
Setting the database connection
Connecting to Powerlogic SMS systems
Connecting to Powerlogic ION systems
Connecting to an EGX300 device
Connecting to AVReporter database (attach to other systems)
Connecting to database has failed
Define first day of the week and time shift in seconds
Rounding settings of calculations and different values
Font style of reports
Report appearance: colours and themes
Language settings
Make a report
First steps
Select type of report
Report window layout
Table report
Line chart
Histogram report
Pie chart
Save report
Save query
Print report
Energy Manager Summary Module
Running the software
Settings
Setting the database connection
Connecting to Powerlogic SMS systems
Connecting to Powerlogic ION systems
Connecting to an EGX300 device
Connecting to AVReporter database (attach to other systems)
Connecting to database has failed
Define starting day of the week and time shift in seconds
Using absolute value summary
Warning in case of unit dimension deviation
Rounding settings of calculations and different values
Font style of reports
Report appearance: colours and themes
Language settings
Creating a report
First steps
Selecting and searching for devices
Selecting the type of report to be displayed
Layout of the report window
Real and Reactive consumption report
Summarized reports
Report by devices
Reactive energy Into the Load - Out of the Load Rate
Real and reactive consumption report settings
Apparent energy consumption report
Apparent report in table form
Apparent energy consumption in column chart or in a pie chart
Apparent consumption report settings
Query table report (consumption reports not only on electric quantities)
Query table formatting
Show the main meter in the report
For example: Finding transformer loss
Assigning alias names to devices
User defined quantities
Save report
Saving an query
Print report
Business Intelligence Module
Running the software
Operation principle of the Business Intelligence Module
Definition of variables
Definition of expressions
Settings
Setting the data base connection (for quantity variables)
Connecting to Powerlogic SMS systems
Connecting to Powerlogic ION systems
Connecting to an EGX300 device
Connecting to AVReporter database (attach to other systems)
Connecting to database has failed
Defining starting day of the week, shifting of grouping time and second shifting
Visual settings
Rounding settings of calculations and different values
Font style of reports
Report appearance: colors and themes
Other settings
Language settings
Usage of Business Intelligence
Creating and Running queries
Creating Queries step by step
Example: Creation of a KPI report, where we determine the power consumption and costs by product unit
Step 1: Start the Business-Intelligence module from the Desktop Manager surface
Step 2: Create a new query
Step 3: Create variables
Step 4: Create our expressions
Step 5: a) Display data in a report
Display the result union in the report
Step 5 b) Export data into another data base
Export the result union into another data base
Save query
Main window of Business Intelligence
Menu bar
Expression groups
Operations
Time interval under survey (Global time interval)
Other filtering possibilities
Construction of the window of expression group
Result handling (Report, Exporting plugin)
Expressions
Displaying file settings (Report))
Variables
Group name
Export Plugins
CSV Export Plugin
ODBC Export Plugin
Handling and creating variables
Quantity variable
Constant variable
CSV variable
ODBC variable
Creating a connection string
ODBC Connection
String variable
User Input variable
Attributes of variables
Creating and editing expressions
Mathematical operations and functions in expressions
Attributes of expressions
Managing the result of queries
Report window layout
Managing queried errors and detecting errors
Syntax checking of expressions
Evaluation checking of expressions (List of group variable events)
Checking and follow-up of the running of export plugins (Event register, etc.)
Creating an own report
Embedding the Visual Basic code into the report
Print report
Save query
AVReporter WEBPublisher Module
Requirements for running AVReporter WEBPublisher application
WEBPublisher Startup
WEBPublisher Main Screen
Settings
System settings
User Accounts
Security groups
Other system settings
User settings
Adding own links
Report default visual properties
Manage user interface layout settings
Manage start page
Manage E-mail settings
Change password
Select time zone
Reports
Open reports
Modify reports
Sending a report by e-mail
Printing reports
Exporting reports to excel or pdf format
Dynamic dashboards
Adding a dynamic dashboard
Preparing diagrams
Editing diagrams
Managing charts, dashboard settings
Comparison of reports and dynamic dashboards
Other document types
File manager
AVR Connection Center Plugin Module
Software requirements
Running the AVR Connection Center plugin
Simple view
Configuration groups
Job scheduler in Simple view
Example: Connecting to ION Enterprise database
Advanced view
Configuration groups
Configurations
Execute VB code before transferring data
Run SQL query before transferring data
Data transfer from source to target
Preferences regarding accessibility of databases and the source table
Table editor
Setting up the output and operations to be performed on source data
Data transfer into a new table of the target database
Data transfer into existing tables of the target database
Selecting features to boost performance (optional)
Data quality features (optional)
Execute Visual Basic code on source table in memory
Run SQL query after transferring data
Execute VB code after transferring data
Own VB functions
Job scheduler in Advanced view
AVR Connection Center Additional Drivers
AVR Connection Center OPC driver guide
AVReporter Configuration Backup and Restore
AVReporter Configuration Backup and Restore Plugin
Logging of data by external application (from program code)
Registering AVRDataImporter.dll
Function of AVRDataImporter.dll
Application examples
Logging from SCADA systems (iFiX, WinCC, Citect, Vijeo Look, RSView ...)
Logging from Visual Basic .NET application
Logging from Visual Basic 6 application
Troubleshooting
Copyright by KONsys