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.

to import excell files(.xls) to P3e

3 replies [Last post]
Wed, 2007-12-12 04:04
shaerah rahman
User offline. Last seen 13 years 5 weeks ago. Offline
Joined: 24 Apr 2007
Posts: 9
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
im having problem to import .xls files to P3e. The problem is on the ’Import project options’. Please.
Top

Replies

Fri, 2008-01-04 00:23
#1
K D
User offline. Last seen 15 years 27 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
Hi shearad.
Could you elaborate your problem sothat we can help you better?
Thanks
Top
Thu, 2007-12-20 00:31
#2
Donny Lai
User offline. Last seen 6 years 15 weeks ago. Offline
Joined: 19 Dec 2007
Posts: 8
Groups: Petro-Chem / Oil & Gas
Ms. Shaerah,

Also could be due to requirement in P5 (the correct terminology apparently) of having superuser access to import. Cheers.....
Top
Mon, 2007-12-17 07:25
#3
David Podmore
User offline. Last seen 12 years 14 weeks ago. Offline
Joined: 26 Apr 2006
Posts: 74
Groups: None
Hi,

My advice is to start by exporting a small sample representative of the data you wish to import. This gives you a template XLS file into which you can cut and paste your required import data. Unfortunately, this is not as simple as it sounds. You need to ensure the Excel data is in the same format as that exported. Also, when exporting/importing relationships and resources etc, the export produces multiple tabs (sheets) in the one export XLS file. Thus, all tabs must be compiled correctly. E.g. there is one row of data for each relationship for a single task.
Again, export to XLS and see what I mean.
Top