hi everyone,
I have a problem when importing an XLS file into P5.
I use an export from P5, run some macros to update some fields, and then import it back into P5.
but it seems that the only field bugging me is the percent complete, which does not import correctly.
in fact, on a 10 activities panel, it has worked for 3 tasks, and every other percentage goes into the "effort_complete_pct" field, which results in no progress at all and a modified upt (which we do not want); in the original export that I modify, the field is clearly stated as "complete_pct", and this field I update, but it seems like when importing, it goes into the wrong field.
I also modify some other fields, like actual start & finish dates, and I even calculate myself, depending on the percentage, the actual_qty & remain_qty on the "TASKRSRC" worksheet.
we looked into it a bit, and saw that every option making fixed duration & upt are on, so now we really don’t know why it acts like this.
last year we used the exact same macros, and it worked fine. we compared both projects, but found no differences in project configuration.
does someone have an idea ?
we’re kind of stuck...
thanks !
I have a problem when importing an XLS file into P5.
I use an export from P5, run some macros to update some fields, and then import it back into P5.
but it seems that the only field bugging me is the percent complete, which does not import correctly.
in fact, on a 10 activities panel, it has worked for 3 tasks, and every other percentage goes into the "effort_complete_pct" field, which results in no progress at all and a modified upt (which we do not want); in the original export that I modify, the field is clearly stated as "complete_pct", and this field I update, but it seems like when importing, it goes into the wrong field.
I also modify some other fields, like actual start & finish dates, and I even calculate myself, depending on the percentage, the actual_qty & remain_qty on the "TASKRSRC" worksheet.
we looked into it a bit, and saw that every option making fixed duration & upt are on, so now we really don’t know why it acts like this.
last year we used the exact same macros, and it worked fine. we compared both projects, but found no differences in project configuration.
does someone have an idea ?
we’re kind of stuck...
thanks !