Fortunately, there are a lot of external resources available for creating SQL strings. I have found this part of configuring the database connection to be the most difficult. The SQL string is used to specify how the database will be queried. We can now complete the SQL String and Fields section of the dialog.
Revizto download driver#
If we look in the connection section portion of the dialog, under the ODBC Driver selection, you can see that the connection has been updated. We are now back to the Edit Link dialog box (Figure 6). If you are having issues with your Database Link connecting to Excel, be sure to check the Version of Excel database that you are using. Just make sure this file has the headers we added in the section above entitled Data Source Setup.Īfter you have selected your excel file, click OK to close the ODBC Microsoft Excel Setup dialog. If you have the default installation of Navisworks 2018 and are using the Gatehouse example, you can find the file at: C:\Program Files\Autodesk\Navisworks Manage 2018\Samples\gatehouse\. This connects the excel data file with Navisworks. Then click on the Select Workbook button to find and select the Excel data file. Select the version of Excel you are using to edit the spreadsheet. I am using Office 365 so selected “Excel 12” from the Version: dropdown. In the ODBC Microsoft Excel Setup dialog (Figure 5), we will select the version of Excel data file and select the file we will be using. Then click the Setup button to open the ODBC Microsoft Excel Setup dialog.įigure 4 - New Database Connection Link dialog
We are going to be working with a Microsoft Excel data source, so select the “Microsoft Excel Driver (*.xls, *.xlsx, )” driver. We then need to select the ODBC Driver Connection type. For this example, I am using the name “Gatehouse Example”. In the New Link dialog (Figure 4), we first want to name the new link connection we are creating. As shown in Figure 1, click the DataTools tab and then click the New button to create a new DataTools link to open the New Link dialog.įigure 3 - File Options dialog for creating a new DataTools link In the File Options dialog, we will start the process of configure our database connection (Figure 3). In Navisworks, on the Home tab, Project panel, click on the File Options button (Figure 2). In this example, I am going to open the gatehouse model as indicated above. With that done, open Navisworks and the Navisworks model that you want to connect your external data source to.
Revizto download drivers#
Our next step, you need to have the ODBC drivers installed, otherwise you will not have the data connection option. We are creating these labels to identify the columns.įigure 1 - Data Source with column labels The first thing I did to the file was add three column headers to identify the “Name”, “Date” and “Notes” columns (Figure 1). The Gatehouse project includes a sample Excel spreadsheet which is why I am using it as an example. The MS Access 2013 runtime drivers can be downloaded here: If you are using an older version of office the MS Access 2010 drivers can be downloaded from here.
Revizto download windows 10#
My Mac running Windows 10 64-bit on parallels using Office 365. My workstations are all Windows 10 64-bit workstations. Data can be linked and viewed inside of Navisworks, but the data can’t be updated within Navisworks. It is also important to note, that the link to Navisworks is one way. 64-bit workstations need to utilize 64-bit ODBC drivers. If you are using a 32-bit workstation, then you need to utilize the 32-bit ODBC drivers. When working with the DataTools in Navisworks, there are a few very important rules to keep in mind. We will then be configuring the database connection. In order to connect an external data source such as an Excel spreadsheet or an Access database to a Navisworks model, we need to configure a DataTools within Navisworks. If you have a newer or older version of Navisworks, the process basically works the same. You can find the files C:\Program Files\Autodesk\Navisworks Manage 2018\Samples\Gatehouse\. For this demo, I am going to use the Gatehouse sample file that ships with Navisworks 2018.
0 kommentar(er)
