DFPATH Tab

How to access the dialog

  • Main Menu | Tools | Preferences

  • Main Menu | Tools | Generate Scripts | SQL Script for Creating Table, Preferences Button

  • Main Menu | Tools | Generate .INT | .INT File from .DAT, Preferences Button

  • Filelist dialog, Convert Database Button, Preferences Button

This tab controls which DFPath Flex2SQL uses during data migration. If the data files are not found in any of the DFPath directories, migration does not take place.

Since there are multiple ways to select a filelist, this setting is very important. When migrating data for a character mode application, select a filelist explicitly. When using Visual DataFlex 4 and above, use workspaces.

DFPath To Use Sub-tab

Open Type

Identifies how the user selected the files to be migrated (i.e. if a workspace was used or a filelist was selected). The option selected here is used to populate the list of directories in the DFPath. This option is read-only.

  • Workspace: This option is selected if the files were selected using the File > Open > Select Workspace option.

  • Filelist: This option is selected if files were selected using the File > Open > Select Filelist option.

  • Files Without Filelist Entry: This option is selected if files were selected using the File > Open > Select Files Without Filelist Entry option.

Check boxes

When you check one of these boxes, the contents of the associated sub-tab are included in the DFPath that Flex2SQL searches to locate DAT or INT files. Check boxes are listed in priority order, so when User Defined is checked, files in the User Defined sub tab are searched first.

  • User Defined: Check this option to include additional paths you enter in the User Defined sub-tab.

  • Use DFENV.cfg: Check this option to include paths listed in the DFENV.cfg sub-tab.

  • Workspace: Selected by default if the Open type is Workspace. When this option is checked the DFPath includes the paths listed in the Workspace sub-tab.

  • Registry: When this option is checked, the DFPath includes the paths listed in the Registry sub-tab.

  • Path: Check this option to include paths listed in the PATH sub-tab.

Preferences DFPATH.png

User Defined Sub-Tab

Paths you enter in this sub-tab are searched first when the User Defined option is selected in the DFPath To Use sub-tab. Add each path to use on a separate line.

DFENV.cfg Sub-Tab

This sub-tab is populated using the dfenv.cfg file and has an entry like: DFPATH=df31dusrdata;df31dwasa. It is read only.

Browse to select the location for the dfenv.cfg file. This option is usually only used by console mode DataFlex.

Workspace Sub-Tab

This sub-tab is populated using the filelist path (without the filelist name) and the data path from the current workspace. It read only.

Registry Tab

This sub-tab is populated from the SystemDFPath in the Windows Registry [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeData Access WorldwideVisual DataFlex17.0Workspaces]. It is read only.

Path Sub-Tab

This sub-tab is populated using the PATH environment variable. It is read only.

Main DataDir

All auxiliary files created by Flex2SQL during data migration will be created in this directory. This is usually the data file directory. This directory is the first path in the DFPath. If you want to change this directory, add this path first in the User Defined sub-tab.

Filelist

Shows the currently selected filelist.