Creating project by importing

[Gilgamesh]

Hi There,
We have the project data stored in an MS SQL Server, and I was wondering if
there's an API set available which allows us to import that data into MS
project and create a project from it.

 

[Rod Gill]

Hi,

Look for and thoroughly digest the projdb.htm file stored in one of
Project's program folders (it's also on the Project cd. This has details of
how you can save data in a database and have Project read it. Read the file
very carefully. First of all save a project to your database. That will
create all tables and fields etc for you to add data to.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Gilgamesh]

This file contains detailed information to export a project into an Access
DB. What I'm looking for is a VB code sample that I could use to read a list
of tasks from SQL serverDB and export it to a new MS project file.

 

[Rod Gill]

No,

The file describes how project saves a file in a database AND how you can
modify that data, or create new projects, tasks, resources and assignments.
You can only do what you want this way, or export the data to text or
spreadsheet files (or xml and some other formats) then import, or use
Automation. The projdb.htm file also describes simple SQL code that will do
what you need: no need for VB code at all in many cases.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Jonathan Stone]

Hi,

I've tackled this in the past where I needed to generate a Project file from
the web. In one of the html help files in that folder where the projdb.htm
file is, there are the exact details... But generally heres what I did:

Using the Project XML data definition, i wrote an XML string from my SQL
data for all the tasks in the database (custom web based task management
system). There are a certain set of information required to generate the fil
(XML Tags) and again, I cant remember the details. If you want to go this
route, I can look at the source to find out the minimum requirements (that I
encountered), it was mostly tricky with some of the time related data...
Anyways, I generated this XML string with the data, then instantiated a
MSProject Application object on the client with CreateObject in the html and
passed it the XML string, then opened the app. Of course, the security zone
had to support unsigned ActiveX controls to open right up, but otherwise...
it fires up a new project with the data very nicely....

-Jon