Published Projects

[HMS Software]

I am using an application which use OLE (VBA not the PDS) to import data from
MS Project and when I specify a project name it must contain an extension of
'published' such as 'ABC.PUBLISHED' as that is the type of project I want to
import and export to. We have seen also that when the application is in
French then the name actually becomes 'ABC.PUBLIE', with 'publie' being the
French equivalent of 'published'. This leads me to assume that every
language with then have it's own syntax for published. So, my question is,
if the client provides my application with the name 'ABC' is there some other
way for me to access the published project without having to specify the
extension, or is there somewhere in the database that I can look up these
extensions?

TIA

Steve

 

[Ed Morrison]

You must use the format "<>\" & filename & extension when opening an
enterprise project using VBA.

You can find the name of the default version for the instance in the
msp_versions table. It is also stored on a project by project basis in
proj_version on the msp_projects table.

 

[HMS Software]

Thanks Ed. I had a quick look at the msp_versions table and I think I get
it. I guess there is a method that I can call to get the version info from
that table and could therefore determine the right naming convention.

Is the VERS_DEFAULT from msp_versions always the equivalent of the
'PUBLISHED' version (ie) when I change languages (ex French) will it be 1 for
the extension of PUBLIE?

TIA again

 

[Ed Morrison]

Correct. When the Vers_default =1, that's the published version.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com

 

[HMS Software]

Cool.

Thanks

Correct. When the Vers_default =1, that's the published version.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com