Product(s):	Bentley Facilities Space Planner
Version(s):	08.11.11.23
Environment:	N\A
Area:	PW Class Editor
Subarea:	N\A

Problem

After creating a new attribute in ProjectWise Class Editor it is not displaying in the correct position in Planner Properties.  The new attribute is showing up at the bottom of the list even though it was specifically placed in the correct order in the ProjectWise Class Editor. 

Since one of the database columns “Rm_Org_Code” currently can only hold 6 characters.  As part of our users requirements they need to extend the size of this column to about 25.  Here are the steps we took to create a new column that can support more characters:

1. Backed up Rm_Org_Code column in the DB.
2. Created a Rm_Org_Code_New attribute with the PW Class editor.
3. Added the Rm_Org_Code_New to the Workstation class.
4. Copied all Rm_Org_Code (6) data over to Rm_Org_Code_New (25).
5. Removed Rm_Org_Code (6).
6. Renamed Rm_Org_Code_New (25) to Rm_Org_Code.

Now that we have done that in our Test environment it appears to have broken the links in Facilities Space Planner.  Now when we open Planner it does not show the “Worksation” in the navigation tree. 
We can revert the changes, but the real question is, ‘Is there another method that we should be using in order to extend the Rm_Org_Code (6) attribute column?’

Solution

You should use Attribute Grouping. Depending on the version of Facilities, you could use the Facilities Administrator to group and order the attributes as needed.

.

Since database operations on adding and deleting columns are challenging, be sure:
1. A different column name is used
2. A different attribute is used
3. The attribute can be named with Label to show different in UI.

Also, running validate class with PW Class Editor is advised after the changes.

It seems as though there are either 2 attributes referring to the same column (either in current or future class) or there is some picklist that should be attached.