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.