<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>http://greggsmith.net/wiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Alex+%28aka+Fancy+Pants%29</id>
		<title>SDU - User contributions [en]</title>
		<link rel="self" type="application/atom+xml" href="http://greggsmith.net/wiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Alex+%28aka+Fancy+Pants%29"/>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Special:Contributions/Alex_(aka_Fancy_Pants)"/>
		<updated>2026-07-27T13:22:13Z</updated>
		<subtitle>User contributions</subtitle>
		<generator>MediaWiki 1.26.1</generator>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=For&amp;diff=1273</id>
		<title>For</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=For&amp;diff=1273"/>
				<updated>2008-02-22T18:35:59Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Category:Spel]]&lt;br /&gt;
== Description ==&lt;br /&gt;
A &amp;quot;for&amp;quot; loop performs a set of commands for each iteration of the loop.&lt;br /&gt;
&lt;br /&gt;
== Usage ==&lt;br /&gt;
for (''starting number'';''while'';''increment'')&lt;br /&gt;
&lt;br /&gt;
You do not have to specify all (or any) of the three values within the, although not doing so may result in an infinite loop. You must have code within the loop itself to exit if you choose to exclude these values. Also, if you do not specify a value you still must use the semi-colon(;) as a separator.&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
*For loop that increments a variable by 1 on each pass&lt;br /&gt;
 int i,count;&lt;br /&gt;
 for (i=0,count=0;i&amp;lt;=4;i++) {&lt;br /&gt;
      count++;&lt;br /&gt;
 }&lt;br /&gt;
&lt;br /&gt;
This will increment the count var to 5.&lt;br /&gt;
&lt;br /&gt;
* For loop which logs all the indexes of the msg array which the send_wait function returns&lt;br /&gt;
 int i;&lt;br /&gt;
 send_wait(0, top_object(), &amp;quot;call_attr&amp;quot;, &amp;quot;cnt&amp;quot;, &amp;quot;get_groups_by_persid&amp;quot;, &amp;quot;cnt:776B094702EABB4B87F04A139E72D44B&amp;quot;);&lt;br /&gt;
 for (i=0;i&amp;lt;msg_length();i++) {&lt;br /&gt;
      logf (SIGNIFICANT, &amp;quot;Msg index #%s: %s&amp;quot;, i,msg[i]);&lt;br /&gt;
 }&lt;br /&gt;
&lt;br /&gt;
* For loop which does not specify all three values&lt;br /&gt;
 int i;&lt;br /&gt;
 i=5;&lt;br /&gt;
 for (i;;) {&lt;br /&gt;
      if (i&amp;gt;-1) {--i; } else {return;}&lt;br /&gt;
 }&lt;br /&gt;
&lt;br /&gt;
This will exit i reaches a value of -1&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=For&amp;diff=1271</id>
		<title>For</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=For&amp;diff=1271"/>
				<updated>2008-02-22T18:34:40Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): New page: == Description == A &amp;quot;for&amp;quot; loop performs a set of commands for each iteration of the loop.  == Usage == for (''starting number'';''while'';''increment'')  You do not have to specify all (or...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Description ==&lt;br /&gt;
A &amp;quot;for&amp;quot; loop performs a set of commands for each iteration of the loop.&lt;br /&gt;
&lt;br /&gt;
== Usage ==&lt;br /&gt;
for (''starting number'';''while'';''increment'')&lt;br /&gt;
&lt;br /&gt;
You do not have to specify all (or any) of the three values within the, although not doing so may result in an infinite loop. You must have code within the loop itself to exit if you choose to exclude these values. Also, if you do not specify a value you still must use the semi-colon(;) as a separator.&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
*For loop that increments a variable by 1 on each pass&lt;br /&gt;
 int i,count;&lt;br /&gt;
 for (i=0,count=0;i&amp;lt;=4;i++) {&lt;br /&gt;
      count++;&lt;br /&gt;
 }&lt;br /&gt;
&lt;br /&gt;
This will increment the count var to 5.&lt;br /&gt;
&lt;br /&gt;
* For loop which logs all the indexes of the msg array which the send_wait function returns&lt;br /&gt;
 int i;&lt;br /&gt;
 send_wait(0, top_object(), &amp;quot;call_attr&amp;quot;, &amp;quot;cnt&amp;quot;, &amp;quot;get_groups_by_persid&amp;quot;, &amp;quot;cnt:776B094702EABB4B87F04A139E72D44B&amp;quot;);&lt;br /&gt;
 for (i=0;i&amp;lt;msg_length();i++) {&lt;br /&gt;
      logf (SIGNIFICANT, &amp;quot;Msg index #%s: %s&amp;quot;, i,msg[i]);&lt;br /&gt;
 }&lt;br /&gt;
&lt;br /&gt;
* For loop which does not specify all three values&lt;br /&gt;
 int i;&lt;br /&gt;
 i=5;&lt;br /&gt;
 for (i;;) {&lt;br /&gt;
      if (i&amp;gt;-1) {--i; } else {return;}&lt;br /&gt;
 }&lt;br /&gt;
&lt;br /&gt;
This will exit i reaches a value of -1&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Sindex&amp;diff=1266</id>
		<title>Sindex</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Sindex&amp;diff=1266"/>
				<updated>2008-02-22T17:06:50Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Category:Spel]]&lt;br /&gt;
