General
Harvest Administration Assistant is a tool that facilitates the processes
administration of Computer Associates
Harvest Software Change Manager.
The application uses direct access to Harvest database; version 1.2.0
was tested with Harvest Change Manager versions r7, r7.1 and r12.1.
Harvest Administration Assistant objective is to assist to Harvest administrators
in management of processes in mid-to-large production environments. The tool allows
users to perform similtaneous modification of several processes definitions or to
duplicate existing process definitions to several projects.
Important! The application uses direct database access and SQL to modify
the Harvest database; database modification using SQL statements is not supported
by Computer Associates. The application software is provided "AS IS" (see the license
for details).
Product Features
Harvest Administration Assistant application provides the following features:
Process definition duplication
- Specify process to duplicate definitions from (by project name, state name and process
name)
- Specify projects states or processes to create new process in
- Duplicate process definitions to one or more projects' states
- Duplicate linked process definitions to one or more processes (as a new linked process)
- Duplicate linked process definitions to one or more projects' states (as a new process)
- Duplicate UDP or Notify process definitions to one or more processes (as a new linked
process)
Processes definition modification
- Select processes for modification by multiple search criteria (project name, state
name, process name etc.)
- Change selected processes common properties (name and note)
- Change selected processes access properties (name and note)
- Change selected processes linked processes properties (name and note)
- Change selected processes process type specific properties (depending on process
type; special UI for UDP and Notify processes)
Linked processes definition modification
- Select linked processes for modification by multiple search criteria (project name
, state name, parent process name etc.)
- Change selected linked processes common properties (name and note)
- Change selected linked processes process type specific properties (special UI for
UDP and Notify processes)
Logging the modification SQL statements
It is possible to log all the statements run by the application in order to modify
the database. If you are interested to see the raw statements or worried about your
database integrity, you may choose to enable the logging at all times. To enable
logging, perform the following steps:
- Open the application folder (by default c:\Program
Files\Attrice Corporation\Harvest Administrator Assistant) in Windows Explorer
- Open file HarvestAssistant.exe.config
located in the folder using Notepad
- Change the following lines
<!--system.diagnostics>
<switches><add name="SqlTracing" value="4" /></switches>
</system.diagnostics-->
to read as following
<system.diagnostics>
<switches><add name="SqlTracing" value="4" /></switches>
</system.diagnostics>
- Save the changes to the file
- If the application is running, close and restart the application
With the logging enabled, a new log file will be created in the application folder
every time the application is started and user successfully logs in to the database.
When database modifications are performed using the application, the SQL statements
and the associated parameters will be saved in the log file. To disable logging
reverse the changes to the config file.
Download
product features presentation in Microsoft PowerPoint format.
Prerequisites
In order to use the application the following products must be installed:
As the application uses direct database access, local Oracle Net Service Name must
be defined for database access through Oracle client (Net Service Name may be defined
either using Oracle Net Configuration Assistant or Net Manager). Additionally, user
must have valid credentials to access and modify Harvest database.
Harvest Administration Assistant screenshots
Downloads
Download
version 1.2.0 of Harvest Administration Assistant
Download
product features presentation in Microsoft PowerPoint format
Legal
Harvest Administration Assistant is a freeware and may be used for any commercial
or noncommercial purpose under the
license.
Feedback
We would be very thankful for any
feedback
on application usage, desirable features and found bugs.
Acknowledgements
Thanks to
- Danny Tylman for inspiration and initial support
- Ron Meyer for helpful feedback
- pureSCM and personally to Vaughn Marshall for adding support for r12.x to Harvest Administration Assistant
|