Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | AXSYS | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | AXSYS | OpenPlant | PlantWise
AutoPLANT | AXSYS | OpenPlant | PlantWise Wiki Database - Plant Project
    • Sign in
    • -Plant Design and Engineering - Wiki
      • OpenPlant Product Compatibility
      • +CONNECT Services - OpenPlant
      • +OpenPlant Modeler CONNECT
      • +OpenPlant PID CONNECT
      • +OpenPlant Isometrics Manager CONNECT
      • +OpenPlant Orthographics Manager CONNECT
      • +OpenPlant Support Engineering CONNECT
      • +OpenPlant Project Administrator CONNECT
      • +OpenPlant Modeler v8i
      • +OpenPlant Isometrics Manager v8i
      • +OpenPlant Project Administrator v8i
      • -OpenPlant PID v8i
        • +Application Solutions - OPPID
        • +Class Editor - OpenPlant PID
        • +Customization - OpenPlant PID
        • -Database - Plant Project
          • How to Create a new SQL Server Project and Synchronize OpenPlant PID Projects to it?
          • How do I turn on Number Auto Incrementation of Components on placement?
          • How to Associate an OpenPlant PID Drawing with Another Project
          • How to Change OPPID and Plant Project's Names
          • How to Configure Particular Project to Work in Offline Mode By Default
          • How to Create Custom Border and Map Custom Property with Database
          • How to Get Related Valve Tag in Instrument List in Data Manager
          • How to Map Custom Properties with Database
          • How to Map Input/Output Signal of Instrument in OpenPlant PID
          • How to Select Field Value from External Database PickList
          • How to Setup a Batch Routine to Sync all Drawings in my Project to the Database at one time
          • How To Show Modified Tag Format in Data Manager
          • How to Sync the Valve End Condition with Project DB
          • Importing Data into the Plant Project Database from an Excel Spreadsheet
          • Mapping Plant Project Extended Data Fields to OpenPlant PowerPID
          • OPPID - All drawings have same GUID. Drawings update database incorrectly
          • OPPID - Database Mapping Tips
          • OPPID - Document and their component Links
          • OPPID - Guidelines to ensure OPPID to APPID database field integrity
          • OPPID - How to determine Database Connection and Sync issues
          • OPPID - How To Get Motor Related to Equipment Sync to Database
          • OPPID - How to use the Class Editor Mapping Extension for the Plant Project Database
          • OPPID - Import of Associated Items
          • OPPID - YStrainer Database populate
          • OPPID Pipeline To-From SQL
          • OPPID- How to add custom properties to specific piece of equipment or sub class and link to a database
          • OPPID- SQL Logging
          • Plant Project Database - Class Mapping
          • Plant Project Database - Mappings
          • Plant Project Database - OpenPlant Validation and Repairing a Database Mapping
          • Plant Project Database - Operations with Schema Mapping and Mapping Add-in panel
          • +Plant Project Database - Oracle Install notes
          • Plant Project Database - Property Mapping
          • Plant Project Database - Relationship Mapping
          • Plant Project Database - Schema Mapping Custom Attributes
          • Plant Project Database Tag Format - Tag Codes
          • Setting OpenPlant PowerPID Project with Plant Database Project
          • SQL Server 2008 and Database to Schema Connection
          • To Import Modified Tags from Excel in Data Manager
          • Error: "Connection Test Failed" While Mapping SQL Database to Plant Project
          • Calculated EC Property Shows Failure Value in Data Manager
          • "{SERVICE_IS_RELATED_TO_EQUIPMENT(VG.0000003279)} belongs to the ECSchema {ECSchema: PlantProjectSchema.01.04} which is not supported in this connection" Error on Synchronizing from Database to Drawing
          • "Project ID 'XXXX' not found in AT_PROJ.DB3"
          • How to Move a Project Database from One Directory to Another For OPPID
        • +Properties - OpenPlant PID
        • +Release Notes - OpenPlant PID
        • +Training - OpenPlant PID
        • +White Papers/Guidelines - OPPID
      • +OpenPlant Orthographics Manager v8i
      • +OpenPlant Support Engineering v8i
      • +OpenPlant ModelServer v8i
      • +OpenPlant Reporting v8i
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
    • i-model Composition Service for S3D

     
     Questions about this article, topic, or product? Click here. 

    Database - Plant Project

    From the navigation bar on the left expand Database - Plant Project and select a solution.

    Additional links

    Creating an AutoPLANT Project Database

    AutoPLANT Project Database Definitions

    • OpenPLANT PowerPID
    • Database
    • Share
    • History
    • More
    • Cancel
    • Stephen Morrow Created by Bentley Colleague Stephen Morrow
    • When: Tue, Apr 26 2011 5:51 PM
    • Phil Chouinard Last revision by Phil Chouinard
    • When: Tue, Feb 25 2014 12:48 PM
    • Revisions: 11
    • Comments: 2
    Anonymous
    • Alain Magnan
      Offline Alain Magnan over 4 years ago

      Hi,

      Can someone explain how and when the "C:\Program Files (x86)\Bentley\PowerPID (SELECTseries 5)\PowerPID\assemblies\ECFramework\extensions\missingfields.xml" file is being used?

      I've been told that the file contains database columns to be added, appended or modified when synching files to the database. I'm using version 08.11.10.523 and columns are not being created thus giving me errors during the sync process. The file contains the right column definitions and it doesn't seem t be used.

      Can someone shed some light on how this is supposed to be working?

      Regards

      Alain

      • Cancel
      • Up 0 Down
      • Reply
      • More
      • Cancel
    • Swapnil M Gholap
      Swapnil M Gholap over 6 years ago

      Respected BENTLEY Family,

      My question is related to the piping and equipment in Bentley AutoPlant application.

      In our company , we are using MS-ACCESS database for having the piping details information of various oil & gas drawing.

      We extract the Autoplant Piping Model into MS-ACCESS database ,then this MS-ACCESS database is use further to create the report in Excel / Crystal Report.

      We also create SpecGen/specification in MS-ACCESS only.

      We are planning about to use SQL-Server database instead of MS-ACCESS , but before that we want following information so that we can take proper decision for database.

      1>  Want to know how SQL-Server can be more helpful than MS-ACCESS in Bentley application for Piping?

      2>  How we can use SQL Server for creating SpecGen instead of MS-Access? , please let me know the step/procedure to create SpecGen in SQL-Server.

      3>  What is the exact limitation of "project size"  for MS-ACCESS,SQL-Server and Oracle? , means want to know exact size of project, so that according to our project size , we can go / think for SQL-Server or other database.

      4>  How, we can create/set different user's login access as per their permission level in SQL-Server?

      5>  I am creating crystal report for various reports , then How to use"i-model Driver for Crystal Reports"?

      6>  We are updating our PC to new High-level workstation having Win7 - 64Bit,then Is Bentley (Piping+Prostructure+Equipment V8i(SELECTseries 4)) will be compatibile with Autocad 2012 - Standalone/Network License ?

      Waiting for your reply with answer of above doubt.

      • Cancel
      • Up 0 Down
      • Reply
      • More
      • Cancel
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • User Management
    • Licensing Manager
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

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