== Description ==&lt;br /&gt;
A spel function which, although much diffrent in syntax, works similar to regex (Regular Expression) string matches found in most other programming languages.&lt;br /&gt;
&lt;br /&gt;
== Usage ==&lt;br /&gt;
sindex(''&amp;quot;string&amp;quot;'',''&amp;quot;match&amp;quot;'');&lt;br /&gt;
&lt;br /&gt;
Unknown if any wildcards are supported&lt;br /&gt;
&lt;br /&gt;
== Results ==&lt;br /&gt;
Sindex will return a -1 is no match is found or a 0 if a match is made.&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
* If statement using sindex (matching a string against a string)&lt;br /&gt;
 if (sindex(&amp;quot;test string&amp;quot;, &amp;quot;test&amp;quot;)==0) {return;}&lt;br /&gt;
&lt;br /&gt;
* Pushing the results of sindex into a variable (matching a string in another variable)&lt;br /&gt;
 int results;&lt;br /&gt;
 results=sindex(group.id, &amp;quot;776B094702EABB4B87F04A139E72D44B&amp;quot;);&lt;br /&gt;
 if (results==-1) {&lt;br /&gt;
       set_return_data(&amp;quot;No Match&amp;quot;);&lt;br /&gt;
 } else {&lt;br /&gt;
       set_return_data(&amp;quot;Match!&amp;quot;);&lt;br /&gt;
 }&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Sindex&amp;diff=1265</id>
		<title>Sindex</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Sindex&amp;diff=1265"/>
				<updated>2008-02-22T17:06:15Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Category:Spel]]&lt;br /&gt;
== Description ==&lt;br /&gt;
A spel function which, although much diffrent in syntax, works similar to regex (Regular Expression) string matches found in most other programming languages.&lt;br /&gt;
&lt;br /&gt;
== Usage ==&lt;br /&gt;
sindex(''&amp;quot;string&amp;quot;'',''&amp;quot;match&amp;quot;'');&lt;br /&gt;
&lt;br /&gt;
== Results ==&lt;br /&gt;
Sindex will return a -1 is no match is found or a 0 if a match is made.&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
* If statement using sindex (matching a string against a string)&lt;br /&gt;
 if (sindex(&amp;quot;test string&amp;quot;, &amp;quot;test&amp;quot;)==0) {return;}&lt;br /&gt;
&lt;br /&gt;
* Pushing the results of sindex into a variable (matching a string in another variable)&lt;br /&gt;
 int results;&lt;br /&gt;
 results=sindex(group.id, &amp;quot;776B094702EABB4B87F04A139E72D44B&amp;quot;);&lt;br /&gt;
 if (results==-1) {&lt;br /&gt;
       set_return_data(&amp;quot;No Match&amp;quot;);&lt;br /&gt;
 } else {&lt;br /&gt;
       set_return_data(&amp;quot;Match!&amp;quot;);&lt;br /&gt;
 }&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Sindex&amp;diff=1264</id>
		<title>Sindex</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Sindex&amp;diff=1264"/>
				<updated>2008-02-22T17:00:27Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Category:Spel]]&lt;br /&gt;
