This feature provides the ability to upload a Microsoft Project file (in MPX format) to Unanet to populate an existing project with task (and other) project information. If the project already has task data entered, this feature in not available.
Location: Project Manager -- Project -- Add/Edit -- More Functions -- Import MPX
You may also be interested in Exporting MSProject-MPX Data From Unanet into MSProject.
From the More Functions dropdown list, select the Import MPX menu option and be presented with a screen similar to the one below. Select a file by either typing in the full file path from you local directory or click on the 'Browse...' button to select the file that you want to upload.
|
Import the specified file in the text box. Note: The uploaded file MUST be in MPX format and have the extension '.mpx' |
 |
Clear the data on the current page. |
 |
Manage Task Data. |
 |
Moves back to the Project List page. |
| More Functions | Allows user to jump to any project related page. |
| MPX Definition Name (Definition ID) |
Unanet Project GUI Name (DB Field Name) |
Unanet Task GUI Name (DB Field Name) |
|---|---|---|
| Name (1) | Project Title (title) | Name (task_name) |
| WBS (2) | ||
| Outline Level (3) | N/A | Used to construct imported task hierarchy. |
| Text1 (4) | N/A | Output (output) |
| Text2 (5) | N/A | Status (status) |
| Text3 (6) | Account Number (account_number) | Account Code (account_code) |
| Work (20) | ||
| Baseline Work (21) | Budgeted Hours (budget_hours) | Budget Hours (budget_hours) |
| Actual Work (22) | ||
| Remaining Work (23) | Estimate To Complete Hours (hours_used_to_date) | Estimate To Complete Hours (hours_used_to_date) |
| Cost (30) | Projected Total Labor Dollars (projected_total_dollars_cap) | Projected Total Labor Dollars (projected_total_dollars_cap) |
| Baseline Cost (31) | Budgeted Labor Dollars (budget_dollars_cap) | Budget Labor Dollars (budget_dollars_cap) |
| Remaining Cost (33) | Estimate To Complete Labor Dollars (dollars_used_to_date_cap) | Estimate To Complete Labor Dollars (dollars_used_to_date_cap) |
| Cost1 (36) | Budgeted Expense Dollars (budget_dollars_op) | Budget Expense Dollars (budget_dollars_op) |
| Cost2 (37) | Estimate To Complete Expense Dollars (dollars_used_to_date_op) | Estimate To Complete Expense Dollars (dollars_used_to_date_op) |
| Cost3 (38) | Projected Total Expense Dollars (projected_total_dollars_op) | Projected Total Expense Dollars (projected_total_dollars_op) |
| Duration (40) | ||
| Baseline Duration (41) | ||
| % Complete (44) | ||
| Start (50) | Original Starting Date (orig_start_date) | Original Start Date (orig_start_date) |
| Finish (51) | Original Ending Date (orig_end_date) | Original End Date (orig_end_date) |
| Actual Start (58) | Revised Starting Date (rev_start_date) | Revised Start Date (rev_start_date) |
| Actual Finish (59) | Revised Ending Date (rev_end_date) | Revised End Date (rev_end_date) |
| ID (90) | N/A | Required for import; used to maintain mpx_mapping table. |
| Unique ID (98) | 0 | Required for import; used to maintain mpx_mapping table. |
| Created (125) | (created) | N/A |
Note: The cells with a gray background [above] are not used during the MPX import.
Return to Unanet Table of Contents page
Copyright © 1998-2002 Computer
Strategies, Inc., All Rights Reserved.
Last revised: September 13, 2002.