Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Export P3 files to Excel Pls.HELP!!!!!!!!!

4 replies [Last post]
Thu, 2007-12-13 03:11
hesham haridi
User offline. Last seen 12 years 11 weeks ago. Offline
Joined: 18 Oct 2007
Posts: 5
Groups: Civil Engineering
Hi all,
realy i face a problem when i export P3 file to excel if this project exceed on 2500 activities how can overcom on this problem.
Regards...
Top

Replies

Tue, 2008-01-08 04:00
#1
Rajesh Moolakkandam
User offline. Last seen 8 years 18 weeks ago. Offline
Joined: 5 Jun 2004
Posts: 15
Groups: Petro-Chem / Oil & Gas
Hi Hesham haridi,

Export to .DBF format only. Then you save to .xls and format the cells. .WKS is limited to around 2000 activities only.

Rajesh M
Top
Thu, 2007-12-13 09:08
#2
Pranab Kumar Deb
User offline. Last seen 3 years 17 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 291
Groups: Civil Engineering
Hello Hesham,
WKS supports only 2048 activities so u have to do the export import in two or more times or do it by selecting .dbf in export and import.
regards
deb
Top
Thu, 2007-12-13 04:27
#3
James Barnes
User offline. Last seen 1 year 27 weeks ago. Offline
Joined: 6 Sep 2007
Posts: 243
Groups: Petro-Chem / Oil & Gas
hesham

Are you exporting to .WKS or .DBF?

Always export to .DBF, .WKS does act funny with larger plans and I think has a restriction on total number of activities.

If you are exporting to manipulate the data and re-import, take care to check your data properly as some flavours of excel don’t handle .DBF files too well and will sometimes snip data (and I think perhaps the newest versions don’t support .DBF at all...?). Back up the "clean" plan before committing to the import aswell.
Top