ProStructures Wiki Importing i-Model metadata into an Excel sheet

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.