Scribd Logo
Upload

Welcome to Scribd!

  • 284 views

    AutoCAD P&ID - PLANTXDBMANAGER

    Uploaded by

    ea88b5
    This document discusses using the External Database Reference Manager in AutoCAD Plant 3D and AutoCAD P&ID to connect these programs to external database files. It describes how to map properties from an Excel spreadsheet stored in an Access database to properties in a Plant 3D project. This allows sharing and reusing data from the database to populate attributes in isometric drawings generated from the project. Benefits mentioned include reduced errors, faster modification, and repeatability by using a single verified data source.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    AutoCAD P&ID - PLANTXDBMANAGER

    Uploaded by

    ea88b5
    284 views19 pages
    This document discusses using the External Database Reference Manager in AutoCAD Plant 3D and AutoCAD P&ID to connect these programs to external database files. It describes how to map properties from an Excel spreadsheet stored in an Access database to properties in a Plant 3D project. This allows sharing and reusing data from the database to populate attributes in isometric drawings generated from the project. Benefits mentioned include reduced errors, faster modification, and repeatability by using a single verified data source.

    Original Description:

    Drive AutoCAD Plant 3D and AutoCAD P&ID Data Using the External Database Reference Manager

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses using the External Database Reference Manager in AutoCAD Plant 3D and AutoCAD P&ID to connect these programs to external database files. It describes how to map properties from an Excel spreadsheet stored in an Access database to properties in a Plant 3D project. This allows sharing and reusing data from the database to populate attributes in isometric drawings generated from the project. Benefits mentioned include reduced errors, faster modification, and repeatability by using a single verified data source.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    284 views19 pages

    AutoCAD P&ID - PLANTXDBMANAGER

    Uploaded by

    ea88b5
    This document discusses using the External Database Reference Manager in AutoCAD Plant 3D and AutoCAD P&ID to connect these programs to external database files. It describes how to map properties from an Excel spreadsheet stored in an Access database to properties in a Plant 3D project. This allows sharing and reusing data from the database to populate attributes in isometric drawings generated from the project. Benefits mentioned include reduced errors, faster modification, and repeatability by using a single verified data source.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 19
    At a glance
    Powered by AI
    The key takeaways are that the External Database Reference Manager allows connecting AutoCAD Plant 3D and P&ID projects to external database tables containing asset information and properties. This allows propagating and reusing this data across projects for consistency.

    The External Database Reference Manager is used to connect AutoCAD Plant 3D and P&ID projects to external database tables containing asset information and properties. This allows the data in these external databases to be used in the projects.

    Most database systems can be used with the External Database Reference Manager if the correct OLE DB providers have been installed. In this example, an Access database created from an Excel spreadsheet is used.

    Drive AutoCAD Plant 3D and AutoCAD P&ID Data

    Using the External Database Reference Manager


    Dan Scales
    Senior Technical Support Specialist

    Join the conversation #AU2015


    What is the External Database Reference Manager?


    What database types!
     Most database systems if the correct OLE DB
    providers have been installed.

     For this class we will use an Access database


    created from an Excel spreadsheet.
    Excel to Access to Plant 3D and into the Iso
    Spreadsheet containing typical data
    •
    •
    •
    •
    •
    •
    •
    •
    •
    •
    •
    •
    •
    Add custom properties to the project
     Add the following 13 properties as “String” •
    properties to Pipe Line Segments: •
    •
    •
    •
    •
    •
    •
    •
    •
    •
    •
    •
    Create an Access Database from the Excel
    Spreadsheet
    Connect the database to the project
    •
    Map the PipeLines Class Properties
    Existing or Virtual Properties?
     Existing Mapping
     The external database data is mapped to an
    existing property in the project.

     Virtual Mapping
     The column in the external database table
    does not become a property in the project
    hierarchy; it will appear as a new property,
    in the DM and can have a name that's
    different from the external database column
    name.
    Open the Data Manager and Load the Mapped
    Properties
    Export the data as LDT.xls
    Link the Isometric style to the LDT.xls
    Place the LDT Attribues into the Iso Template
    Generate an Isometric
    Benefits?

     Verified data from a single source


     Less chance or error
     Less checking required
     Repeatability
     Faster modification
    Be heard! Provide AU session feedback.
     Via the Survey Stations, email or mobile device.

     AU 2016 passes awarded daily!

     Give your feedback after


    each session.

     Give instructors feedback


    in real-time.
    Forget to take notes? No problem!
    After AU visit:
    AutodeskUniversity.com

    Click on My AU to find:

     Class Recordings
     Presentations
     Handouts

    All of your sessions will be there


    to enjoy again and again.

    You might also like