Summary for Patch 339 (Verified)

Summary Configurable Excel text format on dates
Platform Unix
Category
Valid for 4.9.x, 5.0.0.x, 5.0.1.x, 5.1.0.x
Requires 338, 320
Client Required Patch/es
Supersedes
Superseded by
Affects Server: Core
Last Updated September 30, 2009

Download now

Download_red patch339.tar.gz

Description

This patch allows configurable formatting of date/time as text in
Excel output.

To enforce use of text format in Excel charts, set the
REPORTS_EXCEL_CHART_TEXT directive to a comma separated list of time
intervals to be formatted as text. The following intervals are
allowed: "year", "month", "week", "day", and "hms". "hms" covers all
intervals equal to or shorter than one hour.

If e.g. the days and shorter intervals are to be displayed as text,
include the following line in /etc/opt/openit/openit.cfg:

REPORTS_EXCEL_CHART_TEXT  day,hms

Note that "hms" is set by default (and could be skipped in the above
example). Also note that there must be no space characters in the
comma separated list.

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