Problem when importing Excel Xls file to primavera

I have a problem when importing excel to primavera version 6.7 the issue that i export XLS file for resource assignment including Activities & Resource & resource assignment but with applying some filter , after i update the resource data and import back the XLS file by importing resource assignment only ,comes the problem that some actual data is changed like Actual start and actual finish also the remaining duration is going crazy for some activities it gives something like 2465 days also some %complete is changed to 0

Z
Zoltan Palffy 👤 Member for 16 years 10 months

what is your activity type and duration type on the activites that are changing 

if the activity type is resource dependant then this would be why the durations are changing 

also if the duration type is fixed units this could be why the durations are changing

H
haytham saad 👤 Member for 13 years 1 month

thnxx zoltan , but i already did this and still remaining durations is changed and % complete is set to zero  for some activities that was having value before importing is thre any other issue to try

Z
Zoltan Palffy 👤 Member for 16 years 10 months

the changing of actual dates is impossible since you are only importing resource assignments

to make sure that no actual date even has a chance to be changed do not export the Activities only export the Resource & Resource assignments

then only import the resource assignments

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts