Importing and Updating Schedules

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. 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 macro tasks. 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