Adding projects to a category automatically

[Ian Wolstenholme]

Hi,

Is there a way to add a project to a category based on a value assigned to a
project oultine code for that project. We want to do this as an auto close
macro. It needs to be done on the first creation of the project only.

Does anyone know how this might be done ?

Thanks

Ian

 

[Ed Morrison]

I have done this in the past using a SQL update/insert trigger on the
msp_projects table.

 

[Ian Wolstenholme]

Hi Ed,

Would you be willing to share the SQL script for this trigger with me?

Thanks

Ian

 

[Ed Morrison]

I don't have the trigger anymore as I wrote it at my old job. Try the
following
On the creation or update of a new project which you want to add to the
category insert a record into the msp_web_security_category_objects table.
Set WSEC_CAT_ID= the category id found in the msp_web_security_categories
table. Set WSEC_OBJ_TYPE=1 (for a project). Set WSEC_OBJ_ID=the project's
wproj_id.

If the project does not meet the criteria, delete the record that meets the
above criteria.

Hope this helps.
--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com

 

[Ed Morrison]

Since using custom fields is a common question, I have added sample code to
our public FAQ site http://projectserverexperts.com. The article is titled
"Changing the Security Categories using an Enterprise Custom Flag".

Hope this helps.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://projectserverexperts.com