Command Line |
Top Previous Next |
single file conversion:
pxcnv.exe file.db outfile.ext [OPTIONS]
batch conversion:
pxcnv.exe *.db destdir /TOEXT [OPTIONS]
where ext - (.dbf, .txt, .htm, .prg, .xml, .xls, .csv, .sql, .rtf)
Common options:
/SKIPD - skip deleted records
/SEPx - where x delimiter
/SEPPIPE - use | as delimiter
/SEPSPACE - use space as delimiter
/HDR - for put the fields names in first line.
/REVERSE - export in reverse order
/COLUMNS - set columns for export example: pxcnv.exe sample.db sample.csv /COLUMNS:NAME,STREET
/COLUMNSLIST - set columns for export from text file example: pxcnv.exe sample.db sample.csv /COLUMNSLIST:columns where columns - text file with column names (one per line)
/SORTBY:NAME - Sort by field Name
/FILTER:filterfile
filter file format:
Field name:Value|Expression
Examples:
single file conversion:
pxcnv.exe mybase.db out.txt /SEP;
multiple file conversion:
pxcnv.exe c:\base\*.db c:\exports\ /TOSQL
Text/CSV options
/SINGLEQUOTA - single quotas /DOUBLEQUOTA - double quotas
Dbase options
/DBASE3 - DBASE III format /DBASE4 - DBASE IV format /VFP - Visual Foxpro format
example: pxcnv.exe c:\base\myfile.db out.dbf /DBASE4
HTML options /ASFORM - one record on the one page
/NUMBER - record number as first column
/MAXPERPAGE - maximum records on the one page example: /MAXPERPAGE=100
/TITLE - page title example: /TITLE=Customers
/COLOR - Text color example: /COLOR=#0000ff
/BACKGROUND - Background color /BACKGROUND=#c0c0c0
|