Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Blog Have You Outgrown Your Environment? Four Steps to Free Your Data.
    • Sign In

    ProjectWise Product Advantage
    ProjectWise Product Advantage
    Tue, Oct 19 2010
    • environment
    • Oracle
    • Jo West
    • ProjectWise SELECTsupport
    • ProjectWise
    • SQL

    • Share
    • Subscribe by email
    • More
    • Cancel
    • August 2022 (1)
    • December 2020 (1)
    • July 2020 (1)
    • July 2019 (1)
    • November 2017 (1)
    • October 2017 (2)
    • July 2017 (1)
    • June 2017 (2)
    • April 2017 (1)
    • February 2017 (1)
    • January 2017 (2)
    • December 2016 (1)
    • October 2016 (1)
    • September 2016 (2)
    • July 2016 (1)
    • June 2016 (1)
    • April 2016 (2)
    • March 2016 (1)
    • February 2016 (2)
    • January 2016 (1)
    • December 2015 (2)
    • November 2015 (2)
    • August 2015 (2)
    • July 2015 (1)
    • June 2015 (3)
    • April 2015 (3)
    • March 2015 (2)
    • February 2015 (1)
    • December 2014 (1)
    • October 2014 (3)
    • August 2014 (1)
    • June 2014 (1)
    • May 2014 (3)
    • March 2014 (1)
    • November 2013 (2)
    • October 2013 (4)
    • September 2013 (2)
    • August 2013 (4)
    • July 2013 (6)
    • June 2013 (6)
    • April 2013 (8)
    • March 2013 (9)
    • February 2013 (3)
    • January 2013 (4)
    • December 2012 (5)
    • November 2012 (6)
    • October 2012 (3)
    • September 2012 (4)
    • August 2012 (7)
    • July 2012 (4)
    • June 2012 (6)
    • May 2012 (2)
    • April 2012 (5)
    • March 2012 (2)
    • February 2012 (4)
    • January 2012 (2)
    • December 2011 (3)
    • November 2011 (2)
    • October 2011 (4)
    • September 2011 (4)
    • August 2011 (5)
    • July 2011 (5)
    • June 2011 (5)
    • May 2011 (4)
    • April 2011 (6)
    • March 2011 (5)
    • February 2011 (4)
    • January 2011 (8)
    • December 2010 (10)
    • November 2010 (4)
    • October 2010 (3)
    • September 2010 (6)
    • August 2010 (7)
    • July 2010 (6)
    • June 2010 (6)
    • May 2010 (3)
    Related
    Recommended

    Have You Outgrown Your Environment? Four Steps to Free Your Data.

    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:

    1. Add a new attribute you can call it whatever you like. I usually give it the name of the attribute it is replacing with a rev number. (For example: Too_Small_1 replaces Too_Small)
    2. Add an additional attribute. I call this one Change.
    3. In the new attribute Too_Small_1 edit the Properties and change the Update value to $EDIT#Too_Small$
    4.  Change the Update field setting to "Specific Attributes are updated"
    5.  Set the triggering attribute to the new attribute “Change”

    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:

    1. Search for all of the files in the environment that you are modifying.
    2. Select them all (Ctrl-A)
    3. Open Modify from the Right Click Menu
    4. Select the checkbox by the Change Attribute
    5. Enter a new value
    6. Select OK to apply the change and close the dialog.

    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

    1. Open the Properties dialog for the new attribute (Too_Small_1)
    2. Remove the Update value
    3. Modify the properties to match those set in the old attribute (Too_Small)
    4. Replace the Old Attribute (Too_Small) with the new attribute (Too_Small_1) in any attributes, interfaces or views where the old attribute was used.

    Step 4 Once you verify that the replacement is successful you can delete the old attribute (Too_Small) and the change attribute.

    • Sign in to reply
    • Bert Fegyverneki
      Offline Bert Fegyverneki over 8 years ago

      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?

      Thanks!

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • More
      • Cancel
    • Oto
      Offline Oto over 8 years ago

      thanks

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • More
      • Cancel
    • JackiS
      Offline JackiS over 8 years ago

      ** 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.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • More
      • Cancel
    • Oto
      Offline Oto over 9 years ago

      Are there any plans to automate this?

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • More
      • Cancel
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies