Import/Export

Primavera Project Planner - P3
T
Tommy James Nuneza 👤 Member for 10 years 8 months
· Permalink

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

S
Santosh Bhat 👤 Member for 21 years 1 month
· Permalink

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.


R
Rodel Marasigan 👤 Member for 19 years 7 months
· Permalink

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

J
Jonathan Ward 👤 Member for 19 years 4 months
· Permalink

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?

H
Hannes de Bruyne 👤 Member for 20 years 10 months
· Permalink

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

Forum Sponsor

Top Posters

MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
Hunais M J
0 posts