Project Server Blogs

Archive for October, 2007

— Next Page »

Busy

31 October 2007

Popularity: 1% [?]

Multi-List SharePoint Synchronization to Microsoft Project Enterprise Resource Pool Part II

31 October 2007

Popularity: 1% [?]

Update Resource Custom Field Text Value

31 October 2007

Popularity: 1% [?]

Adding a Lookup Table Value to an Enterprise Resource’s Custom Field

31 October 2007

Popularity: 1% [?]

Figuring out the ChangeXML format when using the ‘UpdateStatus’ method

31 October 2007

The Statusing web service (Project Server Interface) in EPM2007 contains a powerful method called UpdateStatus. This method can be used to make changes to tasks and assignments; for instance: Actual Work, % Work Complete, … please refer to the ChangeList Schema Reference in the SDK for a complete list.

To help you generate the XML string required to achieve your customization needs the latest version of the SDK has a powerful tool that will help you generate the ChangeXML command: How to: Generate ChangeXML for Statusing Updates

Your customization will ideally generate the proper ChangerXML command dynamically based on the entities you need to update.

A sample method to generate the ChangeXML string could look like this:

  public static StringBuilder CreateChangeXml(TimeSheetWS.TimesheetDataSet timesheetDs)
        {
            StringBuilder changeXml = new StringBuilder();
            string pidRegularWork = PSLibrary.AssnConstID.s_apid_regular_work.ToString(System.Globalization.CultureInfo.InvariantCulture);

            changeXml.AppendFormat(“<Changes>”);
            for (int i = 0; i < timesheetDs.Lines.Count; i++)
            {
                if (timesheetDs.Lines[i].TS_LINE_VALIDATION_TYPE == (int)PSLibrary.TimesheetEnum.ValidationType.Verified)
                {
                    changeXml.AppendFormat(“<Proj ID=”{0}”>”, timesheetDs.Lines[i].PROJ_UID.ToString());
                    changeXml.AppendFormat(“<Assn ID=”{0}”>”, timesheetDs.Lines[i].ASSN_UID.ToString());
                    changeXml.AppendFormat(“<Change PID=”{0}”>{1}</Change>”, pidRegularWork, timesheetDs.Lines[i].TS_LINE_ACT_SUM_VALUE.ToString(System.Globalization.CultureInfo.InvariantCulture));
                    changeXml.Append(“</Assn></Proj>”);
                }
            }
            changeXml.Append(“</Changes>”);

            return changeXml;
        }

Popularity: 1% [?]

Project Server Extended Report Pack from Project Conference

31 October 2007

Following my presentation yesterday on reporting at the Project Conference in Seattle, please find below the “Extended” EPM report pack I demoed (leveraging SQL Server Reporting Services).

Reports added are:

• Deliverables and Dependencies
• Issues and Risks Report
• Project Workspaces
• ProjectList PSI XML
• ResourceList PSI XML
• Risks - XML Data Srouce
• SSAS Timesheet
• Timesheet Audit 2

Popularity: 2% [?]

Project Conference Day 1

31 October 2007

I had a chance to meet plenty of old friends today - and also put faces to names I have known for a while.  It was good to meet all of you.  Several people asked about the PowerPoint presentation so I have attached it to this posting.  If I get time I may record several of the demos and post them up to MSN Soapbox.  For now the pptx on it’s own at least has many of the links you should find useful.  For those who were not able to be here the session was titled Administration of an EPM Solution and concentrated on Project Server 2007.

Popularity: 1% [?]

At Project Conference This Week

31 October 2007

Judging from the keynote, it looks like a packed house!  I’ll be in the Project Labs from 11am to 1:30pm on Tuesday if you want to talk face to face.

Popularity: 1% [?]

MSProjectConference2007 Day3

31 October 2007

Popularity: 1% [?]

MSProjectConference2007 Day2

31 October 2007

Popularity: 1% [?]

— Next Page »