Importing Activity Data from xls

P
Philip Richards 👤 Member for 22 years 5 months

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

R
Rodel Marasigan 👤 Member for 19 years 7 months

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

Forum Sponsor

Top Posters

Haque Nawaz
10 posts
EViLL1
1 posts
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts