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

K
Kirill PM 👤 Member for 10 years 2 months

The picture disappeared somewhere))

Check another topic for video in English

M
Mohammed Ali 👤 Member for 8 years 2 months

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

Z
Zoltan Palffy 👤 Member for 16 years 10 months

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 

L
Liam Gaudy 👤 Member for 12 years 11 months

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/

I
Ian Nicholson 👤 Member for 16 years 4 months

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

Forum Sponsor

Top Posters

Nigel Hussey
1 posts
James Williams
74 posts
Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts