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 revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
commandline [2019/03/27 11:47] dbfviewercommandline [2019/08/13 10:57] – added new parameters dbfviewer
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 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. 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: 2020/10/11 06:21 by dbfviewer