Michael, Gillian, and Kate,<div><div><br></div><div>Thank you very much for each of your responses.  All of this info will be very helpful.  I may send you follow-up inquiries off-list.</div><div><br></div><div>Best,</div>
<div>Anita<br><br><div class="gmail_quote">On Mon, Jan 24, 2011 at 10:03 AM, Kate Blanch <span dir="ltr">&lt;<a href="mailto:[log in to unmask]"><a href="/cgi-bin/wa?LOGON=A3%3D1101%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D547202%26B%3D--0016364d265b0093d5049ab54c07%26T%3Dtext%252Fhtml%3B%2520charset%3Dwindows-1252%26pending%3D" target="_parent" >[log in to unmask]</a></a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">











<div lang="EN-US" link="#3366CC" vlink="#3366CC">

<div>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>

<div>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959">Hi Anita, the data that populates our Online Collections website
is pulled from a SQL Server database that is refreshed nightly with TMS data. The
refresh is automated and requires no human intervention. We are in the process
of a major website overhaul – the current site was written in .NET but it
is being re-designed in PHP. Data will be pulled from our “middle-man”
SQL Server database into the web server’s MySQL database (housed on a
Unix server) on a nightly basis. We built the SQL Server database in-house that
contains the relevant TMS data and necessary data transformations. The web
designers we contracted with are programming the part of the process whereby
data is pulled into the web server’s MySQL database nightly. Related
media is transported to the web server via a PHP utility which was crafted by
the same web design firm. </span></b></p>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959"> </span></b></p>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959">I’d be happy to share more details offline if any of this
is of interest – budget, data flow, techinical details. We don’t
have a blockbuster budget, and have done a lot with limited means. Our on-staff
web manager can read and program in PHP so will be able to support the new site
to a much greater capacity than the old .NET site. That was a key component in
spearheading this project. </span></b></p>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959"> </span></b></p>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959">All the best!</span></b></p>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959"> </span></b></p>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959"> </span></b></p>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959">Kate Blanch</span></b></p>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959">Administrator, Museum Databases</span></b></p>

<p class="MsoNormal"><span style="font-size:10.0pt;color:#7F7F7F"><a href="mailto:[log in to unmask]" target="_blank"><u><span style="color:#7F7F7F"><a href="/cgi-bin/wa?LOGON=A3%3D1101%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D547202%26B%3D--0016364d265b0093d5049ab54c07%26T%3Dtext%252Fhtml%3B%2520charset%3Dwindows-1252%26pending%3D" target="_parent" >[log in to unmask]</a></span></u></a> / 410.547.9000 ext.
266  </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;color:#7F7F7F"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;color:#7F7F7F">The Walters Art Museum</span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;color:#7F7F7F">600 N. Charles Street, Baltimore MD 21201</span></p>

<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;color:#7F7F7F"><a href="http://www.thewalters.org/" target="_blank"><u><span style="color:#7F7F7F">www.thewalters.org</span></u></a></span></p>


<p class="MsoNormal"><span style="color:#1F497D"><a href="http://thewalters.org/eventscalendar/eventdetails.aspx?e=1770" target="_blank"><b><span style="font-size:10.0pt;color:#595959">Beasts
on Parchment: Picturing Animals in Medieval Manuscripts</span></b></a><i> </i></span><span style="font-size:10.0pt;color:#595959">November
6-February 13</span><span style="font-size:10.0pt;color:#595959"></span></p>

<p class="MsoNormal"><b><span style="font-size:10.0pt;color:#595959"><a href="http://thewalters.org/eventscalendar/eventdetails.aspx?e=1769" target="_blank"><span style="color:#595959">German Drawings from the Walters’ Collection</span></a></span></b><span style="font-size:10.0pt;color:#595959">
November 20–February 13</span></p>

