Skip to content
ProjectControls.com
Primavera Project Planner - P3

Import to Excel

In the Open Standard
Alberto ClaveronMember for 18 years 1 month
Created
4
2
0

Some activities of my resources has 8 digits number,but when i import it in Excel using Resources-Tabular-Loading and save it in DBF format the figures has been limited to 5 digits.Please help how to correct so i can make my weekly plan & "S" cuve.

Thank you.
Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Harzelli Bouasria ·
    #1
    hi
    open your file with excel and change number of digit with cell format
    Report
  2. 0
    Safak Vural ·
    #2
    Hi,

    You shall make column width 15(max) and decimal 2(max) at Format Section of your Loading Report Interface in P3.

    Regards,

    Safak VURAL
    Report
  3. 0
    Alberto Claveron ·
    #3
    Hi Safak & Harzelli,
    I did what you have suggested but when i generate report in P3 a message shows "A Rich Text Format Document is too long.Failed to open Document".If i export it in CSV Format some of the activities which i input million units say 11,031,635.21 becomes 11,031.00.Changing number of digits in cell format in excel doesn’t make a difference too. My schedule has 635 activities and 94 weeks duration.
    Thank you & Regards...
    Report
  4. 0
    Safak Vural ·
    #4
    Dear Alberto,

    Select export to CSV file and use 2 decimals.

    You may need to change decimal sign of windows . to , or vice versa.

    Regards,

    Safak VURAL


    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?