Pdm extract

2012-09-04T01:26:11Z

Cfood:

__NOTOC__
[[Category:Commands]]
{{Global Header}}
{{Global Announcement}}

== 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]
<br>
{|
|-
! 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"

----
<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

SDU - User contributions [en]

Pdm extract