Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Import WBS from Excel

6 replies [Last post]
Fri, 2004-04-30 15:14
Paul Kleppert
User offline. Last seen 30 weeks 1 day ago. Offline
Joined: 30 Apr 2004
Posts: 3
Groups: MS Project for Planners, Petro-Chem / Oil & Gas
I have spent all day trying to understand why my WBS codes will not import from Excel proprerly. The report says "Blank level of WBS value detected, omit processing WBS part of import record". I have read/asked and knowone knows what is happening. Has anyone run into this problem before or know what is happening?

Paul
Top

Replies

Tue, 2017-09-05 13:01
#1
Zoltan Palffy
User offline. Last seen 3 weeks 5 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

unless you use sdk you really cant import the structure only the assignments of the wbs codes to the individual activities. 

If you are using anyhting later than verison 8.4 sdk wil not work 

Top
Mon, 2017-09-04 12:08
#2
Hendrik Oosthuizen
User offline. Last seen 2 years 32 weeks ago. Offline
Joined: 4 Sep 2017
Posts: 3
Groups: Building Information Modelling, Expat Opportunity, Petro-Chem / Oil & Gas, Planning, Claims & Contracting, TURNAROUND & SHUTDOWN (T/A & S/D)

Please do not take me on, on this but it is always recommended that you put the first line manually in P6. Then do your input. It will also apply for import of resources as well.

Top
Sun, 2017-06-25 01:10
#3
Shree Abdullah
User offline. Last seen 3 years 42 weeks ago. Offline
Joined: 12 Aug 2016
Posts: 15
Groups: None

i am unable to import wbs name into p6. it imports the wbs code activities and their ids but the name of wbs does not import. please help me out on this. thank you

Top
Sun, 2004-05-02 04:11
#4
MK TSE
User offline. Last seen 3 years 46 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
May I know the import WBS codes is to WBS dictionary or against each activities?
If WBS dictionary, please note the sequence of data, the spacing between characters and format of the code value.
If WBS against activities, please check the data format.
Top
Sat, 2004-05-01 07:26
#5
Luca Basile
User offline. Last seen 9 years 10 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Have You try the excel utility given in P3 CD-ROM, to import and export WBS structure of the projects?
It should not be affected if some level are "blanck" as look like from You post.
Is in the RA folder.
Top
Sat, 2004-05-01 00:16
#6
MK TSE
User offline. Last seen 3 years 46 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
I think it is the sequence of data only. For example, import 1.3 before 1.3.1
Top