Pdm extract - Revision history

Cfood at 01:26, 4 September 2012

2012-09-04T01:26:11Z

Bartosz: Undo revision 4156 by Agegeleruvy (Talk)

2010-11-26T10:56:25Z

Undo revision 4156 by Agegeleruvy (Talk)

Agegeleruvy at 03:15, 24 November 2010

2010-11-24T03:15:47Z

Kowy: /* Examples */

2009-06-08T11:52:22Z

‎Examples

Gityerfix at 04:04, 27 July 2008

2008-07-27T04:04:37Z

Gityerfix at 11:31, 26 July 2008

2008-07-26T11:31:35Z

Gityerfix at 16:36, 18 July 2008

2008-07-18T16:36:59Z

Gityerfix: /* Examples */

2008-07-16T15:15:02Z

‎Examples

Brez1976: Removed extra quote from pdm_extract filter

2008-02-16T21:16:09Z

Removed extra quote from pdm_extract filter

Gityerfix: /* Examples */

2008-01-27T14:03:40Z

‎Examples

@@ Line 6: / Line 6: @@
 == Overview ==
 Use this command to dump data from the database to the screen or file (typically txt, dat, or csv).
 == Usage ==

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Commands]]
@@ Line 17: / Line 9: @@
 == Usage ==
 pdm_extract [-h] [-f] [-c] [-e] [-r] [-v] [-s] [-u] [-d] [-x] [-X] [ALL | database table names]
-&lt;br&gt;
+<br>
 {|
 |-
@@ Line 73: / Line 65: @@
 == Examples ==
 * Extract all Service Desk tables
-  pdm_extract All &gt; All.txt
+  pdm_extract All > All.txt
 * Extract a filtered list
-  pdm_extract -f &quot;SELECT * FROM Call_Req WHERE type = 'I'&quot; &gt; Call_Req.dat
+  pdm_extract -f "SELECT * FROM Call_Req WHERE type = 'I'" > Call_Req.dat
 * Extract a full table
-  pdm_extract Priority &gt; pri.txt
+  pdm_extract Priority > pri.txt
 * Extract multiple tables
-  pdm_extract Call_Request Activity_Log &gt; call.dat
+  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 &quot;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&quot;
+  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 84: @@
 ----
-&lt;div align='center'&gt;&lt;font color=&quot;green&quot;&gt;To make corrections or additions to this article, select the ''edit'' tab above.&lt;br&gt;
+<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.&lt;/font&gt;&lt;/div&gt;
+To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Commands]]
@@ Line 9: / Line 17: @@
 == Usage ==
 pdm_extract [-h] [-f] [-c] [-e] [-r] [-v] [-s] [-u] [-d] [-x] [-X] [ALL | database table names]
-<br>
+&lt;br&gt;
 {|
 |-
@@ Line 65: / Line 73: @@
 == Examples ==
 * Extract all Service Desk tables
-  pdm_extract All > All.txt
+  pdm_extract All &gt; All.txt
 * Extract a filtered list
-  pdm_extract -f "SELECT * FROM Call_Req WHERE type = 'I'" > Call_Req.dat
+  pdm_extract -f &quot;SELECT * FROM Call_Req WHERE type = 'I'&quot; &gt; Call_Req.dat
 * Extract a full table
-  pdm_extract Priority > pri.txt
+  pdm_extract Priority &gt; pri.txt
 * Extract multiple tables
-  pdm_extract Call_Request Activity_Log > call.dat
+  pdm_extract Call_Request Activity_Log &gt; 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"
+  pdm_extract -f &quot;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&quot;
@@ Line 84: / Line 92: @@
 ----
-<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+&lt;div align='center'&gt;&lt;font color=&quot;green&quot;&gt;To make corrections or additions to this article, select the ''edit'' tab above.&lt;br&gt;
-To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+To discuss or ask questions about this article, select the ''discussion'' tab above.&lt;/font&gt;&lt;/div&gt;

← Older revision		Revision as of 11:52, 8 June 2009
Line 76:		Line 76:
	pdm_extract Call_Request Activity_Log > call.dat		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"

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Commands]]
-<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+{{Global Header}}
-To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+{{Global Announcement}}
 == Overview ==

← Older revision		Revision as of 11:31, 26 July 2008
Line 1:		Line 1:
		+	__NOTOC__
	[[Category:Commands]]		[[Category:Commands]]
		+	<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>
		+
		+	== 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).