Pdm extract

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

---

To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.