EPMFAQ Forums - Connect with the EPM Community  

Go Back   EPMFAQ Forums - Connect with the EPM Community > Legacy Microsoft Project Forums > Project Server 2003


Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-30-2008, 02:22 PM
Junior Member
 
Join Date: Apr 2008
Posts: 7
Thanks: 3
Thanked 0 Times in 0 Posts
Default moving actual work to another project

Hi All!

Is it possible to move all planned and actual work from one project to another?

Using Project Server 2003 on SQL 2000.

Thanks,
David








Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored links
  #2 (permalink)  
Old 05-05-2008, 01:08 PM
ssanderlin's Avatar
EPMFAQ Founder/Owner
 
Join Date: Feb 2008
Location: Quakertown, PA
Posts: 161
Thanks: 0
Thanked 13 Times in 13 Posts
Default

Quote:
Originally Posted by david.dienes View Post
Hi All!

Is it possible to move all planned and actual work from one project to another?

Using Project Server 2003 on SQL 2000.

Thanks,
David
The best way to do this would be by hand... How were the actuals input into the project?
__________________
Stephen Sanderlin
Founder/Owner - EPMFAQ
Principal Consultant - MSProjectExperts

If you found this message useful, please click the Thanks button in the post!

This electronic message, along with any information, advice, and opinions it contains, are mine alone and are not representative of my employer. All information is provided in "GOOD FAITH" and on an "AS IS" basis only. I provide no presentations or warranties, express or implied, including implied warranties of fitness for a particular purpose, merchantability, title, and noninfringement. I strongly advise you to extensively test any changes, workarounds, or techniques described herein on a development system prior to implementation in a production environment, and you are hereby notified that I bear no responsibility whatsoever for any loss, harm, or otherwise negative outcomes resulting from your actions, whether or not said actions were a result of this electronic message, directly or indirectly.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 05-06-2008, 12:35 PM
Junior Member
 
Join Date: Apr 2008
Posts: 7
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Plan was made by Microsoft Office Project 2003.
Actuals were made by Project Web Access.

These are three different human resources, worked about 128 days between Nov.2007 and May.2008, working hours can be 4 to 8 hours per day...

I was rather thinking about some SQL table manipulation, but assigments seem to be located in too many different SQL tables...

Thanks,
David
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 05-06-2008, 03:13 PM
ssanderlin's Avatar
EPMFAQ Founder/Owner
 
Join Date: Feb 2008
Location: Quakertown, PA
Posts: 161
Thanks: 0
Thanked 13 Times in 13 Posts
Default

Quote:
Originally Posted by david.dienes View Post
Plan was made by Microsoft Office Project 2003.
Actuals were made by Project Web Access.

These are three different human resources, worked about 128 days between Nov.2007 and May.2008, working hours can be 4 to 8 hours per day...

I was rather thinking about some SQL table manipulation, but assigments seem to be located in too many different SQL tables...

Thanks,
David
It is possible to do this through SQL manipulations, but it would be very complicated.

Are you using protected actuals?
__________________
Stephen Sanderlin
Founder/Owner - EPMFAQ
Principal Consultant - MSProjectExperts

If you found this message useful, please click the Thanks button in the post!

This electronic message, along with any information, advice, and opinions it contains, are mine alone and are not representative of my employer. All information is provided in "GOOD FAITH" and on an "AS IS" basis only. I provide no presentations or warranties, express or implied, including implied warranties of fitness for a particular purpose, merchantability, title, and noninfringement. I strongly advise you to extensively test any changes, workarounds, or techniques described herein on a development system prior to implementation in a production environment, and you are hereby notified that I bear no responsibility whatsoever for any loss, harm, or otherwise negative outcomes resulting from your actions, whether or not said actions were a result of this electronic message, directly or indirectly.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 05-07-2008, 08:12 AM
Junior Member
 
Join Date: Apr 2008
Posts: 7
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Yes, all actual data is protected.

Important: the destination project already also has some planned and actual hours. The result should be a sort of merge.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 05-07-2008, 01:03 PM
ssanderlin's Avatar
EPMFAQ Founder/Owner
 
Join Date: Feb 2008
Location: Quakertown, PA
Posts: 161
Thanks: 0
Thanked 13 Times in 13 Posts
Default

Quote:
Originally Posted by david.dienes View Post
Yes, all actual data is protected.

Important: the destination project already also has some planned and actual hours. The result should be a sort of merge.
I believe that the best course of action would be for you to lock everyone out of the server, turn off protected actuals, manually move the hours, publish, then re-enable protected actuals.

Note that the submission history will be lost when you do this, but this is the way that I've always moved hours like this. It's also the way we fixed project plans back when Protected Actuals were totally broken from horrible, horrible bugs
__________________
Stephen Sanderlin
Founder/Owner - EPMFAQ
Principal Consultant - MSProjectExperts

If you found this message useful, please click the Thanks button in the post!

This electronic message, along with any information, advice, and opinions it contains, are mine alone and are not representative of my employer. All information is provided in "GOOD FAITH" and on an "AS IS" basis only. I provide no presentations or warranties, express or implied, including implied warranties of fitness for a particular purpose, merchantability, title, and noninfringement. I strongly advise you to extensively test any changes, workarounds, or techniques described herein on a development system prior to implementation in a production environment, and you are hereby notified that I bear no responsibility whatsoever for any loss, harm, or otherwise negative outcomes resulting from your actions, whether or not said actions were a result of this electronic message, directly or indirectly.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to ssanderlin For This Useful Post:
david.dienes (05-30-2008)
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT -4. The time now is 06:01 PM.


Powered by: vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Ad Management by RedTyger

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24