Skip to content

Imprt WBS from XLS

Philip RichardsMember for 22 years 9 months
Created
3
1
0
For ease & versitility, I structure my P5 programmes using Activity Codes, rather than WBS.

I now have a requirement to export to MS Project.

Because I have no WBS set up, the structure will not be carried over.

My initial plan was to export activities (with Activity Codes) to XLS, Use activity code values to set up WBS, and import back to P5.

Is there a facility to do this?

We are about to upgrade to P6. Is there a solution in P6?

3 replies

Oldest first
  1. 0
    Mark Chapman ·
    Hi Phil,

    Moving to P6 already! To import wbs from excel the best tool to use is the SDK (System developers kit). Download this from POINT.

    I hope all is well,

    Mark
  2. 0
    Philip Richards ·
    Hi Mark

    We have SDK, which we use with the ’Dictionary.xls’. But there is no facility to import WBS. Is there another way of accessing the SDK?

    Phil
  3. 0
    Lorne Bussell ·
    Philip,

    I hate say it but... "this is an existing enhancement request" that said, check out knowledge base article prim33867 for a workaround. It does however require some pretty techie skills. Another method may be to use an access front end via sdk to edit the tables but from what I have seen they are may not be to easy to use either.

    Cheers,
    Lorne

Log in or join to reply

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

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