Learn best practices to update import and update schedules from other software
Schedules can be imported from another Fuzor project as well as many different external software as XML or CSV. Fuzor retains 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 information in your 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 Load Options Menu. To import an entire schedule select Schedule XML. Otherwise spreadsheet data in XLSX and CSV 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 exporting options for your schedule. You can export your file as a Microsoft Project XML, a Primavera P6 XML, or a Fuzor CSV. When the appropriate file type has been selected click the Save button in this window. The Cancel button cancels saving your schedule. |
...
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 |
...
Alternative to importing an .xml data can also be loaded from XLSX and CSV spreadsheets. When using a spreadsheet to import data the user must specify how that data is imported into Fuzor. While this may take more time on initial setup, this allows the user more control over how the data is imported. settings are preserved and can be exported and reused so that future updates are easier. For more information about which columns can be mapped see Task Table Columns. Notably both WBS and Task Type cannot be populated with column mapping. | |||||||
The column mapping menu can be opened from the 4D Load Options menu or by right clicking a mappable column header and selecting the button that appears. | |||||||
The Load Spreadsheet button opens the file browser for the user to select a spreadsheet to load data from. The Current Column Map list denotes which columns from the spreadsheet should be used to populate specified columns in Fuzor. When a spreadsheet is first loaded the list is empty. | |||||||
When a spreadsheet is loaded the file name is displayed above the settings to add new mappings to the schedule. There are four drop down menus that control how a new mapping is added. | |||||||
The Source Column denotes the column in the spreadsheet where the data is loaded from. Other columns allow the user to select from available Fuzor columns. | |||||||
Column Type specifies a particular column within a set of dates. Possible values are Duration, Start Date, End Date and all supported Cost Types. A Custom Column is also an option from this drop down menu Task or Baseline specifies a particular schedule to populate. Date Type specifies a particular set of durations and dates to populate. Options are Planned, Actual, Start and End, and Remaining. The Add Column Mapping button adds the mapping specified by the drop down menus to the Current Column Map List When all desired columns are mapped use the Apply button to load the data from the spreadsheet |
...