{"id":430,"date":"2013-09-04T12:52:12","date_gmt":"2013-09-04T12:52:12","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=430"},"modified":"2022-02-03T11:25:03","modified_gmt":"2022-02-03T17:25:03","slug":"working-with-the-project-database-and-its-effect-on-update-from-spec","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/","title":{"rendered":"Working with the Bentley Project Database and its effect on Update from spec"},"content":{"rendered":"

Adding new fields to the database<\/h2>\n

Adding new fields to the database is useful in cases were you more information about a component, but there is no corrosponding field in the database to the one in the specs.<\/p>\n

If you know where your database is you can skip the first\u00a03 steps> To create a new field in the database:<\/p>\n

    \n
  1. Open the “Bentley Project Administrator”.<\/li>\n
  2. select “yourProject->Database->Databases”.<\/li>\n
  3. open the file path specified for “PROJDATA”.<\/li>\n
  4. open the ProjData file in microsoft access.<\/li>\n
  5. Scroll down to the table where your component data is placed.<\/li>\n
  6. right click on the table and select “design view”.<\/li>\n
  7. go to the bottom of the table.<\/li>\n
  8. in the first blank row fill in the required columns.\n
      \n
    1. Column Name. This must be exactly the same as the field in the spec key or it wont be filled from the spec when a component is placed.\u00a0You can also name a field that\u00a0will not be inputed by the specs, but is inputed durring a draw or input function (ie a variable\u00a0length that is taken as input and\u00a0not from the spec).<\/li>\n
    2. Data Type. This is selected from the dropdown menu.<\/li>\n
    3. Length. This indicated the number of characters or digits long the field is.<\/li>\n
    4. Allow Nulls. This indicates wether or not the field can be empty.<\/li>\n
    5. Description (not required). The fields description.<\/li>\n<\/ol>\n<\/li>\n
    6. save and exit the access file.<\/li>\n<\/ol>\n

      Note: the new database field will be empty even for components that has the equivalent spec field filled. This occurs for all components placed before the field was added, these fields can be updated using spec update.<\/p>\n

      Note: the fields specified in the list are what shows up on the second page of the edit components dialogue box.<\/p>\n

      Setting fields to allow for users to update them<\/h2>\n

      When updating from the spec’s you are ussualy limited in which fields can and cannot be updated, even when using the “update all data” method. This is caused by the write restrictions in the project administrator that determines which fields users can change. Sometimes we need to change the write properties for a fields.<\/p>\n

      For example, if we have just recently added a new fields to the database, but we have already placed many of the components that need that information. When the new field is added it is initialy set so that the user cannot update the field, which would leave all of the preplaced components without the required data. Thus we must change the field to allow for user input, then run a spec update on all of the preplaced components.<\/p>\n

      Changing the write permisions of database fields.<\/p>\n

        \n
      1. Open the “Bentley Project Administrator”.<\/li>\n
      2. Select “yourproject->database->databases”, this will open a list of the different database in the project.<\/li>\n
      3. Select “PROJDATA” from the list and click the edit tables button, this will open a list of all of the tables inside of PROJDATA.<\/li>\n
      4. Scroll down to the table that has the data of your components, for example when placing components from the Raceways or Piping menues the components will be placed in the piping table.<\/li>\n
      5. Click the columns button, this will open a window that has a list of all of the fields held on the database, it should be noted that this does NOT always corrospond to the fields in the spec files.<\/li>\n
      6. Scroll down to the field(s) which you want to change, click in the “Allow User Updates” column, then click on the down arrow button to change the field accessability from no to yes or from yes to no.<\/li>\n
      7. once you have finished changing all of the desired fields click OK, then close the tables window for your changes to take effect. (Note: AutoPlant must be reopened for the changes to take effect if it was running while the changes were being made).<\/li>\n<\/ol>\n

        Being able to change which fields are changed durring a spec update can also be useful in cases where you want to update a dimension field for a component only once, such as the rung spacing on a type of cable tray.<\/p>\n

        Updating all data\u00a0from Specs<\/h2>\n

        To run a spec update on a component:<\/p>\n

          \n
        1. in AutoPlant select Raceways->Database Tools->Update from spec<\/li>\n
        2. use the selection method to choose the component(s) that you want to update<\/li>\n
        3. when prompted choose the type of update you want to do to your component\n
            \n
          1. “Update all descriptive data”, this will update all of the database fields that allow user updates identified in the section above.<\/li>\n
          2. “Update the long and short descrition”, this will update only the long and short description, they will not update if they are set so that they don’t allow for user updates.<\/li>\n
          3. “Update the Manufacturer name”, only updates the manufacturer name, if allowed.<\/li>\n
          4. “Update the sort Code information”, only updates the sort code number of the component.<\/li>\n
          5. “update the port size”,only updates the port size of the component.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

            Note: Any fields that effect the dimensions of the component will be updated in the components information, but the physical appearance of the object will not change, to see the changes use the command AT_PIPING_3DREDRAW and selecting the components that you updated<\/p>\n","protected":false},"excerpt":{"rendered":"

            Adding new fields to the database Adding new fields to the database is useful in cases were you more information about a component, but there is no corrosponding field in the database to the one in the specs. If you know where your database is you can skip the first\u00a03 steps> To create a new […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,1],"tags":[],"class_list":["post-430","post","type-post","status-publish","format-standard","hentry","category-bentley-autoplant","category-general"],"yoast_head":"\nWorking with the Bentley Project Database and its effect on Update from spec - ELB Solutions.com Inc.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Working with the Bentley Project Database and its effect on Update from spec - ELB Solutions.com Inc.\" \/>\n<meta property=\"og:description\" content=\"Adding new fields to the database Adding new fields to the database is useful in cases were you more information about a component, but there is no corrosponding field in the database to the one in the specs. If you know where your database is you can skip the first\u00a03 steps> To create a new […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/\" \/>\n<meta property=\"og:site_name\" content=\"ELB Solutions.com Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-04T12:52:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-03T17:25:03+00:00\" \/>\n<meta name=\"author\" content=\"Etienne Bley\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Etienne Bley\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/working-with-the-project-database-and-its-effect-on-update-from-spec\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/working-with-the-project-database-and-its-effect-on-update-from-spec\\\/\"},\"author\":{\"name\":\"Etienne Bley\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"headline\":\"Working with the Bentley Project Database and its effect on Update from spec\",\"datePublished\":\"2013-09-04T12:52:12+00:00\",\"dateModified\":\"2022-02-03T17:25:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/working-with-the-project-database-and-its-effect-on-update-from-spec\\\/\"},\"wordCount\":883,\"articleSection\":[\"B-AutoPLANT\",\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/working-with-the-project-database-and-its-effect-on-update-from-spec\\\/\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/working-with-the-project-database-and-its-effect-on-update-from-spec\\\/\",\"name\":\"Working with the Bentley Project Database and its effect on Update from spec - ELB Solutions.com Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\"},\"datePublished\":\"2013-09-04T12:52:12+00:00\",\"dateModified\":\"2022-02-03T17:25:03+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/working-with-the-project-database-and-its-effect-on-update-from-spec\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/working-with-the-project-database-and-its-effect-on-update-from-spec\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/working-with-the-project-database-and-its-effect-on-update-from-spec\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Working with the Bentley Project Database and its effect on Update from spec\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\",\"name\":\"ELB Solutions.com Inc.\",\"description\":\"Bringing all your IT Pieces together\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\",\"name\":\"Etienne Bley\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"caption\":\"Etienne Bley\"},\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/author\\\/etienne-bley\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Working with the Bentley Project Database and its effect on Update from spec - ELB Solutions.com Inc.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/","og_locale":"en_US","og_type":"article","og_title":"Working with the Bentley Project Database and its effect on Update from spec - ELB Solutions.com Inc.","og_description":"Adding new fields to the database Adding new fields to the database is useful in cases were you more information about a component, but there is no corrosponding field in the database to the one in the specs. If you know where your database is you can skip the first\u00a03 steps> To create a new […]","og_url":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/","og_site_name":"ELB Solutions.com Inc.","article_published_time":"2013-09-04T12:52:12+00:00","article_modified_time":"2022-02-03T17:25:03+00:00","author":"Etienne Bley","twitter_misc":{"Written by":"Etienne Bley","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/#article","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/"},"author":{"name":"Etienne Bley","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"headline":"Working with the Bentley Project Database and its effect on Update from spec","datePublished":"2013-09-04T12:52:12+00:00","dateModified":"2022-02-03T17:25:03+00:00","mainEntityOfPage":{"@id":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/"},"wordCount":883,"articleSection":["B-AutoPLANT","General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/","url":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/","name":"Working with the Bentley Project Database and its effect on Update from spec - ELB Solutions.com Inc.","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/#website"},"datePublished":"2013-09-04T12:52:12+00:00","dateModified":"2022-02-03T17:25:03+00:00","author":{"@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"breadcrumb":{"@id":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/elbsolutions.com\/projects\/working-with-the-project-database-and-its-effect-on-update-from-spec\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elbsolutions.com\/projects\/"},{"@type":"ListItem","position":2,"name":"Working with the Bentley Project Database and its effect on Update from spec"}]},{"@type":"WebSite","@id":"https:\/\/elbsolutions.com\/projects\/#website","url":"https:\/\/elbsolutions.com\/projects\/","name":"ELB Solutions.com Inc.","description":"Bringing all your IT Pieces together","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elbsolutions.com\/projects\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39","name":"Etienne Bley","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","caption":"Etienne Bley"},"url":"https:\/\/elbsolutions.com\/projects\/author\/etienne-bley\/"}]}},"_links":{"self":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/comments?post=430"}],"version-history":[{"count":5,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/430\/revisions"}],"predecessor-version":[{"id":507,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/430\/revisions\/507"}],"wp:attachment":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/media?parent=430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/categories?post=430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/tags?post=430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}