Learn best practices to update import and update schedules using XML format
Schedules can be imported from another Fuzor project as well as many different external software as XML or CSV. Fuzor can read Work Breakdown Structure (WBS), predecessor links, calendars and resources when importing with XML. | |||||||
The XML filetype is used to exchange information between scheduling software. Fuzor can import XML from Asta Powerproject, Primavera P6, and Microsoft Project. Importing an XML is the best way to ensure that the schedule metadata is properly loaded into Fuzor. | |||||||
Asta Powerproject schedules can be imported as an .xml Microsoft Project schedules can be imported as an .xml Primavera P6 schedules can be imported as an .xml or loaded through a Live Link to the P6 API. Microsoft Excel schedules can be imported as a .csv |  | ||||||
The Load button opens the Import Schedule Data Menu. To import an entire schedule select XML / CSV. Otherwise specific column data stored in XLSX and CSV spreadsheets can be imported using Column Mapping. |  | ||||||
The Load Options Dialog Box appears after selecting a schedule with the file browser if your project is already populated with a schedule. The options in this menu allow you to control how tasks stored in your imported schedule merge with your current schedule. The schedule will keep object assignments when Merge By ID is selected. |  | ||||||
The Append radio button adds the tasks in your schedule to the end of your current schedule. The Merge By ID radio button updates tasks with a common ID to the tasks you are importing. The Overwrite radio button replaces the current schedule with the imported schedule The Keep Tasks with Objects checkbox toggles whether tasks with objects assigned are preserved when making an update with Merge By ID. To ensure that tasks are not kept that may have been deleted in authoring software uncheck this setting. | |||||||
The Reload button reloads any external changes to your schedule updating it in Fuzor. The Save button in the 4D Simulation App opens the Save Schedule Menu. The Save Schedule Menu allows the user to export an XML in Primavera P6 and Microsoft Project Format as well as export task data to CSV. |  | ||||||
The radio buttons associated with the Fuzor CSV option allow the user to toggle whether Micro tasks or Macro tasks are saved to the CSV. The Task Linking page provides detailed information about Micro tasks and Macrotasks. The Save button in the Save Schedule menu will open the file browser to select a file location. The Cancel button exits the menu without saving. | |||||||
Imported Schedule Correlations
This section provides detailed information on what Fuzor specific columns are populated by correlating columns and data in supported software.
It is important to know how your schedule is imported from your authoring software. Some Fuzor Columns have no counterparts in authoring software and are for internal use. If a particular column does not have a counterpart in a particular authoring software it is possible that it may still be populated on import. When Using Asta Powerproject is it recommended that the user export to an XML in either Primavera P6 or Microsoft Project Format. | |||||||
Identifiers | |||
Fuzor | Primavera P6 | Asta Powerproject | Microsoft Project |
ID | Activity ID or WBS Code | No Counterpart | No Counterpart |
Name | Activity Name or WBS Name | Name | Task Name |
Durations | |||
Fuzor | Primavera P6 | Asta Powerproject | Microsoft Project |
Duration | At Complete Duration | Duration | Duration |
Planned Duration | Original Duration | Original Duration | No Counterpart |
Actual Duration | Actual Duration | Actual Duration | Actual Duration |
Remaining Duration | Remaining Duration | Duration Remaining | Remaining Duration |
Date Sets | |||
Fuzor | Primavera P6 | Asta Powerproject | Microsoft Project |
Start / End | Start and Finish | Start and Finish | Start and Finish |
Planned | Planned | Original | No Counterpart |
Remaining | Remaining Early | No Counterpart | No Counterpart |
Actual | Actual | Actual | Actual |
Cost Types | |||
Fuzor | Primavera P6 | Asta Powerproject | Microsoft Project |
Labor | Labor or Role | Not supported | Work |
Equipment | Non-Labor | Not supported | No Counterpart |
Expenses | Expenses | Not supported | No Counterpart |
Material | Material | Not supported | Material |
Resources | |||
Fuzor | Primavera P6 | Asta Powerproject | Microsoft Project |
Per Use Price | No Counterpart | Not supported | Per Use Cost |
Overtime Price | Overtime Factor | Not supported | Overtime Cost |
Unit Price | Price / Unit | Not supported | Std. Rate |
Budgeted Units | Planned or Budgeted Units | Not supported | No Counterpart |
Actual Units | Actual Units | Not supported | No Counterpart |
Remaining Units | Remaining Units | Not supported | No Counterpart |
At Completion Units | At Completion Units | Not supported | Units |
Logic and Special Columns | |||
Fuzor | Primavera P6 | Asta Powerproject | Microsoft Project |
% Complete | Duration % Complete | Percent Complete | % Complete |
Constraint Type | Primary Constraint Type | Constraint | Constraint Type |
Constraint Date | Primary Constraint Date | Start Constraint Date or Finish Constraint Date | Constraint Date |
Task Calendar | Activity Calendar | Calendar | Task Calendar |
Total Float/Slack | Total Float | Total Float | Total Slack |