enterprise custom fields

[Daniel Beale]

I have noted the project server tables dbo.MSP_CUSTOM_FIELDS, and
dbo.MSP_LOOKUP_TABLES are where project server adds custom fields to
Project, Resource, Task entities when added via PWA or PSI.

Does anyone know what the tables eg
dbo.MSP_TIMESHEET_CUSTOM_FIELD_DEFINITION,
dbo.MSP_TIMESHEET_CUSTOM_FIELD_VALUES are used for and if it's possible to
add custom fields too the eg timesheet entity programatically through the
PSI?

I am trying to link our 'job number' field in our accounting, operations,
and crm systems to a project number in project server allowing time to be
put against the job number with pwa timesheets etc.


Thanks in Advance
Daniel.

 

[CTA]

I have noted the project server tables dbo.MSP_CUSTOM_FIELDS, and
dbo.MSP_LOOKUP_TABLES are where project server adds custom fields to
Project, Resource, Task entities when added via PWA or PSI.

Does anyone know what the tables eg
dbo.MSP_TIMESHEET_CUSTOM_FIELD_DEFINITION,
dbo.MSP_TIMESHEET_CUSTOM_FIELD_VALUES are used for and if it's possible to
add custom fields too the eg timesheet entity programatically through the
PSI?

I am trying to link our 'job number' field in our accounting, operations,
and crm systems to a project number in project server allowing time to be
put against the job number with pwa timesheets etc.

Thanks in Advance
Daniel.

Hi Daniel,

I haven't seen this done, but the timesheet web service is available
( http://ServerName/ProjectServerName/_vti_bin/psi/TimeSheet.asmx) and
there is a method
TimesheetDataSet.CustomFieldsDataTable.AddCustomFieldsRow that might
work.

Colby