Exporting Data to Databases Project Management Help

Why Might You Export Data to a Database?

• To send project data for analysis on heavy-duty mainframe or mini-computer based databases
• To query Project 2000 data using SQl and OLAP tools

Databases use these file formats: MPD, MDB,various ODBC formats.

Save an Entire Project as a Project Database (MPD) or Access Database (MOB)

This format saves your whole project into an Access database. The proprietary file extension for Project Database is MPD,.and this is the preferable format to use when exchanging project data. An MPD file can contain multiple projects and be queried just like an Access Database (MDB)

1. Open the project you want to save as a Project Database file.
2. Choose File >- Save As.
3. In the Save As dialog box, select the destination for the database file.
4. Select MPD or MDB in the Save As Type drop-down list.
5. Type or select the file name for your exported database. Remember that database files can contain multiple projects when choosing a file name.
6. Click Save.
7. The Save to Database dialog box is displayed, as shown in Figure 19.38.
8. Choose to save the entire project file or export Selective Data.
9. Click Save to export your project database.

For an MPD file, Entire Project is the only export option available. Enter the Name To Give The Project In The Database. If your project has already been saved as a file, its file name will appear in the field. We recommend that you use descriptive names whenever possible-for instance, if you had a project database containing historical project data (the same project fill’ at different times used for trend analysis), you would need to differentiate between projects that will likely haw the same fill’ name. Queries and reports run against a Project database .

Select or enter a

Select or enter a 

With an Access database, if the database file already exists, you will see the message box shown in Figure 19.39. You have three choices: appending the data you are saving onto the end of the existing database, overwriting the database with the data you’re exporting, or canceling and renaming your destination file. Appending your project file .wijl allow multiple projects to be stored in the same database

You see this message

You see this message

Exporting Data as HTML

Hypertext markup language, or HTML, is the language of the Web, and is fast becoming the universal language for data presentation. HTML pages can be published on your Web server, and viewed ina browser by users, regardless of the type of computer they use.

Project uses import/export maps to determine which fields are exported to HTML, and may use a template to determine how and where the information is displayed in the HTML file. You can create or edit both the HTML import/export maps and the HTML templates.

1. Select File > Save As.
2~ In the Save As dialog box, select Web Page (HTML) from the Save As Type dropdown list. Type the name of your destination file and click Save.
3. In the Import/Export Map dialog box, select the name of the map you want to use for exporting your data; or click New, Edit, or Copy to define a new map or edit an existing map. (See “Creating Copying, and Modifying an Import Map,” earlier
4. Click Save.

You can edit the sample templates that Microsoft Project provides for creating formatted HTML files from exported data, or you can create your own templates. If you’re exporting project data based on a template, make sure that the template includes Microsoft Project template tags for all of the data being exported by the map, and make sure that all the tags have the correct spelling and syntax.”

Converting, Linking, and Embedding with Project

Object .linking and Embedding, or OLE (pronounced “c-lay”), is a protocol that-allows applications to communicate with each other to”create or update objects; data that an be embedded or linked in another applications. Word documents, Excel worksheets and charts, Access tables, and Power Point slides are all examples of objects you can insert (embed or link) in Project 2000. You can also insert graphics, sounds, video, and virtually anything else you can select and copy to the Clipboard.

OLE requires an application that can create OLE objects (an O.LEserver) and as application that can accept OLE objects (an OLE client). Project 2000 is ari OLE client, but it is n<;>ta fully compliant OLE 2.0 server, so Project 2000 data cannot be shared in
the same manner with all applications. (You can link or embed Project data in Excel. See “Copying Data Objects frem Project” at the end of this .)

The alternative to OLE is to convert data or objects. When you convert a selection, it is translated from its native format (the format used by the application it was created in) to a format that can be used directly by the application you place the selection into. Importing and exporting both use conversion rather than OLE. Converting creates a copy. After the selection is converted, you use the tools in the destination application to work with it. You can change the converted data without affecting the original because the converted data is, after all, only a copy.

The easiest way to convert (and embed or link) data in Project is to copy and paste. This is especially useful if you just-need a few values, rather than an entire file. Open Project and the other application (called the source application if Objects will be copied FROM; open the destination application if objects will be pasted INTO). Select the object in the source document and copy it to the Clipboard. You can close the source application if you wish; with some programs you’ll be asked if you want to retain the contents of the Clipboard. Choose Yes or you’ll have to reopen the source application and copy again.

Posted on November 27, 2015 in Importing and Exporting Project Data

Share the Story

Back to Top