<p class="MsoNormal"><span style="color:#1F497D"><a href="http://thewalters.org/eventscalendar/eventdetails.aspx?e=1568" target="_blank"><b><span style="font-size:10.0pt;color:#595959">Treasures
of Heaven: Saints, Relics and Devotion in Medieval Europe</span></b></a> </span><span style="font-size:10.0pt;color:#595959">February
13–May 15, 2011</span><span style="font-size:11.0pt;color:#1F497D"></span></p>

<p class="MsoNormal"><a href="http://twitter.com/walters_museum" target="_blank"><span style="font-size:11.0pt;color:#002060"><img border="0" width="24" height="24" src="?ui=2&amp;ik=3c3778d6d9&amp;view=att&amp;th=12db88d244851a71&amp;attid=0.1&amp;disp=emb&amp;zw" alt="Twitter logo"></span></a><span style="font-size:11.0pt;color:#002060">   </span><a href="http://www.facebook.com/pages/Baltimore-MD/The-Walters-Art-Museum/6634368191?ref=ts" target="_blank"><span style="font-size:11.0pt;color:#002060"><img border="0" width="24" height="24" src="?ui=2&amp;ik=3c3778d6d9&amp;view=att&amp;th=12db88d244851a71&amp;attid=0.2&amp;disp=emb&amp;zw" alt="Facebook logo"></span></a><span style="font-size:11.0pt;color:#002060">   </span><a href="http://www.flickr.com/photos/walters-art-museum/sets/" target="_blank"><span style="font-size:11.0pt;color:#002060"><img border="0" width="24" height="24" src="?ui=2&amp;ik=3c3778d6d9&amp;view=att&amp;th=12db88d244851a71&amp;attid=0.3&amp;disp=emb&amp;zw" alt="Flickr logo"></span></a><span style="font-size:11.0pt;color:#002060"></span></p>


</div>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>

<div>

<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">

