Excel Import in P6 16.2 error message.... PLZ HELP

T
Tom Morgan 👤 Member for 9 years 1 month

I am trying to import a line, list IDs and Activity name is all i really need. In 16.2 it is giving me this error message....

The User Preferences used to create this Excel file are not the same as your current preferences. Importing this file could corrupt your data.  Please refer to Help for more information about importing data from Excel. Are you sure that you want to continue?

Running office 13 same steps i always used in 15.2, 7 and 8

When it finally gets through it only adds 1 activity. Anyone else have this problem and find a solution?

B
bryan fardyanto 👤 Member for 13 years 4 months

Dear All , problem for import  excel file  to primavera 16.2, maybe  anyone  can help solution  information  , [[wysiwyg_imageupload:6568:]]

Z
Zoltan Palffy 👤 Member for 16 years 10 months

you usually get this error when the format of the excel file being imported is different from the current user prefernce settings and the project settings are different for these fields 

Duration Type IE. fixed Duration and Units /time 

Quanity type IE. hours

Date format IE. dd-mmm-yy

Currency format IE. Dollars 

B
bryan fardyanto 👤 Member for 13 years 4 months

Dear All, please need your help  with my problem Primavera 16.2, is not working properly  the problem information  :The User Preferences used to create this Excel file are not the same as your current preferences. Importing this file could corrupt your data.  Please refer to Help for more information about importing data from Excel. Are you sure that you want to continue?

T
Tom Morgan 👤 Member for 9 years 1 month

For reference if anyone else has this problem the Patch for 16.2.6 fixed the issue

T
Tom Morgan 👤 Member for 9 years 1 month

i am getting this error

ERROR: Failed to find a matching object for Activity

ERROR: Failed to find a matching object for Activity
T
Tom Morgan 👤 Member for 9 years 1 month

I exported out added my line list and activity numbering then it only adds the 1 activity on the way back in.... its getting frustrating! I tried my import template from 15.2 and it hasnt worked either. 

E
Ed Jones 👤 Member for 18 years 11 months

You did not create the export file or the template you used.  Create a similiar tempalte yourself by running an export.  Then copy paste the data from the import you are trying to run to your new file.  Should work with no problem.

E
Ed Jones 👤 Member for 18 years 11 months

You did not create the export file or the template you used.  Create a similiar tempalte yourself by running an export.  Then copy paste the data from the import you are trying to run to your new file.  Should work with no problem.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts