This is old topic, but I am posting here because I finally allocated time and developed a tool to transfer baseline from one Microsoft Project file to another. It is assumed, that both files represent different versions of the same project schedule.
The limitation of the tool, is that it works on MS Project 2003 and does not work on 2007 and 2010. Reason being is that is uses MS Project feature to save and read project schedule into MS Access format. The feature to save file in MS Access format has been discontinued starting from MS Project 2007.
how complicated! you do not need MS Access or whatever to copy the baseline fields from one file to another
if really you do not want to use the way I have suggested, you could export (File, Save As) the necessary fields from the baselined project to an Excel file or to a MS Access database, then import from there to the new un-baselined file
I actually found now more elegant way, but it requires knowledge of MS Access
Given:
OLD FILE contains schedule, which needs to be moved as baseline to NEW FILE
Procedure:
1) Save schedule to baseline1 in the OLD FILE
2) Save both OLD FILE and NEW FILE in *.mdb format
3) In NEW FILE, go to table MSP_PROJECTS and set the flag PROJ_EXT_EDITED to 1.
4) Now copy and paste all rows where TB_BASE_NUM=1 from tables MSP_ASSIGNMENT_BASELINES, MSP_RESOURCE_BASELINES, MSP_TASK_BASELINES from the OLD FILE to the equivalent tables of the NEW FILE.
Open NEW FILE in MS Project, check that the changes took effect, save file back as *.mpp file.
I tried it on simple schedule, it works.
Member for
19 years 11 months
Member for19 years11 months
Submitted by Trevor Rabey on Thu, 2009-02-12 04:11
Even if you did not baseline the early file, you can still copy the start, finish, duration, work and cost fields from that one and paste them into the corresponding baseline fields in the current file.
In the current file, show the baseline table which already has the fields you are interested in pasting into.
If they both have the same tasks and work breakdown structure you can do each column in one shot, but if not then in chunks of tasks, tedious but it works.
If you are lucky, and you do have the same tasks and WBS, and the exact same number of lines in each file, and if you make a new table in the early file which has the same columns as correspond to the baseline table in the current file, you can copy and paste the whole lot in one go.
Member for
22 years 9 months
Member for22 years9 months
Submitted by Alexandre Faul… on Thu, 2009-02-12 03:19
I would open both files: the one you want to use as the baseline, and the other one
Then in both files, display the Variance table, or any other task table where you can see the "Baseline Start", "Baseline Finish" and if you need them "Baseline Work" and "Baseline Cost"
Finaly, copy / paste the baselined values from project_1 to project_2
Next time, you will not forget to save the baseline before you start updating a project!
Member for
17 years 9 monthsThis is old topic, but I am
This is old topic, but I am posting here because I finally allocated time and developed a tool to transfer baseline from one Microsoft Project file to another. It is assumed, that both files represent different versions of the same project schedule.
The limitation of the tool, is that it works on MS Project 2003 and does not work on 2007 and 2010. Reason being is that is uses MS Project feature to save and read project schedule into MS Access format. The feature to save file in MS Access format has been discontinued starting from MS Project 2007.
Tool has detailed manual (help file) with it.
It can be downloaded here free of charge: mppbaselinecop.sf.net
Evgeny
Member for
22 years 9 monthsRE: Import baseline from one file to another
Hi all,
how complicated! you do not need MS Access or whatever to copy the baseline fields from one file to another
if really you do not want to use the way I have suggested, you could export (File, Save As) the necessary fields from the baselined project to an Excel file or to a MS Access database, then import from there to the new un-baselined file
and thats all
Alexandre
Member for
17 years 9 monthsRE: Import baseline from one file to another
I dont know, I dont have Project 2007 at the moment. But for Project 2007 you should be able to save it to Access 2007 format (.accdb).
Member for
17 years 9 monthsRE: Import baseline from one file to another
Thanks for replies,
I actually found now more elegant way, but it requires knowledge of MS Access
Given:
OLD FILE contains schedule, which needs to be moved as baseline to NEW FILE
Procedure:
1) Save schedule to baseline1 in the OLD FILE
2) Save both OLD FILE and NEW FILE in *.mdb format
3) In NEW FILE, go to table MSP_PROJECTS and set the flag PROJ_EXT_EDITED to 1.
4) Now copy and paste all rows where TB_BASE_NUM=1 from tables MSP_ASSIGNMENT_BASELINES, MSP_RESOURCE_BASELINES, MSP_TASK_BASELINES from the OLD FILE to the equivalent tables of the NEW FILE.
Open NEW FILE in MS Project, check that the changes took effect, save file back as *.mpp file.
I tried it on simple schedule, it works.
Member for
19 years 11 monthsRE: Import baseline from one file to another
Even if you did not baseline the early file, you can still copy the start, finish, duration, work and cost fields from that one and paste them into the corresponding baseline fields in the current file.
In the current file, show the baseline table which already has the fields you are interested in pasting into.
If they both have the same tasks and work breakdown structure you can do each column in one shot, but if not then in chunks of tasks, tedious but it works.
If you are lucky, and you do have the same tasks and WBS, and the exact same number of lines in each file, and if you make a new table in the early file which has the same columns as correspond to the baseline table in the current file, you can copy and paste the whole lot in one go.
Member for
22 years 9 monthsRE: Import baseline from one file to another
Giles,
I would open both files: the one you want to use as the baseline, and the other one
Then in both files, display the Variance table, or any other task table where you can see the "Baseline Start", "Baseline Finish" and if you need them "Baseline Work" and "Baseline Cost"
Finaly, copy / paste the baselined values from project_1 to project_2
Next time, you will not forget to save the baseline before you start updating a project!
Alexandre