Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

  • Brian Smith's Microsoft Project Support Blog

    Latest Project Server 2007 SDK Update Now Available! Updated posting for December 07 Release

    • 2 Comments

     

    The December 2007 update to the SDK is now available

    Project Developer Portal:   http://msdn2.microsoft.com/en-us/office/aa905469.aspx

     

    SDK Online:  Project 2007 SDK in MSDN online library: http://msdn2.microsoft.com/en-us/library/ms512767.aspx

     

    SDK Download:  http://www.microsoft.com/downloads/details.aspx?FamilyId=2672F6F9-7028-4B30-99A2-18CB1EED1ABE&displaylang=en

    New and updated topics since July:

    Articles:

    ·         ERP Connector Solution Starter (20 topics)

    ·         How to: Customize E-Mail for Project Server Notifications  – this is an update of the project_programmability blog post.

    ·         Project XML Data Interchange Schema Reference includes the following topics:

    ·         New XML Elements

    ·         Custom Field Data in XML

    ·         Saving and Opening Projects in XML Format

    ·         How to: Use XSLT Transformations with Project XML Data Interchange Files

    ·         Project Data Interchange Elements includes reference topics for all of the schema sections, XML structure, and XML elements.

     

    PSI Managed Code Reference:

    ·         Additional descriptions of row properties in the following datasets in the Project Server Interface (PSI): LookupTableDataSetLookupTableMultiLangDataSet, AlertSubscriptionInfoDataSet, ReminderSubscriptionInfoDataSet, QueueStatusDataSet, QueueStatusRequestDataSet, StatusingSettingsDataSet.

    ·         Additional descriptions for event receiver methods.

     

    Download:

    ·         ERP Connector:   Complete sample source code and test application for the ERP Connector.

    ·         XML Schema:  Revised XML data interchange schema, mspdi_pj12.xsd.
    Note: The Project XML schema is also now published on http://schemas.microsoft.com/project/2007.

    ·         ProjTool:   Now includes a dialog box for backup and restore of selected projects.

    ·         SP1 library assembly:   Redistribution license for the SP1 build of the Microsoft.Office.Project.Server.Library.dll assembly, and 32- and 64-bit copies of the assembly.
    Note:  The MSIL code of the assembly is the same in both cases, so the file size is the same. However, we provide both builds to be consistent with the Project 2007 SKUs and because there may be differences in the future.

    Technorati Tags: Project Server 2007

  • Brian Smith's Microsoft Project Support Blog

    Project 2007 SP1 - The gift that keeps on giving

    • 11 Comments

    So with the Holiday season in full swing - what to give that difficult person who has everything.  How about Project 2007 SP1?  Yes, the links should soon be live, and until then you can prepare by reading the TechNet article at http://technet2.microsoft.com/Office/en-us/library/c3b86049-7cba-4b9c-8335-e37fb6e7518a1033.mspx?mfr=true 

    Please read all of the article - and also note that there is just one Microsoft Office Server 2007 SP1 which fits the whole family.  So don't go looking for a file that just says "projectserver" as you won't find it.  The file will be called officeserver2007sp1-kb936984... with the last piece of the file name referencing wither the 32 or 64 bit version.

    If you do have Microsoft Office SharePoint Server 2007 then the SP1 file is the same - but the document you should read as well as the one above is http://technet2.microsoft.com/Office/en-us/library/f484f5f2-35bb-4d70-bf56-dd1c4c287c721033.mspx?mfr=true

    And for any version of Office Server you also need to load the Windows SharePoint Services 3.0 SP1 first (it won't work if you don't, and it will tell you why), and both Service Packs need loading on all servers in the farm (except your database server if it isn't doing anything else).  See the related links section of the article for more details on planning for the WSS 3.0 SP1.

    For the client there is a separate SP1.  It is not imperative that you load at the same time as the server - it will work if you load client first and do the server later - or the other way around.  I will update with the links when they are all available - but planning is important - so get reading!

    Links (But please READ the above documents FIRST!):-

    Office 2007 suite SP1 - http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en

    Office Project 2007 SP1 - http://www.microsoft.com/downloads/details.aspx?FamilyID=CEC3E1E2-D802-4A03-BC78-05C48472559B&displayLang=en

    Office Project Language Pack 2007 SP1 - http://www.microsoft.com/downloads/details.aspx?FamilyID=d322ba67-b199-4503-8aff-6813b320d708&DisplayLang=en

    Office Servers 2007 SP1 - http://www.microsoft.com/downloads/details.aspx?FamilyId=AD59175C-AD6A-4027-8C2F-DB25322F791B&displaylang=en

    Office Server Language Pack 2007 SP1 - http://www.microsoft.com/downloads/details.aspx?FamilyId=3A6C26FD-0BEB-40D5-8CBA-15164FAAB150&displaylang=en

    Windows SharePoint Services 3.0 SP1 - http://www.microsoft.com/downloads/details.aspx?FamilyId=4191A531-A2E9-45E4-B71E-5B0B17108BD2&displaylang=en

    Technorati Tags: Project Server 2007

  • Brian Smith's Microsoft Project Support Blog

    Setting custom field values using the PSI

    • 27 Comments

    We don't seem to have done a good job in educating our customers on this topic, so thought I'd put this out there at least as a starting point and I'm sure we can also try and get better samples in the SDK. 

    One of the tricky things with setting custom fields for any entity (Project, Resource or Task - but also assignment or timesheet) is that you cannot always just call up the dataset, navigate to the custom field row and set the value.  In many cases the row may not yet exist, so you need to add it, then set all the required properties and then update back through the PSI.

    As an example if you create a project through the PSI it will have no project level custom field rows created by default, (except ones based on Lookup Tables with a default value forced) and any tasks will only have the "Health" special custom field set, and again- any with Lookup Table defaults. If you then open in Project Professional and just save again, you will then have added any calculated fields at the project level, along with any calculated fields at the task level.  Also at this stage the project summary task (Task 0) is populated with any task level fields with roll up to summary level set.

    As my server does not have all the possible combinations of fields I may be missing something here - but ProjTool is a great way to see just what is in the dataset at any time.

    So whenever you are setting custom fields first see if the row already exists - and if not you will need to add a customfieldrow to whatever dataset you are working with.  Then the next step is to set the appropriate properties - which will depend on the type of field you are setting (defined by FIELD_TYPE_ENUM), and the dataset you are adding it to.  For instance a ProjectCustomFieldsRow will need the PROJ_UID.  A TaskCustomFieldsRow will need the PROJ_UID and the TASK_UID.  A Timesheet CustomFieldsRow will need the TS_UID to identify the timesheet and a TS_LINE_UID to identify the specific line.  Then for any row you need to set a new GUID for the CUSTOM_FIELD_UID, the MD_PROP_UID and/or the MD_PROP_ID to identify the specific custom field and the actual value you want to set in the appropriate property as detailed in the following table.

    Field Type ENUM Value Description Set field value in:
    COST 9 Value in 1/COST_MULTIPLIER dollars NUM_VALUE
    DATE 4 A date value. HIWORD contains days off set from 1/1/84. LOWORD contains minute off-set, ranging from 0 to 1440, from 12:00 A.M. (midnight) DATE_VALUE
    DURATION
    6 Value in 1/DUR_MULTIPLIER minutes DUR_VALUE and DUR_FMT
    TEXT 21 A string value TEXT_VALUE
    FLAG 17 Index into yes/no string table FLAG_VALUE
    NUMBER 15 A number value NUM_VALUE
    (Lookup Table)   GUID CODE_VALUE

    FINISHDATE is also listed in the SDK but is not applicable to these custom fields.  Lookup Table isn't specifically a custom field type - but I added it for completeness.  If the custom field is based on a Lookup Table then the LT_STRUCT_UID of the specific entry in the Lookup Table is entered in the CODE_VALUE property.  For those that accept multiple values there will be a row with each CODE_VALUE - not a single row with multiple CODE_VALUES.

    Another property you will come across in the datasets is the INDICATOR_VALUE - which will hold the enumeration value for the indicator to be displayed based on the custom field settings. 

    No code sample just yet on this - but I will try and come up with some shortly.  I am looking into a support incident where values are being set for summary tasks (or rather they are not) - these are likely to be read-only if "roll-up" is set, so be aware of that.

    *** Update *** Finally got a sample together - hope it is worth the wait - http://blogs.msdn.com/b/brismith/archive/2010/08/25/project-server-adding-custom-fields-to-projects-and-tasks-using-the-psi.aspx 

    The ProjCFDlg.cs sample in ProjTool and the Add Project Custom Field option on the Project Details pane of ProjTool is a great place to look for an example that covers this well.

    Other things to be aware of are that constraints applied to the custom fields will need to be adhered to.  If the custom field only allows selection of codes with no subordinate value (leaf nodes) then the PSI cannot over-ride this. 

  • Brian Smith's Microsoft Project Support Blog

    Project Server 2007 Users: Beware the Fabulous 40!

    • 1 Comments

    No, this isn't some new group of super heroes or villains - but a set of templates you can load on SharePoint 3.0. See http://www.microsoft.com/sharepoint/templates.mspx for full details.  But you should not load one of these templates if you already have Project Server 2007, as the Project Tracking Workspace solution included in the Fabulous 40 will overwrite the good Project Workspace template from Project Server.  When this happens the special features that don't exist in the WSS version, like linking risks, issues, documents and deliverables to project tasks, get broken.  So if you have already done this then your new link page looks like this:-

    image

    when really it should look like this:-

    image

    Notice the missing Link Items option.  Your server may not have the Spelling option - this server also has Office SharePoint Server.  I would expect bad things to happen in plenty of other places too.

    So how to fix it?  You can retract and delete the solution either using the UI of Central Administration or the stsadm command (see the readme that comes with the templates for removal instructions), and then you will need to run a repair of Project Server 2007 either from the setup.exe - or from the Change option in add/remove programs.  You will need to do this on all servers in your farm - and it may require a reboot, and you will need to run the configuration wizard to complete the process.

    So for Project Server 2007 users it should be renamed "The Fabulous 39"!  Thanks to Noel and Shazeb for their work on this topic.  We also plan to get some sort of warning on the download page.

    Technorati Tags: Project Server 2007

  • Brian Smith's Microsoft Project Support Blog

    EPM 2007 Test Data Population Tool

    • 2 Comments

    The EPM 2007 Test Data Population Tool solution starter was published on CodePlex today: http://www.codeplex.com/EPMDatapop

     

    So if you need to get some sample data loaded up for testing purposes - this is the tool for you!  Documentation and source code is also posted  so this will also be a good tool for learning how the PSI is used for getting data into the server.

     

    Q & A is posted in the discussion area - but I'll repeat this one here...

     

    Q: Is the tool supported?

    A: There is no support in terms of CSS/PSS. We expect the support being a CodePlex community effort. Please note that the customization code uses standard supported web service calls available out of the box in EPM2007.

     

     

    Enjoy!

Page 77 of 91 (454 items) «7576777879»