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.

Import via excel into the WBS table

5 replies [Last post]
Thu, 2010-09-16 13:16
Mark Dunn
User offline. Last seen 11 years 38 weeks ago. Offline
Joined: 14 Sep 2010
Posts: 8
Groups: None

Using P 6.2.1, I want to import into the WBS table via excel (to save typing). Anyone know how to do this?  Thanks, Mark

Top

Replies

Thu, 2012-01-19 14:56
#1
mimoune djouallah
User offline. Last seen 5 years 6 days ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team

Mark

 

ok a little late, i have made a guide how to import a wbs iinto Primavera P6, either using the sdk or the xer parser.

the process is rather time consuming but it give a good idea how the database treat the wbs structure.

http://www.plannertuts.com/uncategorized/using-primaveras-xer-file-parse...

 

hope this help.

regards

mimoune

Top
Wed, 2010-09-29 08:50
#2
jeoffrey reyes
User offline. Last seen 4 years 4 weeks ago. Offline
Joined: 19 Jun 2008
Posts: 214
Groups: GPC Qatar, Pinoy Planning Planet Community

Hi Mark,

 

You can use also SDK.

Cheers,

Top
Fri, 2010-09-17 10:54
#3
Mark Dunn
User offline. Last seen 11 years 38 weeks ago. Offline
Joined: 14 Sep 2010
Posts: 8
Groups: None

Thanks guys.

Top
Fri, 2010-09-17 05:32
#4
Arend Kok
User offline. Last seen 10 years 29 weeks ago. Offline
Joined: 19 May 2008
Posts: 38
Groups: Petro-Chem / Oil & Gas

The .xer file parser is another usefull way to do this.

Top
Thu, 2010-09-16 22:05
#5
Richard Rush
User offline. Last seen 9 years 33 weeks ago. Offline
Joined: 1 Jan 2004
Posts: 31
Groups: None

Mark,

 

2 methods :-

 

Excel to Project.xls to P3.1 to P6

or Excel to MS Project (Outlining defines the WBS tree) to P6

 

Best Regards

Top