User Tools

Site Tools


commandline

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
commandline [2019/07/18 05:57]
dbfviewer
commandline [2019/08/13 10:57]
dbfviewer added new parameters
Line 9: Line 9:
 where: 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: Optional parameters:
  
-/brackets enclose ​fields ​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. 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. | 
-/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 | 
--qualifier value you can define the any qualifier for fields in the target text or xml file. You may use +| -fields "​field1,​field2,​..."​ | export the specifted field names only |
-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.** **Note: This feature is not available for Regular licenses.**
commandline.txt · Last modified: 2019/08/13 10:57 by dbfviewer