7.5.1. Importing tasks from Microsoft Project

Celoxis can directly import tasks from Microsoft Project™ files (mpp or xml files) into an existing project. You must first create a project using one of the above methods. Task details including their parent-child relationships, dependencies, constraints and resources are imported.

[Note]Note

To maintain dates correctly, your working hours in Microsoft Project should be same as that in Celoxis and the calendar in Microsoft Project should have the same holidays as entered in Celoxis.

Field Mapping

Table 7.1. Celoxis to Microsoft Project field mapping

CeloxisMicrosoft Project
NameName
StartStart
FinishFinish
DurationDuration
Constraint TypeConstraint Type
Constraint DateConstraint Date
DescriptionNotes
Percent CompletePercent Complete
Fixed CostFixed Cost
PriorityPriority (High/Low and Higher/Lower maps to High/Low, Highest/Lowest to Highest/Lowest)

Limitations:

  • Only predecessors of type FS are imported including lead and lag time.

  • All parent-child relationships are imported.

  • Resources are imported including their individual percentage assignments.

  • As Late As Possible (ALAP) constraint is not supported.

Import tasks from Microsoft Project ™,

  1. First save your Microsoft Project plan as a mpp or xml file.

  2. Select the project into which you want to import the tasks.

  3. From the sub menu bar click TaskImport tasks from Microsoft Project

  4. Click Choose File. Select your MS Project file an click Next

    Import MSP step 1

    Figure 7.3. Import MSP step 1


  5. Map resources from MS Project to corresponding Celoxis users. After the Microsoft Project Plan is imported, these mapped users are allocated to tasks. If you are importing tasks that was previously exported from Celoxis, the mapping will be automatic. However, you can still change it if you like.

    Import MSP step 2

    Figure 7.4. Import MSP step 2


  6. Select tasks to delete that exist in Celoxis but are not in Microsoft Project. If there are no such tasks, this step will not be shown. This is useful if you changed the plan in Microsoft Project and want to delete some or part of the original plan.

  7. Submit