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

T
Tom Morgan 👤 Member for 9 years 2 months

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 5 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 11 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 5 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 2 months

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

T
Tom Morgan 👤 Member for 9 years 2 months

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 2 months

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 19 years

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 19 years

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

James Williams
74 posts
Erim INANC
2 posts
gorilpk
0 posts
Ricky
0 posts
pinoyplanner
1 posts
Siddharth Ranadive
1 posts
Aidar Kurmantayev
0 posts
Dave Morgan
0 posts
blake333_
0 posts
Mohammed Netarwala
12 posts