Skip to content
ProjectControls.com
Oracle Primavera - PM6

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

In the Open Standard
Aitor RodriguezMember for 17 years 6 months
Created
15
5
0
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.
Save Follow Follow forum Report
Reply New topic

15 replies

Oldest first
  1. 0
    Ian Nicholson ·
    #1
    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
    Report
  2. 0
    Arnold Puy ·
    #2
    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
    Report
  3. 0
    Aitor Rodriguez ·
    #3
    Thanks for your comments, very useful.
    Report
  4. 0
    Alhasan Abdalla ·
    #4

    here is the link to the

    here is the link to the latest sdk

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

    Report
  5. 0
    Mimoune Djouallah ·
    #5

    i made a step by step

    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-primavera-p6-using-the-sdk-722/

    regards

    mimoune

    Report
  6. 0
    Liam Gaudy ·
    #6

    Hello. I developed a new tool

    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/

    Report
  7. 0
    Khuong Do ·
    #7

    Hi,You can download the

    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

    Report
  8. 0
    Tareq Mahmoud ·
    #8

    @ Liam Gaudy Please send me

    @ Liam Gaudy Send message to Liam Gaudy

    Please send me the XLS file 
    OR
    You 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/

    Report
  9. 0
    Zoltan Palffy ·
    #9

    that is true any item that

    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 

    Report
  10. 0
    Kirill PM ·
    #10

    I developed tool named

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

    Check video how it works:

    https://youtu.be/EbgFE4UtcXU

    Report
  11. 0
    Zoltan Palffy ·
    #11

    Kirill is there and english

    Kirill is there and english version of your tool box ?

    Report
  12. 0
    Kirill PM ·
    #12

    Sure)

    Sure)

    Report
  13. 0
    Mohammed Ali ·
    #13

    You can try this tool that

    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

    Report
  14. 0
    Zoltan Palffy ·
    #14

    where ?

    where ?

    Report
  15. 0
    Kirill PM ·
    #15

    The picture disappeared

    The picture disappeared somewhere))

    Check another topic for video in English

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?