9.2.2 Export/Import Command Line Parameters

To run the Export/Import utility from the command line, run expimp32.exe. It supports the following command line parameters.

NOTE:

  • Unless you include the /S parameter, the Export/Import Utility dialog box appears, displaying the values specified by the command line parameters.

  • All tables in the database are included by default.

  • Unless you specify otherwise, an ini file is the default format, empty tables are not included in the data file, and a detail file is not created.

/D filename

Export the specified data file. The file is created in the current directory unless you specify a different drive and directory. A file extension is not needed.You can include either the /D or the /Icommand line parameter. If you include both, only the /D command line parameter is used.

/I filename

Import the specified data file. The file is imported from the current directory unless you specify a different drive and directory. A file extension is not needed. You can include either the /D or the /I command line parameter. If you include both, only the /D command line parameter is used.

/A directory

Specifies the location of the InfoConnect Enterprise database to be exported or imported. If you omit this command line parameter, the database specified by the Windows registry is used.

/FC

Use csv format for the data file.

/FI

Use ini format for the data file.

/OD

Create a detail file. If you include the /S command line parameter, you must include both the /D and the /OD command in order to create a detail file. The detail file will have the same name as the data file, but will have a *.dtl extension.

/OE

Include empty tables in the data file.

/OT

Include empty tables in the detail file.

/S

Run in silent mode (no dialog box or message box appears). To run the utility in silent mode, you must also include either the /D or the /I command line parameter.

/B1

Uses a 16-bit InfoConnect database. Omit the /B1 parameter to use a 32-bit database.

For example, the following command exports the current database. It shows no user interface and creates a file called icdata.ini.

expimp32 /S /D c:\icdata.ini

The following command imports content from the icdata.ini file into the current database

expimp32 /S /I c:\mypath\icdata.ini