View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - MSProject Import - ProjeQtOr
 

MSProject Import

More
16 Oct 2015 07:20 #1 by pbourgault
MSProject Import was created by pbourgault
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.

Please Log in or Create an account to join the conversation.

More
16 Oct 2015 09:41 #2 by babynus
Replied by babynus on topic MSProject Import

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.
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: pbourgault

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.038 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form