P3 vs. Excel 2007/2010

I need some help. What is the interface problems between P3 & excel 2007/10. Can you still use .dbf files, .csv files ect.

Primavera Project Planner - P3
M
Michael de Kock 👤 Member for 19 years 10 months
· Permalink

Thanks guys, I will try this out.

I know P3 is very outdated, I personaly use P6 & P3.1, the problem is that some of our clients still wants P3 to be used.

M
Michael de Kock 👤 Member for 19 years 10 months
· Permalink

Thanks guys, I will try this out.

I know P3 is very outdated, I personaly use P6 & P3.1, the problem is that some of our clients still wants P3 to be used.

A
Andrew Corton 👤 Member for 23 years
· Permalink

Hi Michael,

I find ASCII .PRN files work, just be careful when setting the column widths. Depending on how you've been managing these files todate you could: double-click the .PRN file which will either prompt you to choose which application to use to open the file (Excel) then follow the wizard to format data columns OR it will open immediately, although in the latter the P3 column data fields will appear in one column - if so separate them using various Excel funtions to get the data into the desired format, (LEFT, MID, RIGHT, TRIM) - I use a template for this.    

.WK1 files follow the same processes as above. However, beware they will only accept the first 2048 data rows, so .PRN is generally more reliable.

Hope this helps

Andrew 

D
Daniel Limson 👤 Member for 24 years 7 months
· Permalink

Hi Michael,

P3 is an old software running on 16 bit and no longer compatble with the latest softwares available in the market. They already stopped developing this software 7-8 years ago. The things I used to do to make my life easy no longer functions even a simple conversion to PDF file, you need an old version of adobe or you can use cute pdf converter. The process that Shareef mention above may work, you can maybe export it but importing back the file does not work either. So my advice is to move or switch to P6.

Best regards,

Daniel

S
Shareef Abdul Azeez 👤 Member for 20 years 8 months
· Permalink

I am not aware of excel 10 but with excel 07 you can use .dbf file

.csv file is not compatible.

Even with .dbf file it does not open directly.

You will have to open excel first and then drag and drop the .dbf file onto the open excel window.

 

Hope this helps

 

 

Best Regards

Shareef A Azeez

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