If you export the template it should be okay. Date format is in text but it also accept any date format in excel. If you are importing finish milestone activity you should input only the Early Finish date. If start milestone activity then only Early Start.
Import Structure:
Activity ID
Activity Status
WBS Code
These three fields is a must and should enter the data. If you are not familiar on these function, I suggest that before exporting your template, enter a sample data of each activity type that you want to import so you will have an idea of what kind of format when you enter the data into your template. If you include duration it overide your date and use the project calendar.
Member for
21 years 10 monthsRE: Importing Activity Data from xls
Rodel
Thanks, but I have followed your advice, and still no joy.
I have managed a workaround, by importing the xls to P3, then converting the P3 programme to P5.
Regards
Phil
Member for
19 yearsRE: Importing Activity Data from xls
Philip,
If you export the template it should be okay. Date format is in text but it also accept any date format in excel. If you are importing finish milestone activity you should input only the Early Finish date. If start milestone activity then only Early Start.
Import Structure:
Activity ID
Activity Status
WBS Code
These three fields is a must and should enter the data. If you are not familiar on these function, I suggest that before exporting your template, enter a sample data of each activity type that you want to import so you will have an idea of what kind of format when you enter the data into your template. If you include duration it overide your date and use the project calendar.
Regards,
Rodel