User Tools

Site Tools


Action disabled: revisions
commandline

Command line options

The command line is a text string that is passed to the system whenever any program is executed; it contains the path to the program with the following set of parameters. In Windows, you can start a program via Start Menu “Run…” command or by clicking on a Shortcut on the Desktop or in Start menu. If you start a program by clicking a Shortcut, you can edit the command line for the program in Shortcut Properties' “Target” input box.

DBF Manager supports command line parameters for batch file processing:

dbfmanager.exe -i <file or folder> [-o <output folder>] (/sql|/txt|/xml|/xls|/access) /v

where:

-i <file or folder> specifies that the next argument is a source file or folder. If not specified the program uses current path.
-o <save path> specifies that the next argument is a target folder. If not specified the program uses source path.
/sql generate an sql script
/txt export to text file
/csv export to csv file format
/xml export to xml file format
/xls export to MS Excel xls file format
/access export to MS Access mdb file format

Optional parameters:

/brackets enclose field names with square brackets (for sql script only)
-blob “custom_field_type” if specified blob(memo) fields would have custom_field_type type, e.g. -blob “Varchar(8000)”, -blob “Varchar(max)”
/double enclose all string values with double quotes. Default is single quotes
/date2char changes field type from datetime to varchar
/v specifies that the program should show progress window
/comments adds original field type, length and decimal. For sql script only.
-qualifier value you can define the any qualifier for fields in the target text or xml file. You may use none, singlequote, doublequote or any custom character as value. Default value is none.
-delimiter value you can define the separator of fields in the target text file. You may use tab, space or any custom character as value. Default value is tab.
/nolog specifies that the program will not create log file
/nodeleted specifies that the program will not export records marked for deletion
-replacecrlf “value” you can define the new line replacement, e.g. “<br/>”
/oem save content in oem codepage
-fields “field1,field2,…” export the specified field names only
/zerosindate specifies to export day/month as a number with a leading zero
/4Y specifies to use year as a four-digit number
-do (MDY|DMY|YMD|YDM|DYM|MYD) specifies date order format
-dateseparator [value] specifies date separator. If value is empty, then date would be without separator

Note: This feature is not available for Regular licenses.

commandline.txt · Last modified: 2020/10/11 06:21 by dbfviewer