For text files, the Import Utility uses Microsoft Text drivers (.txt and .csv files). Therefore, it is important to properly build the correct profiles. The following steps are necessary to work with Fisher, Masoneilan, and Flowserve interfaces as well as with Import Utility default parameters.
In 64-bit environments, certain ODBC profiles and drivers cannot be seen by the SmartPlant
software. Additionally, they cannot be added from the Windows Control Panel. To add or view these profiles and drivers you need to use the 32-bit version of
the Data Sources which is found under %Systemdrive%\Windows\SysWoW64\odbcad32.exe.
-
In your Windows operating system open Administrative Tools > Data Sources. (64-Bit users see Important note above.)
-
On the ODBC Data Source Administrator dialog, select Add on either the User DSN or System DSN tab, whichever is appropriate.
-
On the Create New Data Source dialog, from the Name list select the Microsoft Text Driver (*.txt; *.csv).
-
Select Finish.
-
On the ODBC Text Setup dialog, type in the Data Source Name and Description for your database.
-
Clear the Use Current Directory check box.
If the Use Current Directory check box is selected, you will not be able to define the format.
-
Select Options.
-
Clear the Default check box.
-
From the extensions list, select *.txt or *.csv.
If the extension doesn't exist in the list you can add it by typing the extension
in the Extension field and then selecting Add.
-
Select Define Format and set the format parameters.
-
Select OK.
-
Select Select Directory and set the default folder for your database.
-
Select Use Current Directory and select OK.
-
Select OK.