Pdm extract

2008-02-16T21:16:09Z

Brez1976: Removed extra quote from pdm_extract filter

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]
<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 several table at once
pdm_extract Call_Request Activity_Log > call.dat

----
<div align='center'><font color="red">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>

[[Category:Commands|Commands man]]

SDU - User contributions [en]

Pdm extract