T
Tiffy Huxtable
Hi!
I can't update Task Enterprise Custom Fields with Lookup Tables using
the PSI methods in Project Server 2007.
1) The SDK says that updating has to be accomplished by using Project
Webservice and QueueUpdateProject. What I do is the following:
a) I read necessary Custom Field data with ReadProjectEntities() and
get a ProjectDataSet
b) I go to the TaskCustomFields data table of the ProjectDataSet
c) I find the needed TaskCustomFields-row and change the CODE_VALUE
value (nothing more)
d) I call the methods TaskCustomFields.AcceptChanges() and
ProjectDataSet.AcceptChanges()
e) I check-out the project.
f) I call QueueUpdateProject() with the ProjectDataSet and a fresh new
job Guid.
g) I wait for job completion of QueueUpdateProject()
and at this point I get an exception from the Queue WebService with
"job state: unknown", no more information. That means the
QueueUpdateProject method() doesn't do anything, the
QueueUpdateProject method does not store a job in the Project Server
queue.
2) I tried using the Statusing WebService in order to set Task
Enterprise Custom Field values, because the SDK says that task values
can be stored, and I prefer to avoid checking-out and checking-in a
whole project just to update one single enterprise custom field.
a) I start a new changeXML string and follow exactly the schema from
the SDK!
b) I create a "Changes" root element in the changeXML
c) I create a "Proj" child and inside there a "Task" child.
d) Inside the "Task" child I create a "Change" child.
e) The "Change" child gets as PID attribute the MD_PROP_ID value from
the CustomFieldDataSet.CustomFields data table of my task enterprise
custom field.
f) I call UpdateStatus(changeXML) from Statusing WebService
There I get the following SOAP exception:
StatusingGetDataForTaskFailed
Is the Statusing WebService really able to do updates on Task
Enterprise Custom Fields and this with Lookup Tables? What exactly can
the Statusing WebService update of task relating values?
3) Besides all that, when I try to store Assignment Enterprise Custom
Fields through the Statusing WebService with the appropriate changeXML
I get a "GeneralUnhandledException".
I'm not suvvessful with all that. Can anybody help with how to update
Task Enterprise Custom Fields with Lookup Table through PSI?
Thank you very much.
Tiffy
I can't update Task Enterprise Custom Fields with Lookup Tables using
the PSI methods in Project Server 2007.
1) The SDK says that updating has to be accomplished by using Project
Webservice and QueueUpdateProject. What I do is the following:
a) I read necessary Custom Field data with ReadProjectEntities() and
get a ProjectDataSet
b) I go to the TaskCustomFields data table of the ProjectDataSet
c) I find the needed TaskCustomFields-row and change the CODE_VALUE
value (nothing more)
d) I call the methods TaskCustomFields.AcceptChanges() and
ProjectDataSet.AcceptChanges()
e) I check-out the project.
f) I call QueueUpdateProject() with the ProjectDataSet and a fresh new
job Guid.
g) I wait for job completion of QueueUpdateProject()
and at this point I get an exception from the Queue WebService with
"job state: unknown", no more information. That means the
QueueUpdateProject method() doesn't do anything, the
QueueUpdateProject method does not store a job in the Project Server
queue.
2) I tried using the Statusing WebService in order to set Task
Enterprise Custom Field values, because the SDK says that task values
can be stored, and I prefer to avoid checking-out and checking-in a
whole project just to update one single enterprise custom field.
a) I start a new changeXML string and follow exactly the schema from
the SDK!
b) I create a "Changes" root element in the changeXML
c) I create a "Proj" child and inside there a "Task" child.
d) Inside the "Task" child I create a "Change" child.
e) The "Change" child gets as PID attribute the MD_PROP_ID value from
the CustomFieldDataSet.CustomFields data table of my task enterprise
custom field.
f) I call UpdateStatus(changeXML) from Statusing WebService
There I get the following SOAP exception:
StatusingGetDataForTaskFailed
Is the Statusing WebService really able to do updates on Task
Enterprise Custom Fields and this with Lookup Tables? What exactly can
the Statusing WebService update of task relating values?
3) Besides all that, when I try to store Assignment Enterprise Custom
Fields through the Statusing WebService with the appropriate changeXML
I get a "GeneralUnhandledException".
I'm not suvvessful with all that. Can anybody help with how to update
Task Enterprise Custom Fields with Lookup Table through PSI?
Thank you very much.
Tiffy