hi all,
I've developped a tool a few years ago, that allowed planner colleagues to enter daily follow-up by scanning barcodes.
this tool is still used today, but it's a pain in the ass partly because of the use of excel files to import/export from P6.
I'm currently looking into improving this tool by bypassing excel and accessing directly the SQL database.
that I've done, but I can't seem to find the field for DURATION PERCENT COMPLETE (we work this way - we update the duration %, and P6 calculates the remaining duration for us - it's easier for the people on field to check 4 boxes : 25% 50% 75% or 100%)
I've found the physical one, it's in the TASK table, but I'm starting to assume I'll have to manually calculate the remaining duration and enter it in SQL so that P6 calculates itself the percentage.
or has anyone found the field I'm looking for ?
thanks,
djo
