Archive
Office 2010 / #MSProject 2010 SP1 + June 2011 Cumulative Update links #ProjectServer #SharePoint #SP2010 #PS2010
As ever, now that my server environment is starting to stabilise after installing SP1 + June 2011 CU (Security Validation issues aside of course), we are now looking at updating the clients to reflect the update.
This is especially important in a Project Server / Microsoft Project 2010 environment.
As a result, here are some useful links that took me a while to dig out for the Office / Project 2010 client updates:
Project 2010
Project 2010 Service Pack 1 x86:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C72141FE-D264-4F6E-AE09-D0FBD32DE5D5
Project 2010 Service Pack 1 x64:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CE1FD136-A1F4-4FF5-909B-50808D6F39CB
Project 2010 – June Cumulative Update 2011 x86 & x64:
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2536590&kbln=en-us
NB: only update binary available for Project 2010 in the June 2011 CU
Office 2010
Office 2010 Service Pack 1 x86:
http://www.microsoft.com/downloads/details.aspx?FamilyId=9D2E1282-8B69-418B-AFA0-9F61239EC8BE
Office 2010 Service Pack 1 x64:
http://www.microsoft.com/downloads/details.aspx?FamilyId=E9F3C2D0-C321-4910-A4CE-B2F294B42D65
Office 2010 – June Cumulative Update 2011 x86 & x64:
http://support.microsoft.com/kb/2553023
NB: no single update binary available, update client applications as required.
Other Useful Links:
On my travels I also found this other link which lists all the updates for the SharePoint and Office Systems:
Podcasts now available on the #SharePoint / #ProjectServer community app #Android #iOS #SP2010 #PS2010 #MSProject
Another week and another update to the SharePoint and Project Server community mobile app.
This time, wrap your audio visual senses around these podcasts that stream directly from the application (watch out for your mobile data caps!!!)
I shall add more as I find them and as ever, if you have any suggestions for the application… get in contact.
The application is currently available for iOS (iPad / iPhone) and Android.
Slipstream #Project Professional 2010 updates #MSProject #PS2010 #PS2007 #ProjectServer #MSOffice
Following on from my previous post Customising the Project Professional install, this post looks at slipstreaming the Project Professional 2010 updates into the Project install media. This simplifies the install as there is just one install file to run. This post will look at slipstreaming Service Pack 1 and the June 2011 Cumulative update into the Project 2010 install media. The same process applies for Project Professional 2007 but use the 2007 updates. This process also applies for other Microsoft Office applications with the relevant updates.
Firstly download the following updates:
- Project 2010 Service pack 1 – KB 2460052
- Project 2010 June 2011 Cumulative Update – KB 2536590
For the purpose of this post, I have both of the updates on the root of the C:\ drive, if you have the updates in a different location please update the commands to reflect the file location.
Create an Updates folder on the root of the C:\ drive
Open Command Prompt, navigate to the root of the C:\ drive and type the following command to extract Project 2010 SP1 to the new Updates folder:
project2010sp1-kb2460052-x86-fullfile-en-us.exe /extract:C:\Updates
Press Enter and accept the license agreement in the pop up box, you will then see the files extracting dialog box
Once complete you will then see installation complete message:
Click OK then you will see the extracted files in the C:\Updates folder:
Copy the contents of the C:\Updates folder and paste the contents into the Updates folder in the install media.
Once the files have been copied to the Updates folder in the install media for Project Professional 2010, delete all of the files from the C:\Updates folder so that you are ready to extract the Project 2010 June 2011 CU.
Open Command Prompt again and navigate to the root of the C:\ drive then type the following command to extract the Project 2010 June 2011 Cumulative Update to the Updates folder:
project2010-kb2536590-fullfile-x86-glb.exe /extract:C:\Updates
Press Enter and accept the license agreement in the pop up box, you will then see the files extracting dialog box appear followed by the installation complete message:
Click OK then you will see the extracted files in the C:\Updates folder:
Copy the contents of the C:\Updates folder and paste the contents into the Updates folder in the install media.
Now the updates have been extracted to the Updates folder in the installation media for Project Professional 2010, the updates will be applied when Project Professional 2010 is installed.
Further mobile app updates #iOS #Android #iPhone #SP2010 #SharePoint #PS2010 #ProjectServer #MSProject
Now that the Android release is out of the way, the application content can be updated.
New features in this content update:
- Location and date updates for Conferences, SharePoint Saturday’s and User Groups (UK)
- CodePlex Project video updates
- Minor link updates to SharePoint and Project Server RSS feeds including adding one of the site authors RSS feed for his new blog (Paul Mather: http://pwmather.wordpress.com)
If you have a blog, user group meeting or anything else you would like to add to the app, please get in contact.
Shenanigans community app now available on Android #in #PS2010 #ProjectServer #SP2010 #SharePoint #Android
As promised last week, the SharePoint (and Project Server) Shenanigans mobile application is now available for Google’s phone OS on Android Market.
Features are exactly the same as the iPhone version of the application and all future updates to the app will be kept in sync via in-app updates for both iPhone and Android.
  |
Application features:
|
Application Name: SP & PS Shenanigans
Application Categories: Social
Search Keywords: SharePoint, Project Server, Giles Hamson, Shenanigans, Social
Screenshots:
 |
 |
 |
 |
 |
 |
 |
 |
 |
Further iPhone application updates #iphone #ipad #ios #SharePoint #SP2010 #MSProject #PS2010 #ProjectServer #in
Just a quick blog to say that I have updated the SharePoint (and Project Server) iPhone application today with the following content:
- About Me – Links to my profile, my company etc…
- SharePoint Conferences around the world – locations & dates
- SharePoint Saturday around the world – locations & dates
- Application Name: SharePoint (and Project Server) Shenanigans
Application Categories: Social Media, News
Search Keywords: SharePoint, Project Server, Giles Hamson, Shenanigans, RSS, Blog
Introducing a new #iPhone / #iPad application for the #SharePoint and #ProjectServer community #SP2010 #MSProject #in
 |
Application features:
|
As the community has been so kind to me, this is my way of giving something back and I welcome new feature suggestions and blogs to be added to the RSS feeds.
The user group meeting locations is currently only for the UK, but if anyone would like to add any further user group locations / dates, anywhere in the world. I will happily add them and they will be available on the application the following day.
|
Although the application is currently only available for the iOS platform, it will soon also be available for Android and potentially Windows Mobile 7 Please send feedback / suggestions via the contact form. |
 |
Application Name: SharePoint (and Project Server) Shenanigans
Application Categories: Social Media, News
Search Keywords: SharePoint, Project Server, Giles Hamson, Shenanigans, RSS, Blog
Screenshots:
Recreating the SharePoint 2010 State Service #SP2010 #SharePoint #PS2010 #MSProject #ProjectServer
My client was so eager to get SP1 and the June 2011 Cumulative Updates up and running on the Development and Test environments that on day one I was installing and testing the updates on my project.
What on earth was my clients requirement I hear ask? couldn’t they wait?
Well the end users are heavy Linux users and the requirement for Timesheet data entry within Firefox is v.strong. As a result, testing SP1 outside of the beta that we had already tested was top priority.
Of course, a few days later the June 2011 Cumulative Update was re-released and it is widely known that the State Service among other things can go wrong.
Looking into it further and the State Service cannot be created in the usual method (clicking the new button in the Managed Service section of Central Administration).
So PowerShell to the rescue:
$StateServiceDB = "SP2010_StateService" $GetSPStateServiceApplication = Get-SPStateServiceApplication If ($GetSPStateServiceApplication -eq $Null) { Write-Host -ForegroundColor White "- Creating State Service Application..." New-SPStateServiceDatabase -Name $StateServiceDB | Out-Null New-SPStateServiceApplication -Name "State Service Application" -Database $StateServiceDB | Out-Null Get-SPStateServiceDatabase | Initialize-SPStateServiceDatabase | Out-Null Write-Host -ForegroundColor White " - Creating State Service Application Proxy..." Get-SPStateServiceApplication | New-SPStateServiceApplicationProxy -Name "State Service Application Proxy" -DefaultProxyGroup | Out-Null Write-Host -ForegroundColor White "- Done creating State Service Application." } Else { Write-Host -ForegroundColor White "- State Service Application already exists." }
Security Validation Issue – Form Services issue with SP1+June 2011 CU (Release 2) #in #SP2010 #SharePoint #MSProject #ProjectServer
We are testing Service Pack 1 heavily in my project that I have talked about on this blog many times.
One of the features of our implementation is a number of developed InfoPath forms. We found one issue previously that required a hotfix and it looks like SP1 and June 2011 CU (Release 2) has introduced another.
My colleague Paul Busby has mentioned it here:
and another user has also confirmed the issue.
I shall be sending the details below to Microsoft through our partner support and hopefully we can get a resolution.
Scenario:
- Form Services
- Administrator Approved Form
- Server Version: 14.0.6106.5002 (Office 2010 SP1 + June 2011 CU – Release 2)
- Client Version: 14.0.6023.1000 (Office 2010 SP1)
- NB: June 2011 Cumulative Update does not include updates for InfoPath 2010
- Microsoft June 2011 Cumulative Update for Office 2010 Client Applications – KB2259686: http://support.microsoft.com/kb/2259686/en-us
The form has two views:
- View one has a people picker
- View two is blank
The form is uploaded via Central Administration and activated to a site collection
A form library is created and the associated content type is attached
Upon creating a new form, the form loads
When the user switches views in the form, a Security Validation Error occurs:
Further Details:
- We have discovered that it appears to happen when switching to or from a view that contains a people picker field.
- Turning off security validation, allows the form to continue to work, but this is not something we want to go live with
- This issue has been found on a client DEV and TEST environment as well as a newly installed RTM machine upgraded to SP1 + June 2011 CU Release 2
SharePoint 2010 Log Details (specific details in red):
07/20/2011 13:54:03.85 w3wp.exe (0x10CC) 0x11BC SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Request (POST:http://vm482:80/_layouts/FormServer.aspx?XsnLocation=http://vm482/FormServerTemplates/SP1SecurityValidationTest_Published.xsn
&SaveLocation=http%3A%2F%2Fvm482%2FSP1SecurityValidationTest&ClientInstalled=true&Source=http%3A%2F%2Fvm482%2FSP1SecurityValidationTest%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1))
07/20/2011 13:54:03.85 w3wp.exe (0x10CC) 0x11BC SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (POST:http://vm482:80/_layouts/FormServer.aspx?XsnLocation=http://vm482/FormServerTemplates/SP1SecurityValidationTest_Published.xsn
&SaveLocation=http%3A%2F%2Fvm482%2FSP1SecurityValidationTest&ClientInstalled=true&Source=http%3A%2F%2Fvm482%2FSP1SecurityValidationTest%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1) 5c0ca3e0-a782-4691-9a79-b2e163e3f0e9
07/20/2011 13:54:03.85 w3wp.exe (0x10CC) 0x11BC SharePoint Foundation Logging Correlation Data xmnv Medium Site=/ 5c0ca3e0-a782-4691-9a79-b2e163e3f0e9
07/20/2011 13:54:03.91 w3wp.exe (0x10CC) 0x11BC SharePoint Foundation Web Controls cm8z Medium Failed to get SPGroupName from GroupID. Error Message: Group cannot be found. Callstack: at Microsoft.SharePoint.SPGroupCollection.GetByID(Int32 id) at Microsoft.SharePoint.WebControls.PeopleEditor.set_SharePointGroupID(Int32 value). 5c0ca3e0-a782-4691-9a79-b2e163e3f0e9
07/20/2011 13:54:03.91 w3wp.exe (0x10CC) 0x11BC SharePoint Foundation General 8kh7 High The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. 5c0ca3e0-a782-4691-9a79-b2e163e3f0e9
07/20/2011 13:54:03.91 w3wp.exe (0x10CC) 0x11BC SharePoint Foundation Runtime tkau Unexpected System.Runtime.InteropServices.COMException: The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. at Microsoft.SharePoint.Library.SPRequestInternalClass.ValidateFormDigest(String bstrUrl, String bstrListName) at Microsoft.SharePoint.Library.SPRequest.ValidateFormDigest(String bstrUrl, String bstrListName) 5c0ca3e0-a782-4691-9a79-b2e163e3f0e9
07/20/2011 13:54:03.91 w3wp.exe (0x10CC) 0x11BC SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (POST:http://vm482:80/_layouts/FormServer.aspx?XsnLocation=http://vm482/FormServerTemplates/SP1SecurityValidationTest_Published.xsn
&SaveLocation=http%3A%2F%2Fvm482%2FSP1SecurityValidationTest&ClientInstalled=true&Source=http%3A%2F%2Fvm482%2FSP1SecurityValidationTest%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1)). Execution Time=66.2620528586734 5c0ca3e0-a782-4691-9a79-b2e163e3f0e9
#ProjectServer 2010 PSI data to a text file using #PowerShell #PS2010 #Project
I recently looked into accessing the Project Server PSI via PowerShell, luckily I came across this MSDN article that helped: http://msdn.microsoft.com/en-us/library/gg607685.aspx#pj14_GettingStartedTa_PowerShell. I needed to get the data into a pipe delimited text file without using compiled code (I’m not a developer!). I have done this before with T-SQL and SSIS but I wanted to try something different. For the purpose of this blog article of have edited the example shown in the MSDN article. The PowerShell script is below:
$pwaUrl = "http://vm353/pwa"
$svcProjectUrl = $pwaUrl + "/_vti_bin/PSI/Project.asmx?wsdl"
$c = Get-Credential
$svcProjectProxy = New-WebServiceProxy -uri $svcProjectUrl -credential $c
$svcProjectProxy.ReadProjectList().Project | Select Proj_name, Proj_UID, Proj_Type `
| Export-CSV C:\projects.txt -Delimiter "|"
This script will export out a list of Project names, Proj UIDs and the Project Types to the C drive in a text file called projects.txt using the pipe delimiter. Screen shots below show the script and the output.
Script:
Output:
This is a very simple example but provides a no code solution to access Project Server data via the PSI.
SharePoint (and Project Server) Shenanigans 
You must be logged in to post a comment.