Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Problem when importing Excel Xls file to primavera

3 replies [Last post]
haytham saad
User offline. Last seen 2 years 40 weeks ago. Offline
Joined: 12 Apr 2013
Posts: 24

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

Replies

Zoltan Palffy
User offline. Last seen 20 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

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

haytham saad
User offline. Last seen 2 years 40 weeks ago. Offline
Joined: 12 Apr 2013
Posts: 24

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

Zoltan Palffy
User offline. Last seen 20 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

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