Project Server 2002 work update

MS Project Server 2002 can be configured to use MS Sql database, Oracle or ms access db or MSDE. Depending on your database you can enter the information directly in the databases. You can find the entire databse structure and description of tables and fields in the help files.

However, because ms project system updated all the related tables and fields for each task, it will be desirable to enter your information in the ms project file and then update it to the server. You can import information in the msproject from excel and you can also write customized VBA code to import information.

Microsoft? Project 2000 can transfer information to and from other applications using import/export maps to ensure that information is imported into the proper fields in Microsoft Project or exported into the proper fields in a destination file.

Import/export maps can be edited to identify which fields will be exported and where in the destination format the data will go. An export filter can also be applied to project data, as part of an import/export map. Import/export maps can be used to exchange data with the following applications:

Microsoft Access
Microsoft Excel
ODBC databases
CSV and tab-delimited text files

You will find the information on the following link useful.
http://www.microsoft.com/office/project/prk/2000/Five/67ct_6.htm

Microsoft Project Pro 2002 and Microsoft Project Server 2002 are two separate products.

Project Pro is the client application which will connect to Microsoft Project Server. Project Server will ONLY use SQL Server for its database on the backend. Oracle, DB2, Access etc can NOT be used. Entering the data directly to the SQL server database is NOT an option. The Project Server database is not a simple database to understand and entering data correctly across all the necessary tables is a huge undertaking. You are much better off using import features of Project Pro. Once you get the data there, its just a matter of saving/publishing your new project schedule to the server.

To answer your question: Using Project Pro, you can use the import wizard to import data from Excel files, older version of Project, comma delimited files etc. I would recommend dumping your data to a comma delimited or Excel spreadsheet file and then using the File|Open menu, choose your file type, and the wizard will appear to walk you through. You'll need your task information, resource information, actuals etc and match the fields up.

If you're looking for a data integration solution between your timesheet app and Project Server, a custom app/script would need to be created to follow the proper security and interface requirements of Project Server. Not an impossible thing, but something that would definitely take some development effort.

David Livingston
david@davidliv.com

This question was auto closed due to inactivity