== Description ==&lt;br /&gt;
A spel function which, although much diffrent in syntax, works similar to regex (Regular Expression) string matches found in most other programming languages.&lt;br /&gt;
&lt;br /&gt;
== Usage ==&lt;br /&gt;
sindex(''&amp;quot;string&amp;quot;'',''&amp;quot;match&amp;quot;'');&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{|&lt;br /&gt;
|-&lt;br /&gt;
! Wildcards&lt;br /&gt;
! Description&lt;br /&gt;
|-&lt;br /&gt;
| *&lt;br /&gt;
| Matches any character, unknown how many times.&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
== Results ==&lt;br /&gt;
Sindex will return a -1 is no match is found or a 0 if a match is made.&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
* If statement using sindex (matching a string against a string)&lt;br /&gt;
 if (sindex(&amp;quot;test string&amp;quot;, &amp;quot;test&amp;quot;)==0) {return;}&lt;br /&gt;
&lt;br /&gt;
* Pushing the results of sindex into a variable (matching a string in another variable)&lt;br /&gt;
 int results;&lt;br /&gt;
 results=sindex(group.id, &amp;quot;776B094702EABB4B87F04A139E72D44B&amp;quot;);&lt;br /&gt;
 if (results==-1) {&lt;br /&gt;
       set_return_data(&amp;quot;No Match&amp;quot;);&lt;br /&gt;
 } else {&lt;br /&gt;
       set_return_data(&amp;quot;Match!&amp;quot;);&lt;br /&gt;
 }&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Sindex&amp;diff=1258</id>
		<title>Sindex</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Sindex&amp;diff=1258"/>
				<updated>2008-02-22T16:51:43Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): New page: Category:Spel:Functions == Description == A spel function which, although much diffrent in syntax, works similar to regex (Regular Expression) string matches found in most other progra...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Category:Spel:Functions]]&lt;br /&gt;
== Description ==&lt;br /&gt;
A spel function which, although much diffrent in syntax, works similar to regex (Regular Expression) string matches found in most other programming languages.&lt;br /&gt;
&lt;br /&gt;
== Usage ==&lt;br /&gt;
sindex(''&amp;quot;string&amp;quot;'',''&amp;quot;match&amp;quot;'');&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{|&lt;br /&gt;
|-&lt;br /&gt;
! Wildcards&lt;br /&gt;
! Description&lt;br /&gt;
|-&lt;br /&gt;
| *&lt;br /&gt;
| Matches any character, unknown how many times.&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
== Results ==&lt;br /&gt;
Sindex will return a -1 is no match is found or a 0 if a match is made.&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
* If statement using sindex (matching a string against a string)&lt;br /&gt;
 if (sindex(&amp;quot;test string&amp;quot;, &amp;quot;test&amp;quot;)==0) {return;}&lt;br /&gt;
&lt;br /&gt;
* Pushing the results of sindex into a variable (matching a string in another variable)&lt;br /&gt;
 int results;&lt;br /&gt;
 results=sindex(group.id, &amp;quot;776B094702EABB4B87F04A139E72D44B&amp;quot;);&lt;br /&gt;
 if (results==-1) {&lt;br /&gt;
       set_return_data(&amp;quot;No Match&amp;quot;);&lt;br /&gt;
 } else {&lt;br /&gt;
       set_return_data(&amp;quot;Match!&amp;quot;);&lt;br /&gt;
 }&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Pdm_tomcat_nxd&amp;diff=1122</id>
		<title>Pdm tomcat nxd</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Pdm_tomcat_nxd&amp;diff=1122"/>
				<updated>2008-02-08T23:39:24Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): /* Usage */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This utility is used to manage the tomcat daemon&lt;br /&gt;
