Autodesk Navisworks

[#1]

Data Tools

I’m having some problems getting DataTools to work,  and would appreiciate any guidance that anyone may have.

As a starter for ten, I am running a 64bit PC with 64bit Navismanage, the necessary 64bit ODBC driver has also been installed.

In brief I want to use a spec reference in the Navis model to pull information from an excel spreadsheet.  (I appreciate that excel does not provide the best prformance for this function, but for now that what we need to do.)

The following image a is excerpt of the xls spreadsheet I am using. <<See Attachement>>

The field that I want to match data to is the “Revit Type”, “Keynote” Field as detailed below.  In this case “H11” <<See Attachement>>

I have added the database under two section and configured them as per the images. 

-       File Options  -> Data Tools <<See Attachement>>

-       Data Tool <<See Attachement>>

After sometime tinkering, I’m pretty close to giving up.

Can anyone spot a school boy error?  Or am I just missing the point altogehter?

[#2]

Also - I've tried removing the WHERE statement, which does not seem to make any difference.  Therefore I suspect the issued in in the DB connection. 

[#3]

The problem appears to be in your connection string.

You have a DSN specified, rather than an ODBC driver. Unless you have created a DSN that points to the Excel file in your Windows ODBC Control Panel applet of the name DataName, this will not work.

Try selecting the driver from the dropdown combo box labelled ODBC driver in DataTools, then click Setup to use Excel's ODBC setup dialog to point to the file.

Hope that helps,

Jeff

[#4]

Sorted!

That has done the trick!