Harvest Administration Assistant


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

© 2006-2016 Attrice Corporation. Last updated 07-Dec-2016 Contact us