Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". 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.

Imprt WBS from XLS

3 replies [Last post]
Tue, 2008-03-04 04:57
Philip Richards
User offline. Last seen 15 years 31 weeks ago. Offline
Joined: 7 Jan 2004
Posts: 29
Groups: None
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?
Top

Replies

Wed, 2008-03-05 01:25
#1
Lorne Bussell
User offline. Last seen 33 weeks 6 days ago. Offline
Joined: 8 Aug 2006
Posts: 17
Groups: Petro-Chem / Oil & Gas
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
Top
Tue, 2008-03-04 11:21
#2
Philip Richards
User offline. Last seen 15 years 31 weeks ago. Offline
Joined: 7 Jan 2004
Posts: 29
Groups: None
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
Top
Tue, 2008-03-04 10:57
#3
Mark Chapman
User offline. Last seen 8 years 46 weeks ago. Offline
Joined: 18 May 2006
Posts: 183
Groups: None
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
Top