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 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: 171
Thanks: 0
Thanked 17 Times in 17 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
VP of Technology - MSProjectExperts
Microsoft Project MVP

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: 171
Thanks: 0
Thanked 17 Times in 17 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
VP of Technology - MSProjectExperts
Microsoft Project MVP

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: 171
Thanks: 0
Thanked 17 Times in 17 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
VP of Technology - MSProjectExperts
Microsoft Project MVP

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)
  #7 (permalink)  
Old 01-28-2010, 02:00 AM
Junior Member
 
Join Date: Jan 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i am making this novel/diary of the trail of tears. I already did my background/research paper. So what i am trying to do is actuall chat or get an actual diary entry or something from a Cherokee. I don't want to make up a diary for my book, I want to do it from a Cherokee's point of view. A point of view from a child, a mother, a father, grandmother, grandfather, cousin, one who ranaway into the North Carolina mountains (that's what my book says), you know at least 10 diary entries from the cherokee. what I am also trying to do is get a descendent or something from one of the men who actually made the cherokee nation move. You know, the men who built the stockades and everything.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
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 10:08 PM.


Powered by: vBulletin®
Copyright ©2000 - 2012, 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