Skip to content
ProjectControls.com
Primavera Project Planner - P3

Import/Export

In the Open Standard
Jonathan WardMember for 19 years 8 months
Created
7
2
0
Hello,
this will probably be somewhat of a no-brainer to most of you,, exporting data from P3 is not an issue, however importing does not work with such ease, i am using the exported .DBF file as a template to add the data that i wish to import back into P3, all of the new activities that i add onto the sheet are given a unique activity ID and i think everything else is correct, i can not get excel to save the data that i am changing in the .dbf file, excel gives a dialog box to say that data may be lost, all of the changes i make are lost from the .dbf file that i have saved!!! jolly frustrating
Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Hannes de Bruyne ·
    #1
    Hi

    something I learned in this forum some time ago:

    in the Excel menu look at Insert->Name. Here you wil find a range called "database". This range must be changed to the new range. Thats all.

    Hannes
    Report
  2. 0
    Jonathan Ward ·
    #2
    thanks for your help, think i may still be missing something here, i have selected all of the new data that i have entered on the sheet, gone to Insert-Name-apply, then having selected ’database’ i get the error that reads ’Microsoft Excel cannot find any references to replace’, the file will not retain any of the data that i have entered?
    Report
  3. 0
    Rodel Marasigan ·
    #3
    Hi Jonathan,

    1) Use Insert-> Name-> Define
    2) then select "Database"
    3) Erase the range on Refer to box
    4) Hilight the range to you want for Database
    5) Click Add and then Okay

    That should change the range of your database.

    Regards,
    Rodel
    Report
  4. 0
    Steven Oliver ·
    #4
    Why not use the wk* format ?
    Report
  5. 0
    Jonathan Ward ·
    #5
    that is great, thank you all very much for your help
    Report
  6. 0
    Santosh Bhat ·
    #6
    2048 lines to be exact.

    Oh and if you’re importing as DBF file type, the field types take their values from the row below the headings. So if your first row contains blanks, adn the second row contains a date, then the DBF file will import that field as a text field and will not import the dates correctly.

    Report
  7. 0
    Tommy James Nuneza ·
    #7

    Dear all, I have problem in

    Dear all,

     

    I have problem in importing xer p6 file.

    Error occur "CVRCU-1939-9  Default value  provided for field ev_compute_type is not valid"

    Waiting for your inputs.

     

    COCOY

    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?