Differences

This shows you the differences between two versions of the page.

--- commandline [2019/03/27 11:47] – dbfviewer
+++ commandline [2020/10/11 06:21] (current) – added new parameters dbfviewer
@@ Line 9: / Line 9: @@
 where:
--i <file or folder> specifies that the next argument is a source file or folder. If not specified the program uses current path.
+| -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. |
--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 |
-/sql generate an sql script
+| /csv                | export to csv file format |
+| /xml                | export to xml file format |
-/txt export to text/csv file
+| /xls                | export to MS Excel xls file format |
+| /access             | export to MS Access mdb 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 if specified fields are enclosed with square brackets
+| /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)" |
--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 |
-/double enclose all string values with double quotes. Default is single quotes
+| /v                          | specifies that the program should show progress window |
+| /comments                   | adds original field type, length and decimal. For sql script only. |
-/date2char changes field type from datetime to varchar
+| -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. |
-/v specifies that the program should show progress window
+| /nolog                      | specifies that the program will not create log file |
+| /nodeleted                  | specifies that the program will not export records marked for deletion |
-/comments adds original field type, length and decimal
+| -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 <nowiki>(MDY|DMY|YMD|YDM|DYM|MYD)</nowiki> | specifies date order format |
+| -dateseparator [value]        | specifies date separator. If value is empty, then date would be without separator |
--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. 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. 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/>"
 **Note: This feature is not available for Regular licenses.**