Need to periodically get a copy of MPP from Project server for sav

[Dinesh Tekkatte]

I need to periodially read all the MPPs in the project server(2007) and save
as MPP to a file share (to be consumed by different application) without user
intervention.

How do I achieve this?

The program doing this job cannot run on Application server(since the
fileshare isn't accessible from App server), but can run on a WFE of the
SharePoint farm or any other server]
Could someone give code samples (in C#) if this needs to be accomplished
using code?

 

[Rod Gill]

The only way to create .mpp files is from Project Professional. So, the
quickest solution by far is VBA to read all project names from the Reporting
db then open and save each project in turn. It can run from any workstation.

--

Rod Gill
Microsoft MVP for Project

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

I need to periodially read all the MPPs in the project server(2007) and
save
as MPP to a file share (to be consumed by different application) without
user
intervention.

How do I achieve this?

The program doing this job cannot run on Application server(since the
fileshare isn't accessible from App server), but can run on a WFE of the
SharePoint farm or any other server]
Could someone give code samples (in C#) if this needs to be accomplished
using code?

__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Dinesh Tekkatte]

I understand that as long as we have MS Project instaleld in a system, we
should be able to achive this.
Could you please elaborate or give pointers on how do we write VBA to
achieve this.

The only way to create .mpp files is from Project Professional. So, the
quickest solution by far is VBA to read all project names from the Reporting
db then open and save each project in turn. It can run from any workstation.

--

Rod Gill
Microsoft MVP for Project

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

I need to periodially read all the MPPs in the project server(2007) and
save
as MPP to a file share (to be consumed by different application) without
user
intervention.

How do I achieve this?

The program doing this job cannot run on Application server(since the
fileshare isn't accessible from App server), but can run on a WFE of the
SharePoint farm or any other server]
Could someone give code samples (in C#) if this needs to be accomplished
using code?

__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Rod Gill]

Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset

'Setup database connection
Set Conn = New ADODB.Connection
Conn.ConnectionString = "Provider=sqloledb;" _
& "Data SourceServerName;" _
& "Initial Catalog=ReportingDatabaseName;" _
& "Integrated Security=SSPI;"
Conn.Open
rs.open "SELECT ProjectName" FROM dbo.MSP_EpmProject_UserView",conn

then loop thru all names opening each project in turn and saving. You'll
need to set a reference to the ADO 2.8 library as well.

--

Rod Gill
Microsoft MVP for Project

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

I understand that as long as we have MS Project instaleld in a system, we
should be able to achive this.
Could you please elaborate or give pointers on how do we write VBA to
achieve this.

The only way to create .mpp files is from Project Professional. So, the
quickest solution by far is VBA to read all project names from the
Reporting
db then open and save each project in turn. It can run from any
workstation.

--

Rod Gill
Microsoft MVP for Project

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

I need to periodially read all the MPPs in the project server(2007) and
save
as MPP to a file share (to be consumed by different application)
without
user
intervention.

How do I achieve this?

The program doing this job cannot run on Application server(since the
fileshare isn't accessible from App server), but can run on a WFE of
the
SharePoint farm or any other server]
Could someone give code samples (in C#) if this needs to be
accomplished
using code?

__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Dinesh Tekkatte]

My Situation is ittle more complicated. I have many project server instances
(many PWA sites) on the same farm & I need to write a service to periodically
fetch the projects from all of them.

Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset

'Setup database connection
Set Conn = New ADODB.Connection
Conn.ConnectionString = "Provider=sqloledb;" _
& "Data SourceServerName;" _
& "Initial Catalog=ReportingDatabaseName;" _
& "Integrated Security=SSPI;"
Conn.Open
rs.open "SELECT ProjectName" FROM dbo.MSP_EpmProject_UserView",conn

then loop thru all names opening each project in turn and saving. You'll
need to set a reference to the ADO 2.8 library as well.

--

Rod Gill
Microsoft MVP for Project

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

I understand that as long as we have MS Project instaleld in a system, we
should be able to achive this.
Could you please elaborate or give pointers on how do we write VBA to
achieve this.

The only way to create .mpp files is from Project Professional. So, the
quickest solution by far is VBA to read all project names from the
Reporting
db then open and save each project in turn. It can run from any
workstation.

--

Rod Gill
Microsoft MVP for Project

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




message I need to periodially read all the MPPs in the project server(2007) and
save
as MPP to a file share (to be consumed by different application)
without
user
intervention.

How do I achieve this?

The program doing this job cannot run on Application server(since the
fileshare isn't accessible from App server), but can run on a WFE of
the
SharePoint farm or any other server]
Could someone give code samples (in C#) if this needs to be
accomplished
using code?

__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Rod Gill]

That means your code is going to have to log onto each instance in turn to
run the code. What you want done is going to take at least a day to finally
get working. I'm happy to help but not to spend many hours doing something
for free I'm afraid!

I suggest you have a list of Server names as Tasks in a project and folder
destinations in Text1 and use that as a source. Your code then loops thru
all data. This project would of course only hold this data and the macro.

--

Rod Gill
Microsoft MVP for Project

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

My Situation is ittle more complicated. I have many project server
instances
(many PWA sites) on the same farm & I need to write a service to
periodically
fetch the projects from all of them.

Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset

'Setup database connection
Set Conn = New ADODB.Connection
Conn.ConnectionString = "Provider=sqloledb;" _
& "Data SourceServerName;" _
& "Initial Catalog=ReportingDatabaseName;" _
& "Integrated Security=SSPI;"
Conn.Open
rs.open "SELECT ProjectName" FROM dbo.MSP_EpmProject_UserView",conn

then loop thru all names opening each project in turn and saving. You'll
need to set a reference to the ADO 2.8 library as well.

--

Rod Gill
Microsoft MVP for Project

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

I understand that as long as we have MS Project instaleld in a system,
we
should be able to achive this.
Could you please elaborate or give pointers on how do we write VBA to
achieve this.

:

The only way to create .mpp files is from Project Professional. So,
the
quickest solution by far is VBA to read all project names from the
Reporting
db then open and save each project in turn. It can run from any
workstation.

--

Rod Gill
Microsoft MVP for Project

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




message I need to periodially read all the MPPs in the project server(2007)
and
save
as MPP to a file share (to be consumed by different application)
without
user
intervention.

How do I achieve this?

The program doing this job cannot run on Application server(since
the
fileshare isn't accessible from App server), but can run on a WFE of
the
SharePoint farm or any other server]
Could someone give code samples (in C#) if this needs to be
accomplished
using code?

__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com





__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus
signature database 4485 (20091006) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus
signature database 4488 (20091007) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4488 (20091007) __________

The message was checked by ESET Smart Security.

http://www.eset.com