Applies To:
Foxtrot, Foxtrot Legacy — All Editions

When attemping to open data, the following message is received:
The following message will be displayed after click OK

This error is typically a result of the Enhanced Import Wizard that is currently deactivated in the Foxtrot Administrator. This typically happens when attempting to open data for the first time after Foxtrot has been installed, but can also be a result of a user not having the proper permission level to the Foxtrot Suite folder.
Upon the installation of Foxtrot, if there has been no previous installations in which these settings have been already changed, Foxtrot will use the default import settings – The Enhanced Import Wizard will remain disabled. If these settings are left as default, Foxtrot can only import .txt,.csv, and .dbf file types.

Furthermore, if the user attempts to import data with an .mdb or .accdb extension, the following message will be seen:


Verify the permission level on the Foxtrot Suite folder, located on “C:\Program Files\Foxtrot Suite”, or “C:\Program Files (x86)\Foxtrot Suite” for 64-bit machines. The user should have read, write, and modify permissions to the directories above. Please have a system administrator grant you these permissions if they do not yet exist. If you do not have the appropriate permissions, you will still be able to continue with the steps below, however, changes will not save.

To activate the Enhanced Import Wizard:

1. Log onto the Foxtrot Administrator
2. Click on the Data Settings view, under the Workstation tab
3. Check both checkboxes that appear*, and choose “MS Access Database” as the default DSN
*These checkboxes may only be checked if the machine has Microsoft Office installed.
4. Click Save Changes along the top left
5. Close Foxtrot and re-launch the application. Going forward, you should be able to import all supported file type