== Usage ==&lt;br /&gt;
pdm_tomcat_nxd [-h] [-s] [-S server_name] [-c start|shutdown|stop|exit] [-d start|shutdown|stop|exit] [-C]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{|&lt;br /&gt;
|-&lt;br /&gt;
! Command&lt;br /&gt;
! Description&lt;br /&gt;
! Remarks&lt;br /&gt;
|-&lt;br /&gt;
| -h&lt;br /&gt;
| Help&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -s&lt;br /&gt;
| When running as a daemon will start tomcat now&lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| -S&lt;br /&gt;
| &lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| -c&lt;br /&gt;
|Command tomcat through tomcat daemon &lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -d&lt;br /&gt;
|Command tomcat directly&lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| -C&lt;br /&gt;
|Provide a new command line without start or stop. Valid for daemon.&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
* Stop tomcat daemon&lt;br /&gt;
 pdm_tomcat_nxd -c stop&lt;br /&gt;
&lt;br /&gt;
*Start tomcat daemon&lt;br /&gt;
 pdm_tomcat_nxd -c start&lt;br /&gt;
&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;div align='center'&amp;gt;&amp;lt;font color=&amp;quot;red&amp;quot;&amp;gt;To make corrections or additions to this article, select the ''edit'' tab above.&amp;lt;br&amp;gt;&lt;br /&gt;
To discuss or ask questions about this article, select the ''discussion'' tab above.&amp;lt;/font&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Category:Commands]]&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Pdm_tomcat_nxd&amp;diff=1119</id>
		<title>Pdm tomcat nxd</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Pdm_tomcat_nxd&amp;diff=1119"/>
				<updated>2008-02-08T23:22:55Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): New page: This utility is used to manage the tomcat daemon == Usage == pdm_tomcat_nxd [-h] [-s] [-S (server_name)] [-c (start|shutdown|stop|exit)] [-d (start|shutdown|stop|exit)] [-C]  &amp;lt;br&amp;gt; {| |- ! ...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This utility is used to manage the tomcat daemon&lt;br /&gt;
== Usage ==&lt;br /&gt;
pdm_tomcat_nxd [-h] [-s] [-S (server_name)] [-c (start|shutdown|stop|exit)] [-d (start|shutdown|stop|exit)] [-C]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{|&lt;br /&gt;
|-&lt;br /&gt;
! Command&lt;br /&gt;
! Description&lt;br /&gt;
! Remarks&lt;br /&gt;
|-&lt;br /&gt;
| -h&lt;br /&gt;
| Help&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -s&lt;br /&gt;
| When running as a daemon will start tomcat now&lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| -S&lt;br /&gt;
| &lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| -c&lt;br /&gt;
|Command tomcat through tomcat daemon &lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -d&lt;br /&gt;
|Command tomcat directly&lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| -C&lt;br /&gt;
|Provide a new command line without start or stop. Valid for daemon.&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
* Stop tomcat daemon&lt;br /&gt;
 pdm_tomcat_nxd -c stop&lt;br /&gt;
&lt;br /&gt;
*Start tomcat daemon&lt;br /&gt;
 pdm_tomcat_nxd -c start&lt;br /&gt;
&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;div align='center'&amp;gt;&amp;lt;font color=&amp;quot;red&amp;quot;&amp;gt;To make corrections or additions to this article, select the ''edit'' tab above.&amp;lt;br&amp;gt;&lt;br /&gt;
To discuss or ask questions about this article, select the ''discussion'' tab above.&amp;lt;/font&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Category:Commands]]&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Pdm_d_refresh&amp;diff=1118</id>
		<title>Pdm d refresh</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Pdm_d_refresh&amp;diff=1118"/>
				<updated>2008-02-08T23:08:07Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): New page: This utility is used to selectively start, stop and restart sets of daemons while the daemon manager is running.  It does not start or stop the daemon manager.  == Usage == pdm_d_refresh [...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This utility is used to selectively start, stop and restart sets of daemons while the daemon manager is running.  It does not start or stop the daemon manager.&lt;br /&gt;
&lt;br /&gt;
== Usage ==&lt;br /&gt;
pdm_d_refresh [-h] [-s] [-r] [-c] [-x] set_name&lt;br /&gt;
&lt;br /&gt;
If -r or -h are not specified then all stopped daemons in the current set will be started.&lt;br /&gt;
&lt;br /&gt;
If only a set_name is specified then only the stopped daemons in this set are started.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{|&lt;br /&gt;
|-&lt;br /&gt;
! Command&lt;br /&gt;
! Description&lt;br /&gt;
! Remarks&lt;br /&gt;
|-&lt;br /&gt;
| -h&lt;br /&gt;
| Help&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -s&lt;br /&gt;
| Start daemon set&lt;br /&gt;
| set_name optional&lt;br /&gt;
|-&lt;br /&gt;
| -r&lt;br /&gt;
| Shuts down daemons and daemons dependents&lt;br /&gt;
| set_name optional&lt;br /&gt;
|-&lt;br /&gt;
| -c&lt;br /&gt;
| Change to set_name on these daemons.  And restarts&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -x&lt;br /&gt;
| Stops daemons and daemons dependent on these daemons. If set_name is not given all daemons will be stopped&lt;br /&gt;
| set_name optional&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
* Start all stopped daemons&lt;br /&gt;
 pdm_d_refresh&lt;br /&gt;
&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;div align='center'&amp;gt;&amp;lt;font color=&amp;quot;red&amp;quot;&amp;gt;To make corrections or additions to this article, select the ''edit'' tab above.&amp;lt;br&amp;gt;&lt;br /&gt;
To discuss or ask questions about this article, select the ''discussion'' tab above.&amp;lt;/font&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Category:Commands]]&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Error_Loading_Migrated_r11_Extract_to_a_New_r11_Install&amp;diff=1117</id>
		<title>Error Loading Migrated r11 Extract to a New r11 Install</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Error_Loading_Migrated_r11_Extract_to_a_New_r11_Install&amp;diff=1117"/>
				<updated>2008-02-08T21:00:49Z</updated>
		
		<summary type="html">&lt;p&gt;Alex (aka Fancy Pants): &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Running a [[pdm_load]] of data coming from a migrated 6.x-&amp;gt;r11.x system could pose problems. In particular, a problem will occur if the extracted data was obtained via the '''[[pdm_extract]] All''' command&lt;br /&gt;
