Tips on using this forum..

(1) Explain your problem as best as you can. Don't simply post "XYZ Isn't working". What is it you expected or wanted? 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???

13 replies [Last post]
Aitor Rodriguez
User offline. Last seen 8 years 23 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 5 hours 38 min ago. Offline
Joined: 9 Mar 2016
Posts: 9
Groups: None

Sure)

6243
snimok_ekrana_2018-11-07_v_23.30.54.png

Zoltan Palffy
User offline. Last seen 12 hours 45 min ago. Offline
Joined: 13 Jul 2009
Posts: 2019

Kirill is there and english version of your tool box ?

Mohammed Ali
User offline. Last seen 1 week 2 days ago. Offline
Joined: 16 Mar 2018
Posts: 13
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 :

The activity file          <ACTIVITY6v83.xls>

The project file          <PROJECTv83.xls>

The dictionary file      <Dictionary6v7.xls>

The WBS file.            <WBS6v6.xls>

Kirill PM
User offline. Last seen 5 hours 38 min ago. Offline
Joined: 9 Mar 2016
Posts: 9
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 12 hours 45 min ago. Offline
Joined: 13 Jul 2009
Posts: 2019

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 2 weeks 18 hours 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 12 weeks 1 day ago. Offline
Joined: 21 Feb 2010
Posts: 109
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 3 years 31 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 20 weeks 1 day ago. Offline
Joined: 14 Oct 2006
Posts: 386

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 6 years 6 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 8 years 23 weeks ago. Offline
Joined: 24 Mar 2009
Posts: 8
Thanks for your comments, very useful.
Arnold Puy
User offline. Last seen 3 years 40 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 8 years 31 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