Difference between revisions of "Pdm extract"
From SDU
Agegeleruvy (Talk | contribs) |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
__NOTOC__ | __NOTOC__ | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| Line 14: | Line 6: | ||
== Overview == | == Overview == | ||
Use this command to dump data from the database to the screen or file (typically txt, dat, or csv). | 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 == | == Usage == | ||
pdm_extract [-h] [-f] [-c] [-e] [-r] [-v] [-s] [-u] [-d] [-x] [-X] [ALL | database table names] | pdm_extract [-h] [-f] [-c] [-e] [-r] [-v] [-s] [-u] [-d] [-x] [-X] [ALL | database table names] | ||
| − | + | <br> | |
{| | {| | ||
|- | |- | ||
| Line 73: | Line 66: | ||
== Examples == | == Examples == | ||
* Extract all Service Desk tables | * Extract all Service Desk tables | ||
| − | pdm_extract All | + | pdm_extract All > All.txt |
* Extract a filtered list | * Extract a filtered list | ||
| − | pdm_extract -f | + | pdm_extract -f "SELECT * FROM Call_Req WHERE type = 'I'" > Call_Req.dat |
* Extract a full table | * Extract a full table | ||
| − | pdm_extract Priority | + | pdm_extract Priority > pri.txt |
* Extract multiple tables | * Extract multiple tables | ||
| − | pdm_extract Call_Request Activity_Log | + | 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) | * Extract two or more joined tables (you cannot use INNER JOIN or similar clausules, only this cross join is possible) | ||
| − | pdm_extract -f | + | 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" |
| Line 92: | Line 85: | ||
---- | ---- | ||
| − | + | <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. | + | To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div> |
Latest revision as of 01:26, 4 September 2012
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.
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.
To discuss or ask questions about this article, select the discussion tab above.