&lt;br /&gt;
In a migrated installation, the [[Computer_Extension]] and [[Software_Extension]] tables exist from earlier releases of Service Desk. In r11.x these tables no longer exist and are not included in a fresh installation. While running the [[pdm_load]], the following error will appear:&lt;br /&gt;
 ** EXIT: Invalid table name : Computer_Extension&lt;br /&gt;
 : Correct table name and rerun from error point.&lt;br /&gt;
&lt;br /&gt;
The easiest solution is to have a DBA do a direct database to database move of data. But if a [[pdm_load]] is your only realistic solution, then here's how you proceed.&lt;br /&gt;
# Run your [[pdm_load]] until it fails.&lt;br /&gt;
# Download a third party file splitter such as [http://www.acc.umu.se/~max/maxsplitter/index_free.html MaxSplitter]. &lt;br /&gt;
# Break the text file into manageable pieces&lt;br /&gt;
# Search the pieces for '''TABLE [[Computer_Extension]]'''.&lt;br /&gt;
# Delete the [[Computer_Extension]] section and everything that has already been loaded.&lt;br /&gt;
# User the file splitter to piece the remaining pieces back together.&lt;br /&gt;
# Run the [[pdm_load]] on your newly compiled file until it fails again.&lt;br /&gt;
# Use your file splitter to break the file into manageable pieces again.&lt;br /&gt;
# Search the pieces for '''TABLE [[Software_Extension]]'''.&lt;br /&gt;
# Delete the [[Sofware_Extension]] section and everything that has already been loaded.&lt;br /&gt;
# User the file splitter to piece the remaining pieces back together.&lt;br /&gt;
# Run the [[pdm_load]] on your newly compiled file.&lt;br /&gt;
&lt;br /&gt;
Currently there is no solution provided by CA. But I don't see how having the load stop if a table is missing is acceptable behavior. In my opinion an error log should be created, but the load should continue (as it does when a column is missing)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;div align='center'&amp;gt;&amp;lt;font color=&amp;quot;red&amp;quot;&amp;gt;To make corrections or additions to this article, select the ''edit'' tab above.&amp;lt;br&amp;gt;&lt;br /&gt;
To discuss or ask questions about this article, select the ''discussion'' tab above.&amp;lt;/font&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Category:Solutions]]&lt;/div&gt;</summary>
		<author><name>Alex (aka Fancy Pants)</name></author>	</entry>

	</feed>