how to create a baseline in the database for designated project?

  • Thread starter vladimir gondarev
  • Start date
V

vladimir gondarev

Hello,

How i can create a new baseline in the Project 2007 database without the
Microsoft Project Pro for required project.
As far as i know PSI doesn't do this.
So last approach is direct datbase access.
But i couldn't find the all places where i need to insert the new records to
accomplish my task.
I have added the records to the following table:
MSP_TASK_BASELINES.
and Modified the PROJ_EXT_EDITED flag for designated project in
MSP_PROJECTS table.
But this didn't help me.

Any suggestions?
 
R

Rod Gill

Too dangerous. The worst case is corruption of your whole Project Server.
Directly entering data is totally unsupported. In addition some data is
entered in binary fields.

Given the cost of rebuilding your Project Server, an extra license for
Project pro is cheap!! You can open projects in Project Pro and save the
baseline thru automation.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




vladimir gondarev said:
Hello,

How i can create a new baseline in the Project 2007 database without the
Microsoft Project Pro for required project.
As far as i know PSI doesn't do this.
So last approach is direct datbase access.
But i couldn't find the all places where i need to insert the new records
to
accomplish my task.
I have added the records to the following table:
MSP_TASK_BASELINES.
and Modified the PROJ_EXT_EDITED flag for designated project in
MSP_PROJECTS table.
But this didn't help me.

Any suggestions?




__________ Information from ESET Smart Security, version of virus
signature database 4852 (20100209) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4852 (20100209) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
V

vladimir gondarev

Thank you for information.
But even if this too dangerous.
Could you please guide me how to make this?
by the way if this totally unsupported. How to set/clear the baseline on
the server side?
For instance through PSI extension that is called by external application.
It is hard to believe that the only way to do this is to install the
Microsoft Project Pro and then automate it.
Thank you.
 
V

vladimir gondarev

Another one question.
When you are saying "Project Pro and save the" baseline thru automation."
do you mean the following things?
1) Create a Enterprice lever VBA macro in Enterprice Global template.
2) Add VBA Code into it. Something like that:
Sub BaselineMyProject()

Dim msg As Integer
msg = MsgBox("Do you wish to save an interim baseline?", vbYesNo, "Save
Baseline")
'if response is yes then save baseline 10
If msg = vbYes Then
BaselineSave All:=True, Copy:=0, Into:=20
End If

MsgBox ("Baseline 10 was saved")
End Sub

3) Call this macro when i need to set the baseline.

Please give me an advice if i was wrong.
 
R

Rod Gill

Yes, that's it.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




vladimir gondarev said:
Another one question.
When you are saying "Project Pro and save the" baseline thru automation."
do you mean the following things?
1) Create a Enterprice lever VBA macro in Enterprice Global template.
2) Add VBA Code into it. Something like that:
Sub BaselineMyProject()

Dim msg As Integer
msg = MsgBox("Do you wish to save an interim baseline?", vbYesNo, "Save
Baseline")
'if response is yes then save baseline 10
If msg = vbYes Then
BaselineSave All:=True, Copy:=0, Into:=20
End If

MsgBox ("Baseline 10 was saved")
End Sub

3) Call this macro when i need to set the baseline.

Please give me an advice if i was wrong.



__________ Information from ESET Smart Security, version of virus
signature database 4855 (20100210) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4855 (20100210) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
R

Rod Gill

I don't think the baseline can be manipulated like that via PSI.

Personally, as a PM and planner, I would react strongly to any server action
that might mess with my Baselines!

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




vladimir gondarev said:
Thank you for information.
But even if this too dangerous.
Could you please guide me how to make this?
by the way if this totally unsupported. How to set/clear the baseline on
the server side?
For instance through PSI extension that is called by external application.
It is hard to believe that the only way to do this is to install the
Microsoft Project Pro and then automate it.
Thank you.



__________ Information from ESET Smart Security, version of virus
signature database 4855 (20100210) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4855 (20100210) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top