Michael, Gillian, and Kate,

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.

Best,
Anita

On Mon, Jan 24, 2011 at 10:03 AM, Kate Blanch <[log in to unmask]>wrote:

>
>
> *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. *
>
> * *
>
> *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. *
>
> * *
>
> *All the best!*
>
> * *
>
> * *
>
> *Kate Blanch*
>
> *Administrator, Museum Databases*
>
> *[log in to unmask]* <[log in to unmask]> / 410.547.9000 ext. 266
>
>
>
>
> The Walters Art Museum
>
> 600 N. Charles Street, Baltimore MD 21201
>
> *www.thewalters.org* <http://www.thewalters.org/>
>
> *Beasts on Parchment: Picturing Animals in Medieval Manuscripts*<http://thewalters.org/eventscalendar/eventdetails.aspx?e=1770>
> * *November 6-February 13
>
> *German Drawings from the Walters’ Collection<http://thewalters.org/eventscalendar/eventdetails.aspx?e=1769>
> * November 20–February 13
>
> *Treasures of Heaven: Saints, Relics and Devotion in Medieval Europe*<http://thewalters.org/eventscalendar/eventdetails.aspx?e=1568> February
> 13–May 15, 2011
>
> [image: Twitter logo] <http://twitter.com/walters_museum>   [image:
> Facebook logo]<http://www.facebook.com/pages/Baltimore-MD/The-Walters-Art-Museum/6634368191?ref=ts>
>    [image: Flickr logo]<http://www.flickr.com/photos/walters-art-museum/sets/>
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]]
> *On Behalf Of *TMSUSERS automatic digest system
> *Sent:* Friday, January 21, 2011 5:00 PM
>
> *To:* [log in to unmask]
> *Subject:* TMSUSERS Digest - 20 Jan 2011 to 21 Jan 2011 (#2011-8)
>
>
>
> *[image: LISTSERV mailing list manager]* <http://www.lsoft.com>
>
> *[image: LISTSERV 16.0]*<http://si-listserv.si.edu/cgi-bin/wa?LIST=TMSUSERS>
>
>
>
>
>    TMSUSERS Digest - 20 Jan 2011 to 21 Jan 2011 (#2011-8) Table of
> contents:
>
>    - *Website Collections Searches (but NOT eMuseum)*<#12db88d244851a71_S1>(3)
>
> 1.     *Website Collections Searches (but NOT eMuseum)*
>
> o    *Website Collections Searches (but NOT eMuseum)* (01/21)
> *From:* Anita Heggli <[log in to unmask]>
>
> o    *Re: Website Collections Searches (but NOT eMuseum)* (01/21)
> *From:* "Michael T. Black" <[log in to unmask]>
>
> o    *Re: Website Collections Searches (but NOT eMuseum)* (01/21)
> *From:* "Michael T. Black" <[log in to unmask]>
>
>
>
> Browse the *TMSUSERS online archives.*<http://si-listserv.si.edu/cgi-bin/wa?LIST=TMSUSERS>
>
> *[image: Powered by the LISTSERV Email List Manager]*<http://www.lsoft.com/products/listserv-powered.asp>
>
>
>