Summary for Patch 436 (Verified)

Summary Fix on average calculation. Update on csv rounding.
Platform Unix
Category bugfix
Valid for 4.9.x
Requires 277, 339, 366
Client Required Patch/es
Supersedes 424, 320, 419, 418, 378, 411, 404, 361, 360, 292
Superseded by
Affects Server: Core
Last Updated September 30, 2009

Download now

Download_red patch436.tar.gz

Description

This patch fixes an error in the back end regarding averaging. In
addition, an option for rounding cvs output is added.

Use the REPORTS_CSV_DECIMAL_DIGITS directive of openit.cfg. To round
to n decimal digits, set:

REPORTS_CSV_DECIMAL_DIGITS <n>

To round up or down always, add a "+" or a "-" after the number, e.g.:

REPORTS_CSV_DECIMAL_DIGITS 3+

Supersedes Patch Description

Expand all

Patch 424 — Support for setting decimal precicion in csv
To limit the number of decimal digits in csv output, set:

REPORTS_CSV_DECIMAL_DIGITS <n>

in /etc/opt/openit/openit.cfg.
Patch 320 — Date formatting in Excel reports. GUI warning when no data.
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.
Patch 419 — Improves database extraction program
Added support for week resolution. Added support for specifying
selected classification values in --classification list.
Patch 418 — More robust handling of Excel reporting
This patch allows Excel reports to be produced when the
OpeniT logo could not be loaded.
Patch 378 — Improves / fixes database extraction program
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.
Patch 411 — Fix problem with formatting of Excel reports
Use of DateSerial() to improve Excel formatting of reports.
Patch 404 — Fix problem with Excel reports when using subtotal/others
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.
Patch 361 — Fixes background of certain cells in table reports
Some times the background color of cells with zero value became light
grey when it should have been dark grey. The patch fixes this.
Patch 360 — Fixes background of certain cells in table reports
Some times the background color of cells with zero value became light
grey when it should have been dark grey. The patch fixes this.
Patch 292 — Fixes sorting in table report
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.

Installation

Unpack tar file in e.g /tmp/patch on the Open iT server. Do the 
following as root:

  cd /tmp/patch
  ./patch.pl

Corresponding Windows Patches

No corresponding Patches available.



Back to Version List