Customizing Deltek Vision - Project Descriptions

If you are a user of Deltek Vision v5.0 you will find that there are some customizations you can do to make Deltek more useful to users. It is important to note that these types of customizations are unsupported by Deltek and should be done in a test/lab environment before making any changes to your production databases. This post assumes you are using Deltek Vision 5.0 on the Windows Server 2003 platform and using Microsoft SQL Server 2005 as the database backend.

Project descriptions are a key component of Deltek as they give the user the ability to categorize project descriptions for use in resumes, proposals, etc. However, it would be helpful if it showed the Modified by user, date, and allowed for customized notes, see below:



To make these changes you will need to modify the application javascript as well as the underlying database table. First, update the table to add the notes column

update table PRDescriptions add column Notes as varchar(MAX)
update table PRDescriptionsTemplate add column Notes as varchar(MAX)

Now in order to update the javascript, you will need to locate the ProjectInfoCenter.js file in your application directory. On my system it is in the c:/Program Files/Deltek/Vision/Web/js directory.

Open the file and look for the following lines:
tmpObj = gridDescr.addHtmlEditColumn("PRDESC.Description", "Description", "string");
tmpObj.width = 320;
tmpObj.displayOnly = true;

Add the following lines:
tmpObj = gridDescr.addHtmlHrefColumn("PRDESC.ModUser AS desModUser", "ModUser", "string:50", "Description");
tmpObj.updateable = false;
tmpObj.displayOnly = true;
tmpObj.width = 50;
tmpObj = gridDescr.addHtmlHrefColumn("PRDESC.ModDate AS desModDate", "ModDate", "string:50", "Description");
tmpObj.updateable = false;
tmpObj.displayOnly = true;
tmpObj.width = 50;
tmpObj = gridDescr.addHtmlEditColumn("PRDESC.Notes", "Notes", "string");
tmpObj.width = 120;
tmpObj.displayOnly = true;

Save the file and reset IIS. Open Deltek and take a look.

Purpose of the blog

This blog will attempt to help developers of various applications find ways to make them more functional and user friendly.

Enjoy