tag:blogger.com,1999:blog-8746200746992694032024-03-05T05:10:50.157-08:00Project and Portfolio Management - PPM365My blog contains information on Microsoft PPM Solution 2016/2013/2010/2007/2003 and Project Online. It covers Microsoft Project, Project Server, Project Portfolio Server, SharePoint, SQL Server, SQL Reporting Services, Analysis Services and OLAP for use in the MS EPM Solution.Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-874620074699269403.post-71314306758754266042017-09-29T07:22:00.003-07:002017-09-29T07:22:29.454-07:00SharePoint Designer- Unable to open a workflow - WWF .NET 3.0, must be installed to use the feature<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="margin: 0px;">
<br /></div>
<div style="margin: 0px 0px 16px;">
<span style="font-family: Calibri;">Every day is a learning day and
If we don’t learn a new thing today, the day is wasted. </span></div>
<br />
<div style="margin: 0px;">
<span style="font-family: Calibri;">I don’t think much of a man who is not wiser today than he
was yesterday ~ ~Abraham Lincoln</span><span style="font-family: Calibri;"> </span></div>
<br />
<div style="margin: 0px;">
<span style="font-family: Calibri;">I would like to write something on the SharePoint Designer
2013 workflow. Recently I started receiving the message from SharePoint
Designer 2013 when I open a workflow that was deployed on MS Project Online and
workflows is working as expected but I wanted to check the steps in Workflow.
The message that received is below and when you click on OK, You see a message
that File is deleted from site or site is having issues, try refreshing to
resolve but nothing worked.</span></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJltf5-vdVDY8rvKQB0mxwD51X7JcCCmUcCZhVYyqfeuBRqsuINA31uUI0-0JFtl_txV0ZPuAmVOfXvWbcDqEqvOamBVTM3s6InrvQuc3skiQRaftPohpoZvQrLg0ScMD804hEvT8byVtr/s1600/1.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="187" data-original-width="658" height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJltf5-vdVDY8rvKQB0mxwD51X7JcCCmUcCZhVYyqfeuBRqsuINA31uUI0-0JFtl_txV0ZPuAmVOfXvWbcDqEqvOamBVTM3s6InrvQuc3skiQRaftPohpoZvQrLg0ScMD804hEvT8byVtr/s400/1.jpg" width="400" /></a></div>
<div>
<span style="font-family: Calibri;"></span><span style="font-family: Calibri;"><span style="font-family: "Calibri",sans-serif; font-size: 11pt; margin: 0px;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj55Nr6GOEmvvbgbwnSoQDwgiIU_WnDIO28IfAQmrF08NInkXnMZO7EY-aabfn7OJETh1ta21hRuCK3ZU9WFrVsNbij0fdgCmqztO68pOTPoF8pEb5SLi6iYq7XkyewHT5VEhnAGAGZ1xfA/s1600/2.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="320" data-original-width="658" height="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj55Nr6GOEmvvbgbwnSoQDwgiIU_WnDIO28IfAQmrF08NInkXnMZO7EY-aabfn7OJETh1ta21hRuCK3ZU9WFrVsNbij0fdgCmqztO68pOTPoF8pEb5SLi6iYq7XkyewHT5VEhnAGAGZ1xfA/s400/2.jpg" width="400" /></a></div>
<br />
<div>
<br /></div>
<div style="margin: 0px;">
</div>
<br />
<div style="margin: 0px;">
<span style="font-family: Calibri;"><br /></span></div>
<div style="margin: 0px;">
<span style="font-family: Calibri;"><br /></span></div>
<div style="margin: 0px;">
<span style="font-family: Calibri;"><br /></span></div>
<div style="margin: 0px;">
<span style="font-family: Calibri;"><br /></span></div>
<div style="margin: 0px;">
<span style="font-family: Calibri;"><br /></span></div>
<div style="margin: 0px;">
<span style="font-family: Calibri;"><br /></span></div>
<div style="margin: 0px;">
<span style="font-family: Calibri;"><br /></span></div>
<div style="margin: 0px;">
<span style="font-family: Calibri;"><br /></span></div>
<div style="margin: 0px;">
<span style="font-family: Calibri;"><br /></span></div>
<div style="margin: 0px;">
<span style="font-family: Calibri;">This was kind of confusing for me as I had the .NET
framework 4.5 and that should include all the previous versions of .NET
framework. If you go online for solution, you may find many such as
installation of Visual Studio 2005 extensions for .NET Framework 3.0 (Windows
Workflow Foundation), hot fixes etc but before we try any of the solution, Try
below steps.</span></div>
<br />
<div style="margin: 0px;">
<br /></div>
<br />
<ol start="1" style="margin-top: 0in;" type="1">
<li style="color: black; font-family: "Calibri",sans-serif; font-size: 11pt; font-style: normal; font-weight: normal; margin: 0px;"><span style="margin: 0px;">Exit SharePoint Designer
(if you have it open in your machine) and Delete the SharePoint Designer
Cache. </span><span style="font-family: Calibri;">Use below commands in CMD</span></li>
</ol>
<div style="margin: 0px 0px 0px 48px;">
<span style="font-family: Calibri;">
rmdir "%LOCALAPPDATA%\Microsoft\WebsiteCache\" /s /q</span></div>
<br />
<div style="margin: 0px 0px 0px 48px;">
<span style="font-family: Calibri;">rmdir
"%APPDATA%\Microsoft\SharePoint Designer\ProxyAssemblyCache\" /s /q</span></div>
<div style="margin: 0px 0px 0px 48px;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD6Tnntm0Bk3vCYW7n4X9svd0fLlv8MUJhXlkwVdGDcPf4eXILv0Fm9gU0BsDaAE31MiZtcshfDNmaAKU2Xk_gWcQEy0ikI13p3_-BJ0hi-Mhe-mtsu8RWaqgS0Q9iQy9dlfRo3HcIh8SF/s1600/3.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="218" data-original-width="1018" height="85" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD6Tnntm0Bk3vCYW7n4X9svd0fLlv8MUJhXlkwVdGDcPf4eXILv0Fm9gU0BsDaAE31MiZtcshfDNmaAKU2Xk_gWcQEy0ikI13p3_-BJ0hi-Mhe-mtsu8RWaqgS0Q9iQy9dlfRo3HcIh8SF/s400/3.jpg" width="400" /></a></div>
<div style="margin: 0px 0px 0px 48px;">
<br /></div>
<span style="font-family: Calibri;"></span><div class="separator" style="clear: both; text-align: center;">
<span style="font-family: Calibri;"></span></div>
<br />
<div style="margin: 0px;">
</div>
<br />
<div style="margin: 0px;">
<br /></div>
<br />
<ol start="2" style="margin-top: 0in;" type="1">
<li style="color: black; font-family: "Calibri",sans-serif; font-size: 11pt; font-style: normal; font-weight: normal; margin: 0px;"><span style="margin: 0px;">Restart the SharePoint
Designer.</span></li>
<li style="color: black; font-family: "Calibri",sans-serif; font-size: 11pt; font-style: normal; font-weight: normal; margin: 0px;"><span style="margin: 0px;">Open the Site and Click
Workflows in site objects</span></li>
<li style="color: black; font-family: "Calibri",sans-serif; font-size: 11pt; font-style: normal; font-weight: normal; margin: 0px;"><span style="margin: 0px;">Workflow should be
opened and should be editable.</span></li>
</ol>
<br />
<div style="margin: 0px;">
<br /></div>
<br />
<div style="margin: 0px;">
<span style="font-family: Calibri;">Happy learning. </span></div>
<b></b><i></i><u></u><sub></sub><sup></sup><strike></strike><span style="font-family: Calibri;"></span></div>
Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com1tag:blogger.com,1999:blog-874620074699269403.post-89114102517258977172017-07-26T12:21:00.002-07:002017-07-26T12:22:25.724-07:00Project Online- Bulk Edit Free on Office Store<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #741b47; font-family: "trebuchet ms" , sans-serif; font-size: large;">Project Server Bulk Edit add-in</span><br />
<br />
<div id="ProviderDescription0">
<span style="font-family: "trebuchet ms" , sans-serif;">Project Server Bulk Edit add-in enables the quick updating of project fields directly from PWA. Bulk Edit is designed from the ground up to take advantage of the features of SharePoint and Project Server 2013, 2016 and Project Online for fast performance and easy edits of hundreds of projects at once.</span></div>
<div id="ProviderDescription1">
<span style="font-family: "trebuchet ms" , sans-serif;">Usage</span></div>
<div id="ProviderDescription2">
<span style="font-family: "trebuchet ms" , sans-serif;">Once installed from the SharePoint App Store, the Bulk Edit icon becomes available on the Project Centre ribbon menu under Apps. </span></div>
<div id="ProviderDescription3">
<span style="font-family: "trebuchet ms" , sans-serif;">Bulk Edit supports updating of all project level Enterprise Custom Fields for all projects that you can access.</span></div>
<div id="ProviderDescription4">
<span style="font-family: "trebuchet ms" , sans-serif;">Features Include</span></div>
<ul id="ProviderDescription5">
<li id="ProviderDescription6"><span style="font-family: "trebuchet ms" , sans-serif;">Support for Project Online and On-premises deployments</span></li>
</ul>
<ul id="ProviderDescription7">
<li id="ProviderDescription8"><span style="font-family: "trebuchet ms" , sans-serif;">Selection of multiple Built-in and Enterprise Custom Fields for editing (only some built-in fields can be edited)</span></li>
</ul>
<ul id="ProviderDescription9">
<li id="ProviderDescription10"><span style="font-family: "trebuchet ms" , sans-serif;">New: Deferred updates, if you prefer you can now make your changes then select Apply to apply all changes at once</span></li>
</ul>
<ul id="ProviderDescription11">
<li id="ProviderDescription12"><span style="font-family: "trebuchet ms" , sans-serif;">Excel style drop filter / sorting from column menus.</span></li>
</ul>
<ul id="ProviderDescription13">
<li id="ProviderDescription14"><span style="font-family: "trebuchet ms" , sans-serif;">Cut and Paste of values</span></li>
</ul>
<ul id="ProviderDescription15">
<li id="ProviderDescription16"><span style="font-family: "trebuchet ms" , sans-serif;">Excel style fill-down editing of field values</span></li>
</ul>
<ul id="ProviderDescription17">
<li id="ProviderDescription18"><span style="font-family: "trebuchet ms" , sans-serif;">AJAX / JSOM Driven for fast viewing / updating of hundreds of projects at once</span></li>
</ul>
<div id="ProviderDescription19">
<span style="font-family: "trebuchet ms" , sans-serif;">Note on On-Premises Installation</span></div>
<div id="ProviderDescription20">
<span style="font-family: "trebuchet ms" , sans-serif;">The Bulk Edit app fully supports on-premises Project Server 2013 and Project Server 2016 deployments, in order to install the app you may need to request from your SharePoint Administrator to install the SharePoint App Management Service, and / or request that this app be approved for installation by your administrator.</span></div>
<div>
<span style="font-family: "trebuchet ms";"><b><i><u><sub><sup><strike><br /></strike></sup></sub></u></i></b>Reference- https://store.office.com/en-us/app.aspx?assetid=WA104148561&rs=en-US&ui=en-US&ad=US&appredirect=false<b></b><i></i><u></u><sub></sub><sup></sup><strike></strike></span></div>
<div>
<span style="font-family: "trebuchet ms";"></span><br />
<h2 id="AppDetailsHeader">
<span style="font-family: "trebuchet ms";">
Details</span></h2>
<span style="font-family: "trebuchet ms";">
<div class="oxStandard" id="DetailsSection">
<span class="oxDetailsTitle" id="ProviderTitle">Provider: </span><a href="https://store.office.com/nearbaseline-solutions-pty-ltd-PN104148553.aspx?assetid=PN104148553" id="ProviderName" lang="en-US">Nearbaseline Solutions Pty Ltd</a><br />
<span class="oxDetailsTitle" id="VersionTitle">Version: </span><span id="VersionNumber" itemprop="version">1.2.0.15</span><br />
<span class="oxDetailsTitle" id="ReleasedTitle">Released: </span><span id="ReleasedDate" itemprop="datePublished">11/1/2013</span><br />
<span class="oxDetailsTitle" id="LanguagesTitle">Languages: </span><br />
<div id="LanguagesList">
English</div>
</div>
<div id="Requirements">
This add-in requires one of the following applications:</div>
<ul id="ProductsList">
<li id="Products0">SharePoint 2013 or later</li>
<li id="Products1">SharePoint Online</li>
</ul>
</span></div>
<br /></div>
Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-19648085668743276692017-07-26T12:16:00.003-07:002017-07-26T12:16:38.672-07:00Project Online- Bulk Calc and Publish app - free on Office store<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
<span style="color: #741b47;">Bulk Calc and Publish</span></h2>
Free:<br />
https://store.office.com/en-us/app.aspx?assetid=WA104380657&rs=en-US&ui=en-US&ad=US&appredirect=false<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitSbQXLQYvL5gVrOnuqKHfOwoHg1fJPXWHH1C0e8u_d3Uf5TBGirFCKBw_glBCUTbE-IAscf8DlUXWYCM6RRrlvGrPQ-vAm76KxnlNuXsqUigth9TTVkfBLtGNuQfHyOZa_WZZstOG_7Nd/s1600/Bulk+Calc.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="234" data-original-width="551" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitSbQXLQYvL5gVrOnuqKHfOwoHg1fJPXWHH1C0e8u_d3Uf5TBGirFCKBw_glBCUTbE-IAscf8DlUXWYCM6RRrlvGrPQ-vAm76KxnlNuXsqUigth9TTVkfBLtGNuQfHyOZa_WZZstOG_7Nd/s320/Bulk+Calc.JPG" width="320" /></a></div>
<br />
<br />
<div id="ProviderDescription0">
<span style="font-family: "Trebuchet MS", sans-serif;">This helpful Project Online add-in allows for more efficiency by automatically bulk calculating and publishing your projects. This is especially helpful with calculated fields that use the current date “Now()” function or any other fields that require calculations. </span></div>
<div id="ProviderDescription1">
<span style="font-family: "Trebuchet MS", sans-serif;">Using this add-in allows you have the power to create a schedule, change the frequency and avoid the manual steps of recalculating and/or publishing your projects.</span></div>
<div id="ProviderDescription2">
</div>
<div id="ProviderDescription3">
<span style="font-family: "Trebuchet MS", sans-serif;">Here are some reasons our clients are using this add-in:</span></div>
<ul id="ProviderDescription4">
<li id="ProviderDescription5"><span style="font-family: "Trebuchet MS", sans-serif;"> Automatically publish all or a subset of your projects within Project Online. If you simply want all your projects published weekly or daily - you can now easily do that. Think about that big Senior Management meeting that you need all project data updated and published - well here you go, this add-in can do that for you.</span></li>
</ul>
<ul id="ProviderDescription6">
<li id="ProviderDescription7"><span style="font-family: "Trebuchet MS", sans-serif;"> Set the Schedule to run when you want it to. With the Bulk Calc and Publish add-in you can automate and save time by avoiding the manual steps of forcing your project to recalculate and publish.</span></li>
</ul>
<ul id="ProviderDescription8">
<li id="ProviderDescription9"><span style="font-family: "Trebuchet MS", sans-serif;"> Ensure the latest project data for Reporting. You can confirm that all projects have been published so your dashboards and reports reflect the latest project updates.</span></li>
</ul>
<div>
<span style="font-family: Trebuchet MS;"><h2 id="AppDetailsHeader">
Details</h2>
<div class="oxStandard" id="DetailsSection">
<span class="oxDetailsTitle" id="ProviderTitle">Provider: </span><a href="https://store.office.com/ppm-works-inc-PN104379346.aspx?assetid=PN104379346" id="ProviderName" lang="en-US">PPM Works Inc.</a><br id="ProviderBr" /><span class="oxDetailsTitle" id="VersionTitle">Version: </span><span id="VersionNumber" itemprop="version">1.2.0.0</span><br id="VersionBr" /><span class="oxDetailsTitle" id="ReleasedTitle">Released: </span><span id="ReleasedDate" itemprop="datePublished">12/2/2016</span><br id="ReleasedBr" /><span class="oxDetailsTitle" id="LanguagesTitle">Languages: </span><div id="LanguagesList">
English</div>
</div>
<div id="Requirements">
This add-in requires one of the following applications:</div>
<ul id="ProductsList">
<li id="Products0">SharePoint 2016 or later</li>
<li id="Products1">SharePoint Online</li>
</ul>
</span></div>
<div>
<br /></div>
<b></b><i></i><u></u><sub></sub><sup></sup><strike></strike><div>
<br /></div>
</div>
Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-36319167657166333092012-07-01T22:58:00.000-07:002012-07-01T23:02:30.127-07:00Microsoft Project Server and SharePoint Server 2007 and 2010 June 2012 CU<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Georgia, "Times New Roman", serif;">The latest Cumulative Updates (CU) for Project and Project Server 2010 and 2007 have been released. Feel free to open a support case if you have any questions around this or need assistance getting these patches deployed.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Feel free to join us in July for a TechNet webcast to go over these patches in greater detail. The information for this event is below:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">TechNet Webcast: Information About Microsoft Project and Project Server Cumulative June Update (Level 200)</span><br />
<a href="https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&EventID=1032454430&CountryCode=US"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&EventID=1032454430&CountryCode=US</span></strong></a><br />
<i><strong><span style="font-family: Georgia, "Times New Roman", serif;">Project and Project Server 2010</span></strong></i><br />
<span style="font-family: Georgia, "Times New Roman", serif;">This include a number of fixes, so Microsoft strongly recommends that you test this in a test environment based on your production environment before putting this fix live in production.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">There was an issue found with one of the other Office Server products which needed to be addressed before release. The issue has been fixed and the Server Rollup Packages are being rebuilt. We expect the patch to be released the first week of July.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Please note that the issue was not with the Project Server Individual Package so the Project Server CU (KB2598375) can be used for testing and/or rapid deployment for organizations who cannot wait for the Server Rollup Patch to be released.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">The article below provides information on how to deploy the Project Server Cumulative Update.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">You can read about the fixes included in the Project and Project Server June CUs from the following articles:</span><br />
<b><i><span style="font-family: Georgia, "Times New Roman", serif;">Server Rollup Package(Recommended):</span></i></b><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">ETA: First week of July</span></b><br />
<b><i><span style="font-family: Georgia, "Times New Roman", serif;">Description of the Project Server 2010 cumulative update package (Project server-package): June 26, 2012</span></i></b><br />
<a href="http://support.microsoft.com/kb/2598355"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2598355</span></strong></a><br />
<i><strong><span style="font-family: Georgia, "Times New Roman", serif;">Individual Project Server Package:</span></strong></i><br />
<i><span style="font-family: Georgia, "Times New Roman", serif;">Only required if you do not install the Server Rollup. </span></i><br />
<b><i><span style="font-family: Georgia, "Times New Roman", serif;">Description of the Project Server 2010 hotfix package (Pjsrvwfe-x-none.msp): June 26, 2012</span></i></b><br />
<a href="http://support.microsoft.com/kb/2598375"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2598375</span></strong></a><br />
<i><strong><span style="font-family: Georgia, "Times New Roman", serif;">Project Client Package:</span></strong></i><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Description of the Project 2010 hotfix package (Project-x-none.msp): June 26, 2012</span></b><br />
<a href="http://support.microsoft.com/kb/2598351"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2598351</span></strong></a><br />
<span style="font-family: Georgia, "Times New Roman", serif;">More information on deploying the Cumulative Update:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">The article below provides information on how to deploy the Project Server Cumulative Update.</span><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Updates for Project Server 2010</span></b><br />
<a href="http://technet.microsoft.com/en-us/projectserver/gg176680.aspx"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://technet.microsoft.com/en-us/projectserver/gg176680.aspx</span></strong></a><br />
<span style="font-family: Georgia, "Times New Roman", serif;">As Project Server 2010 is now based on SharePoint Server 2010 we strongly recommend that you install the Project Server 2010 Server Rollup Package as there are a large number of individual server packages for SharePoint Server. The Project Server 2010 Server Rollup Package contains all the patches released in this Cumulative Update for SharePoint Foundation Server 2010, SharePoint Server 2010 and Project Server 2010.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">For those accustomed to Project Server 2007 Cumulative Updates, you should note that the MOSS Server Rollup Package does not contain the Project Server patches. As in Project Server 2007, the Server Rollup Packages are much larger but they will greatly simplify your Project Server patch deployment.</span><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Client Installation:</span></b><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Installation of the client patch is straightforward and is the same as it was in Project 2007. The instructions for installing the client patch are below.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">NOTE: Microsoft strongly recommends testing within a NON-Production environment prior to rollout.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">1. Download the hotfix from the link in the KB Article.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">2. Extract the patch package by running the .exe file that you downloaded.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">3. Run the extracted .exe file to apply the patch to your Project Professional/Standard client.</span><br />
<b><i><span style="font-family: Georgia, "Times New Roman", serif;">Project and Project Server 2007</span></i></b><br />
<span style="font-family: Georgia, "Times New Roman", serif;">This include a number of fixes, so Microsoft strongly recommends that you test this in a test environment based on your production environment before putting this fix live in production.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">You can read about the fixes included in the June CU from the following articles:</span><br />
<b><i><span style="font-family: Georgia, "Times New Roman", serif;">Server Rollup Packages:</span></i></b><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Description of the Windows SharePoint Services 3.0 cumulative update server hotfix package (WSS server-package): June 26, 2012 </span></b><br />
<a href="http://support.microsoft.com/kb/2687257"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2687257</span></strong></a><br />
<strong><span style="font-family: Georgia, "Times New Roman", serif;">Description of the SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): June 26, 2012</span></strong><br />
<a href="http://support.microsoft.com/kb/2687256"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2687256</span></strong></a><br />
<i><strong><span style="font-family: Georgia, "Times New Roman", serif;">Individual Product Packages:</span></strong></i><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Description of the Windows SharePoint Services 3.0 hotfix package (Sts-x-none.msp): June 26, 2012</span></b><br />
<a href="http://support.microsoft.com/kb/2598389"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2598389</span></strong></a><br />
<strong><span style="font-family: Georgia, "Times New Roman", serif;">Description of the Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): June 26, 2012</span></strong><br />
<a href="http://support.microsoft.com/kb/2687258"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2687258</span></strong></a><br />
<strong><span style="font-family: Georgia, "Times New Roman", serif;">Description of the Project 2007 hotfix package (Project-x-none.msp): June 26, 2012</span></strong><br />
<a href="http://support.microsoft.com/kb/2687253"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2687253</span></strong></a><br />
<span style="font-family: Georgia, "Times New Roman", serif;">More information on deploying the Cumulative Update:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">The article below provides information on how to deploy the Project Server Cumulative Update.</span><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Deploy cumulative updates (Project Server 2007) </span></b><br />
<a href="http://technet.microsoft.com/en-us/library/dd239177.aspx"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://technet.microsoft.com/en-us/library/dd239177.aspx</span></strong></a><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Server Pack 3 for Project and Project Server 2007 has been released. While not required for the June CU, we strongly recommend that you install it as it contains a number of patches to improve performance and reliability. The following blog goes into more detail about SP3.</span><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Office 2007 and SharePoint 2007 Service Pack 3 Availability</span></b><br />
<a href="http://blogs.technet.com/b/office_sustained_engineering/archive/2011/10/25/office-2007-and-sharepoint-2007-service-pack-3-availability.aspx"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://blogs.technet.com/b/office_sustained_engineering/archive/2011/10/25/office-2007-and-sharepoint-2007-service-pack-3-availability.aspx</span></strong></a><br />
<span style="font-family: Georgia, "Times New Roman", serif;">SP3 may be optional, however, Service Pack 2 for both WSS and Office Servers 2007 are required for this Cumulative Update. The KB articles below provide information on how to download and install SP2 if you have not already done so.</span><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Description of Windows SharePoint Services 3.0 SP2 and of Windows SharePoint Services 3.0 Language Pack SP2</span></b><br />
<a href="http://support.microsoft.com/kb/953338"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/953338</span></strong></a><br />
<strong><span style="font-family: Georgia, "Times New Roman", serif;">Description of 2007 Microsoft Office servers Service Pack 2 and of 2007 Microsoft Office servers Language Pack Service Pack 2</span></strong><br />
<a href="http://support.microsoft.com/kb/953334"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/953334</span></strong></a><br />
<span style="font-family: Georgia, "Times New Roman", serif;">The Server CU is released in two different versions. The first version is in Individual Packages specific to a particular product like WSS and Project Server. These are smaller downloads but they do not include language packs or patches for other products so patches for those products would have to be downloaded and installed separately.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">The second version is the Server Rollup Packages. This is a set of two rollup packages which contains all the fixes for WSS, Project Server and MOSS. These packages should be used when MOSS is part of the deployment and/or you have language packs installed. The Server Rollup Packages are much larger but they will greatly simplify MOSS patch deployment.</span><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Client Installation:</span></b><br />
<span style="font-family: Georgia, "Times New Roman", serif;">In order to install this hotfix, you will need to have Microsoft Project 2007 SP2 installed on the client.</span><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;">Description of Office Project 2007 Service Pack 2 (SP2) and of Office Project Language Pack 2007 Service Pack 2 (SP2)</span></b><br />
<a href="http://support.microsoft.com/kb/953326"><strong><span style="color: #0066dd; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/953326</span></strong></a><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Once we know that SP2 is installed, you will install the hotfix by performing the following steps:</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">NOTE: Microsoft strongly recommends testing within a NON-Production environment prior to rollout.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">1. Download the hotfix from either the KB Article.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">2. Extract the patch package by running the .exe file that you downloaded.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">3. Run the extracted .exe file to apply the patch to your Project Professional/Standard SP1 client.</span><br />
<span style="font-family: Georgia, "Times New Roman", serif;">Ref: <a href="http://blogs.technet.com/b/projectadministration/archive/2012/06/29/microsoft-project-server-and-sharepoint-server-2007-and-2010-june-2012-cu-announcement.aspx">http://blogs.technet.com/b/projectadministration/archive/2012/06/29/microsoft-project-server-and-sharepoint-server-2007-and-2010-june-2012-cu-announcement.aspx</a></span></div>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com4tag:blogger.com,1999:blog-874620074699269403.post-36598952036879447392012-06-29T03:14:00.001-07:002012-06-29T03:14:12.102-07:00Project Server 2010 : bug with deliverables<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpCKk-c6sqjDhS_t9NL0z6xNCh45UUYu9-7TVkKiqiGwdyoL99tMdXVRcvGkeyYix66vdUQXoBWF3e-4n12un5Qw43mld3aXZgPEid43Zb1zX2QrzoINAMontrOTJY43lYVd0gwPtpJj2_/s1600/7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="191" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpCKk-c6sqjDhS_t9NL0z6xNCh45UUYu9-7TVkKiqiGwdyoL99tMdXVRcvGkeyYix66vdUQXoBWF3e-4n12un5Qw43mld3aXZgPEid43Zb1zX2QrzoINAMontrOTJY43lYVd0gwPtpJj2_/s320/7.jpg" vca="true" width="320" /></a></div>
<span style="font-family: Georgia, "Times New Roman", serif; font-size: x-small;">if you create a new deliverable from Project site (site teamplate is customized..) using the grid row option (you can enter the deliverable name, start & finish), No deletion/update of columns in deviverables but other lists are custiomized. Once deliverable is crated a small message shows "Server is processing the changes to this row". (First screenshot) ANother way to create a new deliverable using the "New Item" form. so I created one more using this option. (Second screenshot) Now, I have two deliverables (D1 & D2) . When I open the MS project, I can see only one (D1) which is created via adding record using row option.(see the last screenshot). So Issue seems to be with the New Item form which doesn't sync the data to server. Looks liks a bug to me.</span></div>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com1tag:blogger.com,1999:blog-874620074699269403.post-70922244866060111072011-09-08T22:02:00.000-07:002011-09-08T22:02:48.372-07:00Project Server 2010 cumulative update package August 30, 2011<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3;">
<span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">Hello EPM Guys,<br /><br />Got the Information from MS Support abou the August 2011 CU for Project Server 2010.<br />Please visist the below link for Project Server 2010:<br /><a href="http://support.microsoft.com/kb/2553047">http://support.microsoft.com/kb/2553047</a></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3;">
<span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">Issues that this hotfix package fixes</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt;">
<span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><script type="text/javascript">
loadTOCNode(2, 'resolution');
</script><span style="mso-bidi-font-weight: bold;">This cumulative update package resolves the issues that are described in the following Microsoft Knowledge Base (KB) articles:</span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553031"><span style="color: blue; mso-bidi-font-weight: bold;">2553031</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553031/ ) Description of the SharePoint Foundation 2010 hotfix package (sts-x-none.msp): August 30, 2011 </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553037"><span style="color: blue; mso-bidi-font-weight: bold;">2553037</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553037/ ) Description of the SharePoint Server 2010 hotfix package (Osrchwfe-x-none.msp): August 30, 2011 </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553038"><span style="color: blue; mso-bidi-font-weight: bold;">2553038</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553038/ ) Description of the SharePoint Server 2010 hotfix package (Dlc-x-none.msp): August 30, 2011 </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553042"><span style="color: blue; mso-bidi-font-weight: bold;">2553042</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553042/ ) Description of the SharePoint Server 2010 hotfix package (Ifswfe-x-none.msp): August 30, 2011 </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553045"><span style="color: blue; mso-bidi-font-weight: bold;">2553045</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553045/ ) Description of the PerformancePoint Services for SharePoint Server 2010 hotfix package (Ppsmawfe-x-none.msp, Ppsmamui-xx-xx.msp): August 30, 2011 </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553046"><span style="color: blue; mso-bidi-font-weight: bold;">2553046</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553046/ ) Description of the SharePoint Server 2010 hotfix package (Wasrvwfe-x-none.msp):August 30, 2011 </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553047"><span style="color: blue; mso-bidi-font-weight: bold;">2553047</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553047/ ) Description of the Project Server 2010 hotfix package (Pjsrvwfe-x-none.msp): August 30, 2011 </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553048"><span style="color: blue; mso-bidi-font-weight: bold;">2553048</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553048/ ) Description of the SharePoint Server 2010 cumulative update package (SharePoint server-package): August 30, 2011 </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553050"><span style="color: blue; mso-bidi-font-weight: bold;">2553050</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553050/ ) Description of the SharePoint Foundation 2010 cumulative update package (SharePoint Foundation server-package): August 30, 2011 </span></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt 48.5pt; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -0.25in;">
<span style="font-family: Symbol; font-size: 10pt; mso-bidi-font-family: Symbol; mso-bidi-font-size: 11.0pt; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7pt "Times New Roman";"> </span></span></span><span style="font-family: "Trebuchet MS", "sans-serif"; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><a href="http://www.blogger.com/kb/2553117"><span style="color: blue; mso-bidi-font-weight: bold;">2553117</span></a><span style="mso-bidi-font-weight: bold;"> (http://support.microsoft.com/kb/2553117/ ) Description of the SharePoint Foundation 2010 hotfix package (Wssmui-xx-xx.msp): August 30, 2011 </span></span></div>
</div>
Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com1tag:blogger.com,1999:blog-874620074699269403.post-22885390083509311972011-09-08T21:57:00.000-07:002011-09-08T21:57:41.759-07:00Microsoft Project Server and SharePoint 2007 and 2010 August CU 2011<div dir="ltr" style="text-align: left;" trbidi="on">
<h3>
<span size="3"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif; font-size: small;">August 2011 CU for Microsoft Project and Project Server 2010</span></span></h3>
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Server Rollup Package(Recommended):</span></i></b><br />
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Description of the SharePoint Server 2010 and Project Server 2010 Cumulative Update Server Hotfix Package (MOSS server-package, Project server-package): August 30, 2011 </span></i></b><br />
<a href="http://support.microsoft.com/kb/2553049"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2553049</span></a><br />
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Individual Project Server Package:</span></i></b><br />
<i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Only required if you do not install the Server Rollup. </span></i><br />
<b><span style="font-family: Georgia, "Times New Roman", serif;"><span style="color: #073763;">Description of the Project Server 2010 hotfix package (pjsrvwfe-x-none.msp): <i>August 30, 2011</i></span></span></b><br />
<a href="http://support.microsoft.com/kb/2553047"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2553047</span></a><br />
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Project Client Package:</span></i></b><br />
<b><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Description of the Project 2010 hotfix package (project-x-none.msp): <i>August 30, 2011</i> </span></b><br />
<a href="http://support.microsoft.com/kb/2584056"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2584056</span></a><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">More information on deploying the Cumulative Update:</span><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">The article below provides information on how to deploy the Project Server Cumulative Update.</span><br />
<b><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Updates for Project Server 2010</span></b><br />
<a href="http://technet.microsoft.com/en-us/projectserver/gg176680.aspx"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://technet.microsoft.com/en-us/projectserver/gg176680.aspx</span></a><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">As Project Server 2010 is now based on SharePoint Server 2010 we strongly recommend that you install the Project Server 2010 Server Rollup Package as there are a large number of individual server packages for SharePoint Server. The Project Server 2010 Server Rollup Package contains all the patches released in this Cumulative Update for SharePoint Foundation Server 2010, SharePoint Server 2010 and Project Server 2010.</span><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">For those accustomed to Project Server 2007 Cumulative Updates, you should note that the MOSS Server Rollup Package does not contain the Project Server patches. You will need to make sure that you install the MOSS + Project Server Rollup Package (the link is provided below). As in Project Server 2007, the Server Rollup Packages are much larger but they will greatly simplify your Project Server patch deployment.</span><br />
<b><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Client Installation:</span></b><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Installation of the client patch is straightforward and is the same as it was in Project 2007. The instructions for installing the client patch are below.</span><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">NOTE: Microsoft strongly recommends testing within a NON-Production environment prior to rollout.</span><br />
<ol>
<li><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Download the hotfix from the link in the KB Article.</span></li>
<li><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Extract the patch package by running the .exe file that you downloaded.</span></li>
<li><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Run the extracted .exe file to apply the patch to your Project Professional/Standard client.</span></li>
</ol>
<h3>
<span size="4"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif; font-size: small;">August 2011 CU for Microsoft Office Project and Project Server 2007</span></span></h3>
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Server Rollup Packages:</span></i></b><br />
<span style="font-family: Georgia, "Times New Roman", serif;"><span style="color: #073763;"><b><i>Description of the Windows SharePoint Services 3.0 cumulative update package (WSS server-package): August 30, 2011</i></b><b> </b></span></span><br />
<a href="http://support.microsoft.com/kb/2553022"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2553022</span></a><br />
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Description of the Office SharePoint Server 2007 cumulative update package (MOSS server-package): August 30, 2011 </span></i></b><br />
<a href="http://support.microsoft.com/kb/2553020"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2553020</span></a><br />
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Individual Product Packages:</span></i></b><br />
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Description of the Office SharePoint Server 2007 hotfix package (sts-x-none.msp): August 30, 2011</span></i></b><br />
<a href="http://support.microsoft.com/kb/2553019"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2553019</span></a><br />
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Description of the Office Project Server 2007 hotfix package (pjsrvapp-x-none.msp, pjsrvwfe-x-none.msp): August 30, 2011</span></i></b><br />
<a href="http://support.microsoft.com/kb/2553024"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2553024</span></a><br />
<b><i><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Description of the Office Project 2007 hotfix package (project-x-none.msp):August 30, 2011</span></i></b><br />
<a href="http://support.microsoft.com/kb/2553105"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/2553105</span></a><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">More information on deploying the Cumulative Update:</span><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">The article below provides information on how to deploy the Project Server Cumulative Update.</span><br />
<b><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Deploy cumulative updates (Project Server 2007) </span></b><br />
<a href="http://technet.microsoft.com/en-us/library/dd239177.aspx"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://technet.microsoft.com/en-us/library/dd239177.aspx</span></a><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Service Pack 2 for both WSS and Office Servers 2007 are required for this Cumulative Update. The KB articles below provide information on how to download and install SP2 if you have not already done so.</span><br />
<b><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Description of Windows SharePoint Services 3.0 SP2 and of Windows SharePoint Services 3.0 Language Pack SP2</span></b><br />
<a href="http://support.microsoft.com/kb/953338"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/953338</span></a><br />
<b><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Description of 2007 Microsoft Office servers Service Pack 2 and of 2007 Microsoft Office servers Language Pack Service Pack 2</span></b><br />
<a href="http://support.microsoft.com/kb/953334"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/953334</span></a><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">The Server CU is released in two different versions. The first version is in Individual Packages specific to a particular product like WSS and Project Server. These are smaller downloads but they do not include language packs or patches for other products so patches for those products would have to be downloaded and installed separately.</span><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">The second version is the Server Rollup Packages. This is a set of two rollup packages which contains all the fixes for WSS, Project Server and MOSS. These packages should be used when MOSS is part of the deployment and/or you have language packs installed. The Server Rollup Packages are much larger but they will greatly simplify MOSS patch deployment.</span><br />
<b><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Client Installation:</span></b><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">In order to install this hotfix, you will need to have Microsoft Project 2007 SP2 installed on the client.</span><br />
<b><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Description of Office Project 2007 Service Pack 2 (SP2) and of Office Project Language Pack 2007 Service Pack 2 (SP2)</span></b><br />
<a href="http://support.microsoft.com/kb/953326"><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">http://support.microsoft.com/kb/953326</span></a><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Once we know that SP2 is installed, you will install the hotfix by performing the following steps:</span><br />
<span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">NOTE: Microsoft strongly recommends testing within a NON-Production environment prior to rollout.</span><br />
<ol>
<li><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Download the hotfix from either the KB Article or by using the information at the end of this email.</span></li>
<li><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Extract the patch package by running the .exe file that you downloaded.</span></li>
<li><span style="color: #073763; font-family: Georgia, "Times New Roman", serif;">Run the extracted .exe file to apply the patch to your Project Professional/Standard SP1 client.</span></li>
</ol>
</div>
Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com3tag:blogger.com,1999:blog-874620074699269403.post-3311010734003623512011-09-05T10:32:00.000-07:002011-09-08T22:03:44.898-07:00Microsoft Community Contributor Award 2011<div dir="ltr" style="text-align: left;" trbidi="on">
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif; font-size: x-small;"></span><br />
<div class="separator" style="clear: both; text-align: left;">
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif;">July 29th 2011- Friday</span></div>
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif;">Hello EPM folks,</span><br />
<div>
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif;"><br /></span></div>
<div>
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif;">It was a Friday which as usual starts from Client calls & I don't get the time to check my personal emails but on this day, i started my day with my gmail account & checking my emails , full of forum reply & few from others. I noticed an email from "support@<span class="Apple-style-span" style="background-color: white; color: #00681c; font-weight: bold;">microsoftcommunitycontributor</span>" & subject was "Your online community contributions have been recognized by Microsoft".<br />_____________________________________________________________________________________<br /><span class="Apple-style-span" style="background-color: white; font-family: Calibri;">Dear Amit,<br /><br />Congratulations! We’re pleased to inform you that your contributions to Microsoft online technical communities have been recognized with the Microsoft Community Contributor Award.<br /><br />The Microsoft Community Contributor Award is reserved for participants who have made notable contributions in Microsoft online community forums such as TechNet, MSDN and Answers. The value of these resources is greatly enhanced by participants like you, who voluntarily contribute your time and energy to improve the online community experience for others. ..................................................</span></span></div>
<div>
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif;"><span class="Apple-style-span" style="background-color: white; font-family: Calibri;">_____________________________________________________________________________________________________</span></span></div>
<div>
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif;"><span class="Apple-style-span" style="background-color: white; font-family: Calibri;"><br /></span></span></div>
<div>
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif;"><span class="Apple-style-span" style="background-color: white;">Thanks everyone for motivating me to contribute my 2 cents to EPM World.</span></span></div>
<div>
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif;"><span class="Apple-style-span" style="background-color: white; font-family: Calibri;"><br /></span></span></div>
<div>
<span class="Apple-style-span" style="font-family: "Trebuchet MS", sans-serif; font-size: x-small;"><span class="Apple-style-span" style="background-color: white; font-family: Calibri; font-size: 13px;"><br /></span></span></div>
</div>
Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-15366650035644255442011-08-19T00:57:00.000-07:002011-08-19T00:57:15.097-07:00This workbook cannot be opened because it is not stored in an Excel Services Application trusted location<div dir="ltr" style="text-align: left;" trbidi="on"><span closure_uid_32509p="179" style="font-family: Verdana, sans-serif;">When you are using the Office Web apps in SharePoint 2010 then you may come across this error…</span><br />
<div closure_uid_32509p="133"><em closure_uid_32509p="125"><span closure_uid_32509p="157" style="color: red; font-family: Verdana, sans-serif;">“This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.</span></em></div><div closure_uid_32509p="158"><em><span style="color: red; font-family: Verdana, sans-serif;">To create an Excel Services Application trusted location, contact your system administrator.”</span></em></div><a href="http://www.sharepointedutech.com/wp-content/uploads/2010/06/0Capture.png"><span style="font-family: Verdana, sans-serif;"><img alt="" class="alignnone size-full wp-image-534" height="268" src="http://www.sharepointedutech.com/wp-content/uploads/2010/06/0Capture.png" title="0Capture" width="418" /></span></a><br />
<span style="font-family: Verdana, sans-serif;">If you happen to be the system administrator and you’ve turned to <span style="text-decoration: line-through;">google</span> <span style="text-decoration: line-through;">bing</span> google to find the answer hopefully this blog post will help you out!</span><br />
<span style="font-family: Verdana, sans-serif;">I believe this error is most likely if you are going over SSL as the default trusted location is just http://</span><br />
<span style="font-family: Verdana, sans-serif;">Jump into central admin (please ignore my heath analyzer!) and goto Manage service applications.</span><a href="http://www.sharepointedutech.com/wp-content/uploads/2010/06/1Capture.png"><span style="font-family: Verdana, sans-serif;"><img alt="" class="alignnone size-full wp-image-535" src="http://www.sharepointedutech.com/wp-content/uploads/2010/06/1Capture.png" title="1Capture" /></span></a><br />
<span style="font-family: Verdana, sans-serif;">Click on Excel services Application.</span><br />
<a href="http://www.sharepointedutech.com/wp-content/uploads/2010/06/2Capture.png"><span style="font-family: Verdana, sans-serif;"><img alt="" class="alignnone size-full wp-image-536" src="http://www.sharepointedutech.com/wp-content/uploads/2010/06/2Capture.png" title="2Capture" /></span></a><br />
<span style="font-family: Verdana, sans-serif;">Then click on “Trusted file locations”</span><br />
<a href="http://www.sharepointedutech.com/wp-content/uploads/2010/06/3Capture.png"><span style="font-family: Verdana, sans-serif;"><img alt="" class="alignnone size-full wp-image-537" src="http://www.sharepointedutech.com/wp-content/uploads/2010/06/3Capture.png" title="3Capture" /></span></a><br />
<span style="font-family: Verdana, sans-serif;">You can see that http:// is already there, so you could just add https:// or put in a url to a specific location</span><br />
<a href="http://www.sharepointedutech.com/wp-content/uploads/2010/06/4Capture.png"><span style="font-family: Verdana, sans-serif;"><img alt="" class="alignnone size-full wp-image-538" src="http://www.sharepointedutech.com/wp-content/uploads/2010/06/4Capture.png" title="4Capture" /></span></a><br />
<span style="font-family: Verdana, sans-serif;">Fill in the boxes, I also ticked the trust children box.</span><br />
<a href="http://www.sharepointedutech.com/wp-content/uploads/2010/06/5Capture.png"><span style="font-family: Verdana, sans-serif;"><img alt="" class="alignnone size-full wp-image-539" src="http://www.sharepointedutech.com/wp-content/uploads/2010/06/5Capture.png" title="5Capture" /></span></a><br />
<div closure_uid_32509p="134"><br />
</div><div closure_uid_32509p="134"><span style="font-family: Verdana, sans-serif;">Now, You should be able to open the Excel workbook from your sample excel report in BI center of Project server.</span></div></div>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-49463063694054025222011-06-21T05:03:00.000-07:002011-06-21T05:03:06.618-07:00Project Server 2010- Demand Management Useful links<div dir="ltr" style="text-align: left;" trbidi="on"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; border-collapse: separate; color: black; font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-style-span" style="border-collapse: collapse; color: #333333; font-family: "Segoe UI", "Lucida Grande", Verdana, Arial, Helvetica, sans-serif; line-height: 16px;"><span style="font-family: "Trebuchet MS", sans-serif;"></span></span></span><br />
<div style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; margin: 0px 0px 12px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><strong><u><span style="font-family: "Trebuchet MS", sans-serif;">Read technical articles about Demand Management in Project Server 2010:</span></u></strong></div><ul class="bulletedlist" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; line-height: 19px; list-style-type: disc; margin: 12px 0px 12px 24px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://technet.microsoft.com/library/ff686781(office.14).aspx" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Demand Management in Project Server 2010 (white paper)"><span style="font-family: "Trebuchet MS", sans-serif;">Demand Management in Project Server 2010 (white paper)</span></a></li>
<li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://technet.microsoft.com/library/cc197644(office.14).aspx" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Determine project management requirements (see Using Project Server 2010 for Demand Management section)"><span style="font-family: "Trebuchet MS", sans-serif;">Determine project management requirements (see Using Project Server 2010 for Demand Management section)</span></a></li>
<li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://technet.microsoft.com/library/gg597674(office.14).aspx" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Create a custom enterprise project type (Project Server 2010)"><span style="font-family: "Trebuchet MS", sans-serif;">Create a custom enterprise project type</span></a></li>
<li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://technet.microsoft.com/library/gg557445(office.14).aspx" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Define the phases and stages of a project life cycle (Project Server 2010)"><span style="font-family: "Trebuchet MS", sans-serif;">Define the phases and stages of a project life cycle</span></a></li>
</ul><div style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; margin: 0px 0px 12px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><strong><u><span style="font-family: "Trebuchet MS", sans-serif;">View the following webcasts to learn more:</span></u></strong></div><ul class="bulletedlist" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; line-height: 19px; list-style-type: disc; margin: 12px 0px 12px 24px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://www.microsoft.com/events/series/epm.aspx?tab=Webcasts&seriesid=51&webcastid=13490" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Project Server 2010 Demand Management — Overview (level 200, part 1 of 4)"><span style="font-family: "Trebuchet MS", sans-serif;">Project Server 2010 Demand Management — Overview (level 200, part 1 of 4)</span></a></li>
<li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://www.microsoft.com/events/series/epm.aspx?tab=Webcasts&seriesid=51&webcastid=13493" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Project Server 2010 Demand Management — Create and select phases (level 200, part 2 of 4)"><span style="font-family: "Trebuchet MS", sans-serif;">Project Server 2010 Demand Management — Create and select phases (level 200, part 2 of 4)</span></a></li>
<li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://www.microsoft.com/events/series/epm.aspx?tab=Webcasts&seriesid=51&webcastid=13491" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Project Server 2010 Demand Management — Plan, manage, and close phases (level 200, part 3 of 4)"><span style="font-family: "Trebuchet MS", sans-serif;">Project Server 2010 Demand Management — Plan, manage, and close phases (level 200, part 3 of 4)</span></a></li>
<li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://www.microsoft.com/events/series/epm.aspx?tab=Webcasts&seriesid=51&webcastid=13492" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Project Server 2010 Demand Management — Test the theory and review (level 200, part 4 of 4)"><span style="font-family: "Trebuchet MS", sans-serif;">Project Server 2010 Demand Management — Test the theory and review (level 200, part 4 of 4)</span></a></li>
<li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://www.microsoft.com/events/series/epm.aspx?tab=Webcasts&seriesid=51&webcastid=13332" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Project 2010 Workflow Deep Dive — PWA and administrator experience (level 200, part 1 of 2)"><span style="font-family: "Trebuchet MS", sans-serif;">Project 2010 Workflow Deep Dive — PWA and administrator experience (level 200, part 1 of 2)</span></a></li>
<li style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://www.microsoft.com/events/series/epm.aspx?tab=Webcasts&seriesid=51&webcastid=13041" style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; color: #0066dd; cursor: pointer; font-family: inherit; margin: 0px; outline-width: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-decoration: none;" title="Managing the project life cycle with Demand Management (level 200)"><span style="font-family: "Trebuchet MS", sans-serif;">Managing the project life cycle with Demand Management (level 200)</span></a></li>
</ul><div style="border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; font-family: inherit; list-style-image: url(http://i3.technet.microsoft.com/Areas/Sto/Content/Theming/images/bullet.gif); margin: 0px; outline-width: 0px; padding-bottom: 3px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><br />
</div></div>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-26135676270782434172011-06-21T04:53:00.000-07:002011-06-21T04:55:56.391-07:00Project Server 2010 - Demand Management- Showcase - Nice video<div dir="ltr" style="text-align: left;" trbidi="on"><div style="height: 360px; width: 640px;"><i><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Ref:<span class="Apple-style-span" style="color: blue;"> </span></span><a href="http://www.microsoft.com/showcase/en/us/details/34f2e816-bec5-4a5a-a7f8-b356dac292fc"><span class="Apple-style-span" style="color: blue;">http://www.microsoft.com/showcase/en/us/details/34f2e816-bec5-4a5a-a7f8-b356dac292fc</span></a></span></i><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Project Server has a new infrastructure for building out a demand management process. This session covers the capabilities built in and how the workflow can be customized and extended to meet your business needs. This session will go over the following concepts: Developer experience in creating a Workflow; Deployment story for Project workflows; Administrator experience in creating Workflow Controlled Enterprise Project Types:</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><object data="data:application/x-silverlight-2," height="360" type="application/x-silverlight-2" width="640"><param name="source" value="http://www.microsoft.com/showcase/silverlight/player/1/player-en.xap" /><param name="initParams" value="Culture=en-US,Uuid=31184ff3-f797-4647-985f-4ccd873d71fb,Autoplay=False,ShowMarketingOverlay=true,MiscControls=FullScreen;Detached,ShowMenu=True,Tabs=Embed;Email;Share;Info,ShowCaption=false,AgeGate=True,AgeGateDayMonthYearOrder=MDY,VideoUrl=http://www.microsoft.com/showcase/en/us/details/31184ff3-f797-4647-985f-4ccd873d71fb,Mode=Player" /><param name="enableHtmlAccess" value="true" /><param name="allowHtmlPopupwindow" value="true" /><param name="background" value="#FF000000" /><param name="minRuntimeVersion" value="4.0.50401.0" /><param name="autoUpgrade" value="true" /><div><a href="http://go.microsoft.com/fwlink/?LinkID=149156" style="text-decoration: none;" onmousedown="javascript:new Image().src = 'http://m.webtrends.com/dcsygm2gb10000kf9xm7kfvub_9p1t/dcs.gif?dcsdat=' + new Date().getTime() + '&dcssip=www.microsoft.com&dcsuri=' + window.location.href + '&WT.tz=-8&WT.bh=16&WT.ul=en-US&WT.cd=32&WT.jo=Yes&WT.ti=&WT.js=Yes&WT.jv=1.5&WT.fi=Yes&WT.fv=10.0&WT.sli=Not%20Installed&WT.slv=Version%20Unavailable&WT.dl=1&WT.seg_1=Not%20Logged%20In&WT.vt_f_a=2&WT.vt_f=2&WT.vt_nvr1=2&WT.vt_nvr2=2&WT.vt_nvr3=2&WT.vt_nvr4=2&vp_site=Embedded&wtEvtSrc=' + window.location.href + '&vp_sli=Embedded'"><img src="http://img.microsoft.com/showcase/Content/img/resx/en-US/installSL.gif" alt="Get Microsoft Silverlight" style="border-style: none"/></a></div><div style='margin-top: -80px; text-align: center;'><a style='text-align: center; color: #7db0d2; text-decoration: none; font-size: 80%; font-family: "Segoe UI", Segoe, Tahoma, Verdana, sans-serif;' href='mms://msnvidweb.wmod.msecnd.net/a10026/e1/ft/share10/5a67/0/bc3e2f7f-f0d0-436d-a42c-7909cdf9f479.wmv'>View this video as a WMV</a></div><noscript><div><img alt="DCSIMG" id="DCSIMG" width="1" height="1" src="http://m.webtrends.com/dcsygm2gb10000kf9xm7kfvub_9p1t/njs.gif?dcsuri=/nojavascript&WT.js=No"/></div></noscript></object></span></div><script type="text/javascript">
document.write("<script type='text/javascript' src='" + (window.location.protocol) + "//c.microsoft.com/ms.js'><\/script>");
</script></div>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-14193749124775539752011-06-20T04:38:00.000-07:002011-08-18T21:50:53.041-07:00Project Server 2010: Task level formula based Text Custom field<div dir="ltr" style="text-align: left;" trbidi="on"><br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: "Trebuchet MS", sans-serif;">Hello EPM Users/Techies,<br />
<br />
Today I was browsing the </span><a href="http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/threads"><span style="font-family: "Trebuchet MS", sans-serif;">Project Server forum</span></a><span style="font-family: "Trebuchet MS", sans-serif;"> & found a very easy but interesting question about displaying the task calender information in report which pulls the data from Project Server Reporting database. Since this information is not available in reporting database so thought a workaround & get the information.</span><br />
<br />
<span style="font-family: "Trebuchet MS", sans-serif;">1. Tried creating a TAsk level text custom field using formula:</span><br />
<br />
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpFxK0Lk0z7yrBc4wNFUnaS8ZZPQTrx0H7ToO1EjjyeQ2H_EJVp8D0AaqwsXp0URS8Zwa4aPp7vJMPtBpgVA1HQXWrz32Ym4sw8ZmEoD8ZkoqmdgwZtU2QuMOyjsyBTDBnlRlMdl6cbuH8/s1600/1.png" imageanchor="1" style="clear: left; cssfloat: left; float: left; height: 174px; margin-bottom: 1em; margin-right: 1em; width: 551px;"><span style="font-family: "Trebuchet MS", sans-serif;"><img border="0" height="314" i$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpFxK0Lk0z7yrBc4wNFUnaS8ZZPQTrx0H7ToO1EjjyeQ2H_EJVp8D0AaqwsXp0URS8Zwa4aPp7vJMPtBpgVA1HQXWrz32Ym4sw8ZmEoD8ZkoqmdgwZtU2QuMOyjsyBTDBnlRlMdl6cbuH8/s640/1.png" width="640" /></span></a></div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><span style="font-family: "Trebuchet MS", sans-serif;">2. In the formula section, picked up the field Text> Task Calendar</span></div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjgDt1CUmi68s-KKfWWYeIoaDOjcUdKj2zJ1XbmW_whRj9oFJDgZtBWKkTRwjrOVoqxNdaBpk88Ov20nUK58y8w8KpEdzcGW4q1sbqgx4v95Jcu4ItiMRVd8eDYrYnoFt_p2u8-w8wOje_/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="344" i$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjgDt1CUmi68s-KKfWWYeIoaDOjcUdKj2zJ1XbmW_whRj9oFJDgZtBWKkTRwjrOVoqxNdaBpk88Ov20nUK58y8w8KpEdzcGW4q1sbqgx4v95Jcu4ItiMRVd8eDYrYnoFt_p2u8-w8wOje_/s640/2.png" width="640" /></a></div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><br />
</div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><br />
</div><br />
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><span style="font-family: Trebuchet MS;">3. Added Task Calendar & when I tried to save that, got the error:</span></div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_9oq85pj5q9dj9ciu2K1AEb2oEy5PYW2FpvhqakNYDivqhelLn4BzfGoNdNIO9EpUpNqrBvhdSgzLtz7mh3Bky9H1wnvZ_kKqSz7MG0YUn64QYAyfKq_lVvE_R8UPDdh9K9uvHiGbRaCD/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="299" i$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_9oq85pj5q9dj9ciu2K1AEb2oEy5PYW2FpvhqakNYDivqhelLn4BzfGoNdNIO9EpUpNqrBvhdSgzLtz7mh3Bky9H1wnvZ_kKqSz7MG0YUn64QYAyfKq_lVvE_R8UPDdh9K9uvHiGbRaCD/s640/3.png" width="640" /></a></div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><br />
</div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><br />
</div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"></div><table cellpadding="0" cellspacing="0" style="width: 100%;"><tbody>
<tr><td style="width: 100%;"><span class="ErrorMsgBox" id="idPageErrorContainer"><span style="color: red;"><span style="font-family: Arial, Helvetica, sans-serif;"><span id="idPageErrorInfoHeader">The custom field could not be saved due to the following reason(s):</span> </span></span></span><br />
<ul class="ErrorMsgBox" id="ctl00_ctl00_PlaceHolderMain_idPageErrorInfo"><li><span style="color: red; font-family: Arial, Helvetica, sans-serif;">This formula contains references to one or more fields that do not exist in the system. Correct the formula and try again.</span></li>
</ul></td></tr>
</tbody></table><br />
<div class="separator" style="clear: both; text-align: center;"></div><br />
<div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH5O5Z8QRGWDdpwGpKzFsu0TcR3IC5yV_nlw5hL_QslkKRNygXsegV3ncUWfgSY-txAmdWV_BChmgZ1c47wngMTJMUwDfZGFEyfvIX51SNrjj6BQGV9YbztCjIv1y-AhQyzT6n0ECF7X66/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="344" i$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH5O5Z8QRGWDdpwGpKzFsu0TcR3IC5yV_nlw5hL_QslkKRNygXsegV3ncUWfgSY-txAmdWV_BChmgZ1c47wngMTJMUwDfZGFEyfvIX51SNrjj6BQGV9YbztCjIv1y-AhQyzT6n0ECF7X66/s640/4.png" width="640" /></a></div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><br />
</div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><span style="font-family: Trebuchet MS;">4. Now, I thought to create the same field from project professional :<br />
- Open project professioanl & Connect to Server<br />
- Click on Project Tab</span></div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"><span style="font-family: Trebuchet MS;">- Click on Custom fields button on the ribbon<br />
- Select Task (radio button) & selected Text from the drop downlist of "Type"</span></div><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDg40lUtRfryC3pWt-dGsyjda4R1QrarxR-dX0HNdDnmokGjaT41q8qIkCBSRIgibau267reowSWR0vXuwf6gcoicqXGTRoUhyynUtpF2CZLCy-qUzZu8TYgRNl2siv0H-xNgQfgbh1Tku/s1600/5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="480" i$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDg40lUtRfryC3pWt-dGsyjda4R1QrarxR-dX0HNdDnmokGjaT41q8qIkCBSRIgibau267reowSWR0vXuwf6gcoicqXGTRoUhyynUtpF2CZLCy-qUzZu8TYgRNl2siv0H-xNgQfgbh1Tku/s640/5.png" width="640" /></a></div><br />
<br />
<span style="font-family: Trebuchet MS;">- Clicked on formula</span><br />
<div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiozsBdH4Gl0iRb5RPIhvzo6FgbPWbhvqo3ipVOkz5etkZvJ2CsWphu6XmViERyXwKe2PyK_wBAAzqDDen1NzqkQVHUQOVXeHoc8aqJLR28mjMoGBbB1joIVidwm3jtaLkJEj-QTvWQl7O5/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="354" i$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiozsBdH4Gl0iRb5RPIhvzo6FgbPWbhvqo3ipVOkz5etkZvJ2CsWphu6XmViERyXwKe2PyK_wBAAzqDDen1NzqkQVHUQOVXeHoc8aqJLR28mjMoGBbB1joIVidwm3jtaLkJEj-QTvWQl7O5/s640/6.png" width="640" /></a></div><br />
<span style="font-family: Trebuchet MS;">- Also, Clicked on Add field to Enterprise<br />
- <span style="font-family: "Trebuchet MS", sans-serif;">Created a plan & kept the TAsk level calender & added the TASK_CAL_CF column & I was able to see</span></span><span style="font-family: "Trebuchet MS", sans-serif;"> the calender applied to the task copied to Custom field.Published the Plan<br />
- Ran the below query, I was able to get the information in PS Reporting database</span><br />
<span style="font-family: "Trebuchet MS", sans-serif;">SELECT<br />
<span style="color: blue;"><span style="color: blue;"></span></span>[TaskUID]<span style="color: grey;"><span style="color: grey;">,</span></span>[TaskParentUID]<span style="color: grey;"><span style="color: grey;">,</span></span>[ProjectUID]<span style="color: grey;"><span style="color: grey;">,</span></span>[FixedCostAssignmentUID]<span style="color: grey;"><span style="color: grey;">,</span></span>[TaskName]<span style="color: grey;"><span style="color: grey;">,</span></span>[TASK_CAL_CF (Text1)]<span style="color: blue;"><span style="color: blue;">FROM</span></span> [ProjectServer_Reporting]<span style="color: grey;"><span style="color: grey;">.</span></span>[dbo]<span style="color: grey;"><span style="color: grey;">.</span></span>[MSP_EpmTask_UserView]</span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
</div>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com1tag:blogger.com,1999:blog-874620074699269403.post-13268369358041251952011-06-19T23:31:00.000-07:002011-06-20T04:08:09.919-07:00Project server 2007 life cycle & Support Information<div dir="ltr" style="text-align: left;" trbidi="on"><span class="Apple-style-span" style="border-collapse: collapse; font-family: Verdana, Arial, Helvetica, sans-serif;"></span><br />
<div class="wp TCon m1" id="C_5037" style="border-bottom-style: none; border-color: initial; border-left-style: none; border-right-style: none; border-top-style: none; border-width: initial; box-sizing: border-box; margin-bottom: 5px; margin-left: 0px; margin-right: 0px; margin-top: 5px; padding-bottom: 5px; padding-left: 0px; padding-right: 0px; padding-top: 5px;"><span class="Apple-style-span" style="color: #990000; font-family: 'Trebuchet MS', sans-serif; font-size: x-small;"></span><br />
<span class="Apple-style-span" style="color: #990000; font-family: 'Trebuchet MS', sans-serif; font-size: x-small;">Ref:<u><i> http://support.microsoft.com/lifecycle/?p1=11388</i></u></span><br />
<span class="Apple-style-span" style="color: #990000; font-family: 'Trebuchet MS', sans-serif; font-size: x-small;">Microsoft Support Life cycle</span><br />
<span class="Apple-style-span" style="color: #990000; font-family: 'Trebuchet MS', sans-serif; font-size: x-small;">Product support lifecycle information:</span><br />
</div><div class="lcr" style="box-sizing: border-box; width: 982px;"><div class="tableContainer" id="tableContainer" style="box-sizing: border-box; margin-bottom: 10px; width: 982px;"><table border="1" bordercolor="#a5b4da" cellpadding="0" cellspacing="0" class="results" id="results" style="border-collapse: collapse; box-sizing: border-box; empty-cells: show; width: 982px;"><thead style="box-sizing: border-box;">
<tr style="box-sizing: border-box;"><th class="pnColumn" style="background-color: #ecf0ff; box-sizing: border-box; color: blue; font-size: 10px; font-weight: bold; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px; text-align: left; width: 196px;"><a href="http://support.microsoft.com/lifecycle/?p1=11388#" style="box-sizing: border-box; color: #07679a; overflow-x: hidden; overflow-y: hidden; text-decoration: none;" title="Sort by Product Name">Products Released</a></th><th class="gaColumn" style="background-color: #ecf0ff; box-sizing: border-box; color: blue; font-size: 10px; font-weight: bold; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px; text-align: left; width: 98px;"><a href="http://support.microsoft.com/lifecycle/?p1=11388#" style="box-sizing: border-box; color: #07679a; overflow-x: hidden; overflow-y: hidden; text-decoration: none;" title="Sort by General Availability Date">General Availability Date</a></th><th class="msColumn" style="background-color: #ecf0ff; box-sizing: border-box; color: blue; font-size: 10px; font-weight: bold; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px; text-align: left; width: 98px;"><a href="http://support.microsoft.com/lifecycle/?p1=11388#" style="box-sizing: border-box; color: #07679a; overflow-x: hidden; overflow-y: hidden; text-decoration: none;" title="Sort by Mainstream Support Retirement Date">Mainstream Support End Date</a></th><th class="esColumn" style="background-color: #ecf0ff; box-sizing: border-box; color: blue; font-size: 10px; font-weight: bold; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px; text-align: left; width: 98px;"><a href="http://support.microsoft.com/lifecycle/?p1=11388#" style="box-sizing: border-box; color: #07679a; overflow-x: hidden; overflow-y: hidden; text-decoration: none;" title="Sort by Extended Support Retirement Date">Extended Support End Date</a></th><th class="spColumn" style="background-color: #ecf0ff; box-sizing: border-box; color: blue; font-size: 10px; font-weight: bold; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px; text-align: left; width: 98px;"><a href="http://support.microsoft.com/lifecycle/?p1=11388#" style="box-sizing: border-box; color: #07679a; overflow-x: hidden; overflow-y: hidden; text-decoration: none;" title="Sort by Service Pack Retirement Date">Service Pack Support End Date</a></th><th style="background-color: #ecf0ff; box-sizing: border-box; color: blue; cursor: default; font-size: 10px; font-weight: bold; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px; text-align: left;">Notes</th></tr>
</thead><tbody id="dataItems" style="box-sizing: border-box;">
<tr style="box-sizing: border-box;"><td class="pnColumn" id="pnColumn" style="box-sizing: border-box; font-size: 10px; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px; width: 196px;">Project Server 2007</td><td style="box-sizing: border-box; font-size: 10px; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px;">27-01-2007</td><td style="box-sizing: border-box; font-size: 10px; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px;">10-04-2012</td><td style="box-sizing: border-box; font-size: 10px; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px;">11-04-2017</td><td style="box-sizing: border-box; font-size: 10px; padding-bottom: 3px; padding-left: 3px; padding-right: 3px; padding-top: 3px;">13-01-2009</td></tr>
</tbody></table></div></div></div>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-78818984402790420132011-06-17T03:20:00.000-07:002011-06-17T03:22:22.444-07:00Update Project level Multiline Text Custom Fields<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: "Trebuchet MS", sans-serif;">What a beautilful weather & I was kinda enjoying but suddenly One of My coworker pinged me & asked me a question about the Project level custom fields (multiline Text) so while I explained him about the usage of this kind of field, thought to write down somthing which might help Project Server community :)</span><br />
<br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; border-collapse: separate; color: black; font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-style-span" style="font-family: "Segoe UI", Verdana, Arial; text-align: left;">Text custom fields can be multiline up to 4000 bytes, for use in project detail pages (PDPs) and with workflows for demand management in Project Web App. Multiline text custom fields are not usable in Project Professional. so I added a Project level Multiline text field in my PDP & now I wanted to update this field in a given project from my PSI program.<br />
<br />
Here is the code for the Console application :</span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; border-collapse: separate; color: black; font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-style-span" style="font-family: "Segoe UI", Verdana, Arial; text-align: left;">1. You will need to add project web service (ProjectWebSvc) web ref in the solution: <a href="http://servername/pwa/_vti_bin/PSI/Project.asmx?wsdl">http://servername/pwa/_vti_bin/PSI/Project.asmx?wsdl</a></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; border-collapse: separate; color: black; font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-style-span" style="font-family: "Segoe UI", Verdana, Arial; text-align: left;">2. Its very basic code, which has TEXT_VALUE update for a Multiline field</span></span><br />
_____________________________________________________________________<br />
<span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">using</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> System;</span></span><br />
<span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">using</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> System.Diagnostics;</span></span><br />
<span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">using</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> System.Net;</span></span><br />
<span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">using</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> System.Data;</span></span><br />
<span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">using</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> System.Text;</span></span><br />
<span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">using</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> Microsoft.Office.Project.Server.Library;</span></span><br />
<span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">using </span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">PSLibrary = Microsoft.Office.Project.Server.Library;</span></span><br />
<br />
<span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">namespace<br />
{</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">ReadProjectResourcePSI</span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">class</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">Program</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">{<br />
<br />
{</span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">static</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">void</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> Main(</span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">string</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">[] args)</span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">try</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">{<br />
UpdateProjectMultiplineTextCField();</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">}<br />
<br />
{<br />
<br />
<br />
}<br />
}<br />
<br />
<br />
{<br />
<span style="font-family: Consolas;"><span style="font-family: Consolas;">ProjectWebSvc.<br />
proj.UseDefaultCredentials = <br />
ProjectWebSvc.</span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">Project</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> proj = </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">new</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> ProjectWebSvc.</span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">Project</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">();</span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">true</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">;</span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">ProjectDataSet</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> pds = </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">null</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">;</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"></span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><br />
Guid</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> projectGuid = </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">new</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">Guid</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">(</span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"195D9230-4A41-438A-917F-FDB6B292F586"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">); //Project for which I want to update the Multiline text field</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><br />
<br />
pds = proj.ReadProjectEntities(projectGuid, 1 | 4 | 32, ProjectWebSvc.</span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">DataStoreEnum</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">.PublishedStore);</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><br />
{<br />
row.TEXT_VALUE = <br />
<br />
}</span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">foreach</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> (ProjectWebSvc.</span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">ProjectDataSet</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">.</span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">ProjectCustomFieldsRow</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> row </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">in</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> pds.ProjectCustomFields)</span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"TYPE your multiline text,TYPE your multiline text,TYPE your multiline text,TYPE your multiline textTYPE your multiline textTYPE your multiline text,TYPE your multiline text,TYPE your multiline text,TYPE your multiline textTYPE your multiline text,TYPE your multiline text,TYPE your multiline text"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">;</span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">Guid</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> sessionUId = </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">Guid</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">.NewGuid();</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">proj.CheckOutProject(projectGuid, sessionUId, </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">" "</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">);</span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">Guid</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> jobUId = </span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">Guid</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">.NewGuid();</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">proj.QueueUpdateProject(jobUId, sessionUId, pds, <br />
proj.QueuePublish(jobUId, projectGuid, <br />
jobUId = <br />
proj.QueueCheckInProject(jobUId, projectGuid, </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">false</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">);</span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">true</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">, </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">" "</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">);</span></span><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;"><span style="color: #2b91af; font-family: Consolas;">Guid</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">.NewGuid();</span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">false</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">, sessionUId, </span></span><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;"><span style="color: #a31515; font-family: Consolas;">"none"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;">);</span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> }<br />
<br />
}<br />
_____________________________________________________________________<br />
<br />
<strong><span style="font-family: Trebuchet MS;"><span style="font-family: Segoe UI;">Thanks to my coworker - Sumit Manchanda for initiating this :)</span></span></strong><br />
<span style="font-family: Trebuchet MS;"><span style="font-family: Segoe UI;">Happy coding :)</span></span></span></span></span></span></div>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com1tag:blogger.com,1999:blog-874620074699269403.post-69614407805241937072011-06-17T01:05:00.000-07:002011-06-17T02:10:07.508-07:00Project Server 2010: Enterprise Project Types<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: left;"><span class="Apple-style-span"><span style="font-family: Georgia, 'Times New Roman', serif; line-height: 16px;">Enterprise Project Types (EPTs) are project templates that represent various types of projects and non-project work within the portfolio. </span><span class="Apple-style-span" style="font-family: Georgia, 'Times New Roman', serif; line-height: 16px;">For example, you can create an Enterprise Project Type to represent a HR related software Maintenance/development project or a marketing campaign.<br />
An EPT is a combination of phases, stages, a single workflow, and Project Detail Pages. Each EPT represents a single project type. Normally, project types are aligned with individual departments, for example, marketing projects, IT projects, HR projects, and so forth. Using project types in Project 2010 now helps to categorize projects within the same organization that have a similar project life cycle</span></span></div><span style="font-family: Georgia, 'Times New Roman', serif;"><br />
</span><br />
<div style="line-height: 16px;"><span class="Apple-style-span" style="line-height: 15px;"><br />
<span style="font-family: Georgia, 'Times New Roman', serif;"></span></span><br />
<h3 class="subHeading" style="font-weight: 700; margin: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif; font-size: small;">To create a new enterprise project type</span></h3><span style="font-family: Georgia, 'Times New Roman', serif;"><br />
</span><br />
<div class="subSection"><span style="font-family: Georgia, 'Times New Roman', serif;">On the PWA home page, click <strong>Server Settings</strong>.</span></div><div class="subSection" style="margin-bottom: 3px; margin-left: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;"><br />
</span></div><div class="subSection" style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5619098707510063490" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYOM0AgTHdtCpOZ5CptqsRCXpjSXK8k3-m7OoNdEzBHQlocsKxQ5jTwQOP9jX5GvI3jS3UVCJUwwF_oFxDTU5YiMQmM9s0tW0p0e2_EJFeNwWQlb4IglMJ3lWePbUROGjKVJ-RrzwEZvi7/s320/1.png" style="cursor: hand; display: block; height: 172px; margin: 0px auto 10px; text-align: center; width: 320px;" /></span></div><ol class="ordered" style="line-height: 15px; list-style-type: decimal; margin-bottom: 15px;"><li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">Click <strong>New Enterprise Project Type</strong>. In the <strong>Name</strong> box, enter a name for the type (e.g HR_Project_EPT), and then provide a brief description in the <strong>Description</strong> box.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">Select a workflow from the <strong>Site Workflow Association</strong> list. Once you associate a site workflow with a project type and save the type, you cannot go back and update the type to use a different workflow.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">Select a project detail page from the <strong>New Project Page</strong> list.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">If you selected <strong>No Workflow</strong> from the <strong>Site Workflow Association</strong> list, select the project detail pages that you want to include in this project type from the <strong>Available Project Detail Pages</strong> box, and then click <strong>Add</strong> to move them to the box on the right.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">If the enterprise project type that you are creating is the one that all new projects should use by default, select the<strong>Use this as the default Enterprise Project Type during Project Creation</strong> check box.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">Click the button next to the <strong>Departments</strong> field to select the departments that you want to associate with this project type, if it is appropriate.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">If you want to associate an image with this project type, provide the URL for the image in the <strong>Type the URL</strong> box.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">In the <strong>Order</strong> section, choose whether you want this project type to appear at the end of the list of project types, or if you want to control its placement in the list.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">To include this type at the end of the list, select the <strong>Position this type at the end</strong> check box.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">To control the placement of this type in the list, clear the <strong>Position this type at the end</strong> check box, and then choose the type that you want to appear just before the type that you are creating from the <strong>Choose the type before which the current type should be positioned</strong> list.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">Select a template from the <strong>Project Plan Template</strong> list, if it is appropriate.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">Select a template from the <strong>Project Site Template</strong> list, if it is appropriate.</span></div></li>
<li style="margin-bottom: 3px; margin-left: 0px;"><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;">Click <strong>Save</strong> to save this enterprise project type to the server, thus making it available for new project or proposal creation.</span></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNlK4T0JL8_4XGU0J9gGBMZtnSI83nRzboHEG7QKoHycfLy-0sxi6zRw4T7GsaKOsI9HM-i723uKpktIQKRMgrWMTnk3Hsu4ZmnZAEPDGqodVpOZl9WSsqHJCWhugWDJbhCZ9DGdEWy1_J/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Georgia, 'Times New Roman', serif;"><img border="0" height="149" i$="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNlK4T0JL8_4XGU0J9gGBMZtnSI83nRzboHEG7QKoHycfLy-0sxi6zRw4T7GsaKOsI9HM-i723uKpktIQKRMgrWMTnk3Hsu4ZmnZAEPDGqodVpOZl9WSsqHJCWhugWDJbhCZ9DGdEWy1_J/s320/2.png" width="320" /></span></a></div><div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;"><br />
</span></div><span style="font-family: Arial, Helvetica, sans-serif; font-size: x-small;">Watch the video:</span><a href="http://office.microsoft.com/en-us/project-server-help/video-create-a-custom-enterprise-project-type-VA101829948.aspx"><span style="font-family: Arial, Helvetica, sans-serif; font-size: x-small;">http://office.microsoft.com/en-us/project-server-help/video-create-a-custom-enterprise-project-type-VA101829948.aspx</span></a><br />
<div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Arial, Helvetica, sans-serif;"><br />
<span style="font-size: x-small;"></span></span></div><br />
<div style="margin: 0px 0px 10px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><span style="font-family: Georgia, 'Times New Roman', serif;"><br />
</span></div></li>
</ol></div></div>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-28526064562108013032008-03-25T14:42:00.000-07:002008-03-25T14:49:15.836-07:00Query to find the deleted Tasks in Projects<span style="font-size:85%;">All,</span><br /><span style="font-size:85%;"></span><br /><span style="font-size:85%;">Hope this query will help you in finding the Deleted tasks form MS-Project 2003. In this case, team <span class="blsp-spelling-corrected" id="SPELLING_ERROR_0">members</span> can see the <span class="blsp-spelling-error" id="SPELLING_ERROR_1">PWA</span> tasks in their <span class="blsp-spelling-error" id="SPELLING_ERROR_2">timesheet</span> but they can't update the Actual hrs.</span><br /><span style="font-size:85%;"><u>Run this query <span class="blsp-spelling-corrected" id="SPELLING_ERROR_3">against</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_4">ProjectServer</span> database:</u></span><br /><span style="font-size:85%;"></span><br /><span style="font-size:85%;color:#000099;">select </span><br /><span style="font-size:85%;color:#000099;">mp.<span class="blsp-spelling-error" id="SPELLING_ERROR_5">Proj</span>_Name AS [Project Name],</span><br /><span style="font-size:85%;color:#000099;">ma.TASK_NAME AS [Task Name] ,</span><br /><span style="font-size:85%;color:#000099;">ma.ASSN_START_DATE AS [Start date],</span><br /><span style="font-size:85%;color:#000099;">ma.ASSN_FINISH_DATE AS [Finish date],</span><br /><span style="font-size:85%;color:#000099;">ma.ASSN_WORK/60000 As 'Work',</span><br /><span style="font-size:85%;color:#000099;">ma.ASSN_ACT_WORK/60000 As 'Actual Hours Reported',</span><br /><span style="font-size:85%;color:#000099;"><span class="blsp-spelling-error" id="SPELLING_ERROR_6">mr</span>.RES_NAME As Resource </span><br /><span style="font-size:85%;color:#000099;">from <span class="blsp-spelling-error" id="SPELLING_ERROR_7">MSP</span>_WEB_ASSIGNMENTS ma </span><br /><span style="font-size:85%;color:#000099;">JOIN <span class="blsp-spelling-error" id="SPELLING_ERROR_8">MSP</span>_WEB_PROJECTS mp ON ma.<span class="blsp-spelling-error" id="SPELLING_ERROR_9">WPROJ</span>_ID = mp.<span class="blsp-spelling-error" id="SPELLING_ERROR_10">WPROJ</span>_ID</span><br /><span style="font-size:85%;color:#000099;">JOIN <span class="blsp-spelling-error" id="SPELLING_ERROR_11">MSP</span>_WEB_RESOURCES <span class="blsp-spelling-error" id="SPELLING_ERROR_12">mr</span> ON ma.<span class="blsp-spelling-error" id="SPELLING_ERROR_13">WRES</span>_ID = <span class="blsp-spelling-error" id="SPELLING_ERROR_14">mr</span>.<span class="blsp-spelling-error" id="SPELLING_ERROR_15">WRES</span>_ID where </span><br /><span style="font-size:85%;color:#000099;">ma.<span class="blsp-spelling-error" id="SPELLING_ERROR_16">WASSN</span>_DELETED_IN_<span class="blsp-spelling-error" id="SPELLING_ERROR_17">PROJ</span> <>0 </span><br /><span style="font-size:85%;color:#000099;">Order by mp.<span class="blsp-spelling-error" id="SPELLING_ERROR_18">Proj</span>_Name</span><br /><span style="font-size:85%;"></span>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-24484779712756815292008-03-25T14:02:00.000-07:002008-03-25T14:13:30.883-07:00Actions to take if the Project Server 2007 queue stops processing jobs<span style="font-family:georgia;font-size:85%;">There are several reasons why the queue can get stuck. The easiest way to know whether the queue is stuck is to look in the Manage Queue page in PWA. If there are several jobs sitting in the “Waiting to be processes” state, then the queue is most likely stuck.<br /><br />The thing to do first is to find the one job that is in queue position 1 and that is holding up all the other jobs from processing. Follow these steps to help find the stuckedjob:<br /><br />1) In the “Manage Queue” page in PWA>Server Settings expand the “Job History” </span><span style="font-family:georgia;font-size:85%;">and set the “From Date” back to as early as you think the stuck job might be found. A week back would probably be sufficient if this is a recent occurrence.<br />2) In the “Job Completion Status” remove all jobs statuses and only add back in the following: Getting Queued, Processing<br />3) Hit the “Refresh” button in the Jobs Grid</span>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0tag:blogger.com,1999:blog-874620074699269403.post-74876809531227997942007-09-16T01:51:00.000-07:002007-09-16T01:54:10.689-07:00Hi All<span style="font-family:trebuchet ms;font-size:85%;">Hi All,</span><br /><span style="font-family:trebuchet ms;font-size:85%;"></span><br /><span style="font-family:trebuchet ms;font-size:85%;">I am very new to blogs, Hope you will like my bolgs & the technical materials,</span><br /><span style="font-family:trebuchet ms;font-size:85%;"></span><br /><span style="font-family:trebuchet ms;font-size:85%;">Cheers,</span><br /><span style="font-family:trebuchet ms;font-size:85%;">Amit</span>Amit Kharehttp://www.blogger.com/profile/06837681622885965913noreply@blogger.com0