Command line interface DBF to CSV Converter
Common parameters
| /OVERWRITE=1 | Overwrite existing file. |
| /OVERWRITE=0 | Do not overwrite existing file. (Append to existing file). |
| /SKIPDEL=1 | Skip records marked as deleted. |
| /SKIPDEL=0 | Do not skip records marked as deleted. |
| /ASIS | Codepage as is. |
| /ANSI | Convert to ANSI codepage. |
| /OEM | Convert to OEM codepage. |
| /OPEN=1 | Open the output file after conversion. |
| /OPEN=0 | Do not open the output file after conversion. |
| /BATCH | Batch mode. The program does not ask any questions (if possible). |
| /SILENT | Batch mode. The program does not display any windows. |
| /WAIT | Do not close the program at the end. (Wait on the finish page). |
| /LOG | Create a log file in a common repository for application-specific data. A typical path is C:\Documents and Settings\username\Application Data. |
| /STATUS /STATUS=filename.ext | Create a text file with a current status (Conversion In Progress, Successful, Failed, Cancelled etc). By default: %Program dir%\status.log |
| /FILTER=condition | It allows you to convert records which satisfy the condition. |
CSV specific parameters
| Drive:\Path\FileName.dbf | Source DBF file |
| Drive:\Path\FileName.csv | Target CSV file |
| /REMTRAIL=1 | Remove trailing spaces in Character and Memo fields. |
| /REMTRAIL=0 | Do not remove trailing spaces in Character and Memo fields. |
| /REMCRLF=1 | Remove CR+LF in Memo fields. |
| /REMCRLF=0 | Do not remove CR+LF in Memo fields. |
| /ESCAPE=????? | Escape character before a single or a double quote. Examples: /ESCAPE=# "/ESCAPE="" |
| /QUOTES=1 | Conclude character and memo fields in double quotes. |
| /QUOTES=0 | Do not conclude character and memo fields in double quotes. |
| /FIELDS=? | Delimiter between fields. Example: /FIELDS=;
Special values: |
| /RECORDS=? | Delimiter between records. Example: /FIELDS=CRLF
Special values: |
| /HEADER=1 | Include fields names. |
| /HEADER=0 | Do not include field names. |
|
/YYYYMMDD /YYYY.MM.DD /MM.DD.YYYY /MM-DD-YYYY /DD.MM.YYYY /DD-MM-YYYY /YYYY-MM-DD | Use this format for date fields. |
| /STRIPYEAR=1 | Remove two leading digits in year for Date fields. i.e. 2006 -> 06 |
| /STRIPYEAR=0 | Display Date fields in default format |
| /LOGICAL=T,F | Allows you to override values from the source file to your own values. /LOGICAL=1,0 /LOGICAL=True,False /LOGICAL=Yes,No |
