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