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] <mailto:[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 <http://twitter.com/walters_museum> <http://www.facebook.com/pages/Baltimore-MD/The-Walters-Art-Museum/66343 68191?ref=ts> <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) LISTSERV mailing list manager <http://www.lsoft.com> 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) (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> Powered by the LISTSERV Email List Manager <http://www.lsoft.com/products/listserv-powered.asp>