ProjectWise now allows you to add new attributes and to delete old ones from an Environment; But what about the attribute that is now too small or the wrong data type? Are you stuck with the past?
This blog is going to show you how to replace one field in your environment with another using the ProjectWise Administrator and Explorer GUI, ensuring that you won’t break your database by making changes directly in SQL or Oracle. (Which by the way you should NEVER do!) You can use this process on an existing database any time you need to change an attribute’s width or change from numeric or date data types after the database has been in production.
This is an example of changing the size (Chars) of an Attribute. The first step is to create the new attribute in the environment that will replace the old one. The create a second attribute that will trigger the new attribute to update its value to that of the old attribute. The second step is to make the change to the new attribute. Third step is to replace the orginal attribute with the new one in interfaces and views. Fourth step once your are comfortable that the data is sound is to delete the onl attribute and the change attribute.
Step 1 In ProjectWise Administrator:
This creates the new attribute that will replace the old one and an attribute to trigger the data copy.
Step 2 In the ProjectWise Explorer:
After the dialog closes all of the data from the old attribute will be copied into the new attribute for every document selected.
Step 3 In ProjectWise Administrator
Step 4 Once you verify that the replacement is successful you can delete the old attribute (Too_Small) and the change attribute.
Are there any plans to automate this?