Project 2007 Project Resource Kit
Hi everyone, Phil Smail from the Project Product Group here. Just wanted to announce the news that I know a lot of you out there have been waiting for. The Project Resource Kit for Project 2007 has released!! It’s available for x86 and x64 in English only
The PRK consists of the following tools:
- Portfolio Analyzer Views Migration: Allows an administrator to bulk edit the location of an analysis server for multiple data analysis views.
- Project Server Settings Backup and Restore (Playbooks): Allows an administrator to backup Project Server settings and restore those settings to another Project Server.
- Project Server Data Populator: Allows an administrator to populate Project Server with projects, resources and other objects. Useful for helping capacity and performance testing.
- Project Workspace Site Relinker: Allows an administrator to relink the connection between Project Server and Project Workspace sites.
- View Effective Rights: Allows an administrator to query the Project Server to determine the effective permissions of users against projects or resources.
Full documentation on the tools is expected shortly. In the meantime try them out and feel free to post comments
URL:
Comments
Anonymous
January 25, 2008
Hello, I just wanted to point everyone to our other team blog: http://blogs.msdn.com/project/archive/2008/01/25/project-2007-project-resource-kit.aspxAnonymous
January 25, 2008
Hello, I just wanted to point everyone to our other team blog: http://blogs.msdn.com/project/archiveAnonymous
January 28, 2008
I have been playing with Playbooks, and it is going to solve a lot of longstanding migration issues for us. However, I get the following error trying to backup the server security settings: ERROR: Could not load file or assembly 'Microsoft.Office.Project.Server.Library, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. Any thoughts?Anonymous
January 30, 2008
The "Portfolio Analyzer Views Migration" utility works well, but the database pick list is so narrow I couldn't tell what I was choosing until I got to the summary screen. Also, view names can be very long and it's nice to see their current database setting which is only shown at the end of the view name in the Select Views screen. Any plans to create a utility to migrate views from one instance of Project Server to another?! That would be super handy.Anonymous
February 06, 2008
If tried out the Playbooks, but it seems it doesn't transfer all client global settings. I created a fresh instance and restored a configuration, but then all the client views/tables/filters/groupings were missing. Only the macros had been transferred. So it runs pretty well, but still is not complete. Also a nice feature for further development would be the selection of single items from item groups to restore, e.g. Restore only lookup table "xyz" Regards, TrutzAnonymous
February 07, 2008
I downloaded the resource kit and I installed it on my app server. I'm able to use the effective rights feature but every time I want to use the Playbook it keeps asking me for correct URL, user name and password. I see there is a config file but I do not the format...Please help as I need to copy production data to a development server. Thank You.Anonymous
February 14, 2008
I Tried out the Playbooks with a customized install. Enterprise Global settings (client views, tables, etc) were missing. Enterprise custom fields with lookup, PWA views and settings were restored correctly. But enterprise custom fields with formula were absolute wrong (Mixed Enterpise Custom field names in the formula etc.)Anonymous
February 16, 2008
Hi, Server settings and PWA views migration works great. But no Project Professional views will be migrated !Anonymous
February 29, 2008
To Craig: You'll need a copy of Microsoft.Office.Project.Server.Library in the same directory as the PRK tools. It ships in the Project SDK Location: http://www.microsoft.com/downloads/details.aspx?FamilyId=2672F6F9-7028-4B30-99A2-18CB1EED1ABE&displaylang=enAnonymous
February 29, 2008
To AFrank: Thanks for the feedback on the tool We do have a tool to migrate views from one instance to another, it's called Playbooks and it ships in the PRK!Anonymous
February 29, 2008
To cesar cruz: Having to enter the username/password when running playbooks should prevent you from migrating data from production to environmentAnonymous
February 29, 2008
To papt: The formula custom fields issue is known and we are looking into how we will resolve that. No ETA unfortunatelyAnonymous
March 18, 2008
Awesome tool. Is there any plan to be able to backup/restore the following? Enterprise Calendars Financial Periods These unfortunately are probably the two of the biggest things that we would like to use the tool for.Anonymous
March 24, 2008
I downloaded the tools and tried beginning with the view effective rights because I currently have an issue where this could be very handy. I don't seem to be able to run the utility. I tried on my workstation & when that didn't work, I tried to run it directly from the application server. This netted better results, but with no database server information, it showed that it was connecting. When I added the database server name, it said 'disconnected' and it didn't appear I could get it to try again. Any ideas? Thanks, R HalbachAnonymous
May 11, 2008
I have been trying to get the "View Effective Rights" tool working and this had been failing. The Technet site that describes this tool (http://technet.microsoft.com/en-us/library/cc197528.aspx) states that read access into the _Published database is required. However, after much gnashing of teeth we got the tool working by granting dbo rights. I would rather not have the people using this tool having dbo access. Is there any known work around for this? Has anyone else had similar issues? We are using SQL Server 2005 SP1.Anonymous
May 11, 2008
Actually, a mis-type. We run SQL Server 2005 SP2 (not SP1) We have also tried changing permissions to dbo_securityadmin but this connects to the server and retrieves that database name, then the application errs and closes.Anonymous
September 24, 2008
Hi Despite granting my user dbo rights in every database on the SQL 2005 server we are running, I keep getting this error when trying to start playbooks.exe : "ERROR: Server was unable to process request ---> Cannot open database "SSPrvCfg01" requested by login. The login failed. Login failed for user DOMAINserviceaccount . Please set URL, username and password correctly." The service account we use has full local admin rights on the server and is sa in the SQL database server and dbo in every database on the server. Note the SQL database is a named instance. We are using WSS 3.0 and have only one PWA. Any help most appreciated Steve.Anonymous
October 01, 2008
The comment has been removedAnonymous
October 14, 2008
The comment has been removedAnonymous
October 29, 2008
The Project 2007 Project Resource Kit is a very useful set of tools. The PRK consists of the followingAnonymous
February 04, 2009
Hi Phil, As an implementer of Project Server 2007, I've been using the RK tools since they have been released and have to say all of them are useful were worth the wait. I have a question regarding the View Effective Rights tools when using it with a server with Multiple PWA instances and therefore multiple Published databases. The tools seems to want to default the connection to the name of the first Published database it sees alphabetically. Even when I select the other instance's Published DB the connection does not refresh. Is there a way to force the connection to refresh to connect to the other PWA instance? Thanks KenAnonymous
June 25, 2009
Hi, I am getting following error while restoring the Custom fields and Lookup table. ERROR: Project Server Error: CustomFieldInvalidUID Context: Updating custom field <Custom Field Name>. Please help!!!!!Anonymous
July 02, 2009
Hello, I am getting the same error as Sam. ERROR: Project Server Error: CustomFieldInvalidUID Context: Updating custom I have tried the Playbook tool on our PWA server and my client pc with no luck. I have also checked permissions to add enterprise fields and everything looks fine. Any information would be helpful. Thanks!Anonymous
November 02, 2009
Hi, i am trying to work with PRK. it fetches all the information (Resources, Views, from the database, but not the projects. Any Idea? Thanks in Advance.