<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.tntware.com/donorwise/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Search Names</title><link>https://www.tntware.com/donorwise/help/en/pages/contacts-searchnames.aspx</link><description>Search Names is a field on the Personal Info Tab. Read More &amp;gt; Personal Info Tab This is an excellent place to put other names you want available when searching. A good example of use of this box is to import previously existing Contact IDs that cannot</description><dc:language>en</dc:language><generator>CommunityServer 2008.5 SP2 (Debug Build: 40407.4157)</generator><item><title>re: Search Names</title><link>https://www.tntware.com/donorwise/help/en/pages/contacts-searchnames.aspx#3612</link><pubDate>Mon, 20 Jun 2016 20:17:33 GMT</pubDate><guid isPermaLink="false">de06579a-5120-4393-a24b-6f68f5e7a3ec:3612</guid><dc:creator>Troy Wolbrink</dc:creator><description>&lt;p&gt;After importing legacy Donor IDs or Designation IDs into Search Names, you might want to apply them to the &amp;quot;Global Donor Code&amp;quot; or &amp;quot;Global Designation Code&amp;quot; fields. &amp;nbsp;This way you can refer to them in other places, like in the &amp;quot;Import Historical Batch&amp;quot; screen. &amp;nbsp;Here&amp;#39;s a script you can run in SQL Server Management Studio. &amp;nbsp;Just right-click on your DonorWise database and &amp;quot;New Query&amp;quot; to run this:&lt;/p&gt;
&lt;p&gt; UPDATE Desig Set GlobalDesigCode = (SELECT SearchNames &lt;/p&gt;
&lt;p&gt; &amp;nbsp; FROM Contact WHERE Contact.ContactID = Desig.ContactID)&lt;/p&gt;
&lt;p&gt; GO&lt;/p&gt;
&lt;p&gt; UPDATE Donor Set GlobalDonorCode = (SELECT SearchNames &lt;/p&gt;
&lt;p&gt; &amp;nbsp; FROM Contact WHERE Contact.ContactID = Donor.ContactID)&lt;/p&gt;
&lt;p&gt; GO&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="https://www.tntware.com/donorwise/aggbug.aspx?PostID=3612" width="1" height="1"&gt;</description></item></channel></rss>