Convert Activity Codes to WBS

This should be easy, provided you had earlier structured the activities into WBS. Go to View, click Group and Sort->customize->under Group by select WBS. Then apply and click ok. Now you can activities sorted by WBS. 

In case you haven't created WBS and were using activity codes to sort. You need to first create the WBS by going to Project->WBS. Having done this, you then need to go to activity window, select each activity under general tab you can find WBS linking tab. Then start establishing the link between the WBS and activities. Other easy way if your activity codes resemble to same wbs. Insert a column wbs in the window and select first activity and select the wbs. Now select the activity and along with other activities falling under the same wbs using control key or shift key and use fill down option. 

Hope this will adress the issue.

Michiel,

For other software such as Old SureTrak with the use of a provided script you could do it, also it is embedded in Spider Project.  You just need to tell the software which activity codes you want to use and the hierarchy order they will be organized.

With Spider we have unlimited WBS Structures or Dictionaries so you can define several WBS using different codes and codes hierarchy order.

If you send me the Xer file with the list(s) of activity codes and the order I can create several files for you with the desired combinations.  Maybe with the use of a user defined field we can save several of the WBS codes so you can use a global change to switch WBS.  I have never tried it before but we can try. 

Best Regards,

Rafael

@Rafael:

I would like to thank you for your offer to help me to create the files. but I am looking for a more permanent solution we can use across my company. I will take a look at Spider Project, thanks.

@ Khaja

The problem is I don't have a WBS, the schedule is grouped by using activity codes, I am looking for a way to more or less atomatically convert the result I get bij grouping by activity code to a WBS.

Michiel,

I suggest you use the excel through SDK. Or copy paste those codes into wbs pane.

Regards,

@Raymund

We use a network installation of P6 on a citrix-server, I don't think it is possible for me to use the SDK, I am checking with our ICT-guys to see if this is possible.

Michiel,

Check out the Project and import to another PC with standalone. After completing the Job Check in back to the Server.

Hope this will help

Michiel,

If the Citrix server is emulating windows XP then if you can get a license of SureTrack it shall run and give you access to the XER to P3 file converter as well as to the P3 to XER.  Using the SureTrak provided script might do it. 

Not bad for one time execution on each job you and your co-workers have such need. 

Of course you might use SureTrak to get the MSP files directly and keep your single WBS as P6 is not capable of handling multiple WBS. 

Good Luck,

Rafael

Hi Michiel,

The only fastest and easisest way to create WBS is by using the SDK. However, If you cannot access your SDK you can then use the Microsoft Access as shown below: I have the steps created out of this.

Cheers,

Arnold

@Arnold:

I am very interested in the steps you mention, are you willing to share these, either on the forum of by email?