In this wiki, we are going to learn how to import *.iModel metadata into an Excel sheet via i-Model ODBC.
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.
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