Skip to content
ProjectControls.com
Oracle Primavera - PM6

XLSX

In the Open Standard
Meobeo UMember for 7 years 8 months
Created
2
2
0

Hello there!

I am having issues while importing units and durations on P6, using XLSX files. 

When I import floating point values, it ignores the decimal point and import as an integer. For example, importing 12.05 and it writes 1,205 in the database. 

Does anybody have any idea on why does it happen and how to fix it?

I tried the oracle support here in Brazil but the company analysts only search the knowledge base and send default answers and workarounds that generally don't work. 

I am using P6 PRofessional R16.2 Release 16.2.7 (Build #: 23684).

Thank you!!!

Lee!

Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    what is your units per day

    what is your units per day set on your resource ?

    a quick fix would be to run a global change 

    where budgeted cost is not equal to 0

    then budgeted cost  = budgeted cost / 100

    or 

    where budgeted units is not equal to 0

    then budgeted units  = budgeted units / 100

    Report
  2. 0
    Shaohua Chen ·
    #2

    Could you check the resource

    Could you check the resource usage ---graph--calcualte average ?

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?