Pdm extract
From SDU
Use this command to dump data from the database to the screen or file (typically txt, dat, or csv).
Usage
pdm_extract [-h] [-f] [-c] [-e] [-r] [-v] [-s] [-u] [-d] [-x] [-X] [ALL | database table names]
| Command | Description | Remarks |
|---|---|---|
| -h | Help | |
| -f | format string | |
| -c | csv output | |
| -e | csv output with double double quotes | |
| -r | informal report output | |
| -v | verbose | |
| -s | saved script | |
| -u | no headers | |
| -d | use dataent.fmt | |
| -x | locale sensitive numeric formats | |
| -X | extract all tables except table list |
Examples
- Extract all Service Desk tables
pdm_extract All > All.txt
- Extract a filtered list
pdm_extract -f "SELECT * FROM Call_Req" WHERE type = 'I'" > Call_Req.dat
- Extract a full table
pdm_extract Priority > pri.txt
- Extract several table at once
pdm_extract Call_Request Activity_Log > call.dat
