Pdm extract

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.

Overview

Use this command to dump data from the database to the screen or file (typically txt, dat, or csv). Note: The table names are case sensitive.

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 multiple tables

pdm_extract Call_Request Activity_Log > call.dat

• Extract two or more joined tables (you cannot use INNER JOIN or similar clausules, only this cross join is possible)

pdm_extract -f "SELECT  ca_contact.id, c_acctyp_id FROM ca_contact, usp_contact WHERE ca_contact.id = usp_contact.id AND c_acctyp_id is null"

---

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.