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.
Hi ProjectWise Team,
When performing the above data transfer, is it possible to create the new column as a different data type and still have this work...for example, if the original column is (varchar (13) Null) can I create the new column as (nvarchar (14) Null)? I just tried this scenario and I am getting AAERR_DMS_ERR_DOCUMENT_ATTRIBUTE_INCORRECT errors...is the error due to the difference in the data type or could it be something else?
** If you have a large number of documents or find that this process may be too cumbersome please contact your AM to engage Professional Services for assistance. They have a Modifyenv tool they developed specifically for this.
Are there any plans to automate this?