Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProStructures
  • Product Communities
ProStructures
ProStructures Wiki Importing i-Model metadata into an Excel sheet
    • Sign In
    • -ProStructures
      • +ProStructures - What's New
      • +ProStructures For Beginners
      • -ProStructures CONNECT Edition
        • +Installation - ProStructures CONNECT Edition
        • +MicroStation CONNECT Edition Basics - ProStructures CONNECT Edition
        • +General - ProStructures CONNECT Edition
        • +Setup & Customization - ProStructures CONNECT Edition
        • +Template Manager - ProStructures CONNECT Edition
        • +Navigation & Display Commands - ProStructures CONNECT Edition
        • +Administrate Groups command - ProStructures CONNECT Edition
        • +Global Settings/Options - ProStructures CONNECT Edition
        • +Key-in Commands - ProStructures CONNECT Edition
        • -Import/Export - ProStructures CONNECT Edition
          • +ISM (Integrated Structural Model) - Import/Export
          • +IFC (Industry Foundation Classes) - Import/Export
          • +DWG - Import/Export
          • +ProStructures-Navisworks - Import/Export
          • Importing i-Model metadata into an Excel sheet
          • Importing i-Model metadata into MS Access
          • Workaround for MS Access error “… is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long”
          • i.dgn model created via ProStructures CONNECT Edition get crash in Navigator V8i, while doing Clash check
          • Error : ISM engine failed
          • How to print 3D PDF in ProStructures CONNECT Edition?
          • How to print 3D PDF which includes the element properties in it?
          • Upgradation of multiple ProStructures DGN files from the lower version to the higher version.
          • How to open/view the ProStructures' file in Tekla structures
          • How to export the STEP file from the ProStructures CONNECT Edition
        • +ProStructures CONNECT Edition FAQ
        • API / SDK ProStructures Connect Edition
      • +ProStructures V8i SELECTSeries
      • +ProjectWise Integration - ProStructures
      • +Object Enablers – ProStructures/ProSteel
      • Working from home with ProStructures
      • ProStructures Platform Version on Release Updates
      • ProStructures Version Support
    • +ProSteel
    • +ProConcrete
    • +ProStructures Licensing
    • +ProStructures Customer Examples / Projects

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

    Importing i-Model metadata into an Excel sheet

      Product(s): ProStructures
      Version(s): CONNECT Edition (10.XX.00.XX)
      Environment: N/A
      Area: N/A
      Subarea: N/A
      Original Author: Vyanktesh Nama, Bentley Product Advantage Group

    Overview

    In this wiki, we are going to learn how to import *.iModel metadata into an Excel sheet via i-Model ODBC.

    Method

    Please follow the below steps to get metadata of *.iModel into excel sheet:

    Prerequisite: You need to have installed the “iModel ODBC Driver 64-bit” in your system. To download this click here.

    a. Open ProStructures model of which you want to get metadata into an excel sheet. (for e.g. see below image).

    b. Go to Backstage > File and click on “Publish i-model”.

    c. After clicking on that “Publish i-model(s)” dialog box will open. Please follow the steps as shown in the below image.

    1. Check the box for “Create a single package”.

    2. Here you can set the default path to save all iModels.

    3. Check the box for “Create an iModel version”.

    4. Select the 1.6 version for iModel.

    5. Finally, click on the “Publish” button to publish i-Models.

    d. Wait for a few seconds to complete the process. After completion process, go to the default path here you can find *.imodel is get published.

    e. Now, search “odbc data sources (64-bit)” in the windows start button and click on it to launch.

    f. In ODBC Data Source Administrator (64-bit) dialog box,

    1. Go to the System DSN tab.

    2. Double click on iModel 1.6 Data Source. iModel ODBC DSN Configuration dialog box will open.

    3. Click on the Browse button to browse recently published *.iModel.

    4. Now, here select the iModel and

    5. Click on the open button.

    6. Click on the OK button of the iModel ODBC DSN Configuration dialog box.

    7. Click on the OK button of the ODBC Data Source Administrator (64-bit) dialog box.

    g. Now, launch Microsoft Excel and click on the Blank workbook.

    Method 1: From ODBC

    h. In excel, go to Data > Get Data > From Other Sources > From ODBC.

    i. In the ODBC dialog box, click on the dropdown and select iModel 1.6 Data Source and then click on the OK button.

    j. In the Navigator dialog box, you can select only one table. (In this case, I have selected PSElementProperties)

    k. In the below image you can see all the data get imported into an Excel Sheet.

    Method 2: From Data Connection Wizard (Legacy)

    h. In Excel, go to Backstage > File > options. Here in the Excel Options dialog box, Enable “From Data Connection Wizard (Legacy)” in the Data tab.

    i. Now, go to Data > Get Data > Legacy Wizards > From Data Connection Wizard (Legacy).

    j. In the Data Connection Wizard dialog box, double click on ODBC DSN.

    k. After that, double click on the iModel 1.6 Data Source.

    l. Here you can select only one table at a time. Then click the Next button.

    m. In the next window, click on the Finish button.

    n. In the Import Data dialog box, click on the OK button to import all data into excel.

    o. Now, you can see that data in the Excel sheet.

    In this way, we can import the *.iModel metadata into an Excel sheet via i-Model ODBC.

    See Also

    Importing i-Model metadata into MS Access:
    https://communities.bentley.com/products/prostructures/w/structural_drafting_and_detailing__wiki/45378/importing-i-model-metadata-into-ms-access

    Workaround for MS Access error “… is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long”:
    https://communities.bentley.com/products/prostructures/w/structural_drafting_and_detailing__wiki/46850/workaround-for-ms-access-error-is-not-a-valid-name-make-sure-that-it-does-not-include-invalid-characters-or-punctuation-and-that-it-is-not-too-long

    • ProStructures
    • Excel
    • excel sheet
    • ODBC
    • MS Excel
    • PSElementProperties
    • ODBC Databace
    • iModel 1.6 Data Source
    • Legacy Wizards
    • imodel
    • ProStructures CONNECT Edition
    • ODBC DSN
    • odbc data sources
    • System DSN
    • iModel metadata
    • ProSteel
    • i-Model ODBC
    • iModel ODBC Driver 64-bit
    • From Data Connection Wizard (Legacy)
    • Share
    • History
    • More
    • Cancel
    • Vyanktesh Nama Created by Bentley Colleague Vyanktesh Nama
    • When: Fri, Dec 20 2019 9:46 AM
    • Vyanktesh Nama Last revision by Bentley Colleague Vyanktesh Nama
    • When: Wed, Dec 28 2022 8:41 AM
    • Revisions: 2
    • Comments: 0
    Recommended
    Related
    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