How to create the WBS in excel to import to P6???
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
The picture disappeared somewhere))
Check another topic for video in English
where ?
Sure)
[[wysiwyg_imageupload:6243:]]
Kirill is there and english version of your tool box ?
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
I developed tool named ToolBox that could make wbs structure from Excel file.
Check video how it works:
https://youtu.be/EbgFE4UtcXU
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
@ Liam Gaudy
OR
This blog is open to invited readers only
http://www.li-am.com/
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
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 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-pr…
regards
mimoune
here is the link to the latest sdk
http://www.eh.com.au/software.html
Thanks for your comments, very useful.
Hi Aitor,
In addition to Ian info, you can try the link below:
http://knowledgebase.primavera.com/attachment/PATTLNK_1172008_031-WBS.x…
You can then create & define WBS similar to Activity Codes. However, you need to have SDK installed into your machine.
Regards,
Arnold
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