Importing and Exporting from excel to P6

Hi everyone

PLease explain why some data imported from excel file cannot be read in P6.

What is the reason. How P6 read or store data?

What are the things that should be done to the data in order for us to succesfully import to P6.

THank you for the explaination in advance.

 

Z
Zoltan Palffy 👤 Member for 16 years 10 months

for the most part this is true but some dates can be imported.

But generally speaking it is beacuse they fields are calculated

What is it you want to import

Also you can use SDK and import anything 

S
Suhaila Tsu 👤 Member for 15 years

Hi Santosh Bhat

Meaning only certain field in P6 can be loaded in excel and then imported back right?

Thank you Santosh!

S
Santosh Bhat 👤 Member for 21 years 1 month

The best method is to export out a sample of data, continnue populating the list and then import. Note that any field exported with a (*) cannot be imported - usually becuase this is a calculated field - such as dates.

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