Mar 23 2022 03:31 AM
when we are trying to import tasks from excel to MS project it show some errors and when we open the file by ignoring the errors then, at the end of task list some randomly generated tasks are there. It's not from the excel I think it's generated by MS project. If anyone knows please help us.
Mar 23 2022 08:45 AM
Mar 23 2022 10:01 PM - edited Mar 23 2022 10:22 PM
1. We are using Append import. Because we need to set the custom project calendar and and project start date. We are also try this by setting up the project as new project , but it's also not working.
2. we are trying to import those fields such as,
ID | Name | SUMMARY | Outline Level | DURATION | Start | Finish | Actual Start | Actual Finish | Successors | PREDECESSORS | % Complete | TASK MODE | Baseline Start | Baseline Finish | CRITICAL | Activity Type | CONSTRAINT_DATE | CONSTRAINT_TYPE |
3. Now we are importing tasks only.
4.
5. We are trying to do is ,we have some data about project. The project contains 8000+ tasks and it has task links. We need to calculate the time duration taken by project and each task.is that everything is going fine. But the bad thing is we cant import the excel to the MS Project with out any errors.
[we are attaching the excel file along with it]
Mar 24 2022 09:34 AM