Import baseline from one file to another
Forum Sponsor
Top Posters
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts
David Smith
4 posts
Peter Holroyd
51 posts
fridau
0 posts
Rahmat Hidayat
32 posts
pinoyplanner
1 posts
Saqib Ullah
1 posts
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
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
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).
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.
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.
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