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.

How to create the WBS in excel to import to P6???

15 replies [Last post]
Aitor Rodriguez
User offline. Last seen 13 years 47 weeks ago. Offline
Joined: 24 Mar 2009
Posts: 8
Hello, first sorry for my English, I know I’ve to improved it. My dude is:

I’ve a problem, I’d like to import an excel file in which I’ve created the WBS to create a new project but I can’t do it. Some people told me that it’s impossible because when you export an excel file of P6 if the row have (*) you canĀ“t change it. Is it true?

Please, if you know how to do it tell me it.

Thanks for your comment.

Replies

Kirill PM
User offline. Last seen 4 years 11 weeks ago. Offline
Joined: 9 Mar 2016
Posts: 14
Groups: None

The picture disappeared somewhere))

Check another topic for video in English

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

where ?

Kirill PM
User offline. Last seen 4 years 11 weeks ago. Offline
Joined: 9 Mar 2016
Posts: 14
Groups: None

Sure)

6243
snimok_ekrana_2018-11-07_v_23.30.54.png

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

Kirill is there and english version of your tool box ?

Mohammed Ali
User offline. Last seen 1 year 46 weeks ago. Offline
Joined: 16 Mar 2018
Posts: 72
Groups: None

You can try this tool that can perform all tasks from Primavera to Excel and vice versa.

http://www.mediafire.com/file/ougb7bfikqdae9n/PM_Advanced.xlsm/file

where this video <in English> explains exactly how you can use it      https://youtu.be/YjVqyzOCgSE

The link of the same video <in Arrabic> is     https://youtu.be/VbAuokYeJWk

In addition to some extra features it performs the all tasks of the 4 Excel-Sdk files :

 <ACTIVITY6v83.xls> <PROJECTv83.xls> <Dictionary6v7.xls> <WBS6v6.xls>

The links of the three videos that illustrates how you can use the magic tool to export the Dictionary, Project, WBS and Activities data to the Primavera database

Primavera Excel SDK Connection Export WBS & Activities Part 3
https://youtu.be/lO0HLvHnu1Q

Primavera Excel SDK Connection Export Project & Dictionary Part 2
https://youtu.be/aeP4-QUNW8w

Primavera Excel SDK Connection Export Project & Dictionary Part 1
https://youtu.be/K_kmIBsUxxY

Kirill PM
User offline. Last seen 4 years 11 weeks ago. Offline
Joined: 9 Mar 2016
Posts: 14
Groups: None

I developed tool named ToolBox that could make wbs structure from Excel file.

Check video how it works:

https://youtu.be/EbgFE4UtcXU

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

that is true any item that has a * on it it can not be imported but the work around is to use SDk and import it that way 

Tareq Mahmoud
User offline. Last seen 5 years 6 weeks ago. Offline
Joined: 15 Sep 2012
Posts: 3
Groups: None

Liam Gaudy Send message to Liam Gaudy

Please send me the XLS file 
ORYou please invite me to your blog When I try to download this (http://www.li-am.com/p/p6xl.html)I got an error:This blog is open to invited readers only

http://www.li-am.com/

Khuong Do
User offline. Last seen 2 years 3 weeks ago. Offline
Joined: 22 Feb 2010
Posts: 118
Groups: None

Hi,

You can download the Primavera SDK Excel file in my blog : https://doduykhuong.wordpress.com/2016/06/29/primavera-sdk-excel-file-to-import-export-data/

Cheer

Liam Gaudy
User offline. Last seen 9 years 2 weeks ago. Offline
Joined: 18 Jun 2013
Posts: 8
Groups: None

Hello. I developed a new tool in Excel that helps with this kind of automation. It is called the P6XL Bridge. It allows the user to manage their P6 schedule data in Excel and get the results live without importing. It uses the SDK in the background. The link is below. I hope it could be of use to you.

 http://code.google.com/p/p6xl/

mimoune djouallah
User offline. Last seen 4 years 40 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388

i made a step by step tutorial how to import the WBS from Excel to primavera using the sdk, hope you find it useful.

http://www.plannertuts.com/tutorials/how-to-import-wbs-from-excel-to-pri...

regards

mimoune

Alhasan Abdalla
User offline. Last seen 11 years 30 weeks ago. Offline
Joined: 21 Apr 2011
Posts: 13
Groups: None

here is the link to the latest sdk

http://www.eh.com.au/software.html

Aitor Rodriguez
User offline. Last seen 13 years 47 weeks ago. Offline
Joined: 24 Mar 2009
Posts: 8
Thanks for your comments, very useful.
Arnold Puy
User offline. Last seen 9 years 12 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Aitor,

In addition to Ian info, you can try the link below:

http://knowledgebase.primavera.com/attachment/PATTLNK_1172008_031-WBS.xls

You can then create & define WBS similar to Activity Codes. However, you need to have SDK installed into your machine.

Regards,

Arnold
Ian Nicholson
User offline. Last seen 14 years 3 weeks ago. Offline
Joined: 29 Jan 2010
Posts: 42
You can create a WBS through Excel using the XER parser that is available on the Oracle Primavera Knowledgebase.

You can create and XER, modify it in Excel using the parser and then re-import it and the WBS elements will be created.

The Excel native import only supports activities and resources, not WBS element import.

http://www.emerald-associates.com