Hello,
I'm trying to import projects for MPP MSProject files. I parse the MPP file using a python script and COM automation to parse the MSProject object model. The script generates a csv file that is imported using the "Import data" tool with the "Activity" import type.
Regarding tasks/activities, I am now able to import the list of the tasks with the parent/child relationship, dates and duration, etc....
However, I have two issues :
1/ I did not find a way to import the predecessor/successor information of the tasks. Is there any way to do that using "import data" tool or another tool ?
2/ Everything is ok with task work (field validatedWork). Task work can be less than a day (let say 0,5 days for example) or may be 3,5 days. However, task duration (fields initialDuration or validatedDuration) cannot be set to less than a day. Moreover, it seems not possible to set task duration to values like 2,25 or 2,5. for example, task duration of 3,5 days seems to be rounded to 4 days with imported. The consequence regarding planning calculation is that 4 tasks of, let say, 0,25 day of duration takes 4 days (of course, when these tasks have predecessor relationship between them 🙂 ) or two tasks of 2,5 days takes 6 days. Did I miss something ?
Regards,
Philippe.
1/ I did not find a way to import the predecessor/successor information of the tasks. Is there any way to do that using "import data" tool or another tool ?
It seems to be a limitation of the tool. Also it seems milestones are not managed.
2/ Everything is ok with task work (field validatedWork). Task work can be less than a day (let say 0,5 days for example) or may be 3,5 days. However, task duration (fields initialDuration or validatedDuration) cannot be set to less than a day. Moreover, it seems not possible to set task duration to values like 2,25 or 2,5. for example, task duration of 3,5 days seems to be rounded to 4 days with imported. The consequence regarding planning calculation is that 4 tasks of, let say, 0,25 day of duration takes 4 days (of course, when these tasks have predecessor relationship between them 🙂 ) or two tasks of 2,5 days takes 6 days. Did I miss something ?
This is not linked to import, it is a ProjeQtOr restriction.
ProjeQtOr :
1) is effort driven
2) manages duration mostly for information, and only in days (duration = end date - start date)
So fixed durations of 0,25 days are not possible : fixed duration are really reserved to major delays
But if you have small tasks of 0,25 work days, with dependencies, planned "asap" you may also face 1 day duration for each in Gantt. This is because in ProjeQtOr, default dependency mode is restrictive : if task B follows task A, start of B is the day after end of B. This can be changed in Global parameters to use non strict dependency mode : this will allow B to start same day as A ends.