This patch fixes an error in the back end regarding averaging. In
addition, an option is added to allow for converting classification
values to all lower or upper case.

The config file related to this feature is called substitution_specs
and is located under /var/opt/openit/etc/. The content is a recursive
list (empty by default). The list contains data type names on the
topmost level, and a list pairs, each pair consisting of the
classification name and the specification "upper" or "lower".

For an example, see
/var/opt/openit/etc/examples/substitution_specs. This file specifies
that the user classifications of the "Windows Application usage" are
to be converted to lower case.

After the substitution_specs file is modified, run
/opt/openit/bin/generate_classvar_mapping as the "openit" user and
restart the GUI.

To limit the number of decimal digits in csv output, set:

REPORTS_CSV_DECIMAL_DIGITS <n>

in /etc/opt/openit/openit.cfg.

This update will reduce the classvar mapping lists generated from 
virtual mapping files.

Previously all destination values where always extracted. Now the
EXACT_MAPPINGS section is first scanned to find all possible destination
values for every source value and then when the data is scanned only the
potential destination values are added to the classvar mapping output.

This improvement will usually give significant reductions in the size of 
the classvar_mapping file when the mapping files are automatically created
from external sources.

Fix on parsing of the OpeniT license key. Sometimes the host-locked
key was not recognized. This should now be fixed.

This patch changes the behaviour of LSF and GridEngine parameters
so that it no longer requires that the directories they point to
exists in order to start the Open iT client.

The affect parameters are

   LSB_ACCT_DIR
   LSF_BIN_DIR
   SGE_ROOT_DIR

The first LSF is used when collection LSF Batch accounting data
(lsb.acct) the other LSF parameter is for LSF Pending reports
(bjobs) that was added in Open iT 5.1. The last parameter is
for GridEngine configuration.

1. Excel reports now get dates formatted with a suited "Custom" date
format, whenever possible. Weeks are formatted with "General"
format. Dates used in charts is also formatted as "General".

2. An extra check is added during report generation to give a warning
when there would be no data in a report.

Added support for week resolution. Added support for specifying
selected classification values in --classification list.

This patch allows Excel reports to be produced when the
OpeniT logo could not be loaded.

Fixes a bug in the handling of the virtual values. Values in acc_types
that follows after a virtual, is now handled.
Support for 1 hour resolution is added.

Use of DateSerial() to improve Excel formatting of reports.

Exports of table reports to Excel failes when "time" columns contain
"subtotal" or "others" cells. This fix makes the export functioni
correctly mark the cells as text (and not date) fields.

Some times the background color of cells with zero value became light
grey when it should have been dark grey. The patch fixes this.

Some times the background color of cells with zero value became light
grey when it should have been dark grey. The patch fixes this.

Fixes sorting of entries in tables with vertical classifications
only. In 4.7-4.9 the number of maximum available licenses is indicated
for each feature. Previously these numbers were erroneously indicated
for each feature version.