StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9482746
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-02-28T13:25:41.750
FavoriteCount
0
LastActivityDate
2016-05-02T08:45:15.557
LastEditDate
2016-05-02T08:45:15.557
LastEditorUserId
1138326
OwnerUserId
1138326
ParentId
9421313
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
I know your problem. Microsoft has really bad examples on MSDN. Lot of stuff doesn't work or has just been copied from the 2007 manual. I've started yesterday to develop with the Webservice for Project Server 2010. Here is a simple (maybe not the best) solution for setting custom fields: Complete source code: <a href="http://pastebin.com/tr7CGJsW" rel="nofollow noreferrer">http://pastebin.com/tr7CGJsW</a> <h2>Prepare your solution</h2> First I've added a Service Reference to: <blockquote> http: //servername/instance/_vti_bin/PSI/Project.asmx?wsdl </blockquote> <a href="https://i.stack.imgur.com/q0S9S.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/q0S9S.png" alt="Service Reference"></a> After that, I've edited the app.config because I had to use special credentials to login into the project server (maybe this is not necessarily for you): <pre class="lang-xml prettyprint-override"><code>... <security mode="TransportCredentialOnly"> <transport clientCredentialType="Ntlm" proxyCredentialType="Ntlm" realm="" /> <message clientCredentialType="UserName" algorithmSuite="Default" /> </security>  </binding> </code></pre> The commented code has been created by Visual Studio <h2>Connect and Update</h2> Now we can create a new SoapClient which communicates with the Project Server: <pre class="lang-cs prettyprint-override"><code>//Creating a new service client object ProjectSoapClient projectSvc = new ProjectSoapClient(); //Just if you need to authenticate with another account! projectSvc.ClientCredentials.Windows.ClientCredential = new NetworkCredential("test", "test", "demo"); projectSvc.ClientCredentials.Windows.AllowedImpersonationLevel = TokenImpersonationLevel.Impersonation; </code></pre> Now I have declared two Guids, that we know, what we want to update. The other variables are used later and are comment in the code: <pre class="lang-cs prettyprint-override"><code>//Guid of my project Guid myProjectId = new Guid("{610c820f-dc74-476c-b797-1e61a77ed6c6}"); //Guid of the custom field Guid myCustomFieldId = new Guid("{cd879634-b3ee-44eb-87f7-3063a3523f45}"); //creating a new sessionId and a new jobId Guid sessionId = Guid.NewGuid(); //the sessionId stays for the whole updating process Guid jobId = Guid.NewGuid(); //for each job, you give to the server, you need a new one //indicator if you have to update the project Boolean updatedata = false; </code></pre> Then we are ready to load the <a href="https://msdn.microsoft.com/en-us/library/gg224487.aspx" rel="nofollow noreferrer">ProjectDataSet</a> from the server, find the CustomField and updating the data. It's really simple: <ol> <li>loading the ProjectDataSet</li> <li>iterate trough the CustomFieldsRow</li> <li>checking if the CustomField matches with our Guid</li> <li>updating the value</li> <li>setting the indicator to update</li> </ol> <pre class="lang-cs prettyprint-override"><code>//loading project data from server //Every change on this dataset will be updated on the server! ProjectDataSet project = projectSvc.ReadProject(myProjectId, DataStoreEnum.WorkingStore); //To find your custom field, you have to search for it in the CustomFieldsRow foreach (ProjectServerCSVImport.PSS.Project.ProjectDataSet.ProjectCustomFieldsRow row in project.ProjectCustomFields) { //check if the GUID is the same if (row.MD_PROP_UID == myCustomFieldId) { //if yes, write it into the container row.NUM_VALUE = 12345; //and set the indicater updatedata = true; } } </code></pre> If we changed a value, we have to send the ProjectDataSet to the ProjectServer now. It will update the changed values in the ProjectDataSet. For this, we have to check out our project, update it and check in again: <pre class="lang-cs prettyprint-override"><code>//update if you have changed anything if (updatedata) { //check out the project first projectSvc.CheckOutProject(myProjectId, sessionId, "custom field update checkout"); //send the dataset to the server to update the database bool validateOnly = false; projectSvc.QueueUpdateProject(jobId, sessionId, project, validateOnly); //wait 4 seconds just to be sure the job has been done System.Threading.Thread.Sleep(4000); //create a new jobId to check in the project jobId = Guid.NewGuid(); //CheckIn bool force = false; string sessionDescription = "updated custom fields"; projectSvc.QueueCheckInProject(jobId, myProjectId, force, sessionId, sessionDescription); //wait again 4 seconds System.Threading.Thread.Sleep(4000); </code></pre> But now we just have updated the database. The server will still show us the "old" value and not the new one. This is because we didn't have published our project yet: <pre class="lang-cs prettyprint-override"><code>//again a new jobId to publish the project jobId = Guid.NewGuid(); bool fullPublish = true; projectSvc.QueuePublish(jobId, myProjectId, fullPublish, null); //maybe we should wait again ;) System.Threading.Thread.Sleep(4000); </code></pre> Finally we're done and our project is updated! <h2>Enhancements</h2> I'm very new to this platform (Project Server 2010), so this code maybe is not the best example. So there are some enhancements, which would made the solution better: <ul> <li>The Sleep function is a very bad workaround, but I couldn't find an example which handles the same thing (<a href="http://msdn.microsoft.com/en-us/library/websvcproject.project.readproject%28v=office.12%29.aspx" rel="nofollow noreferrer">like here</a>) with a <a href="https://msdn.microsoft.com/en-us/library/websvcqueuesystem.queuesystem(v=office.12).aspx" rel="nofollow noreferrer">QueueSystem</a> for 2010?!</li> <li>If you don't know the Guid of your project, but the name, you can resolve it by following function:</li> </ul> <pre class="lang-cs prettyprint-override"><code>/// <summary> /// Returns the GUID for a specified project /// and sets the guid for this class /// </summary> /// <param name="client">soap service client</param> /// <param name="projectname">name of the project</param> /// <returns>Project GUID</returns> public Guid GetGuidByProjectName(ProjectSoapClient client, string projectname) { Guid pguid = new Guid(); ProjectDataSet data = client.ReadProjectList(); foreach (DataRow row in data.Tables[0].Rows) { if (row[1].ToString() == projectname) //compare - case sensitive! { pguid = new Guid(row[0].ToString()); } } return pguid; } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSetting custom fields using the PSI - Microsoft Project Server
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. UScansik
UserOwnerUserId
1. UScansik
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POSetting custom fields using the PSI - Microsoft Project Server
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.