SQL to update / populate custom fields

[BrandonSi]

I've been tasked with ensuring that our custom/enterprise fields in MS
Project Server 2007 are populated from certain database tables to ensure
consistency in our projects. For example, we have a custom field for
'Department' that all Projects need to have set. Currently this drop-down box
is populated by data that was at one time entered by hand.

I've done plenty of research, but I'm still lost as to how I would go about
getting Project Server to populate that field by using a query.. For example,
just 'select dept_name from department'.

It's starting to look like I need to write something in Visual Studio to
interface with the PSI web services?

Again, completely lost.. Any help or just a high level overview would be
greatly appreciated.

 

[Stephen Sanderlin]

You're on the right track -- if you're looking to populate a lookup
table with values from an external data source, you will need to write
something to act as an importation mechanism from the external source to
the PSI.

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com