<p class="MsoNormal"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt"> The Museum System
(TMS) Users [mailto:<a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1101%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D547202%26B%3D--0016364d265b0093d5049ab54c07%26T%3Dtext%252Fhtml%3B%2520charset%3Dwindows-1252%26pending%3D" target="_parent" >[log in to unmask]</a></a>] <b>On Behalf Of </b>TMSUSERS
automatic digest system<br>
<b>Sent:</b> Friday, January 21, 2011 5:00 PM</span></p><div class="im"><br>
<b>To:</b> <a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1101%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D547202%26B%3D--0016364d265b0093d5049ab54c07%26T%3Dtext%252Fhtml%3B%2520charset%3Dwindows-1252%26pending%3D" target="_parent" >[log in to unmask]</a></a><br>
</div><b>Subject:</b> TMSUSERS Digest - 20 Jan 2011 to 21 Jan 2011 (#2011-8)<p></p>

</div>

</div>

<p class="MsoNormal"> </p>

<table border="1" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border:solid #999999 1.0pt">
 <tbody><tr>
  <td style="border:none;padding:0in 0in 0in 0in">
  <p class="MsoNormal"><span style="font-size:9.0pt;color:black"><a href="http://www.lsoft.com" target="_blank"><b><img border="0" src="http://SI-LISTSERV.SI.EDU/archives/images/b-listserv.jpg" alt="LISTSERV mailing list manager"></b></a></span></p>

  </td>
  <td style="border:none;padding:0in 0in 0in 0in">
  <p class="MsoNormal"><span style="font-size:9.0pt;color:black"><a href="http://si-listserv.si.edu/cgi-bin/wa?LIST=TMSUSERS" target="_blank"><b><img border="0" src="http://SI-LISTSERV.SI.EDU/archives/images/b-version.jpg" alt="LISTSERV 16.0"></b></a></span></p>

  </td>
  <td style="border:none;padding:0in 0in 0in 0in">
  <p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.0pt;color:black"> </span></p>
  </td>
 </tr>
</tbody></table>

<p class="MsoNormal"><span style="font-size:9.0pt;color:black"> </span></p>

<table border="1" cellspacing="0" cellpadding="0" style="border:solid #999999 1.0pt">
 <tbody><tr>
  <td style="border:none;background:#F1F4FA;padding:0in 0in 0in 0in">
  <table border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
   <tbody><tr>
    <td style="padding:7.5pt 7.5pt 7.5pt 7.5pt">
    <h2>TMSUSERS Digest - 20 Jan 2011 to 21 Jan 2011 (#2011-8)</h2>
    <h3>Table of contents:</h3>
    <ul type="disc">
     <li class="MsoNormal" style="color:black"><span style="font-size:9.0pt"><a href="#12db88d244851a71_S1"><b>Website Collections Searches
         (but NOT eMuseum)</b></a> (3) </span></li>
    </ul>
    <p class="MsoNormal" style="margin-left:.5in"><a name="12db88d244851a71_S1"><span style="font-size:9.0pt;color:black"><span>1.<span style="font:7.0pt &quot;Times New Roman&quot;">    
    </span></span></span><b><span style="font-size:9.0pt;color:#3366CC">Website Collections Searches (but NOT
    eMuseum)</span></b></a><span style="font-size:9.0pt;color:black"></span></p>
    <p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"><span>o<span style="font:7.0pt &quot;Times New Roman&quot;">   
    </span></span></span><span style="font-size:9.0pt;color:black"><a><b>Website
    Collections Searches (but NOT eMuseum)</b></a> (01/21)<br>
    <b>From:</b> Anita Heggli &lt;<a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1101%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D547202%26B%3D--0016364d265b0093d5049ab54c07%26T%3Dtext%252Fhtml%3B%2520charset%3Dwindows-1252%26pending%3D" target="_parent" >[log in to unmask]</a></a>&gt; </span></p>
    <p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"><span>o<span style="font:7.0pt &quot;Times New Roman&quot;">   
    </span></span></span><span style="font-size:9.0pt;color:black"><a><b>Re:
    Website Collections Searches (but NOT eMuseum)</b></a> (01/21)<br>
    <b>From:</b> &quot;Michael T. Black&quot; &lt;<a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1101%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D547202%26B%3D--0016364d265b0093d5049ab54c07%26T%3Dtext%252Fhtml%3B%2520charset%3Dwindows-1252%26pending%3D" target="_parent" >[log in to unmask]</a></a>&gt; </span></p>
    <p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"><span>o<span style="font:7.0pt &quot;Times New Roman&quot;">   
    </span></span></span><span style="font-size:9.0pt;color:black"><a><b>Re:
    Website Collections Searches (but NOT eMuseum)</b></a> (01/21)<br>
    <b>From:</b> &quot;Michael T. Black&quot; &lt;<a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa?LOGON=A3%3D1101%26L%3DTMSUSERS%26E%3Dquoted-printable%26P%3D547202%26B%3D--0016364d265b0093d5049ab54c07%26T%3Dtext%252Fhtml%3B%2520charset%3Dwindows-1252%26pending%3D" target="_parent" >[log in to unmask]</a></a>&gt;</span></p>
    </td>
   </tr>
  </tbody></table>
  </td>
 </tr>
</tbody></table>

<p class="MsoNormal"><span style="font-size:9.0pt;color:black"> </span></p>

<table border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
 <tbody><tr>
  <td style="padding:0in 0in 0in 0in">
  <p>Browse the <a href="http://si-listserv.si.edu/cgi-bin/wa?LIST=TMSUSERS" target="_blank"><b>TMSUSERS online archives.</b></a></p>
  </td>
  <td style="padding:0in 0in 0in 0in">
  <p align="right" style="text-align:right"><a href="http://www.lsoft.com/products/listserv-powered.asp" target="_blank"><b><img border="0" src="http://SI-LISTSERV.SI.EDU/archives/images/b-lpowered.gif" alt="Powered by the LISTSERV Email List Manager"></b></a></p>

  </td>
 </tr>
</tbody></table>

<p class="MsoNormal"> </p>

</div>

</div>


</blockquote></div><br></div></div>